ASP.Net with C# 2.0,3.0,LinqToSql,WCF + Json,JQuery,MVP Architecture

Query to Find First and Last Day of Current Month

2010-04-26T03:51:00.000-07:00

Hello friends,
Following is a TSQL script that will find the 'Last day of previous month','First day of current month' and so on...
Hope so this will help you.

DECLARE @mydate DATETIME
SELECT @mydate = GETDATE()
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)),@mydate),101) ,
'Last Day of Previous Month'
UNION
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(@mydate)-1),@mydate),101) AS Date_Value,
'First Day of Current Month' AS Date_Type
UNION
SELECT CONVERT(VARCHAR(25),@mydate,101) AS Date_Value, 'Today' AS Date_Type
UNION
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))),DATEADD(mm,1,@mydate)),101) ,
'Last Day of Current Month'
UNION
SELECT CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))-1),DATEADD(mm,1,@mydate)),101) ,
'First Day of Next Month'
GO

You can find main article on this url i.e. http://blog.sqlauthority.com/2007/05/13/sql-server-query-to-find-first-and-last-day-of-current-month/

Regards,
Kinjal

XML Path Query

2010-03-22T23:02:00.000-07:00

Hello Friends,
Here I provide you one link that will share you how to use xml in sql server.

http://beyondrelational.com/blogs/jacob/archive/2008/08/04/for-xml-path-how-to-remove-the-lt-row-gt-element-from-the-output-of-a-for-xml-path-query.aspx

Hopes it will help for beginners.

Regards,
Kinjal

MVC2

2010-03-16T03:27:00.000-07:00

http://microsoftpdc.com/Sessions/FT59?type=wmv

Create MessageBox user control using ASP.NET and CSS

2010-03-15T23:02:00.000-07:00

Hello friends,
I read one article that will shown how an importance of handling different message types properly.

So here I just put the link of that article.
http://www.jankoatwarpspeed.com/post/2008/05/28/Create-MessageBox-user-control-using-ASPNET-and-CSS.aspx

I hopes you are also interest in it.

Regards,
Kinjal

Embeded Script

2010-03-12T01:37:00.000-08:00

Redirect from Http to Https in ASP.NET

2010-03-02T00:28:00.000-08:00

Hello frnds,
In my one project, there is a requirement for redirect some page from HTTP to HTTPS.
So find one great article that will help me. So here I post the link of that article and code of how its work.

http://www.xdevsoftware.com/blog/post/Redirect-from-Http-to-Https-in-ASPNET.aspx

