ASP.Net with C#

ASP.NET With JQuery

2009-10-13T23:01:00.000-07:00

Hello Frnds,
Here I post you reference link of article which give good example of how to implement asp.net with jquery.

I know some of the people are aware of it but still I post link of that article here.
http://www.dotnetcurry.com/BrowseArticles.aspx?CatID=63

Kinjal Shah
(Asp.Net Developer)

Ajax Style File Upload

2009-10-01T04:19:00.000-07:00

Hello Friends,
I need to implement file upload functionality using ajax. So after doing some RND on it then I will come with solutions.

Here I post live sample of ajax style file upload.

ASPX File:-uploadtest.aspx

   1:  <%@ Page Language="C#" AutoEventWireup="true" CodeFile="uploadtest.aspx.cs" Inherits="uploadtest" %>

2:

   3:  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

   4:  <html xmlns="http://www.w3.org/1999/xhtml">

   5:  <head runat="server">

   6:      <title></title>

7:

   8:      <script language="javascript" type="text/javascript">

9:

  10:          function onerror(args, context) {

  11:              document.getElementById("<%=message.ClientID %>").innerHTML = "Upload Failed";

  12:          }

  13:          function results(args, context) {

  14:              document.getElementById("<%=message.ClientID %>").innerHTML = "File has been uploaded successfully";

  15:          }

  16:          function Button1_onclick() {

  17:              arguments = document.getElementById("path").value + "/" + document.getElementById("File1").value;

  18:              <%= cbref %>

  19:          }

  20:      </script>

  21:  </head>

  22:  <body>

  23:      <form id="form1" runat="server">

  24:      <div>

  25:          <input type="text" id="path" value="" />

  26:          <input id="File1" type="file" />

  27:          <input id="Button1" type="button" value="upload" onclick="return Button1_onclick()" />

  28:      </div>

  29:      <span id="message" runat="server"></span>

  30:      <script language="javascript" type="text/javascript">

  31:          document.getElementById("<%=message.ClientID %>").innerHTML = "";

  32:      </script>

  33:      </form>

  34:  </body>

  35:  </html>

CS File:-uploadtest.aspx.cs

   1:  using System;

   2:  using System.Collections.Generic;

   3:  using System.Linq;

   4:  using System.Web;

   5:  using System.Web.UI;

   6:  using System.Web.UI.WebControls;

   7:  using System.Web.UI.HtmlControls;

   8:  using System.Net;

9:

  10:  public partial class uploadtest : System.Web.UI.Page, ICallbackEventHandler

  11:  {

  12:      protected string cbref = string.Empty;

  13:      protected void Page_Load(object sender, EventArgs e)

  14:      {

15:

  16:          ClientScriptManager csm = Page.ClientScript;

  17:          cbref = csm.GetCallbackEventReference(this, "arguments", "results", null, "onerror", true);

  18:      }

19:

20:

  21:      #region ICallbackEventHandler Members

22:

  23:      public string GetCallbackResult()

  24:      {

  25:          return cbref;

  26:      }

27:

  28:      public void RaiseCallbackEvent(string eventArgument)

  29:      {

  30:          System.Net.WebClient wc = new System.Net.WebClient();

  31:          wc.UploadFile("http://localhost:2830/Amadeus/uploadfile.aspx", "POST", eventArgument);

  32:      }

33:

  34:      #endregion

  35:  }

Now here is an uploadfile.aspx.cs where file upload start.

   1:  using System;

   2:  using System.Collections.Generic;

   3:  using System.Linq;

   4:  using System.Web;

   5:  using System.Web.UI;

   6:  using System.Web.UI.WebControls;

   7:  using System.Web.UI.HtmlControls;

8:

   9:  public partial class uploadfile : System.Web.UI.Page

  10:  {

  11:      protected void Page_Load(object sender, EventArgs e)

  12:      {

  13:          HttpPostedFile myfile = Request.Files[0];

  14:          string path = Server.MapPath("~/upload");

  15:          if (!System.IO.Directory.Exists(path))

  16:          {

  17:              System.IO.Directory.CreateDirectory(path);

  18:          }

  19:          string filename = myfile.FileName;

  20:          string fullpath = System.IO.Path.Combine(path, filename);

  21:          myfile.SaveAs(fullpath);

  22:      }

  23:  }

I hopes this will help you :)
Happy Programming...!

Reference : - http://www.dotnetfunda.com/articles/article484-ajax-style-fileupload.aspx

Regards,
Kinjal Shah

Create Custom control

2009-09-23T05:08:00.000-07:00

Hello frnds,
I think most of people who need to make textbox value as a mandatory then they are use required field validator in each page. But at my point of view this is not good and so that I came with proper solution. I have create on class file in which I inherited textbox web server control and made that textbox control value with mandatory.

Here I post sample example of it and I hopes it will help you also.

Class File : TextControl.CS
Whenever you add any class file then it will prompt you to add app_code folder. So for that click on no.

   1:  using System;

   2:  using System.Collections.Generic;

   3:  using System.Linq;

   4:  using System.Web;

   5:  using System.Web.UI.WebControls;

   6:  /// <summary>

   7:  /// Summary description for TextControl

   8:  /// </summary>

   9:  ///

10:

11:

  12:  namespace ControlValidator

  13:  {

14:

  15:      public class TextControl:TextBox

  16:      {

  17:          public bool Required { get; set; }

  18:          public string ErrorMessage { get; set; }

19:

  20:          private RequiredFieldValidator RequiredFieldValidator;

  21:          protected override void OnInit(EventArgs e)

  22:          {

  23:              if (this.Required)

  24:              {

  25:                  RequiredFieldValidator = new RequiredFieldValidator();

  26:                  RequiredFieldValidator.ControlToValidate = this.ID;

  27:                  RequiredFieldValidator.ErrorMessage = this.ErrorMessage;

  28:                  Controls.Add(RequiredFieldValidator);

  29:              }

  30:          }

31:

  32:          protected override void Render(System.Web.UI.HtmlTextWriter writer)

  33:          {

  34:              base.Render(writer);

  35:              if (this.Required)

  36:              {

  37:                  RequiredFieldValidator.RenderControl(writer);

  38:              }

  39:          }

  40:      }

41:

42:

  43:  }

After that u need to create dll file for this class file using following command.
I hopes you current prompt is you working webapp path.

C:\Documents and Settings\kinjal.SOLUTIONS.000\My Documents\Downloads\MyCustomControls\MyCustomControls>
csc /out:bin\ControlValidator.dll /target:library /r:system.dll TextControl.cs

After that you add default.aspx file
File Name : Default.aspx

   1:  <%@ Register Namespace="ControlValidator" Assembly="ControlValidator" TagPrefix="Control" %>

2:

   3:  <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

4:

   5:  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

   6:  <html xmlns="http://www.w3.org/1999/xhtml">

   7:  <head runat="server">

   8:      <title></title>

   9:  </head>

  10:  <body>

  11:      <form id="form1" runat="server">

  12:      <div>

  13:          <Control:TextControl runat="server" ID="txtName" Required="true" ErrorMessage="Name Is Required"></Control:TextControl>

  14:          <br />

  15:          <asp:Button ID="btnOk" runat="server" Text="Click me" />

  16:      </div>

  17:      </form>

  18:  </body>

  19:  </html>

Happy Programming and coding...!

Date Calculation

2009-09-13T11:49:00.000-07:00

Please ignore this post due to not proper format and proper instruction.

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections;
using System.Collections.Generic;
using System.Globalization;
public partial class _Default : System.Web.UI.Page
{
List<string> ListDay = new List<string>();
List<string> ListMonth = new List<string>();

List<ShowDate> ListDate = new List<ShowDate>();

string[] dayArr = { "sunday", "monday", "tuesday", "wednesday", "thursday", "friday", "saturday" };
string[] monthArr = { "january", "february", "march", "april", "may", "june", "july", "august", "september", "october", "november", "december" };

Hashtable HTWeekDay = new Hashtable();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DateTime DT = DateTime.Now;
DT = GetFirstDateOfWeek(DT);

System.Globalization.CultureInfo ci = System.Threading.Thread.CurrentThread.CurrentCulture;

object index = DateTime.Now;
string r = String.Format("ww", index);
int res = getPreviousWeekNumber(index);

//0 First day of year
res = System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(
Convert.ToDateTime(index), System.Globalization.CalendarWeekRule.FirstDay, System.Globalization.DateTimeFormatInfo.CurrentInfo.FirstDayOfWeek);

res = System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(
Convert.ToDateTime(index), System.Globalization.CalendarWeekRule.FirstDay, DayOfWeek.Sunday);
DateTime curMonth = Convert.ToDateTime(DateTime.Today.Year.ToString() + "-09-07");
//Calendar1.VisibleDate = curMonth;
Response.Write(getISOWeek(curMonth).ToString());

int week = ci.Calendar.GetWeekOfYear(DateTime.Now , ci.DateTimeFormat.CalendarWeekRule, ci.DateTimeFormat.FirstDayOfWeek);

//Convert.ToDateTime(index), System.Globalization.CalendarWeekRule.FirstDay, System.Globalization.DateTimeFormatInfo.CurrentInfo.FirstDayOfWeek);

HTWeekDay.Add("FirstWeekDay", "1");
HTWeekDay.Add("SecondWeekDay", "2");
HTWeekDay.Add("ThirdWeekDay", "3");
HTWeekDay.Add("FourthWeekDay", "4");
foreach (string day in dayArr)
{
ListDay.Add(day);
}

foreach (string month in monthArr)
{
ListMonth.Add(month);
}

// foreach (string weekday in weekArr)
// {
// ListWeekDay.Add(weekday);
// }
drpDay.DataSource = ListDay;
drpDay.DataBind();
drpDay.Items.Insert(0, new ListItem("ALL", "0"));
drpMonth.DataSource = ListMonth;
drpMonth.DataBind();
drpMonth.Items.Insert(0, new ListItem("ALL", "0"));
drpDay.SelectedValue = "0";
drpMonth.SelectedValue = "0";

drpWeekDay.DataSource = HTWeekDay;
drpWeekDay.DataTextField = "key";
drpWeekDay.DataValueField = "value";
drpWeekDay.DataBind();
drpWeekDay.Items.Insert(0, new ListItem("ALL", "0"));
drpWeekDay.SelectedValue = "0";

}
}
protected void btnClick_Click(object sender, EventArgs e)
{
DateTime FromDt = CalFromDt.SelectedDate;
//Response.Write((CalToDt.SelectedDate-FromDt).Days);
string day = string.Empty;
string month = string.Empty;
while ((CalToDt.SelectedDate - FromDt).Days >= 0)
{
day = FromDt.DayOfWeek.ToString().ToLower();
month = FromDt.ToString("MMMM").ToLower();
if (!drpDay.SelectedValue.Equals("0"))
{
if (!drpMonth.SelectedValue.Equals("0"))
{
if (month.Equals(drpMonth.SelectedValue) && day.Equals(drpDay.SelectedValue))
{
ShowDateBasedonsingleCriteria(FromDt);
}
}
else if (day.Equals(drpDay.SelectedValue))
{
ShowDateBasedonsingleCriteria(FromDt);
}
}
else if (!drpMonth.SelectedValue.Equals("0"))
{
if (month.Equals(drpMonth.SelectedValue))
{
ShowDateBasedonsingleCriteria(FromDt);
}
}
else if (!drpWeekDay.SelectedValue.Equals("0"))
{
int weekday = System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(FromDt, CalendarWeekRule.FirstDay, System.Globalization.DateTimeFormatInfo.CurrentInfo.FirstDayOfWeek);
if (weekday == 0) { weekday = 5; }
Math.DivRem(weekday, 5, out weekday);
if (weekday.ToString().Equals(drpWeekDay.SelectedValue))
{
ShowDateBasedonsingleCriteria(FromDt);
}
}
else
{
ShowDateBasedonsingleCriteria(FromDt);
}

FromDt = FromDt.AddDays(1);
}
gv.DataSource = ListDate;
gv.DataBind();
//lblDiff.Text = (CalToDt.SelectedDate - CalFromDt.SelectedDate).ToString();

}

private void ShowDateBasedonsingleCriteria(DateTime FromDt)
{
ShowDate objshowdate = new ShowDate();
objshowdate.rownumber = 1;
objshowdate.date = FromDt.ToString("dd/MM/yyyy");
ListDate.Add(objshowdate);
}

private int getPreviousWeekNumber(Object Date)
{
DateTime dtSend;
try
{
dtSend = Convert.ToDateTime(Date);
}
catch (Exception)
{
throw new Exception("Please give Valid Date");
}
object dtLastWeek = dtSend.AddDays(-7); // Am adding -7 Days because it exactly a 7 Days back from to Day

return System.Globalization.CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(
Convert.ToDateTime(dtLastWeek), System.Globalization.CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Sunday);
}

public class ShowDate
{
public int rownumber { get; set; }
public string date { get; set; }
}

public static DateTime GetFirstDateOfWeek(DateTime dayInWeek)
{

CultureInfo defaultCultureInfo = CultureInfo.CurrentCulture;

return GetFirstDateOfWeek(dayInWeek, defaultCultureInfo);

}

public static DateTime GetFirstDateOfWeek(DateTime dayInWeek, CultureInfo cultureInfo)
{

DayOfWeek firstDay = cultureInfo.DateTimeFormat.FirstDayOfWeek;

DateTime firstDateInWeek = dayInWeek.Date;

while (firstDateInWeek.DayOfWeek != firstDay)

firstDateInWeek = firstDateInWeek.AddDays(-1);

return firstDateInWeek;

}

public int getISOWeek(DateTime day)
{
return CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(day, System.Globalization.CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);
}

}

Read XmlNode and bind in gridview

2009-09-12T02:36:00.000-07:00

Please ignore this post.
cs file
------------------
using System;
using System.Collections.Generic;
using System.Linq;

   1:  using System.Web;

   2:  using System.Web.UI;

   3:  using System.Web.UI.WebControls;

4:

   5:  using System.Text.RegularExpressions;

   6:  using System.Reflection;

   7:  using System.IO;

   8:  using System.Text;

   9:  using System.Net;

  10:  using System.Data;

