OrcasHelper(.Net Reviews)

Make an Ajax Get call to a page ...

noreply@blogger.com (Manoj Kumar Joshi) — Sun, 08 May 2011 05:45:00 +0000

For making an ajax Get call we have to create a page which render's the data expected and here are some code snippets which can be helpful while making a call :

Create a parameters used to refine search or make an criteria . totally optional
var params = {};
params = { 'ProductID': productID};

Now make a call to the page with the params :

$.get('ProductInfoAjaxPage.aspx', params, function (data) {

// add data to the div
$("#getData").html(data);

}, 'html');

Here getData is the div inside the page where we are making ajax call and used to display ajax call response html.

so here you are calling ProductInfoAjaxPage.aspx page and passing a parameter ProductID which
can be used at ProductInfoAjaxPage.aspx page like :

In class file of ProductInfoAjaxPage.aspx page we can write

string productID= HttpContext.Current.Request.Params["ProductID"]; and use it for getting some information
related to that product ID

That's all ,

Cheers :)

Navitaire : How to change the Trip Availability Request

noreply@blogger.com (Manoj Kumar Joshi) — Sun, 08 May 2011 05:41:00 +0000

TripAvailabilityRequest availRequest = (TripAvailabilityRequest)this.SessionStore[SessionKey.TripAvailabilityRequest];
foreach (AvailabilityRequest request in availRequest.AvailabilityRequests)
{
request.BeginDate = DateTime.Now; //Changed Date

request.EndDate = DateTime.Now; //End date will be the same can change it
}

//Save it to the Existing session
this.SessionStore.Remove(SessionKey.TripAvailabilityRequest);
this.SessionStore.Add(SessionKey.TripAvailabilityRequest, availRequest);

Cheers ,

Meredith & Derek - if you have to leave, i wish that you would just leav...

noreply@blogger.com (Manoj Kumar Joshi) — Sat, 29 Jan 2011 12:51:00 +0000

I love this video..

SQL: Where clause with group By..

noreply@blogger.com (Manoj Kumar Joshi) — Wed, 26 Jan 2011 09:54:00 +0000

We can use where clause with group by.

In that case first the where clause will apply to the statement and after filtering it Group by will grouped it. And further if we want to use Having to further filter it we can use.

here is small snippet for the same :

Select employee_ID , Max(sale)from Employee_Sale where Sale > 10000 group by employee_ID

Now the above statement with Having clause :

Select employee_ID , Max(sale)from Employee_Sale where sale > 10000 group by employee_ID having sum(sale) > 50000

Cheers

Date Formating like 26th..21st or just 1st

noreply@blogger.com (Manoj Kumar Joshi) — Wed, 26 May 2010 16:34:00 +0000

Hi,

A few days before i got a requirement from my client for date formating which is like
"Saturday - 26th June 2010" well it seems to be a small thing but i faced problem when i start changing
date to something like 26th..21st or just 1st...

After some googling i haven't find any good solution or not any inbuild format for this in C#.

So i just create a method which takes the date as a parameter and return the required date format.
and here is this method:

///

/// This method accept the Date and convert it to the format like: Sunday - 3rd October 2010
///

///
///
private string GetFormatedDate(DateTime dateTime)
{

string dateSuffix = (dateTime.Day.ToString().EndsWith("1"))
? ((dateTime.Day.ToString().StartsWith("1") &&
dateTime.Day != 1)
? "th"
: "st")
: (dateTime.Day.ToString().EndsWith("2"))
? (dateTime.Day.ToString().StartsWith("1")
? "th"
: "nd")
: (dateTime.Day.ToString().EndsWith("3"))
? (dateTime.Day.ToString().StartsWith("1")
? "th"
: "rd")
: "th";

return dateTime.ToString("dddd - d~ MMMM yyyy").Replace("~", dateSuffix);

}
In the above example i used Conditional operator which is something like:

CheckCondition ? If_True_Then_This_Value : Else_This_Value;

And at the last line :

return dateTime.ToString("dddd - d~ MMMM yyyy").Replace("~", dateSuffix);

i just suffix a character '~', it can be anything but not the part of any date format and replaced it with the date suffix (ie. th, st, rd or nd).

Hope this will help you guys when you try to do the same.

Cheers.....

Show and Hide div using Jquery

noreply@blogger.com (Manoj Kumar Joshi) — Sun, 16 May 2010 16:03:00 +0000

Hey with just a simple line of code you can show and hide a div...