Code:-
-------------------------------------------------------
Class File Name: SecurePages.cs
-------------------------------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Collections.Specialized;
#region "SecurePage Class"
public class SecurePage
{
string _path = "";
string _pathType = "";

public string Path
{
get { return this._path; }
set { this._path = value; }
}

public string PathType
{
get { return this._pathType; }
set { this._pathType = value; }
}
}
#region "SecurePath Class"
public class SecurePath
{

public static bool IsSecure(string path)
{
List lstPages = new List();

bool isSecure = false;

try
{
//Fill the list of pages defined in web.config
NameValueCollection sectionPages = (NameValueCollection)ConfigurationManager.GetSection("SecurePages");

foreach (string key in sectionPages)
{
if ((!string.IsNullOrEmpty(key)) && (!string.IsNullOrEmpty(sectionPages.Get(key))))
{
lstPages.Add(new SecurePage { PathType = sectionPages.Get(key), Path = key });
}
}

//loop through the list to match the path with the value in the list item
foreach (SecurePage page in lstPages)
{
switch (page.PathType.ToLower().Trim())
{
case "directory":
if (path.Contains(page.Path))
{
isSecure = true;
}
break;
case "page":
if (path.ToLower().Trim() == page.Path.ToLower().Trim())
{
isSecure = true;
}
break;
default:
isSecure = false;
break;
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}

return isSecure;
}
}
#endregion

#endregion

/* Add New custom section in web.config */

<configuration>
<configSections>
<section name="SecurePages" type="System.Configuration.NameValueFileSectionHandler, System, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</configSections>
<SecurePages>
<add key="/admin" value="directory" />
<add key="/WebForm2.aspx" value="page" />
<add key="/WebForm1.aspx" value="page" />
<add key="/myDir/myDirSec" value="directory" />
</SecurePages>
</configuration>

Generate N Level Product List Using CTE

2010-02-12T03:28:00.000-08:00

Hello Friends,
Here I show you example which will generate navigation list for product through N level. Please check below query for generate N Level product list.

Query:-
-----------------------------------------------

DECLARE @Category TABLE
(
CategoryID INT
,Name VARCHAR(100)
,ParentID INT
)

INSERT INTO @Category(CategoryID,Name,ParentID) VALUES ( 1,'Mobile',0)
INSERT INTO @Category(CategoryID,Name,ParentID) VALUES ( 2,'Nokia',1)
INSERT INTO @Category(CategoryID,Name,ParentID) VALUES ( 3,'Samsung',1)
INSERT INTO @Category(CategoryID,Name,ParentID) VALUES ( 4,'Headphone',0)
INSERT INTO @Category(CategoryID,Name,ParentID) VALUES ( 5,'Nokia N70',2)
INSERT INTO @Category(CategoryID,Name,ParentID) VALUES ( 6,'Nokia N72',2)
INSERT INTO @Category(CategoryID,Name,ParentID) VALUES ( 7,'IBall',4)

;WITH CTE(CategoryID,Name,ParentID,level,ParentName)
AS
(
SELECT CategoryID,Name,ParentID,0,cast('.' + Name + '.' AS VARCHAR(MAX)) FROM @Category WHERE ParentID=0
UNION ALL
SELECT C.CategoryID,C.Name,CT.ParentID,level + 1,CAST (CT.ParentName + '.' + C.Name AS VARCHAR(MAX)) FROM @Category C
INNER JOIN CTE CT ON CT.CategoryID=C.ParentID
)
SELECT SPACE(level * 4) + Name AS Products FROM CTE ORDER BY ParentName

Output
-------------------

Common Table Expression Example

2010-01-27T03:05:00.001-08:00

Hello Friends,
Here I put the sample code example using CTE.

--Generate Fibonacii Series using CTE

;WITH FibonaciiSeries(N,F1,F2,F3)
AS
(
SELECT CAST(1 AS BIGINT), CAST(1 AS BIGINT),CAST(0 AS BIGINT),CAST(1+0 AS BIGINT)
UNION ALL
SELECT N+1, F2,F3,F2+F3 FROM FibonaciiSeries WHERE N<92
)
SELECT * FROM FibonaciiSeries

--OUTPUT
-------------------------

--Find Factorial

;WITH Factorial(N,Number)
AS
(
SELECT CAST (1 AS BIGINT), CAST (1 AS BIGINT)
UNION ALL
SELECT N+1,CAST ((N+1)*(Number) AS BIGINT) FROM Factorial WHERE N<10
)

SELECT * FROM Factorial

--OUTPUT
-------------------------

Find the second highest salary for each department

2010-01-25T03:16:00.000-08:00

Hello Friends,
Here I post one TSQL Challenge. I hopes it will help you.

TSQL Beginner’s Challenge #1 – Find the second highest salary for each department

http://beyondrelational.com/blogs/tcb/archive/2009/10/13/tsql-beginner-s-challenge-1-find-the-second-highest-salary-for-each-department.aspx

TSQL Challenge Solved-

TSQL:-
SET NOCOUNT ON
DECLARE @Employees TABLE(
EmployeeID INT IDENTITY,
EmployeeName VARCHAR(15),
Department VARCHAR(15),
Salary NUMERIC(16,2)
)

INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('T Cook','Finance', 40000)
INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('D Michael','Finance', 25000)
INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('A Smith','Finance', 25000)
INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('D Adams','Finance', 15000)

INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('M Williams','IT', 80000)
INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('D Jones','IT', 40000)
INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('J Miller','IT', 50000)
INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('L Lewis','IT', 50000)

INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('A Anderson','Back-Office', 25000)
INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('S Martin','Back-Office', 15000)
INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('J Garcia','Back-Office', 15000)
INSERT INTO @Employees(EmployeeName, Department, Salary)
VALUES('T Clerk','Back-Office', 10000)

SELECT * FROM @Employees

;WITH SecondHighestSalary
AS
(
SELECT EmployeeID,EmployeeName,Department,SALARY AS SALARY,RANK() over (partition by Department order by salary) AS SalaryNumber FROM @Employees
)
SELECT EmployeeID,EmployeeName,Department,SALARY FROM SecondHighestSalary WHERE SalaryNumber=2

OUTPUT:-

Use of Sys.Net.WebRequest

2010-01-19T21:52:00.000-08:00

Hello Friends,
I read on article which can access web service using Sys.Net.WebRequest. Below is a read article URL i.e
http://www.dotnetfunda.com/articles/article480-accessing-webservice-by-using-sysnetwebrequest-.aspx

So I need to access handler using Sys.Net.WebRequest.

So here is a sample code to access handler using Sys.Net.WebRequest.

WebRequest.Aspx Page
---------------------------------------------

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div>
<input type="text" id="text1" /><br />
<input type="button" id="Button1" value="Button" onclick="return Button1_onclick()" />
</div>
<div id="result">

</div>
</div>
<script language="javascript" type="text/javascript">
function Button1_onclick() {

var myRequest = new Sys.Net.WebRequest;
myRequest.set_url("sampleHandler.ashx");
myRequest.set_httpVerb("POST");
var tbvalue = document.getElementById("text1").value;
var body = "Param1=" + tbvalue;
myRequest.set_body(body);
myRequest.get_headers()["Content-Length"] = body.length;
myRequest.add_completed(myResultHandler);
myRequest.invoke();
}

function myResultHandler(executor, eventArgs) {
if (executor.get_responseAvailable) {
var result = document.getElementById("result");
result.innerHTML = executor.get_responseData();
}
}
</script>
</form>
</body>
</html>

Now Here is a code for 'sampleHandler.ashx'

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

using System;
using System.Web;

public class sampleHandler : IHttpHandler {

public void ProcessRequest (HttpContext context) {
string paramValue = string.Empty;
if (HttpContext.Current.Request.Form["Param1"]!="")
{
paramValue = HttpContext.Current.Request.Form["Param1"];
}
context.Response.ContentType = "text/plain";
context.Response.Write(paramValue);
}

public bool IsReusable {
get {
return false;
}
}

}

Happy Coding and Enjoy it...

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