11:

  12:  using System.Xml;

  13:  public partial class _Default : System.Web.UI.Page

  14:  {

15:

  16:      protected void Page_Load(object sender, EventArgs e)

  17:      {

18:

  19:          List<AirFareSelection> ListAirFareSelection = new List<AirFareSelection>() ;

  20:          /*

  21:          DataTable DTAirFareSelection = new DataTable("DTAirFareSelection");

22:

  23:          DataColumn departureDate = new DataColumn();

  24:          departureDate.ColumnName = "departureDate";

  25:          departureDate.DataType = typeof(string);

26:

  27:          DataColumn departureTime = new DataColumn();

  28:          departureTime.ColumnName = "departureTime";

  29:          departureTime.DataType = typeof(string);

30:

  31:          DataColumn arrivalDate = new DataColumn();

  32:          arrivalDate.ColumnName = "arrivalDate";

  33:          arrivalDate.DataType = typeof(string);

34:

  35:          DataColumn arrivalTime = new DataColumn();

  36:          arrivalTime.ColumnName = "arrivalTime";

  37:          arrivalTime.DataType = typeof(string);

38:

  39:          DataColumn departureLocation = new DataColumn();

  40:          departureLocation.ColumnName = "departureLocation";

  41:          departureLocation.DataType = typeof(string);

42:

  43:          DataColumn arrivalLocation = new DataColumn();

  44:          arrivalLocation.ColumnName = "arrivalLocation";

  45:          arrivalLocation.DataType = typeof(string);

46:

  47:          DataColumn flightnumber = new DataColumn();

  48:          flightnumber.ColumnName = "flightnumber";

  49:          flightnumber.DataType = typeof(string);

50:

  51:          DataColumn marketingCompany = new DataColumn();

  52:          marketingCompany.ColumnName = "marketingCompany";

  53:          marketingCompany.DataType = typeof(string);

54:

  55:          DataColumn numberofstop = new DataColumn();

  56:          numberofstop.ColumnName = "numberofstop";

  57:          numberofstop.DataType = typeof(int);

58:

  59:          DTAirFareSelection.Columns.Add(departureDate);

  60:          DTAirFareSelection.Columns.Add(departureTime);

  61:          DTAirFareSelection.Columns.Add(arrivalDate);

  62:          DTAirFareSelection.Columns.Add(arrivalTime);

  63:          DTAirFareSelection.Columns.Add(departureLocation);

  64:          DTAirFareSelection.Columns.Add(arrivalLocation);

  65:          DTAirFareSelection.Columns.Add(flightnumber);

  66:          DTAirFareSelection.Columns.Add(marketingCompany);

  67:          DTAirFareSelection.Columns.Add(numberofstop);

  68:          */

69:

70:

  71:          //String sessionid1 = Security_Authenticate(wsap1, "WS1APOC", "NCEP02001", "MnJPRWJyaSZXb1V0", "12");

  72:          /*string sessionid1 = Security_Authenticate(wsap2, "WS1ATES", "NCE1A0950", "QU1BREVVUw==", "7");*/

  73:          string sessionid1 = AmadeusService.Security_Authenticate(AmadeusService.wsap2, AmadeusService.user, AmadeusService.office, AmadeusService.password, AmadeusService.passlen);

74:

  75:          String xml = "<Air_MultiAvailability>"

  76:                      + "<messageActionDetails>"

  77:                        + "<functionDetails>"

  78:                          + "<actionCode>44</actionCode>"

  79:                      + "</functionDetails>"

  80:                    + "</messageActionDetails>"

  81:                      + "<requestSection>"

  82:                        + "<availabilityProductInfo>"

  83:                          + "<availabilityDetails>"

  84:                            + "<departureDate>220909</departureDate>"

  85:                        + "</availabilityDetails>"

  86:                          + "<departureLocationInfo>"

  87:                            + "<cityAirport>CAK</cityAirport>"

  88:                        + "</departureLocationInfo>"

  89:                          + "<arrivalLocationInfo>"

  90:                            + "<cityAirport>CUN</cityAirport>"

  91:                        + "</arrivalLocationInfo>"

  92:                      + "</availabilityProductInfo>"

  93:                        + "<availabilityOptions>"

  94:                          + "<productTypeDetails>"

  95:                            + "<typeOfRequest>TD</typeOfRequest>"

  96:                        + "</productTypeDetails>"

  97:                      + "</availabilityOptions>"

  98:                    + "</requestSection>"

  99:                  + "</Air_MultiAvailability>";

 100:

 101:

 102:

 103:          /*String result = Command_Cryptic(wsap1, sessionid1, xml);*/

 104:

 105:          String result = AmadeusService.SendQuery(AmadeusService.wsap2, sessionid1, xml);

 106:          result = GetFlightInfo(result);

 107:

 108:          XmlDocument xmldocument = new XmlDocument();

 109:          xmldocument.LoadXml(result);

 110:

 111:          XmlNodeList nodelist = xmldocument.SelectNodes("flight/flightInfo");

 112:          int count = 0;

 113:          foreach (XmlNode node in nodelist)

 114:          {

 115:

 116:

 117:           //   DataRow dr = DTAirFareSelection.NewRow();

 118:              string departuredate = GetNodeValue(node.InnerXml, "departureDate");

 119:              departuredate = departuredate.Substring(departuredate.IndexOf('>') + 1, 6);

 120:              string departuretime = GetNodeValue(node.InnerXml, "departureTime");

 121:              departuretime = departuretime.Substring(departuretime.IndexOf('>') + 1, 4);

 122:              string arrivaldate = GetNodeValue(node.InnerXml, "arrivalDate");

 123:              arrivaldate = arrivaldate.Substring(arrivaldate.IndexOf('>') + 1, 6);

 124:              string arrivaltime = GetNodeValue(node.InnerXml, "arrivalTime");

 125:              arrivaltime = arrivaltime.Substring(arrivaltime.IndexOf('>') + 1, 4);

 126:              string departurelocation = GetNodeValue(node.InnerXml, "departureLocation");

 127:              departurelocation = departurelocation.Substring(departurelocation.IndexOf("<cityAirport>") + 13, 3);

 128:

 129:              string arrivallocation = GetNodeValue(node.InnerXml, "arrivalLocation");

 130:              arrivallocation = arrivallocation.Substring(arrivallocation.IndexOf("<cityAirport>") + 13, 3);

 131:              string identifier = GetNodeValue(node.InnerXml, "identifier");

 132:              identifier = identifier.Substring(identifier.IndexOf('>') + 1, 2);

 133:              string number = GetNodeValue(node.InnerXml, "number");

 134:              number = number.Substring(number.IndexOf('>') + 1,4);

 135:

 136:              if (departurelocation.Equals("CAK"))

 137:              {

 138:                  AirFareSelection OBJAirFareSelection = new AirFareSelection();

 139:                  OBJAirFareSelection.departureDate = departuredate;

 140:                  OBJAirFareSelection.departureTime = departuretime;

 141:                  OBJAirFareSelection.arrivalDate = arrivaldate;

 142:                  OBJAirFareSelection.arrivalTime = arrivaltime;

 143:                  OBJAirFareSelection.departureLocation = departurelocation;

 144:                  OBJAirFareSelection.arrivalLocation = arrivallocation;

 145:                  OBJAirFareSelection.marketingCompany = identifier;

 146:                  OBJAirFareSelection.flightnumber = number;

 147:                  OBJAirFareSelection.numberofstop = 0;

 148:                  ListAirFareSelection.Add(OBJAirFareSelection);

 149:                  count = count + 1;

 150:              }

 151:              else

 152:              {

 153:                  ListAirFareSelection.ToList()[count - 1].arrivalLocation = arrivallocation;

 154:                  ListAirFareSelection.ToList()[count - 1].numberofstop = ListAirFareSelection.ToList()[count - 1].numberofstop + 1;

 155:

 156:                  //  .Rows[count - 1]["numberofstop"] = Convert.ToInt32(DTAirFareSelection.Rows[count - 1]["numberofstop"]) + 1;

 157:                  //DTAirFareSelection.Rows[count - 1]["arrivalLocation"] = arrivallocation;

 158:              }

 159:              /*

 160:              if (departurelocation.Equals("JFK"))

 161:              {

 162:                  dr["departureDate"] = departuredate;

 163:                  dr["departureTime"] = departuretime;

 164:                  dr["arrivalDate"] = arrivaldate;

 165:                  dr["arrivalTime"] = arrivaltime;

 166:                  dr["departureLocation"] = departurelocation;

 167:                  dr["arrivalLocation"] = arrivallocation;

 168:

 169:                  dr["marketingCompany"] = identifier;

 170:                  dr["flightnumber"] = number;

 171:

 172:                  dr["numberofstop"] = 0;

 173:

 174:

 175:                  DTAirFareSelection.Rows.Add(dr);

 176:                  count = count + 1;

 177:              }

 178:              else

 179:              {

 180:                  DTAirFareSelection.Rows[count - 1]["numberofstop"] = Convert.ToInt32(DTAirFareSelection.Rows[count - 1]["numberofstop"]) + 1;

 181:                  DTAirFareSelection.Rows[count - 1]["arrivalLocation"] = arrivallocation;

 182:              }

 183:            *

 184:            * */

 185:

 186:              Response.Write(departuredate + " -> ");

 187:              Response.Write(departuretime + " -> ");

 188:              Response.Write(arrivaldate + " -> ");

 189:              Response.Write(arrivaltime + " -> ");

 190:              Response.Write(departurelocation + " -> ");

 191:              Response.Write(arrivallocation + " -> ");

 192:              Response.Write(identifier + " -> ");

 193:              Response.Write(number + " <br/>");

 194:

 195:          }

 196:          gv.DataSource = ListAirFareSelection.ToList();

 197:          gv.DataBind();

 198:

 199:          AmadeusService.Security_SignOut(AmadeusService.wsap2, sessionid1);

 200:

 201:      }

 202:      public static String GetFlightInfo(String response)

 203:      {

 204:          String flightinfo = "<?xml version=\"1.0\"?><flight>";

 205:

 206:          Regex regex = new Regex("<flightInfo>.*</flightInfo>");

 207:          Match m = regex.Match(response);

 208:          if (m.Success)

 209:              flightinfo += m.Value;

 210:          else

 211:              return "";

 212:          flightinfo += "</flight>";

 213:          return flightinfo;

 214:      }

 215:

 216:      public static String GetNodeValue(String response, string node)

 217:      {

 218:          string nodevalue;

 219:          Regex regex = new Regex("<" + node + ">.*</" + node + ">");

 220:          Match m = regex.Match(response);

 221:          if (m.Success)

 222:              nodevalue = m.Value;

 223:          else

 224:              return "";

 225:          return nodevalue;

 226:      }

 227:

 228:      public class AirFareSelection

 229:      {

 230:          public string departureDate { get; set; }

 231:          public string departureTime { get; set; }

 232:          public string arrivalDate { get; set; }

 233:          public string arrivalTime { get; set; }

 234:          public string departureLocation { get; set; }

 235:          public string arrivalLocation { get; set; }

 236:          public string marketingCompany { get; set; }

 237:          public string flightnumber { get; set; }

 238:          public int numberofstop { get; set; }

 239:      }

 240:  }