Before Jquery we write our code something like :

For hiding a div : document.getElementById(id).style.display = 'none';
For Showing a div: document.getElementById(id).style.display = 'block';

and now with the cool feature of JQuery :

For hiding a div : $("#divResult").hide();
For Showing a div: $("#divResult").show();

And also we can play around with this
like

$("#divResult").show(2000);

It will slowly display the div in 2 seconds.....

And for hiding

$("#divResult").hide("slow");

Its hides your div slowly..

Cheers...

Lambda Expression in .net Part1

noreply@blogger.com (Manoj Kumar Joshi) — Thu, 04 Mar 2010 16:33:00 +0000

Lambda Expression new feature introduce in .net 3.0, is an anonymous method without a name and perform several operation in a few line of codes which is great.

In lambda expression we use the lambda operator => , Known as "goes to".

Here is an example of lambda operator

IList quieueList = list of BookingQueueInfo class;

Now we find all the BookingQueueInfo class which have property QueueEventType as 'ScheduleTimeChange' or as 'ReaccommodationMove'

Here is the code :

List bqiList =
new List(quieueList).FindAll(
q =>
q.QueueEventType == 'ScheduleTimeChange' || q.QueueEventType == 'ReaccommodationMove');

Please post if you have any query for Lambda Expression.

Cheers

Encrypt and Decrypt a String in C# using Cryptography

noreply@blogger.com (Manoj Kumar Joshi) — Sun, 05 Jul 2009 16:41:00 +0000

I am going to explain how to encrypt and decrypt a string in C# using Cryptography and by generating an MD5 hash from the password.

First of all we need to add System.Security.Cryptography; namespace in our code, I am going to create a class with two Methods

1) Encrypter
2) Decrypter

Encrypter used to encrypt a string and Decrypter used to descrypt the string encrypted by Encrypter.

Here is this beautiful class. Its a competetely implemented Class, what all you need to do is just Copy and Paste.

public class EncryptDecrypt
{
public EncryptDecrypt()
{
//
// TODO: Add constructor logic here
//
}

public string Encrypter(string strStringToEncrypt)
{
string strOriginal, strEncryptedString, password;
TripleDESCryptoServiceProvider des;
MD5CryptoServiceProvider hashmd5;
byte[] pwdhash, buff;

//create a secret password. the password is used to encrypt and decrypt
//strings. Without the password, the encrypted string cannot be
//decrypted and is just garbage. You must use the same password to
//decrypt an encrypted string as the string was originally encrypted with.

password = "manojjoshi";

//create a string to encrypt
//original = "String to encrypt";

strOriginal = strStringToEncrypt;

//generate an MD5 hash from the password.a hash is a one way
//encryption meaning once you generate the hash, you cant derive the
//password back from it.

hashmd5 = new MD5CryptoServiceProvider();
pwdhash = hashmd5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(password));
hashmd5 = null;

//implement DES3 encryption
des = new TripleDESCryptoServiceProvider();

//the key is the secret password hash.
des.Key = pwdhash;

//the mode is the block cipher mode which is basically the details of how
//the encryption will work. There are several kinds of ciphers available in
//DES3 and they all have benefits and drawbacks. Here the Electronic
//Codebook cipher is used which means that it encrypt each
//block individually and a given bit of text is always encrypted exactly the
// same when the same password is used.

des.Mode = CipherMode.ECB; //CBC, CFB

//----- encrypt an un-encrypted string ------------
//the original string, which needs encrypted, must be in byte array
//form to work with the des3 class. everything will because most encryption
//works at the byte level so you'll find that the class takes in byte
//arrays and returns byte arrays and you'll be converting
//those arrays to strings.

buff = ASCIIEncoding.ASCII.GetBytes(strOriginal);

//encrypt the byte buffer representation of the original string and base64
//encode the encrypted string. The reason the encrypted bytes are being
//base64 encoded as string is the encryption will have created some weird
//characters in there. Base64 encoding provides a platform independent view
//of the encrypted string and can be sent as a plain text string to wherever.

strEncryptedString = Convert.ToBase64String(
des.CreateEncryptor().TransformFinalBlock(buff, 0, buff.Length)
);

return strEncryptedString;
}