/* XML FILE */

   1:  <flight>

   2:  - <flightInfo>

   3:  - <basicFlightInfo>

   4:  - <flightDetails>

   5:    <departureDate>211009</departureDate>

   6:    <departureTime>0545</departureTime>

   7:    <arrivalDate>211009</arrivalDate>

   8:    <arrivalTime>0900</arrivalTime>

   9:    </flightDetails>

  10:  - <departureLocation>

  11:    <cityAirport>JFK</cityAirport>

  12:    </departureLocation>

  13:  - <arrivalLocation>

  14:    <cityAirport>MIA</cityAirport>

  15:    </arrivalLocation>

  16:  - <marketingCompany>

  17:    <identifier>AA</identifier>

  18:    </marketingCompany>

  19:  - <flightIdentification>

  20:    <number>1033</number>

  21:    </flightIdentification>

  22:  - <productTypeDetail>

  23:    <productIndicators>S</productIndicators>

  24:    <productIndicators>ET</productIndicators>

  25:    </productTypeDetail>

  26:    <lineItemNumber>1</lineItemNumber>

  27:    </basicFlightInfo>

  28:  - <infoOnClasses>

  29:  - <productClassDetail>

  30:    <serviceClass>F</serviceClass>

  31:    <availabilityStatus>7</availabilityStatus>

  32:    </productClassDetail>

  33:    </infoOnClasses>

  34:  - <infoOnClasses>

  35:  - <productClassDetail>

  36:    <serviceClass>A</serviceClass>

  37:    <availabilityStatus>7</availabilityStatus>

  38:    </productClassDetail>

  39:    </infoOnClasses>

  40:  - <infoOnClasses>

  41:  - <productClassDetail>

  42:    <serviceClass>Y</serviceClass>

  43:    <availabilityStatus>7</availabilityStatus>

  44:    </productClassDetail>

  45:    </infoOnClasses>

  46:  - <infoOnClasses>

  47:  - <productClassDetail>

  48:    <serviceClass>B</serviceClass>

  49:    <availabilityStatus>7</availabilityStatus>

  50:    </productClassDetail>

  51:    </infoOnClasses>

  52:  - <infoOnClasses>

  53:  - <productClassDetail>

  54:    <serviceClass>H</serviceClass>

  55:    <availabilityStatus>7</availabilityStatus>

  56:    </productClassDetail>

  57:    </infoOnClasses>

  58:  - <infoOnClasses>

  59:  - <productClassDetail>

  60:    <serviceClass>K</serviceClass>

  61:    <availabilityStatus>7</availabilityStatus>

  62:    </productClassDetail>

  63:    </infoOnClasses>

  64:  - <infoOnClasses>

  65:  - <productClassDetail>

  66:    <serviceClass>M</serviceClass>

  67:    <availabilityStatus>7</availabilityStatus>

  68:    </productClassDetail>

  69:    </infoOnClasses>

  70:  - <infoOnClasses>

  71:  - <productClassDetail>

  72:    <serviceClass>L</serviceClass>

  73:    <availabilityStatus>7</availabilityStatus>

  74:    </productClassDetail>

  75:    </infoOnClasses>

  76:  - <infoOnClasses>

  77:  - <productClassDetail>

  78:    <serviceClass>V</serviceClass>

  79:    <availabilityStatus>7</availabilityStatus>

  80:    </productClassDetail>

  81:    </infoOnClasses>

  82:  - <infoOnClasses>

  83:  - <productClassDetail>

  84:    <serviceClass>W</serviceClass>

  85:    <availabilityStatus>7</availabilityStatus>

  86:    </productClassDetail>

  87:    </infoOnClasses>

  88:  - <infoOnClasses>

  89:  - <productClassDetail>

  90:    <serviceClass>G</serviceClass>

  91:    <availabilityStatus>7</availabilityStatus>

  92:    </productClassDetail>

  93:    </infoOnClasses>

  94:  - <infoOnClasses>

  95:  - <productClassDetail>

  96:    <serviceClass>S</serviceClass>

  97:    <availabilityStatus>7</availabilityStatus>

  98:    </productClassDetail>

  99:    </infoOnClasses>

 100:  - <infoOnClasses>

 101:  - <productClassDetail>

 102:    <serviceClass>N</serviceClass>

 103:    <availabilityStatus>7</availabilityStatus>

 104:    </productClassDetail>

 105:    </infoOnClasses>

 106:  - <infoOnClasses>

 107:  - <productClassDetail>

 108:    <serviceClass>Q</serviceClass>

 109:    <availabilityStatus>7</availabilityStatus>

 110:    </productClassDetail>

 111:    </infoOnClasses>

 112:  - <infoOnClasses>

 113:  - <productClassDetail>

 114:    <serviceClass>O</serviceClass>

 115:    <availabilityStatus>7</availabilityStatus>

 116:    </productClassDetail>

 117:    </infoOnClasses>

 118:  - <additionalFlightInfo>

 119:  - <flightDetails>

 120:    <typeOfAircraft>757</typeOfAircraft>

 121:    <numberOfStops>0</numberOfStops>

 122:    <onTimePercentage>8</onTimePercentage>

 123:    </flightDetails>

 124:  - <departureStation>

 125:    <terminal>8</terminal>

 126:    </departureStation>

 127:  - <productFacilities>

 128:    <type>AS</type>

 129:    </productFacilities>

 130:  - <productFacilities>

 131:    <type>DA</type>

 132:    </productFacilities>

 133:  - <productFacilities>

 134:    <type>LSA</type>

 135:    </productFacilities>

 136:  - <productFacilities>

 137:    <type>M</type>

 138:    </productFacilities>

 139:    </additionalFlightInfo>

 140:    </flightInfo>

 141:  - <flightInfo>

 142:  - <basicFlightInfo>

 143:  - <flightDetails>

 144:    <departureDate>211009</departureDate>

 145:    <departureTime>1135</departureTime>

 146:    <arrivalDate>211009</arrivalDate>

 147:    <arrivalTime>1350</arrivalTime>

 148:    </flightDetails>

 149:  - <departureLocation>

 150:    <cityAirport>MIA</cityAirport>

 151:    </departureLocation>

 152:  - <arrivalLocation>

 153:    <cityAirport>PUJ</cityAirport>

 154:    </arrivalLocation>

 155:  - <marketingCompany>

 156:    <identifier>AA</identifier>

 157:    </marketingCompany>

 158:  - <flightIdentification>

 159:    <number>2415</number>

 160:    </flightIdentification>

 161:  - <productTypeDetail>

 162:    <productIndicators>E</productIndicators>

 163:    <productIndicators>ET</productIndicators>

 164:    </productTypeDetail>

 165:    </basicFlightInfo>

 166:  - <infoOnClasses>

 167:  - <productClassDetail>

 168:    <serviceClass>J</serviceClass>

 169:    <availabilityStatus>7</availabilityStatus>

 170:    </productClassDetail>

 171:    </infoOnClasses>

 172:  - <infoOnClasses>

 173:  - <productClassDetail>

 174:    <serviceClass>D</serviceClass>

 175:    <availabilityStatus>7</availabilityStatus>

 176:    </productClassDetail>

 177:    </infoOnClasses>

 178:  - <infoOnClasses>

 179:  - <productClassDetail>

 180:    <serviceClass>I</serviceClass>

 181:    <availabilityStatus>7</availabilityStatus>

 182:    </productClassDetail>

 183:    </infoOnClasses>

 184:  - <infoOnClasses>

 185:  - <productClassDetail>

 186:    <serviceClass>Y</serviceClass>

 187:    <availabilityStatus>7</availabilityStatus>

 188:    </productClassDetail>

 189:    </infoOnClasses>

 190:  - <infoOnClasses>

 191:  - <productClassDetail>

 192:    <serviceClass>B</serviceClass>

 193:    <availabilityStatus>7</availabilityStatus>

 194:    </productClassDetail>

 195:    </infoOnClasses>

 196:  - <infoOnClasses>

 197:  - <productClassDetail>

 198:    <serviceClass>H</serviceClass>

 199:    <availabilityStatus>7</availabilityStatus>

 200:    </productClassDetail>

 201:    </infoOnClasses>

 202:  - <infoOnClasses>

 203:  - <productClassDetail>

 204:    <serviceClass>K</serviceClass>

 205:    <availabilityStatus>7</availabilityStatus>

 206:    </productClassDetail>

 207:    </infoOnClasses>

 208:  - <infoOnClasses>

 209:  - <productClassDetail>

 210:    <serviceClass>M</serviceClass>

 211:    <availabilityStatus>7</availabilityStatus>

 212:    </productClassDetail>

 213:    </infoOnClasses>

 214:  - <infoOnClasses>

 215:  - <productClassDetail>

 216:    <serviceClass>L</serviceClass>

 217:    <availabilityStatus>7</availabilityStatus>

 218:    </productClassDetail>

 219:    </infoOnClasses>

 220:  - <infoOnClasses>

 221:  - <productClassDetail>

 222:    <serviceClass>V</serviceClass>

 223:    <availabilityStatus>7</availabilityStatus>

 224:    </productClassDetail>

 225:    </infoOnClasses>

 226:  - <infoOnClasses>

 227:  - <productClassDetail>

 228:    <serviceClass>W</serviceClass>

 229:    <availabilityStatus>7</availabilityStatus>

 230:    </productClassDetail>

 231:    </infoOnClasses>

 232:  - <infoOnClasses>

 233:  - <productClassDetail>

 234:    <serviceClass>G</serviceClass>

 235:    <availabilityStatus>7</availabilityStatus>

 236:    </productClassDetail>

 237:    </infoOnClasses>

 238:  - <infoOnClasses>

 239:  - <productClassDetail>

 240:    <serviceClass>S</serviceClass>

 241:    <availabilityStatus>7</availabilityStatus>

 242:    </productClassDetail>

 243:    </infoOnClasses>

 244:  - <infoOnClasses>

 245:  - <productClassDetail>

 246:    <serviceClass>N</serviceClass>

 247:    <availabilityStatus>7</availabilityStatus>

 248:    </productClassDetail>

 249:    </infoOnClasses>

 250:  - <infoOnClasses>

 251:  - <productClassDetail>

 252:    <serviceClass>Q</serviceClass>

 253:    <availabilityStatus>7</availabilityStatus>

 254:    </productClassDetail>

 255:    </infoOnClasses>

 256:  - <infoOnClasses>

 257:  - <productClassDetail>

 258:    <serviceClass>O</serviceClass>

 259:    <availabilityStatus>7</availabilityStatus>

 260:    </productClassDetail>

 261:    </infoOnClasses>

 262:  - <additionalFlightInfo>

 263:  - <flightDetails>

 264:    <typeOfAircraft>757</typeOfAircraft>

 265:    <numberOfStops>0</numberOfStops>

 266:    <legDuration>0805</legDuration>

 267:    </flightDetails>

 268:  - <productFacilities>

 269:    <type>AS</type>

 270:    </productFacilities>

 271:  - <productFacilities>

 272:    <type>DA</type>

 273:    </productFacilities>

 274:  - <productFacilities>

 275:    <type>LSA</type>

 276:    </productFacilities>

 277:  - <productFacilities>

 278:    <type>M</type>

 279:    </productFacilities>

 280:    </additionalFlightInfo>

 281:    </flightInfo>

 282:  - <flightInfo>

 283:  - <basicFlightInfo>

 284:  - <flightDetails>

 285:    <departureDate>211009</departureDate>

 286:    <departureTime>0600</departureTime>

 287:    <arrivalDate>211009</arrivalDate>

 288:    <arrivalTime>0724</arrivalTime>

 289:    </flightDetails>

 290:  - <departureLocation>

 291:    <cityAirport>JFK</cityAirport>

 292:    </departureLocation>

 293:  - <arrivalLocation>

 294:    <cityAirport>IAD</cityAirport>

 295:    </arrivalLocation>

 296:  - <marketingCompany>

 297:    <identifier>UA</identifier>

 298:    </marketingCompany>

 299:  - <flightIdentification>

 300:    <number>7811</number>

 301:    </flightIdentification>

 302:  - <productTypeDetail>

 303:    <productIndicators>S</productIndicators>

 304:    <productIndicators>702</productIndicators>

 305:    <productIndicators>ET</productIndicators>

 306:    </productTypeDetail>

 307:    <lineItemNumber>2</lineItemNumber>

 308:    </basicFlightInfo>

 309:  - <infoOnClasses>

 310:  - <productClassDetail>

 311:    <serviceClass>Y</serviceClass>

 312:    <availabilityStatus>9</availabilityStatus>

 313:    </productClassDetail>

 314:    </infoOnClasses>

 315:  - <infoOnClasses>

 316:  - <productClassDetail>

 317:    <serviceClass>H</serviceClass>

 318:    <availabilityStatus>9</availabilityStatus>

 319:    </productClassDetail>

 320:    </infoOnClasses>

 321:  - <infoOnClasses>

 322:  - <productClassDetail>

 323:    <serviceClass>Q</serviceClass>

 324:    <availabilityStatus>9</availabilityStatus>

 325:    </productClassDetail>

 326:    </infoOnClasses>

 327:  - <infoOnClasses>

 328:  - <productClassDetail>

 329:    <serviceClass>V</serviceClass>

 330:    <availabilityStatus>9</availabilityStatus>

 331:    </productClassDetail>

 332:    </infoOnClasses>

 333:  - <infoOnClasses>

 334:  - <productClassDetail>

 335:    <serviceClass>W</serviceClass>

 336:    <availabilityStatus>9</availabilityStatus>

 337:    </productClassDetail>

 338:    </infoOnClasses>

 339:  - <infoOnClasses>

 340:  - <productClassDetail>

 341:    <serviceClass>T</serviceClass>

 342:    <availabilityStatus>9</availabilityStatus>

 343:    </productClassDetail>

 344:    </infoOnClasses>

 345:  - <infoOnClasses>

 346:  - <productClassDetail>

 347:    <serviceClass>L</serviceClass>

 348:    <availabilityStatus>9</availabilityStatus>

 349:    </productClassDetail>

 350:    </infoOnClasses>

 351:  - <infoOnClasses>

 352:  - <productClassDetail>

 353:    <serviceClass>B</serviceClass>

 354:    <availabilityStatus>9</availabilityStatus>

 355:    </productClassDetail>

 356:    </infoOnClasses>

 357:  - <infoOnClasses>

 358:  - <productClassDetail>

 359:    <serviceClass>M</serviceClass>

 360:    <availabilityStatus>9</availabilityStatus>

 361:    </productClassDetail>

 362:    </infoOnClasses>

 363:  - <infoOnClasses>

 364:  - <productClassDetail>

 365:    <serviceClass>S</serviceClass>

 366:    <availabilityStatus>9</availabilityStatus>

 367:    </productClassDetail>

 368:    </infoOnClasses>

 369:  - <infoOnClasses>

 370:  - <productClassDetail>

 371:    <serviceClass>E</serviceClass>

 372:    <availabilityStatus>9</availabilityStatus>

 373:    </productClassDetail>

 374:    </infoOnClasses>

 375:  - <infoOnClasses>

 376:  - <productClassDetail>

 377:    <serviceClass>U</serviceClass>

 378:    <availabilityStatus>9</availabilityStatus>

 379:    </productClassDetail>

 380:    </infoOnClasses>

 381:  - <infoOnClasses>

 382:  - <productClassDetail>

 383:    <serviceClass>K</serviceClass>

 384:    <availabilityStatus>0</availabilityStatus>

 385:    </productClassDetail>

 386:    </infoOnClasses>

 387:  - <infoOnClasses>

 388:  - <productClassDetail>

 389:    <serviceClass>G</serviceClass>

 390:    <availabilityStatus>0</availabilityStatus>

 391:    </productClassDetail>

 392:    </infoOnClasses>

 393:  - <additionalFlightInfo>

 394:  - <flightDetails>

 395:    <typeOfAircraft>ER4</typeOfAircraft>

 396:    <numberOfStops>0</numberOfStops>

 397:    </flightDetails>

 398:  - <departureStation>

 399:    <terminal>7</terminal>

 400:    </departureStation>

 401:  - <productFacilities>

 402:    <type>AS</type>

 403:    </productFacilities>

 404:  - <productFacilities>

 405:    <type>DA</type>

 406:    </productFacilities>

 407:  - <productFacilities>

 408:    <type>LSA</type>

 409:    </productFacilities>

 410:    </additionalFlightInfo>

 411:    </flightInfo>

 412:  - <flightInfo>

 413:  - <basicFlightInfo>

 414:  - <flightDetails>

 415:    <departureDate>211009</departureDate>

 416:    <departureTime>0840</departureTime>

 417:    <arrivalDate>211009</arrivalDate>

 418:    <arrivalTime>1009</arrivalTime>

 419:    </flightDetails>

 420:  - <departureLocation>

 421:    <cityAirport>IAD</cityAirport>

 422:    </departureLocation>

 423:  - <arrivalLocation>

 424:    <cityAirport>CLT</cityAirport>

 425:    </arrivalLocation>

 426:  - <marketingCompany>

 427:    <identifier>UA</identifier>

 428:    </marketingCompany>

 429:  - <flightIdentification>

 430:    <number>7251</number>

 431:    </flightIdentification>

 432:  - <productTypeDetail>

 433:    <productIndicators>C</productIndicators>

 434:    <productIndicators>702</productIndicators>

 435:    <productIndicators>ET</productIndicators>

 436:    </productTypeDetail>

 437:    </basicFlightInfo>

 438:  - <infoOnClasses>

 439:  - <productClassDetail>

 440:    <serviceClass>F</serviceClass>

 441:    <availabilityStatus>5</availabilityStatus>

 442:    </productClassDetail>

 443:    </infoOnClasses>

 444:  - <infoOnClasses>

 445:  - <productClassDetail>

 446:    <serviceClass>Y</serviceClass>

 447:    <availabilityStatus>9</availabilityStatus>

 448:    </productClassDetail>

 449:    </infoOnClasses>

 450:  - <infoOnClasses>

 451:  - <productClassDetail>

 452:    <serviceClass>H</serviceClass>

 453:    <availabilityStatus>9</availabilityStatus>

 454:    </productClassDetail>

 455:    </infoOnClasses>

 456:  - <infoOnClasses>

 457:  - <productClassDetail>

 458:    <serviceClass>Q</serviceClass>

 459:    <availabilityStatus>9</availabilityStatus>

 460:    </productClassDetail>

 461:    </infoOnClasses>

 462:  - <infoOnClasses>

 463:  - <productClassDetail>

 464:    <serviceClass>V</serviceClass>

 465:    <availabilityStatus>9</availabilityStatus>

 466:    </productClassDetail>

 467:    </infoOnClasses>

 468:  - <infoOnClasses>

 469:  - <productClassDetail>

 470:    <serviceClass>W</serviceClass>

 471:    <availabilityStatus>9</availabilityStatus>

 472:    </productClassDetail>

 473:    </infoOnClasses>

 474:  - <infoOnClasses>

 475:  - <productClassDetail>

 476:    <serviceClass>T</serviceClass>

 477:    <availabilityStatus>9</availabilityStatus>

 478:    </productClassDetail>

 479:    </infoOnClasses>

 480:  - <infoOnClasses>

 481:  - <productClassDetail>

 482:    <serviceClass>L</serviceClass>

 483:    <availabilityStatus>9</availabilityStatus>

 484:    </productClassDetail>

 485:    </infoOnClasses>

 486:  - <infoOnClasses>

 487:  - <productClassDetail>

 488:    <serviceClass>P</serviceClass>

 489:    <availabilityStatus>5</availabilityStatus>

 490:    </productClassDetail>

 491:    </infoOnClasses>

 492:  - <infoOnClasses>

 493:  - <productClassDetail>

 494:    <serviceClass>A</serviceClass>

 495:    <availabilityStatus>4</availabilityStatus>

 496:    </productClassDetail>

 497:    </infoOnClasses>

 498:  - <infoOnClasses>

 499:  - <productClassDetail>

 500:    <serviceClass>B</serviceClass>

 501:    <availabilityStatus>9</availabilityStatus>

 502:    </productClassDetail>

 503:    </infoOnClasses>

 504:  - <infoOnClasses>

 505:  - <productClassDetail>

 506:    <serviceClass>M</serviceClass>

 507:    <availabilityStatus>9</availabilityStatus>

 508:    </productClassDetail>

 509:    </infoOnClasses>

 510:  - <infoOnClasses>

 511:  - <productClassDetail>

 512:    <serviceClass>S</serviceClass>

 513:    <availabilityStatus>9</availabilityStatus>

 514:    </productClassDetail>

 515:    </infoOnClasses>

 516:  - <infoOnClasses>

 517:  - <productClassDetail>

 518:    <serviceClass>E</serviceClass>

 519:    <availabilityStatus>9</availabilityStatus>

 520:    </productClassDetail>

 521:    </infoOnClasses>

 522:  - <infoOnClasses>

 523:  - <productClassDetail>

 524:    <serviceClass>U</serviceClass>

 525:    <availabilityStatus>9</availabilityStatus>

 526:    </productClassDetail>

 527:    </infoOnClasses>

 528:  - <infoOnClasses>

 529:  - <productClassDetail>

 530:    <serviceClass>K</serviceClass>

 531:    <availabilityStatus>0</availabilityStatus>

 532:    </productClassDetail>

 533:    </infoOnClasses>

 534:  - <infoOnClasses>

 535:  - <productClassDetail>

 536:    <serviceClass>G</serviceClass>

 537:    <availabilityStatus>0</availabilityStatus>

 538:    </productClassDetail>

 539:    </infoOnClasses>

 540:  - <additionalFlightInfo>

 541:  - <flightDetails>

 542:    <typeOfAircraft>CR7</typeOfAircraft>

 543:    <numberOfStops>0</numberOfStops>

 544:    </flightDetails>

 545:  - <productFacilities>

 546:    <type>AS</type>

 547:    </productFacilities>

 548:  - <productFacilities>

 549:    <type>DA</type>

 550:    </productFacilities>

 551:  - <productFacilities>

 552:    <type>LSA</type>

 553:    </productFacilities>

 554:    </additionalFlightInfo>

 555:    </flightInfo>

 556:  - <flightInfo>

 557:  - <basicFlightInfo>

 558:  - <flightDetails>

 559:    <departureDate>211009</departureDate>

 560:    <departureTime>1150</departureTime>

 561:    <arrivalDate>211009</arrivalDate>

 562:    <arrivalTime>1535</arrivalTime>

 563:    </flightDetails>

 564:  - <departureLocation>

 565:    <cityAirport>CLT</cityAirport>

 566:    </departureLocation>

 567:  - <arrivalLocation>

 568:    <cityAirport>PUJ</cityAirport>

 569:    </arrivalLocation>

 570:  - <marketingCompany>

 571:    <identifier>UA</identifier>

 572:    </marketingCompany>

 573:  - <operatingCompany>

 574:    <identifier>US</identifier>

 575:    </operatingCompany>

 576:  - <flightIdentification>

 577:    <number>2080</number>

 578:    </flightIdentification>

 579:  - <productTypeDetail>

 580:    <productIndicators>E</productIndicators>

 581:    <productIndicators>701</productIndicators>

 582:    <productIndicators>ET</productIndicators>

 583:    </productTypeDetail>

 584:    </basicFlightInfo>

 585:  - <infoOnClasses>

 586:  - <productClassDetail>

 587:    <serviceClass>F</serviceClass>

 588:    <availabilityStatus>0</availabilityStatus>

 589:    </productClassDetail>

 590:    </infoOnClasses>

 591:  - <infoOnClasses>

 592:  - <productClassDetail>

 593:    <serviceClass>Y</serviceClass>

 594:    <availabilityStatus>0</availabilityStatus>

 595:    </productClassDetail>

 596:    </infoOnClasses>

 597:  - <infoOnClasses>

 598:  - <productClassDetail>

 599:    <serviceClass>H</serviceClass>

 600:    <availabilityStatus>0</availabilityStatus>

 601:    </productClassDetail>

 602:    </infoOnClasses>

 603:  - <infoOnClasses>

 604:  - <productClassDetail>

 605:    <serviceClass>Q</serviceClass>

 606:    <availabilityStatus>0</availabilityStatus>

 607:    </productClassDetail>

 608:    </infoOnClasses>

 609:  - <infoOnClasses>

 610:  - <productClassDetail>

 611:    <serviceClass>V</serviceClass>

 612:    <availabilityStatus>0</availabilityStatus>

 613:    </productClassDetail>

 614:    </infoOnClasses>

 615:  - <infoOnClasses>

 616:  - <productClassDetail>

 617:    <serviceClass>W</serviceClass>

 618:    <availabilityStatus>0</availabilityStatus>

 619:    </productClassDetail>

 620:    </infoOnClasses>

 621:  - <infoOnClasses>

 622:  - <productClassDetail>

 623:    <serviceClass>T</serviceClass>

 624:    <availabilityStatus>0</availabilityStatus>

 625:    </productClassDetail>

 626:    </infoOnClasses>

 627:  - <infoOnClasses>

 628:  - <productClassDetail>

 629:    <serviceClass>L</serviceClass>

 630:    <availabilityStatus>0</availabilityStatus>

 631:    </productClassDetail>

 632:    </infoOnClasses>

 633:  - <infoOnClasses>

 634:  - <productClassDetail>

 635:    <serviceClass>P</serviceClass>

 636:    <availabilityStatus>0</availabilityStatus>

 637:    </productClassDetail>

 638:    </infoOnClasses>

 639:  - <infoOnClasses>

 640:  - <productClassDetail>

 641:    <serviceClass>A</serviceClass>

 642:    <availabilityStatus>0</availabilityStatus>

 643:    </productClassDetail>

 644:    </infoOnClasses>

 645:  - <infoOnClasses>

 646:  - <productClassDetail>

 647:    <serviceClass>B</serviceClass>

 648:    <availabilityStatus>0</availabilityStatus>

 649:    </productClassDetail>

 650:    </infoOnClasses>

 651:  - <infoOnClasses>

 652:  - <productClassDetail>

 653:    <serviceClass>M</serviceClass>

 654:    <availabilityStatus>0</availabilityStatus>

 655:    </productClassDetail>

 656:    </infoOnClasses>

 657:  - <infoOnClasses>

 658:  - <productClassDetail>

 659:    <serviceClass>S</serviceClass>

 660:    <availabilityStatus>0</availabilityStatus>

 661:    </productClassDetail>

 662:    </infoOnClasses>

 663:  - <infoOnClasses>

 664:  - <productClassDetail>

 665:    <serviceClass>E</serviceClass>

 666:    <availabilityStatus>0</availabilityStatus>

 667:    </productClassDetail>

 668:    </infoOnClasses>

 669:  - <infoOnClasses>

 670:  - <productClassDetail>

 671:    <serviceClass>U</serviceClass>

 672:    <availabilityStatus>0</availabilityStatus>

 673:    </productClassDetail>

 674:    </infoOnClasses>

 675:  - <infoOnClasses>

 676:  - <productClassDetail>

 677:    <serviceClass>K</serviceClass>

 678:    <availabilityStatus>0</availabilityStatus>

 679:    </productClassDetail>

 680:    </infoOnClasses>

 681:  - <infoOnClasses>

 682:  - <productClassDetail>

 683:    <serviceClass>G</serviceClass>

 684:    <availabilityStatus>0</availabilityStatus>

 685:    </productClassDetail>

 686:    </infoOnClasses>

 687:  - <additionalFlightInfo>

 688:  - <flightDetails>

 689:    <typeOfAircraft>E90</typeOfAircraft>

 690:    <numberOfStops>0</numberOfStops>

 691:    <legDuration>0935</legDuration>

 692:    </flightDetails>

 693:  - <productFacilities>

 694:    <type>AS</type>

 695:    </productFacilities>

 696:  - <productFacilities>

 697:    <type>DA</type>

 698:    </productFacilities>

 699:  - <productFacilities>

 700:    <type>LSA</type>

 701:    </productFacilities>

 702:  - <productFacilities>

 703:    <type>M</type>

 704:    </productFacilities>

 705:    </additionalFlightInfo>

 706:    </flightInfo>

 707:  - <flightInfo>

 708:  - <basicFlightInfo>

 709:  - <flightDetails>

 710:    <departureDate>211009</departureDate>

 711:    <departureTime>0625</departureTime>

 712:    <arrivalDate>211009</arrivalDate>

 713:    <arrivalTime>0824</arrivalTime>

 714:    </flightDetails>

 715:  - <departureLocation>

 716:    <cityAirport>JFK</cityAirport>

 717:    </departureLocation>

 718:  - <arrivalLocation>

 719:    <cityAirport>CLT</cityAirport>

 720:    </arrivalLocation>

 721:  - <marketingCompany>

 722:    <identifier>US</identifier>

 723:    </marketingCompany>

 724:  - <flightIdentification>

 725:    <number>3155</number>

 726:    </flightIdentification>

 727:  - <productTypeDetail>

 728:    <productIndicators>S</productIndicators>

 729:    <productIndicators>702</productIndicators>

 730:    <productIndicators>ET</productIndicators>

 731:    </productTypeDetail>

 732:    <lineItemNumber>3</lineItemNumber>

 733:    </basicFlightInfo>

 734:  - <infoOnClasses>

 735:  - <productClassDetail>

 736:    <serviceClass>Y</serviceClass>

 737:    <availabilityStatus>9</availabilityStatus>

 738:    </productClassDetail>

 739:    </infoOnClasses>

 740:  - <infoOnClasses>

 741:  - <productClassDetail>

 742:    <serviceClass>B</serviceClass>

 743:    <availabilityStatus>9</availabilityStatus>

 744:    </productClassDetail>

 745:    </infoOnClasses>

 746:  - <infoOnClasses>

 747:  - <productClassDetail>

 748:    <serviceClass>M</serviceClass>

 749:    <availabilityStatus>9</availabilityStatus>

 750:    </productClassDetail>

 751:    </infoOnClasses>

 752:  - <infoOnClasses>

 753:  - <productClassDetail>

 754:    <serviceClass>H</serviceClass>

 755:    <availabilityStatus>9</availabilityStatus>

 756:    </productClassDetail>

 757:    </infoOnClasses>

 758:  - <infoOnClasses>

 759:  - <productClassDetail>

 760:    <serviceClass>Q</serviceClass>

 761:    <availabilityStatus>9</availabilityStatus>

 762:    </productClassDetail>

 763:    </infoOnClasses>

 764:  - <infoOnClasses>

 765:  - <productClassDetail>

 766:    <serviceClass>N</serviceClass>

 767:    <availabilityStatus>9</availabilityStatus>

 768:    </productClassDetail>

 769:    </infoOnClasses>

 770:  - <infoOnClasses>

 771:  - <productClassDetail>

 772:    <serviceClass>V</serviceClass>

 773:    <availabilityStatus>9</availabilityStatus>

 774:    </productClassDetail>

 775:    </infoOnClasses>

 776:  - <infoOnClasses>

 777:  - <productClassDetail>

 778:    <serviceClass>W</serviceClass>

 779:    <availabilityStatus>9</availabilityStatus>

 780:    </productClassDetail>

 781:    </infoOnClasses>

 782:  - <infoOnClasses>

 783:  - <productClassDetail>

 784:    <serviceClass>L</serviceClass>

 785:    <availabilityStatus>9</availabilityStatus>

 786:    </productClassDetail>

 787:    </infoOnClasses>

 788:  - <infoOnClasses>

 789:  - <productClassDetail>

 790:    <serviceClass>S</serviceClass>

 791:    <availabilityStatus>9</availabilityStatus>

 792:    </productClassDetail>

 793:    </infoOnClasses>

 794:  - <infoOnClasses>

 795:  - <productClassDetail>

 796:    <serviceClass>T</serviceClass>

 797:    <availabilityStatus>9</availabilityStatus>

 798:    </productClassDetail>

 799:    </infoOnClasses>

 800:  - <infoOnClasses>

 801:  - <productClassDetail>

 802:    <serviceClass>G</serviceClass>

 803:    <availabilityStatus>9</availabilityStatus>

 804:    </productClassDetail>

 805:    </infoOnClasses>

 806:  - <infoOnClasses>

 807:  - <productClassDetail>

 808:    <serviceClass>K</serviceClass>

 809:    <availabilityStatus>9</availabilityStatus>

 810:    </productClassDetail>

 811:    </infoOnClasses>

 812:  - <infoOnClasses>

 813:  - <productClassDetail>

 814:    <serviceClass>U</serviceClass>

 815:    <availabilityStatus>9</availabilityStatus>

 816:    </productClassDetail>

 817:    </infoOnClasses>

 818:  - <infoOnClasses>

 819:  - <productClassDetail>

 820:    <serviceClass>E</serviceClass>

 821:    <availabilityStatus>9</availabilityStatus>

 822:    </productClassDetail>

 823:    </infoOnClasses>

 824:  - <infoOnClasses>

 825:  - <productClassDetail>

 826:    <serviceClass>R</serviceClass>

 827:    <availabilityStatus>1</availabilityStatus>

 828:    </productClassDetail>

 829:    </infoOnClasses>

 830:  - <additionalFlightInfo>

 831:  - <flightDetails>

 832:    <typeOfAircraft>E75</typeOfAircraft>

 833:    <numberOfStops>0</numberOfStops>

 834:    </flightDetails>

 835:  - <departureStation>

 836:    <terminal>7</terminal>

 837:    </departureStation>

 838:  - <productFacilities>

 839:    <type>AS</type>

 840:    </productFacilities>

 841:  - <productFacilities>

 842:    <type>DA</type>

 843:    </productFacilities>

 844:  - <productFacilities>

 845:    <type>LSA</type>

 846:    </productFacilities>

 847:    </additionalFlightInfo>

 848:    </flightInfo>

 849:  - <flightInfo>

 850:  - <basicFlightInfo>

 851:  - <flightDetails>

 852:    <departureDate>211009</departureDate>

 853:    <departureTime>1150</departureTime>

 854:    <arrivalDate>211009</arrivalDate>

 855:    <arrivalTime>1535</arrivalTime>

 856:    </flightDetails>

 857:  - <departureLocation>

 858:    <cityAirport>CLT</cityAirport>

 859:    </departureLocation>

 860:  - <arrivalLocation>

 861:    <cityAirport>PUJ</cityAirport>

 862:    </arrivalLocation>

 863:  - <marketingCompany>

 864:    <identifier>US</identifier>

 865:    </marketingCompany>

 866:  - <flightIdentification>

 867:    <number>1967</number>

 868:    </flightIdentification>

 869:  - <productTypeDetail>

 870:    <productIndicators>E</productIndicators>

 871:    <productIndicators>ET</productIndicators>

 872:    </productTypeDetail>

 873:    </basicFlightInfo>

 874:  - <infoOnClasses>

 875:  - <productClassDetail>

 876:    <serviceClass>F</serviceClass>

 877:    <availabilityStatus>2</availabilityStatus>

 878:    </productClassDetail>

 879:    </infoOnClasses>

 880:  - <infoOnClasses>

 881:  - <productClassDetail>

 882:    <serviceClass>A</serviceClass>

 883:    <availabilityStatus>2</availabilityStatus>

 884:    </productClassDetail>

 885:    </infoOnClasses>

 886:  - <infoOnClasses>

 887:  - <productClassDetail>

 888:    <serviceClass>P</serviceClass>

 889:    <availabilityStatus>2</availabilityStatus>

 890:    </productClassDetail>

 891:    </infoOnClasses>

 892:  - <infoOnClasses>

 893:  - <productClassDetail>

 894:    <serviceClass>Y</serviceClass>

 895:    <availabilityStatus>9</availabilityStatus>

 896:    </productClassDetail>

 897:    </infoOnClasses>

 898:  - <infoOnClasses>

 899:  - <productClassDetail>

 900:    <serviceClass>B</serviceClass>

 901:    <availabilityStatus>9</availabilityStatus>

 902:    </productClassDetail>

 903:    </infoOnClasses>

 904:  - <infoOnClasses>

 905:  - <productClassDetail>

 906:    <serviceClass>M</serviceClass>

 907:    <availabilityStatus>9</availabilityStatus>

 908:    </productClassDetail>

 909:    </infoOnClasses>

 910:  - <infoOnClasses>

 911:  - <productClassDetail>

 912:    <serviceClass>H</serviceClass>

 913:    <availabilityStatus>9</availabilityStatus>

 914:    </productClassDetail>

 915:    </infoOnClasses>

 916:  - <infoOnClasses>

 917:  - <productClassDetail>

 918:    <serviceClass>Q</serviceClass>

 919:    <availabilityStatus>4</availabilityStatus>

 920:    </productClassDetail>

 921:    </infoOnClasses>

 922:  - <infoOnClasses>

 923:  - <productClassDetail>

 924:    <serviceClass>N</serviceClass>

 925:    <availabilityStatus>0</availabilityStatus>

 926:    </productClassDetail>

 927:    </infoOnClasses>

 928:  - <infoOnClasses>

 929:  - <productClassDetail>

 930:    <serviceClass>V</serviceClass>

 931:    <availabilityStatus>0</availabilityStatus>

 932:    </productClassDetail>

 933:    </infoOnClasses>

 934:  - <infoOnClasses>

 935:  - <productClassDetail>

 936:    <serviceClass>W</serviceClass>

 937:    <availabilityStatus>0</availabilityStatus>

 938:    </productClassDetail>

 939:    </infoOnClasses>

 940:  - <infoOnClasses>

 941:  - <productClassDetail>

 942:    <serviceClass>L</serviceClass>

 943:    <availabilityStatus>0</availabilityStatus>

 944:    </productClassDetail>

 945:    </infoOnClasses>

 946:  - <infoOnClasses>

 947:  - <productClassDetail>

 948:    <serviceClass>S</serviceClass>

 949:    <availabilityStatus>0</availabilityStatus>

 950:    </productClassDetail>

 951:    </infoOnClasses>

 952:  - <infoOnClasses>

 953:  - <productClassDetail>

 954:    <serviceClass>T</serviceClass>

 955:    <availabilityStatus>0</availabilityStatus>

 956:    </productClassDetail>

 957:    </infoOnClasses>

 958:  - <infoOnClasses>

 959:  - <productClassDetail>

 960:    <serviceClass>G</serviceClass>

 961:    <availabilityStatus>0</availabilityStatus>

 962:    </productClassDetail>

 963:    </infoOnClasses>

 964:  - <infoOnClasses>

 965:  - <productClassDetail>

 966:    <serviceClass>K</serviceClass>

 967:    <availabilityStatus>0</availabilityStatus>

 968:    </productClassDetail>

 969:    </infoOnClasses>

 970:  - <infoOnClasses>

 971:  - <productClassDetail>

 972:    <serviceClass>U</serviceClass>

 973:    <availabilityStatus>0</availabilityStatus>

 974:    </productClassDetail>

 975:    </infoOnClasses>

 976:  - <infoOnClasses>

 977:  - <productClassDetail>

 978:    <serviceClass>E</serviceClass>

 979:    <availabilityStatus>0</availabilityStatus>

 980:    </productClassDetail>

 981:    </infoOnClasses>

 982:  - <infoOnClasses>

 983:  - <productClassDetail>

 984:    <serviceClass>R</serviceClass>

 985:    <availabilityStatus>0</availabilityStatus>

 986:    </productClassDetail>

 987:    </infoOnClasses>

 988:  - <additionalFlightInfo>

 989:  - <flightDetails>

 990:    <typeOfAircraft>E90</typeOfAircraft>

 991:    <numberOfStops>0</numberOfStops>

 992:    <legDuration>0910</legDuration>

 993:    </flightDetails>

 994:  - <productFacilities>

 995:    <type>AS</type>

 996:    </productFacilities>

 997:  - <productFacilities>

 998:    <type>DA</type>

 999:    </productFacilities>