public string Decrypter(string StrEncryptedString)
{
string decrypted, password;
TripleDESCryptoServiceProvider des;
MD5CryptoServiceProvider hashmd5;
byte[] pwdhash, buff;

//create a secret password. the password is used to encrypt
//and decrypt strings. Without the password, the encrypted
//string cannot be decrypted and is just garbage. You must
//use the same password to decrypt an encrypted string as the
//string was originally encrypted with.
password = "manojjoshi

//generate an MD5 hash from the password.
//a hash is a one way encryption meaning once you generate
//the hash, you cant derive the password back from it.
hashmd5 = new MD5CryptoServiceProvider();
pwdhash = hashmd5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(password));
hashmd5 = null;

//implement DES3 encryption
des = new TripleDESCryptoServiceProvider();

//the key is the secret password hash.
des.Key = pwdhash;

//the mode is the block cipher mode which is basically the
//details of how the encryption will work. There are several
//kinds of ciphers available in DES3 and they all have benefits
//and drawbacks. Here the Electronic Codebook cipher is used
//which means that a given bit of text is always encrypted
//exactly the same when the same password is used.
des.Mode = CipherMode.ECB; //CBC, CFB

//----- decrypt an encrypted string ------------
//whenever you decrypt a string, you must do everything you
//did to encrypt the string, but in reverse order. To encrypt,
//first a normal string was des3 encrypted into a byte array
//and then base64 encoded for reliable transmission. So, to
//decrypt this string, first the base64 encoded string must be
//decoded so that just the encrypted byte array remains.
buff = Convert.FromBase64String(StrEncryptedString);

//decrypt DES 3 encrypted byte buffer and return ASCII string
decrypted = ASCIIEncoding.ASCII.GetString(
des.CreateDecryptor().TransformFinalBlock(buff, 0, buff.Length)
);

return decrypted;
}

}

And we are done with this. Now play with encryption and decryption Cheers..

How to Send mail through C# using SMTP

noreply@blogger.com (Manoj Kumar Joshi) — Sun, 05 Jul 2009 12:26:00 +0000

If you need to send mails through your code here is the simple Example in
C#

1) Add the System.Net.Mail; namespace to your code.

2) Wirte this code or modify it according to your need.

SmtpClient smtpClient = new SmtpClient();
MailMessage message = new MailMessage();
try
{
string sHostName = "mail.test.com";
string strEmailFrom = "Manoj@mailtest.com";
string sFromName = "Manoj";
string strToEmail = "manojjoshi@gmail.com";
string strSubject = "Test Mail From Manoj";
string strBody = "< table >< tr >< td >This is just a test mail< /td >
< /tr >< /table >"; // Format your massage body here

MailAddress fromAddress = new MailAddress(strEmailFrom, sFromName);

// You can specify the host name or ipaddress of your server
// Default in IIS will be localhost in this case it is mail.test.com
smtpClient.Host = sHostName;
//Default port will be 25
smtpClient.Port = 25;
//From address will be given as a MailAddress Object
message.From = fromAddress;
// To address collection of MailAddress
message.To.Add(strToEmail);
message.Subject = strSubject;
string ccMailIDs = "MyCC1@gmail.com";

///this line of code is for adding more Recipients in cc of your mail

message.CC.Add(new MailAddress(ccMailIDs));
ccMailIDs = "MyCC2@gmail.com";
message.CC.Add(new MailAddress(ccMailIDs));
ccMailIDs = "MyCC3@gmail.com";
message.CC.Add(new MailAddress(ccMailIDs));
//Body can be Html or text format
//Specify true if it is html message
message.IsBodyHtml = true;
// Message body content
message.Body = strBody;

// Send SMTP mail
smtpClient.Send(message);

}
catch (Exception ex)
{
string s = ex.Message;
}

And you are done. Cheers

View State Versus Control State

noreply@blogger.com (Manoj Kumar Joshi) — Wed, 01 Jul 2009 16:43:00 +0000

View State Versus Control State

ViewState is a mechanism through which Asp.Net preserve state of the controls during postback and preserve data in hidden fields. Whenever any request goes to the server the whole value that is in hidden fields decrypt using BASE64 encoding and further incrypt after server response. We can set enable viewstate property to false if we dont want viewstate.

And Control State work in the same manner as ViewState but with a big difference, we can't disable controlstate.Control state is used for storing a control's essential data that is needed on postback to enable the control to function even when view state has been disabled.

Mostly Use the Control State property when you are going to implement Custom Control by overriding the SaveControlState method to save the data in Control State

Cheers

Rounding a Number in Javascript

noreply@blogger.com (Manoj Kumar Joshi) — Fri, 05 Jun 2009 05:02:00 +0000