1000:  - <productFacilities>

1001:    <type>LSA</type>

1002:    </productFacilities>

1003:  - <productFacilities>

1004:    <type>M</type>

1005:    </productFacilities>

1006:    </additionalFlightInfo>

1007:    </flightInfo>

1008:  - <flightInfo>

1009:  - <basicFlightInfo>

1010:  - <flightDetails>

1011:    <departureDate>211009</departureDate>

1012:    <departureTime>0625</departureTime>

1013:    <arrivalDate>211009</arrivalDate>

1014:    <arrivalTime>0824</arrivalTime>

1015:    </flightDetails>

1016:  - <departureLocation>

1017:    <cityAirport>JFK</cityAirport>

1018:    </departureLocation>

1019:  - <arrivalLocation>

1020:    <cityAirport>CLT</cityAirport>

1021:    </arrivalLocation>

1022:  - <marketingCompany>

1023:    <identifier>US</identifier>

1024:    </marketingCompany>

1025:  - <flightIdentification>

1026:    <number>3155</number>

1027:    </flightIdentification>

1028:  - <productTypeDetail>

1029:    <productIndicators>S</productIndicators>

1030:    <productIndicators>702</productIndicators>

1031:    <productIndicators>ET</productIndicators>

1032:    </productTypeDetail>