function roundToWhatever()

{

var numberToRound = document.getElementById("idOfTheInputProvider").value

var numberToRound = new Number(numberToRound );

var result =numberToRound.toFixed(10);

document.getElementById("idOfTheInputProvider").value = result ;

}

Boxing and Unboxing

noreply@blogger.com (Manoj Kumar Joshi) — Mon, 20 Apr 2009 12:28:00 +0000

Whenever we convert an Value type to a Reference type this process is called Boxing and opposite of that is UnBoxing

for ex :

class BoxingUnBoxing
{
static void Main()
{
int i = 1;
object o = i; // boxing
int j = (int) o; // unboxing
}
}

In this example we are assigning a value type to a reference type (eg. object o = i) , Object o is of reference type and i is of value type. and after that we assign an reference type to a value type (eg. int j = (int) o)

Cool Rendering of a page like animation Effect :) I Love it

noreply@blogger.com (Manoj Kumar Joshi) — Thu, 16 Apr 2009 10:35:00 +0000

Hi

If you dont like the page loading while page is postback and the page refereshes.
Then try it really very nice feature and make your page loading amazing, really i do that with one of my website. And it loads with fabulous effects. No need to write nasty of codes just put that tag on your master page. and see your site :)

< meta http-equiv="Page-Exit" content="progid:DXImageTransform.Microsoft.Fade(duration=.5)"/>

Keep Smiling :)

Add Favicon to your site (Icon that dispays at the start of the url)

noreply@blogger.com (Manoj Kumar Joshi) — Wed, 15 Apr 2009 12:02:00 +0000

Want to add a beautiful icon at the start point of your URL (Called Favicon). Just add this tag to your master Page in the < head> section and before the < /head> Section :

< link rel="shortcut icon" type="image/x-icon" href="favicon.ico">

and place an icon named favicon.ico on the Root directory.

When you add this site to add to favorites it will display the icon along with url. For doing that just add the following code also:

< a href="javascript:window.external.AddFavorite('http://www.test.com', 'Test Site')">
Click here to add Test Site to your favorites < /a>

it's a cool Feature..

Error Handling in Asp.Net

noreply@blogger.com (Manoj Kumar Joshi) — Wed, 15 Apr 2009 10:54:00 +0000

Asp.Net provide there way of handling errors. We can handle error at
1) Page Level
2) Application Level
3) Through Web.Confing

1) Page Level Error Handling :

We can handle error at page level so that if any error comes under the page scope it will handle through the OnError Method of page, But its only at page level not outside that scope. Whenever we create a web form its class drive from System.Web.UI.Page and that why page object help us to invoke page level error. What we do we override OnError method of the page. Like

protected override void OnError(EventArgs e)
{
Exception objException = Server.GetLastError (); // Return Current Exception

string errorDescription =
"Source of Error:" + objException.Source +
"Message : " + objException.Message +
"Stack trace: " + objException.StackTrace;

Response.Write (errorDescription); // Or you can log the Error or redirect to somewhere else/

}

2) Application Level Error Handling :

Another approach for error handling is at application level. Whenever any Error comes Application_Error sub called. Its a good place for handling error because no need to write it on every page. It Works something like that:

void Application_Error(object sender, EventArgs e)
{
Exception objException = Server.GetLastError (); // Return Current Exception

string errorDescription =
"Source of Error: " + objException.Source +
"Message : " + objException.Message +
"Stack trace: " + objException.StackTrace;

// After that use that Error errorDescription as you want eithr make log or redirect to somewhere else/

}
3) Web.Config Custom Errors

Third place is Web.Config, it enables us to configure html error pages to be displayed in place of a error stack trace Yellow page(really developer hate this). Through it we can handle error on specific code or we can create a single page for handling all the Error.

When we create a new website it looks like
Here we have mode attribute which can be "On|Off|RemoteOnly"

"RemoteOnly" options is the default option. Specifies that custom errors are shown only to remote clients, and ASP.NET errors are shown to the local host
"On" option shows custom errors are enabled.

"Off" Specifies custom errors are disabled.

We can handle errors based on specific code like that:

< customErrors mode="On" >
< error statusCode="403" redirect="NoAccess.htm" />
< error statusCode="404" redirect="FileNotFound.aspx" />
< error statusCode="500" redirect="GenericErrorPage.htm"/>

or We can use a single page redirect for all the Errors

< customErrors mode="On" defaultRedirect="ForAllError.htm" />