1033:    <lineItemNumber>4</lineItemNumber>

1034:    </basicFlightInfo>

1035:  - <infoOnClasses>

1036:  - <productClassDetail>

1037:    <serviceClass>Y</serviceClass>

1038:    <availabilityStatus>9</availabilityStatus>

1039:    </productClassDetail>

1040:    </infoOnClasses>

1041:  - <infoOnClasses>

1042:  - <productClassDetail>

1043:    <serviceClass>B</serviceClass>

1044:    <availabilityStatus>9</availabilityStatus>

1045:    </productClassDetail>

1046:    </infoOnClasses>

1047:  - <infoOnClasses>

1048:  - <productClassDetail>

1049:    <serviceClass>M</serviceClass>

1050:    <availabilityStatus>9</availabilityStatus>

1051:    </productClassDetail>

1052:    </infoOnClasses>

1053:  - <infoOnClasses>

1054:  - <productClassDetail>

1055:    <serviceClass>H</serviceClass>

1056:    <availabilityStatus>9</availabilityStatus>

1057:    </productClassDetail>

1058:    </infoOnClasses>

1059:  - <infoOnClasses>

1060:  - <productClassDetail>

1061:    <serviceClass>Q</serviceClass>

1062:    <availabilityStatus>9</availabilityStatus>

1063:    </productClassDetail>

1064:    </infoOnClasses>

1065:  - <infoOnClasses>

1066:  - <productClassDetail>

1067:    <serviceClass>N</serviceClass>

1068:    <availabilityStatus>9</availabilityStatus>

1069:    </productClassDetail>

1070:    </infoOnClasses>

1071:  - <infoOnClasses>

1072:  - <productClassDetail>

1073:    <serviceClass>V</serviceClass>

1074:    <availabilityStatus>9</availabilityStatus>

1075:    </productClassDetail>

1076:    </infoOnClasses>

1077:  - <infoOnClasses>

1078:  - <productClassDetail>

1079:    <serviceClass>W</serviceClass>

1080:    <availabilityStatus>9</availabilityStatus>

1081:    </productClassDetail>

1082:    </infoOnClasses>

1083:  - <infoOnClasses>

1084:  - <productClassDetail>

1085:    <serviceClass>L</serviceClass>

1086:    <availabilityStatus>9</availabilityStatus>

1087:    </productClassDetail>

1088:    </infoOnClasses>

1089:  - <infoOnClasses>

1090:  - <productClassDetail>

1091:    <serviceClass>S</serviceClass>

1092:    <availabilityStatus>9</availabilityStatus>

1093:    </productClassDetail>

1094:    </infoOnClasses>

1095:  - <infoOnClasses>

1096:  - <productClassDetail>

1097:    <serviceClass>T</serviceClass>

1098:    <availabilityStatus>9</availabilityStatus>

1099:    </productClassDetail>

1100:    </infoOnClasses>

1101:  - <infoOnClasses>

1102:  - <productClassDetail>

1103:    <serviceClass>G</serviceClass>

1104:    <availabilityStatus>9</availabilityStatus>

1105:    </productClassDetail>

1106:    </infoOnClasses>

1107:  - <infoOnClasses>

1108:  - <productClassDetail>

1109:    <serviceClass>K</serviceClass>

1110:    <availabilityStatus>9</availabilityStatus>

1111:    </productClassDetail>

1112:    </infoOnClasses>

1113:  - <infoOnClasses>

1114:  - <productClassDetail>

1115:    <serviceClass>U</serviceClass>

1116:    <availabilityStatus>9</availabilityStatus>

1117:    </productClassDetail>

1118:    </infoOnClasses>

1119:  - <infoOnClasses>

1120:  - <productClassDetail>

1121:    <serviceClass>E</serviceClass>

1122:    <availabilityStatus>9</availabilityStatus>

1123:    </productClassDetail>

1124:    </infoOnClasses>

1125:  - <infoOnClasses>

1126:  - <productClassDetail>

1127:    <serviceClass>R</serviceClass>

1128:    <availabilityStatus>1</availabilityStatus>

1129:    </productClassDetail>

1130:    </infoOnClasses>

1131:  - <additionalFlightInfo>

1132:  - <flightDetails>

1133:    <typeOfAircraft>E75</typeOfAircraft>

1134:    <numberOfStops>0</numberOfStops>

1135:    </flightDetails>

1136:  - <departureStation>

1137:    <terminal>7</terminal>

1138:    </departureStation>

1139:  - <productFacilities>

1140:    <type>AS</type>

1141:    </productFacilities>

1142:  - <productFacilities>

1143:    <type>DA</type>

1144:    </productFacilities>

1145:  - <productFacilities>

1146:    <type>LSA</type>

1147:    </productFacilities>

1148:    </additionalFlightInfo>

1149:    </flightInfo>

1150:  - <flightInfo>

1151:  - <basicFlightInfo>

1152:  - <flightDetails>

1153:    <departureDate>211009</departureDate>

1154:    <departureTime>1150</departureTime>

1155:    <arrivalDate>211009</arrivalDate>

1156:    <arrivalTime>1535</arrivalTime>

1157:    </flightDetails>

1158:  - <departureLocation>

1159:    <cityAirport>CLT</cityAirport>

1160:    </departureLocation>

1161:  - <arrivalLocation>

1162:    <cityAirport>PUJ</cityAirport>

1163:    </arrivalLocation>

1164:  - <marketingCompany>

1165:    <identifier>UA</identifier>

1166:    </marketingCompany>

1167:  - <operatingCompany>

1168:    <identifier>US</identifier>

1169:    </operatingCompany>

1170:  - <flightIdentification>

1171:    <number>2080</number>

1172:    </flightIdentification>

1173:  - <productTypeDetail>

1174:    <productIndicators>E</productIndicators>

1175:    <productIndicators>701</productIndicators>

1176:    <productIndicators>ET</productIndicators>

1177:    </productTypeDetail>

1178:    </basicFlightInfo>

1179:  - <infoOnClasses>

1180:  - <productClassDetail>

1181:    <serviceClass>F</serviceClass>

1182:    <availabilityStatus>0</availabilityStatus>

1183:    </productClassDetail>

1184:    </infoOnClasses>

1185:  - <infoOnClasses>

1186:  - <productClassDetail>

1187:    <serviceClass>Y</serviceClass>

1188:    <availabilityStatus>0</availabilityStatus>

1189:    </productClassDetail>

1190:    </infoOnClasses>

1191:  - <infoOnClasses>

1192:  - <productClassDetail>

1193:    <serviceClass>H</serviceClass>

1194:    <availabilityStatus>0</availabilityStatus>

1195:    </productClassDetail>

1196:    </infoOnClasses>

1197:  - <infoOnClasses>

1198:  - <productClassDetail>

1199:    <serviceClass>Q</serviceClass>

1200:    <availabilityStatus>0</availabilityStatus>

1201:    </productClassDetail>

1202:    </infoOnClasses>

1203:  - <infoOnClasses>

1204:  - <productClassDetail>

1205:    <serviceClass>V</serviceClass>

1206:    <availabilityStatus>0</availabilityStatus>

1207:    </productClassDetail>

1208:    </infoOnClasses>

1209:  - <infoOnClasses>

1210:  - <productClassDetail>

1211:    <serviceClass>W</serviceClass>

1212:    <availabilityStatus>0</availabilityStatus>

1213:    </productClassDetail>

1214:    </infoOnClasses>

1215:  - <infoOnClasses>

1216:  - <productClassDetail>

1217:    <serviceClass>T</serviceClass>

1218:    <availabilityStatus>0</availabilityStatus>

1219:    </productClassDetail>

1220:    </infoOnClasses>

1221:  - <infoOnClasses>

1222:  - <productClassDetail>

1223:    <serviceClass>L</serviceClass>

1224:    <availabilityStatus>0</availabilityStatus>

1225:    </productClassDetail>

1226:    </infoOnClasses>

1227:  - <infoOnClasses>

1228:  - <productClassDetail>

1229:    <serviceClass>P</serviceClass>

1230:    <availabilityStatus>0</availabilityStatus>

1231:    </productClassDetail>

1232:    </infoOnClasses>

1233:  - <infoOnClasses>

1234:  - <productClassDetail>

1235:    <serviceClass>A</serviceClass>

1236:    <availabilityStatus>0</availabilityStatus>

1237:    </productClassDetail>

1238:    </infoOnClasses>

1239:  - <infoOnClasses>

1240:  - <productClassDetail>

1241:    <serviceClass>B</serviceClass>

1242:    <availabilityStatus>0</availabilityStatus>

1243:    </productClassDetail>

1244:    </infoOnClasses>

1245:  - <infoOnClasses>

1246:  - <productClassDetail>

1247:    <serviceClass>M</serviceClass>

1248:    <availabilityStatus>0</availabilityStatus>

1249:    </productClassDetail>

1250:    </infoOnClasses>

1251:  - <infoOnClasses>

1252:  - <productClassDetail>

1253:    <serviceClass>S</serviceClass>

1254:    <availabilityStatus>0</availabilityStatus>

1255:    </productClassDetail>

1256:    </infoOnClasses>

1257:  - <infoOnClasses>

1258:  - <productClassDetail>

1259:    <serviceClass>E</serviceClass>

1260:    <availabilityStatus>0</availabilityStatus>

1261:    </productClassDetail>

1262:    </infoOnClasses>

1263:  - <infoOnClasses>

1264:  - <productClassDetail>

1265:    <serviceClass>U</serviceClass>

1266:    <availabilityStatus>0</availabilityStatus>

1267:    </productClassDetail>

1268:    </infoOnClasses>

1269:  - <infoOnClasses>

1270:  - <productClassDetail>

1271:    <serviceClass>K</serviceClass>

1272:    <availabilityStatus>0</availabilityStatus>

1273:    </productClassDetail>

1274:    </infoOnClasses>

1275:  - <infoOnClasses>

1276:  - <productClassDetail>

1277:    <serviceClass>G</serviceClass>

1278:    <availabilityStatus>0</availabilityStatus>

1279:    </productClassDetail>

1280:    </infoOnClasses>

1281:  - <additionalFlightInfo>

1282:  - <flightDetails>

1283:    <typeOfAircraft>E90</typeOfAircraft>

1284:    <numberOfStops>0</numberOfStops>

1285:    <legDuration>0910</legDuration>

1286:    </flightDetails>

1287:  - <productFacilities>

1288:    <type>AS</type>

1289:    </productFacilities>

1290:  - <productFacilities>

1291:    <type>DA</type>

1292:    </productFacilities>

1293:  - <productFacilities>

1294:    <type>LSA</type>

1295:    </productFacilities>

1296:  - <productFacilities>

1297:    <type>M</type>

1298:    </productFacilities>

1299:    </additionalFlightInfo>

1300:    </flightInfo>

1301:    </flight>

Implement code format in aspnet.html

2009-09-02T05:25:00.000-07:00

Hello frnds,
Here I found one url which will converted your code in asp.net format.
To read more click on below link

http://dotnetguts.blogspot.com/2008/05/implement-code-format-in-aspnet.html

SQL Optimization Tips

2009-09-02T04:23:00.001-07:00

SQL Optimization Tips

• Use views and stored procedures instead of heavy-duty queries.
This can reduce network traffic, because your client will send to
server only stored procedure or view name (perhaps with some
parameters) instead of large heavy-duty queries text. This can be used
to facilitate permission management also, because you can restrict
user access to table columns they should not see.

• Try to use constraints instead of triggers, whenever possible.
Constraints are much more efficient than triggers and can boost
performance. So, you should use constraints instead of triggers,
whenever possible.

• Use table variables instead of temporary tables.
Table variables require less locking and logging resources than
temporary tables, so table variables should be used whenever possible.
The table variables are available in SQL Server 2000 only.

• Try to use UNION ALL statement instead of UNION, whenever possible.
The UNION ALL statement is much faster than UNION, because UNION ALL
statement does not look for duplicate rows, and UNION statement does
look for duplicate rows, whether or not they exist.

• Try to avoid using the DISTINCT clause, whenever possible.
Because using the DISTINCT clause will result in some performance
degradation, you should use this clause only when it is necessary.

• Try to avoid using SQL Server cursors, whenever possible.
SQL Server cursors can result in some performance degradation in
comparison with select statements. Try to use correlated sub-query or
derived tables, if you need to perform row-by-row operations.

• Try to avoid the HAVING clause, whenever possible.
The HAVING clause is used to restrict the result set returned by the
GROUP BY clause. When you use GROUP BY with the HAVING clause, the
GROUP BY clause divides the rows into sets of grouped rows and
aggregates their values, and then the HAVING clause eliminates
undesired aggregated groups. In many cases, you can write your select
statement so, that it will contain only WHERE and GROUP BY clauses
without HAVING clause. This can improve the performance of your query.

• If you need to return the total table's row count, you can use
alternative way instead of SELECT COUNT(*) statement.
Because SELECT COUNT(*) statement make a full table scan to return the
total table's row count, it can take very many time for the large
table. There is another way to determine the total row count in a
table. You can use sysindexes system table, in this case. There is
ROWS column in the sysindexes table. This column contains the total
row count for each table in your database. So, you can use the
following select statement instead of SELECT COUNT(*): SELECT rows
FROM sysindexes WHERE id = OBJECT_ID('table_name') AND indid < 2 So,
you can improve the speed of such queries in several times.

• Include SET NOCOUNT ON statement into your stored procedures to stop
the message indicating the number of rows affected by a T-SQL statement.
This can reduce network traffic, because your client will not receive
the message indicating the number of rows affected by a T-SQL statement.

• Try to restrict the queries result set by using the WHERE clause.
This can results in good performance benefits, because SQL Server will
return to client only particular rows, not all rows from the table(s).
This can reduce network traffic and boost the overall performance of
the query.

• Use the select statements with TOP keyword or the SET ROWCOUNT
statement, if you need to return only the first n rows.
This can improve performance of your queries, because the smaller
result set will be returned. This can also reduce the traffic between
the server and the clients.

• Try to restrict the queries result set by returning only the
particular columns from the table, not all table's columns.
This can results in good performance benefits, because SQL Server will
return to client only particular columns, not all table's columns.
This can reduce network traffic and boost the overall performance of
the query.
1.Indexes
2.avoid more number of triggers on the table
3.unnecessary complicated joins
4.correct use of Group by clause with the select list
5 In worst cases Denormalization

Index Optimization tips

• Every index increases the time in takes to perform INSERTS, UPDATES
and DELETES, so the number of indexes should not be very much. Try to
use maximum 4-5 indexes on one table, not more. If you have read-only
table, then the number of indexes may be increased.

• Keep your indexes as narrow as possible. This reduces the size of
the index and reduces the number of reads required to read the index.

• Try to create indexes on columns that have integer values rather
than character values.

• If you create a composite (multi-column) index, the order of the
columns in the key are very important. Try to order the columns in the
key as to enhance selectivity, with the most selective columns to the
leftmost of the key.

• If you want to join several tables, try to create surrogate integer
keys for this purpose and create indexes on their columns.

• Create surrogate integer primary key (identity for example) if your
table will not have many insert operations.

• Clustered indexes are more preferable than nonclustered, if you need
to select by a range of values or you need to sort results set with
GROUP BY or ORDER BY.

• If your application
will be performing the same query over and over
on the same table, consider creating a covering index on the table.

• You can use the SQL Server Profiler Create Trace Wizard with
"Identify Scans of Large Tables" trace to determine which tables in
your database may need indexes. This trace will show which tables are
being scanned by queries instead of using an index.

• You can use sp_MSforeachtable undocumented stored procedure to
rebuild all indexes in your database. Try to schedule it to execute
during CPU idle time and slow production periods.
sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"

Concatenate multiple rows delimited by comma

2009-09-01T03:42:00.000-07:00

Hello frnds,
Most of people need to select multiple row and convert it into CSV format.
Here I came with solutions.

For Example:-

   1:  Declare @tbl table (id int,sid int)

2:

   3:  insert into @tbl

   4:  select 1,11

   5:  union

   6:  select 1,12

   7:  union

   8:  select 1,13

   9:  union

  10:  select 2,21

  11:  union

  12:  select 2,22

13:

  14:  SELECT * FROM @tbl

15:

  16:  --With CTE:-

  17:  --------------------

  18:  ;WITH RowRank

  19:  AS

  20:  (

  21:  SELECT id,CAST(sid AS VARCHAR) sid,ROW_NUMBER() OVER(PARTITION BY id order by id) AS Row FROM @tbl

  22:  )

  23:  ,Concat(id,sid,Row)

  24:  AS

  25:  (

  26:  SELECT id,CAST(RowRank.sid AS VARCHAR),Row FROM RowRank WHERE Row=1

  27:  UNION ALL

  28:  select RowRank.id, CAST(Concat.sid + ', ' + RowRank.sid AS VARCHAR ) ,RowRank.Row

  29:  from RowRank

  30:  inner join Concat on RowRank.id = Concat.id and RowRank.Row -1 = Concat.Row

31:

  32:  )

  33:  ,CommaSeperatedResult (id, sid)

  34:  as

  35:  (

  36:  select Concat.id, Concat.sid

  37:  from Concat

  38:  join (select id, max(Row) max_row from RowRank group by id) max_row

  39:  on Concat.id = max_row.id and Concat.Row = max_row.max_row

  40:  )

  41:  SELECT * FROM CommaSeperatedResult ORDER BY ID

42:

43:

  44:  --WITH FOR XML PATH:-

  45:  ------------------------------

  46:  select distinct id,

  47:  replace

  48:  (

  49:  (

  50:  select cast(sid as varchar)+',' from @tbl t where t.id=t1.id for XML path('')

  51:  ) +'$',',$',''

  52:  )

  53:  as sid

  54:  from @tbl t1

55:

Output is:-
----------------

Using common table expressions (CTE) to generate sequences

2009-08-31T01:43:00.000-07:00