Stay away from Errors now
Keep Happy and Programming:)

Identify Mobile Browser or Iphone using c# Code

noreply@blogger.com (Manoj Kumar Joshi) — Tue, 14 Apr 2009 15:09:00 +0000

Recently i created a mobile browser compatible website for our existing Website.
So as we already marketed our website well for desktop browser but not for Iphone or other Mobile device so we started doing that. Now what client want that whenever any person open our website on mobile device it will redirect to Iphone compatible website
So what, I Just write these lines of code:

if (HttpContext.Current.Request.Browser.IsMobileDevice || HttpContext.Current.Request.UserAgent.ToLower().Contains("iphone"))
{
Response.Redirect("http://iphone.anjolee.com");
}

on the above code Line
HttpContext.Current.Request.Browser.IsMobileDevice detects the mobile devices but as our Iphone not detected through that so thats why i add one more line :
HttpContext.Current.Request.UserAgent.ToLower().Contains("iphone")
Which detects the Iphone you can use this one for other mobile device not supported by .NET

Import data from Excel to SQl Server

noreply@blogger.com (Manoj Kumar Joshi) — Tue, 14 Apr 2009 13:58:00 +0000

Facing problem while importing table data from Excel to Sql Server.
Some time we have some fields on Excel which contain data which is not supported by
Sql Server like single qote('). I take it just as a example. So i write a program
in c# which collects data from excel table read it make changes on data if we need and insert it to SQL. Problem is basically
that if we have lakhs of record its not possible to edit them manually and then import to sql.

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// Connection String to Excel Workbook
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=YourExcelDataSource(like D:\\Detail.xls);Extended Properties=""Excel 8.0;HDR=YES;""";
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
{
OleDbCommand command = new OleDbCommand("Select * FROM [Data$]", connection);

connection.Open();
DataSet ds = new DataSet();

OleDbDataAdapter oda = new OleDbDataAdapter(command);
oda.Fill(ds);

string sqlConnectionString = "Data Source= SqlDataSource; Initial Catalog=DataBaseName;uid=Userid; Password=pwd";

SqlConnection con = new SqlConnection(sqlConnectionString);
con.Open();

for (int c = 0;c < ds.Tables[0].Rows.Count;c++)
{
try
{
DataRow dro = ds.Tables[0].Rows[c];

object[] array = ds.Tables[0].Rows[c].ItemArray; //Break Table to array

string str = "insert into tableName values(";

for (int k = 1; k < array.Length; k++)
{
if (array[k].ToString().Contains("'"))
{
array[k] = array[k].ToString().Replace("'", "''");
}

str = str+"'"+ array[k] + "',";
}

str = str.Substring(0, str.Length - 1);
str = str + ")";
SqlCommand com = new SqlCommand(str);
com.Connection = con;
com.ExecuteNonQuery();
}
catch(Exception ex)
{
continue;
}
}
//}
}
}
}

Validation of viewstate MAC failed / The state information is invalid for this page and might be corrupted Problem

noreply@blogger.com (Manoj Kumar Joshi) — Tue, 14 Apr 2009 13:37:00 +0000

facing a new problem
Validation of viewstate MAC failed / The state information is invalid for this page and might be corrupted

I face this problem long time ago. My websites woriking well at my end in India office and on my client system also. But problem was that it was not working on some system (another office) and they told me that they face some problem (Site through errors) as i use custom error so the error will not display but site was not working. The error we got was
Validation of viewstate MAC failed / The state information is invalid for this page and might be corrupted

So i worked on that and got the answer (after googling). Just add it to your webconfig file: -
pages validateRequest="false" enableEventValidation="false" viewStateEncryptionMode="Never" enableViewStateMac="false" />

and problem resolved

IE8 Compatibility Problem

noreply@blogger.com (Manoj Kumar Joshi) — Tue, 14 Apr 2009 13:10:00 +0000

Hi,
Have u in trouble due to not working of your site on IE8 (but Working well on IE7). Here is the
solution (I faced in one of my project).
Just add a HTTP-EQUIV meta tag on your master page if you have or place it on your page
meta equiv="X-UA-Compatible" content="IE=EmulateIE7"/>
and see your website working on IE8 .
Keep Smiling and Programming :)

Its all about .Net (Share your Knowldge here)

noreply@blogger.com (Manoj Kumar Joshi) — Tue, 14 Apr 2009 12:32:00 +0000

Hi,
Share your views, Knowldge and problems here

Thanks