Hello frnds,
One of the best enhancements in T-SQL with SQL Server 2005 was Common Table Expressions(CTEs). CTEs are very helpful in writing more readable and manageable queries. The good things don’t end here; self-referencing CTEs are a very powerful method of implementing recursion in SQL queries. In this post, I will present a few examples of generating sequences using CTEs.
The following statements create a number sequence from 1 to 10.

Example:-

   1:  Declare @start int, @end int

   2:  Select @start=1, @end=10

3:

4:

   5:  ;WITH CTESequence(number)

   6:  AS

   7:  (

   8:  SELECT @start

   9:  UNION ALL

  10:  SELECT number +1 FROM CTESequence

  11:  WHERE number<@end

  12:  )

  13:  SELECT * FROM CTESequence

Output is :-

ASP.NET MasterPages and User Defined Events

2009-08-28T01:28:00.000-07:00

ASP.NET MasterPages and User Defined Events

Master pages were introduced in ASP.NET 2.0 and are a great way to create a consistent layout for the pages throughout your application. I thought a good article would be to demonstrate how to create a custom event that web content pages can raise if they click on web server controls located in the master page. If you want to raise an event and pass data to an event handler, you need to create a class that inherits from System.EventArgs . EventsArgs is the base class for classes containing event data. It contains no event data. It is used by events to pass data to an event handler when an event is raised.

To begin with open Visual Studio 2008 and choose File > New > Web > ASP.NET Web Application. Add a master page to the project and name it Site.Master. Before going any further add a new class to the project and name it CustomArgs. Add the following code to the newly created class:
C#

   1:  public class CustomArgs : EventArgs

   2:  {

   3:  public bool Cancel { get; set; }

   4:        public string Message { get; set; }

   5:        public string NavigateTo { get; set; }

   6:  }

In the code above, CustomArgs inherits EventArgs. This means that when we raise an event in the master page, a reference to CustomArgs will be passed to our event handler, so we can set these properties and have the master page determine what to do next.
Go back to the master page and add the following code to create a new event:
C#

   1:  public EventHandler ButtonClick;

We have just created a new event called ButtonClick that accepts CustomArgs as the argument. Now add a Button to the page and add the following code to the Button’s Click event:
C#
---------------------

   1:  protected void Button1_Click(object sender, EventArgs e)

   2:  {

   3:  lblValue.Text = null;

   4:        if (ButtonClick != null)

   5:        {

   6:              CustomArgs args = new CustomArgs();

   7:              ButtonClick(sender, args);

   8:              if (args.Cancel)

   9:              {

  10:                    lblValue.Text = args.Message;

  11:  }

  12:              else

  13:              {

  14:                    Response.Redirect(args.NavigateTo);

  15:              }

  16:  }

  17:  }

What’s happening in the code above is when a user clicks on the Button, which resides in the master page, it will check to see if there’s code that raises the ButtonClick event. If there is, the event handler will be executed. Once the event handler has completed, the master page will check the value of CustomArgs.Cancel property, and if it is false, it will display what is in the CustomArgs.Message property; otherwise it will navigate to the CustomArgs.NavigateTo page.
To see this in action add two web content forms to the project and select the master page added earlier. Leave these pages as WebForm1.aspx and WebForm2.aspx:

To be able to call the event from the master page, you’ll need to add a new MasterType directive to the both pages:

   1:  <%@ MasterType VirtualPath="~/Site.Master" %>

This provides a way to create a strongly typed reference to the master page when the master page is accessed from the Master() property. Now we must create an event handler for the ButtonClick event. Add the following code to WebForm1.aspx:
C#
-----------------------------

   1:  protected void Page_Load(object sender, EventArgs e)

   2:  {

   3:       Master.ButtonClick += new EventHandler<CustomArgs>(MasterButtonClick);

   4:  }

5:

   6:  private void MasterButtonClick(object sender, CustomArgs e)

   7:  {

   8:  if (!string.IsNullOrEmpty(TextBox1.Text))

   9:        {

  10:              e.Cancel = false;

  11:              e.NavigateTo = "~/WebForm2.aspx";

  12:  }

  13:        else

  14:        {

  15:              e.Cancel = true;

  16:              e.Message = "There was no text entered...";

  17:  }

  18:  }

19:

In the code above an event handler called MasterButtonClick has been created. This event handler will be raised when the user clicks the Button in the master page. To simulate a business application I’ve added a TextBox to the page so if the user leaves it blank, validation will fail and they should be alerted to this. This is made possible by setting the CustomArgs.Cancel property. If the user does enter data then they will be allowed to navigate to the next page.
Open the WebForm2.aspx page and add the following code to the code behind:
C#
---------------------------------

   1:  protected void Page_Load(object sender, EventArgs e)

   2:  {

   3:  Master.ButtonClick = delegate(object s, CustomArgs c)

   4:        {

   5:              c.Cancel = false;

   6:              c.NavigateTo = "~/WebForm1.aspx";

   7:  };

   8:  }

In the code above I have created an anonymous method that handles the ButtonClick event. This page will not validate anything and therefore will direct the user back to the WebForm1.aspx page.

If you run the application and step through the code you’ll see that when you click on the button in the master page, it will check and execute the event handlers in the web content forms. This is a nice way of being able to create a wizard style application, but having the flexibility of raising events in the child pages when you need to.

Solve TSQL Challenge9

2009-08-12T04:22:00.000-07:00

Hello friends,
Here I have solve TSQL challenge9. Please read the challenge from the below url.
http://beyondrelational.com/blogs/tc/archive/2009/06/04/tsql-challenge-9.aspx

Solution:-
-------------

   1:  DECLARE @tc9 TABLE(

   2:  ID INT IDENTITY(1,1),

   3:  CreationDate DATETIME,

   4:  Content NVARCHAR(10),

   5:  SendState BIT,

   6:  AckState BIT

   7:  )

8:

   9:  INSERT INTO @tc9 (CreationDate,Content,SendState,AckState)

  10:  SELECT GETDATE()-1.0,'Msg #1',0,0 UNION

  11:  SELECT GETDATE()-0.9,'Msg #2',0,0 UNION

  12:  SELECT GETDATE()-0.8,'Msg #3',1,1 UNION

  13:  SELECT GETDATE()-0.7,'Msg #4',1,1 UNION

  14:  SELECT GETDATE()-0.6,'Msg #5',1,1 UNION

  15:  SELECT GETDATE()-0.5,'Msg #6',1,0 UNION

  16:  SELECT GETDATE()-0.4,'Msg #7',1,0 UNION

  17:  SELECT GETDATE()-0.3,'Msg #8',1,0 UNION

  18:  SELECT GETDATE()-0.2,'Msg #9',1,0 UNION

  19:  SELECT GETDATE()-0.1,'Msg #10',1,1

20:

  21:  SELECT * FROM @tc9

22:

  23:  ;WITH CTE

  24:  AS

  25:  (

  26:  SELECT *,ID-ROW_NUMBER() over( partition by sendstate,ackstate order by ID) as GroupID FROM @tc9

  27:  )

  28:  SELECT MIN(ID) FirstIDInclusive,MAX(ID) LastIDInclusive,SendState,AckState FROM CTE GROUP BY GroupID,SendState,AckState

  29:  ORDER BY MIN(ID)

Dynamic load user control with delegate event

2009-07-27T05:33:00.000-07:00

Hello Friends,
Here I will explain you how can you load dynamically user control and perform delegate event on it.
Let's see example here.

Usercontrol : Calc.ascx
-------------------------------

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="Calc.ascx.cs" Inherits="Calc" %>

<asp:Label ID="lblNum1" runat="server" Text="Enter The Number One"></asp:Label>
<asp:TextBox ID="txtNum1" runat="server"></asp:TextBox>
<br />
<asp:Label ID="lblOperation" runat="server" Text="+" runat="server"></asp:Label><br />
<asp:Label ID="lblNum2" runat="server" Text="Enter The Number Two"></asp:Label>
<asp:TextBox ID="txtNum2" runat="server"></asp:TextBox>
<br />
<asp:Button ID="btnAnswer" runat="server" Text="Answer" CausesValidation="false" OnClick="btnAnswer_Click" />
<br />

Usercontrol : Calc.ascx.cs
--------------------------------------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Calc : System.Web.UI.UserControl
{
public delegate void PerformOperationHandler(double num1, double num2);
public event PerformOperationHandler PerformOperation;

protected void Page_Load(object sender, EventArgs e)
{

}

protected void btnAnswer_Click(object sender, EventArgs e)
{
if (PerformOperation != null)
{
PerformOperation(double.Parse(txtNum1.Text),double.Parse(txtNum2.Text));
}
}
}

Page Name:Default.aspx
--------------------------
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default" %>
<%@ Reference Control="~/Calc.ascx" %>

<form id="form1" runat="server">
<div>
<asp:PlaceHolder ID="placeholder" runat="server"></asp:PlaceHolder>
<br />
<asp:Label ID="lblAnswer" runat="server"></asp:Label>
</div>
</form>

Page Name:Default.aspx.cs
----------------------------------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

UserControl Calculation = LoadControl("~/Calc.ascx") as UserControl ;
placeholder.Controls.Clear();
placeholder.Controls.Add(Calculation);
((Calc)Calculation).PerformOperation+=new Calc.PerformOperationHandler(PerformOperation);

}

public void PerformOperation(double num1, double num2)
{
lblAnswer.Text = (num1 + num2).ToString();
}
}

I hopes it will help you.

Regards,
Kinjal Shah

Create Custom Calendar

2009-07-27T03:31:00.000-07:00

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack && Request["date"] == null)
{
RenderCalendar(System.DateTime.Now);
}
else
{
if (Request["date"] != null)
{
RenderCalendar(Convert.ToDateTime(Request["date"]));
}
}
}

private void RenderCalendar(DateTime CurrentDate)
{
tblCalendar.Rows.Clear();
TableRow TitleRow = new TableRow();
TableCell PrevCell = new TableCell();
HyperLink hypPrev = new HyperLink();
hypPrev.Text = "<";
hypPrev.NavigateUrl = "Calendar.aspx?date=" + CurrentDate.AddMonths(-1).ToShortDateString();
TitleRow.Cells.Add(PrevCell);
PrevCell.Controls.Add(hypPrev);

TableCell DateHeaderCell = new TableCell();
DateHeaderCell.ColumnSpan = 5;
Label lblHeader = new Label();

lblHeader.Text = String.Format("{0:MMM}", CurrentDate) + " " + CurrentDate.Year.ToString();
DateHeaderCell.VerticalAlign = VerticalAlign.Middle;
DateHeaderCell.HorizontalAlign = HorizontalAlign.Center;
DateHeaderCell.Font.Bold = true;
TitleRow.Cells.Add(DateHeaderCell);
DateHeaderCell.Controls.Add(lblHeader);

TableCell NextCell = new TableCell();
HyperLink hypNext = new HyperLink();
hypNext.Text = ">";
hypNext.NavigateUrl = "Calendar.aspx?date=" + CurrentDate.AddMonths(1).ToShortDateString();

TitleRow.Cells.Add(NextCell);
NextCell.Controls.Add(hypNext);

tblCalendar.Rows.Add(TitleRow);

TableRow DayRow = new TableRow();
TableCell DayCellSun = new TableCell();
DayCellSun.Text = "Sun";
DayCellSun.Font.Bold = true;
DayRow.Cells.Add(DayCellSun);

TableCell DayCellMon = new TableCell();
DayCellMon.Text = "Mon";
DayCellMon.Font.Bold = true;
DayRow.Cells.Add(DayCellMon);

TableCell DayCellTue = new TableCell();
DayCellTue.Text = "Tue";
DayCellTue.Font.Bold = true;
DayRow.Cells.Add(DayCellTue);

TableCell DayCellWed = new TableCell();
DayCellWed.Text = "Wed";
DayCellWed.Font.Bold = true;
DayRow.Cells.Add(DayCellWed);

TableCell DayCellThu = new TableCell();
DayCellThu.Text = "Thu";
DayCellThu.Font.Bold = true;
DayRow.Cells.Add(DayCellThu);

TableCell DayCellFri = new TableCell();
DayCellFri.Text = "Fri";
DayCellFri.Font.Bold = true;
DayRow.Cells.Add(DayCellFri);

TableCell DayCellSat = new TableCell();
DayCellSat.Text = "Sat";
DayCellSat.Font.Bold = true;
DayRow.Cells.Add(DayCellSat);

tblCalendar.Rows.Add(DayRow);

String nDate = Convert.ToString(CurrentDate.ToShortDateString());

int year = CurrentDate.Year;
int month = CurrentDate.Month;
// int totalDays = DateTime.DaysInMonth(year,month);

String StartDate = month + "/1/" + year;
String FirstDay = Convert.ToDateTime(StartDate).DayOfWeek.ToString();

int currentDay = Convert.ToInt16(Convert.ToDateTime(nDate).Day);
// string CurrentWeekDay = Convert.ToDateTime(nDate).DayOfWeek.ToString();

int count = 0;
DateTime CountDate = Convert.ToDateTime(StartDate);
for (int i = 0; i <= 6; i++)
{
TableRow tr = new TableRow();
for (int j = 1; j <= 7; j++)
{
String CurrDay = GetDay(Convert.ToString(j));
TableCell td = new TableCell();
if (count >= 1 || FirstDay == CurrDay)
{
if (month == Convert.ToDateTime(CountDate).Month)
{
td.Text = Convert.ToDateTime(CountDate).Day.ToString();
count = count + 1;
DateTime dt = Convert.ToDateTime(CountDate).AddDays(1);
CountDate = Convert.ToDateTime(dt.ToShortDateString());

td.Attributes.Add("onClick", "Javascript:alert(" + count + ");");
}
}
else
{
td.Text = " ";
}
tr.Cells.Add(td);
}
tblCalendar.Rows.Add(tr);
}
}
private String GetDay(String Day)
{
switch (Day)
{
case "1":
return "Sunday";
case "2":
return "Monday";
case "3":
return "Tuesday";
case "4":
return "Wednesday";
case "5":
return "Thursday";
case "6":
return "Friday";
case "7":
return "Saturday";

}
return null;
}

URL Rewriting using Intelligencia UrlRewriter

2009-07-21T22:46:00.000-07:00

http://www.blogiversity.org/blogs/blogdayafternoon/archive/2008/12/18/url-rewriting-using-intelligencia-urlrewriter.aspx

Select Box I.E. Width Problem

2009-07-20T03:05:00.000-07:00

Hi,
I trouble with IE dropdown cuteoff problem.
Finally I got solution and here I put that url from where I find solutions.
http://www.hedgerwow.com/360/dhtml/ui_select_with_fixed_width/bk/demo.php

Regards,
Kinjal Shah

Return String value from enum instead of int value

2009-07-16T22:28:00.000-07:00

Hello Frnds,
In my recent project,there is a requirement to get enum string value instead of int. As u all know that enum which will return integer value.
Finally I got the solution. Here I place the code of that customize enum. I hopes it will help you.

Class Name: Enums.cs
public enum HotelActivity : int
{
[StringValue("family friendly")]
Family_Friendly=1
,[StringValue("adults only")]
Adults_Only=2
}

Class Name: StringValueAttribute.cs
public class StringValueAttribute : Attribute
{

public string StringValue { get; protected set; }

public StringValueAttribute(string value)
{
this.StringValue = value;
}
}

Class Name: Extensions.cs
public static class Extensions
{
public static string GetStringValue(this Enum value)
{
// Get the type
Type type = value.GetType();

// Get fieldinfo for this type
System.Reflection.FieldInfo fieldInfo = type.GetField(value.ToString());

// Get the stringvalue attributes
StringValueAttribute[] attribs = fieldInfo.GetCustomAttributes(
typeof(StringValueAttribute), false) as StringValueAttribute[];

// Return the first if there was a match.
return attribs.Length > 0 ? attribs[0].StringValue : null;
}
}

default.aspx.cs
public partial class default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Response.Write(Framework.Enums.HotelActivity.Family_Friendly.GetStringValue());
}
}

Try to implement this code and enjoy :)

Regards,
Kinjal Shah

HTTP Handlers for Image resize in ASP.NET

2009-07-07T23:49:00.000-07:00

Hello frnds,
Here I put the code of image resize using http handler.

Page:PhotoResizeHandler.ashx

<%@ WebHandler Language="C#" Class="PhotoResizeHandler" %>

using System;
using System.Web;
using System.IO;
using System.Drawing.Imaging;
using System.Drawing;
public class PhotoResizeHandler : IHttpHandler
{
string _StrImage = string.Empty;
string _StrExt = string.Empty;
int _IntThumbWidth;
int _IntThumbHeight;

public void ProcessRequest(HttpContext context)
{
if (context.Request.Params["Height"] != null)
{
try
{
_IntThumbHeight = int.Parse(context.Request.Params["Height"]);
}
catch
{
_IntThumbHeight = 0;
}
}
if (context.Request.Params["Width"] != null)
{
try
{
_IntThumbWidth = int.Parse(context.Request.Params["Width"]);
}
catch
{
_IntThumbWidth = 0;
}
}
if (context.Request.Params["Image"] != null)
{
try
{
_StrImage = (context.Request.Params["Image"]).ToString();
}
catch
{
_StrImage = string.Empty;
}
}
if (context.Request.Params["Ext"] != null)
{
try
{
_StrExt = (context.Request.Params["Ext"]).ToString();
}
catch
{
_StrExt = string.Empty;
}
}
ResizeImage(_StrImage, _IntThumbWidth, _IntThumbHeight, _StrExt);

}

public bool IsReusable
{
get
{
return false;
}
}

private void ResizeImage(string MainImage, int thumbWidth, int thumbHeight, string ext)
{
try
{
System.Drawing.Image Image = System.Drawing.Image.FromFile(MainImage);
int srcWidth = Image.Width;
int srcHeight = Image.Height;

int w = thumbWidth, h = thumbHeight;
#region "Proposnal Ratio"
// proposnal resize of your image
if (srcHeight > thumbHeight)
{
w = srcWidth * thumbHeight / srcHeight;
}
else
h = srcHeight;

if (srcWidth > thumbWidth)
{
h = srcHeight * thumbWidth / srcWidth;
}
else
if (w > srcWidth)
w = srcWidth;
if (w > thumbWidth)
h = srcHeight * thumbWidth / srcWidth;
if (h > thumbHeight)
w = srcWidth * thumbHeight / srcHeight;

thumbWidth = (thumbWidth > w ? w : thumbWidth);
thumbHeight = (thumbHeight > h ? h : thumbHeight);
thumbWidth = (thumbWidth == 0 ? 1 : thumbWidth);
thumbHeight = (thumbHeight == 0 ? 1 : thumbHeight);

#endregion

Bitmap bmp = new Bitmap(thumbWidth, thumbHeight);
System.Drawing.Graphics gr = System.Drawing.Graphics.FromImage(bmp);
gr.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;
gr.CompositingQuality = System.Drawing.Drawing2D.CompositingQuality.HighQuality;
gr.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;

System.Drawing.Rectangle rectDestination = new System.Drawing.Rectangle(0, 0, thumbWidth, thumbHeight);
gr.DrawImage(Image, rectDestination, 0, 0, srcWidth, srcHeight, GraphicsUnit.Pixel);

switch (ext.ToUpper())
{
case ".JPG":
case ".JPEG":
HttpContext.Current.Response.ContentType = "image/Jpeg";
bmp.Save(HttpContext.Current.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
break;
case ".GIF":
HttpContext.Current.Response.ContentType = "image/Gif";
bmp.Save(HttpContext.Current.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Gif);
break;
case ".PNG":
System.IO.MemoryStream MemStream = new System.IO.MemoryStream();
HttpContext.Current.Response.ContentType = "image/Png";
bmp.Save(MemStream, System.Drawing.Imaging.ImageFormat.Png);

MemStream.WriteTo(HttpContext.Current.Response.OutputStream);
//bmp.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Png );
break;
}
Image.Dispose();
}
catch (Exception Exc)
{
throw Exc;
}

}
}

Now you need to add one aspx page and create one asp:image controls there.

<asp:Image ID="img" runat="server" />

Then in cs file with on page load event, try to put this line
img.ImageUrl = "PhotoResizeHandler.ashx?Image=" + MainImage + "&Width=65&Height=65&Ext=" + ext;

Hopes this will help you.

Regards,
Kinjal Shah

Some date functions - just date no time, last day of month, first day of month, first day of week and last day of week

2009-07-02T23:51:00.000-07:00

Hi,
I found one article which will fulfill my requirement to perform date operation.
Here I post that link. I hopes it will also help you

http://sqlblogcasts.com/blogs/simons/archive/2008/10/28/Some-date-functions---just-date-no-time--last-day-of-month--first-day-of-month--first-day-of-week-and-last-day-of-week.aspx

Perform paging in sql

2009-07-02T23:13:00.000-07:00

CREATE TABLE DuplicateRcordTable (Col1 INT, Col2 INT)
INSERT INTO DuplicateRcordTable
SELECT 1, 1
UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 2
UNION ALL
SELECT 1, 2 --duplicate
UNION ALL
SELECT 1, 3
UNION ALL
SELECT 1, 4

UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 2
UNION ALL
SELECT 1, 2 --duplicate
UNION ALL
SELECT 1, 3
UNION ALL
SELECT 1, 4

UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 2
UNION ALL
SELECT 1, 2 --duplicate
UNION ALL
SELECT 1, 3
UNION ALL
SELECT 1, 4
UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 2
UNION ALL
SELECT 1, 2 --duplicate
UNION ALL
SELECT 1, 3
UNION ALL
SELECT 1, 4

UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 2
UNION ALL
SELECT 1, 2 --duplicate
UNION ALL
SELECT 1, 3
UNION ALL
SELECT 1, 4

SELECT * FROM DuplicateRcordTable

--Start to perform Paging

DECLARE @PageSize AS INT
SET @PageSize=5
Declare @StartIndex as int
SET @StartIndex=1

SET @StartIndex=((@StartIndex*@PageSize)-@PageSize) + 1
SET @PageSize=(@StartIndex + @PageSize)-1

SELECT Col1,Col2 FROM
(
SELECT *,ROW_NUMBER() over(order by col1) AS RowNumber FROM DuplicateRcordTable
) T WHERE T.RowNumber between @StartIndex and @PageSize

Result:-
Show All Records

Show records based on paging

Remove duplicate records from the table using CTE

2009-07-02T23:06:00.000-07:00

Hello everyone,
I need to remove duplicate rows from the table and for that I made one query with CTE which will remove all duplicate rows from the table.
Here I put an example. So you can get better idea of it.

DROP TABLE DuplicateRcordTable
CREATE TABLE DuplicateRcordTable (Col1 INT, Col2 INT)
INSERT INTO DuplicateRcordTable
SELECT 1, 1
UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 1 --duplicate
UNION ALL
SELECT 1, 2
UNION ALL
SELECT 1, 2 --duplicate
UNION ALL
SELECT 1, 3
UNION ALL
SELECT 1, 4

SELECT * FROM DuplicateRcordTable

;with DuplicateRows
AS
(
SELECT *,ROW_NUMBER() over(partition by Col1,Col2 order by Col1) DuplicateRow FROM DuplicateRcordTable
)
DELETE FROM DuplicateRows where DuplicateRow>1

SELECT * FROM DuplicateRcordTable

RESULT:-
Before deleted duplicate records:-

After deleted duplicate records

TSQL Challenge 3 to Reverse string without using Reverse() function

2009-07-02T03:52:00.000-07:00

I have accept TSQL Challenge 3 from site and try to solve it.
Here is a URL of TSQL Challenge
http://beyondrelational.com/blogs/tc/archive/2009/05/24/tsql-challenge-3.aspx

Solved TSQL Challenge-3

DECLARE @t TABLE( ID INT IDENTITY, data VARCHAR(20))
INSERT INTO @t(data) SELECT 'Jacob'
INSERT INTO @t(data) SELECT 'Sebastian'

SET NOCOUNT ON

;WITH ReverseName AS
(
SELECT T.ID,T.data,CAST('' AS VARCHAR) AS ReverseData ,TotalLength=LEN(T.data),position=0 FROM @t T
UNION ALL
SELECT ReverseName.ID,ReverseName.data , CAST((ReverseName.ReverseData + substring(ReverseName.data,len(ReverseName.data)-position,1)) AS VARCHAR ) as ReverseData ,ReverseName.TotalLength,position=position+1 FROM ReverseName
where ReverseName.TotalLength>=position
)

SELECT ID,ReverseData AS [Reverse String] FROM ReverseName where position>TotalLength order by ID desc

OUTPUT:-

List of Category with it's parent category name

2009-06-30T22:41:00.000-07:00

Here I post one example which will show the result of category and it's parent category name.
Let's come with an example.

Example:-

1) First here I create one function

CREATE FUNCTION CategoryTitle
(
@ID int
) RETURNS varchar(255)
AS
BEGIN
DECLARE @Name VARCHAR(255)
SELECT @Name=Name from CategoryMaster WHERE ID=@ID
return @Name
END

2) Then now I will create one table say as 'CategoryMaster' and inserted some proper values in it.

CREATE Table CategoryMaster
(
ID INT identity(1,1)
, Name varchar(255)
, ParentId int
)

INSERT INTO CategoryMaster VALUES ('Electronics',0),('Camera',1),('Mobile',1),('Sony Ericsson',3),('Nokia',3)

3) Now show the result of CategoryMaster table.

SET NOCOUNT ON

SELECT ID,Name,ParentId FROM CategoryMaster

SELECT ID,[Name] AS Category ,ISNULL((dbo.CategoryTitle(ParentId)),'Root') AS [Parent Category] FROM CategoryMaster

Other way using CTE:-
;WITH Category AS
(
SELECT ID,Name AS Category,CAST('Root' AS VARCHAR) AS [Parent Category] FROM CategoryMaster WHERE ParentId=0
UNION ALL
SELECT CM.ID,CM.Name AS Category,CAST(C.Category AS VARCHAR) AS [Parent Category] FROM CategoryMaster CM
INNER JOIN Category C ON C.ID=CM.ParentId
)
SELECT * FROM Category

RESULT :-

I hopes this will help you.

Creating RSS FEED in asp.net

2009-04-12T09:05:00.000-07:00

Hello guys,

Please read below url if u need to implement RSS feed in your site.
I hopes this below URL will give better idea how to make RSS FEED.

http://www.aspcode.net/Creating-an-RSS-feed-for-your-ASPNET-site.aspx

Thanks

Introduction of a dynamic sql query

2009-04-12T08:35:00.000-07:00

Hello guys,
In past few a days, I need to make procedure which will pass as a parameter and based on that parameter value need to execute query. So I have made this procedure with dynamic query.

There is a basically two alternate way where you made dynamic query. Let see below example.

1) Using Exec.

With this approach you are building the SQL statement on the fly and can pretty much do whatever you need to in order to construct the statement.

An Example

Declare @query as varchar(1000)
Declare @Name as varchar(100)
SET @Name=’’’Andy’’’

Set @query=’SELECT * FROM CUSTOMER WHERE NAME=’+ @Name

Exec(@query)

2) USING sp_executesql
sp_executesql is a system stored procedure that you can use in place of "exec" to execute your dynamic sql.
This allows you to have parameters in your dynamic query and pass them in. The end result is that SQL Server will try to cache the execution plan for your query giving you some of the advantages of a fully compiled query.

An example
Declare @SQL nVarChar(1000) sp_executesql
SELECT @SQL = 'SELECT * FROM CUSTOMER WHERE NAME = @Name

Exec sp_executesql @SQL, N'@Name nVarChar(50)', @Name = 'Andy'

So advantages of build dynamic query using sp_executesql is that 1) No risk for SQL injection.2) Better plan reuse in the plan cache.

LINQ Pad

2008-12-17T09:54:00.000-08:00

Hello,

I hope some are aware of linqpad.
It will provide nice example to learn and understand what about LINQ to SQL.

Anyone who are interested and need more information then go through this url http://www.linqpad.net/ and download LINQPad.

LINQToSql Tutorial

http://it-box.blogturk.net/wp-content/themes/it-box/files/LINQToSql.pdf

I hope this will help you.