private void getall()
{
// blbooking.action = "Upstream";
/// blbooking.PackageId = ddlPackage.SelectedValue;
if (txtfrom.Text != "")
{
blbooking._dtStartDate = DateTime.Parse(txtfrom.Text);
}
else
{
blbooking._dtStartDate = DateTime.Parse("1990/01/01");
}
if (txtTo.Text != "")
{
blbooking._dtEndDate = DateTime.Parse(txtTo.Text);
}
else
{
blbooking._dtEndDate = DateTime.Parse("1990/01/01");
}
dtall = dlbooking.getmonthlyrevenueAll(blbooking);
if (ddlPackage.SelectedValue != "All Packages")
{
DataView dvopendates = new DataView(dtall);
string filter = "packageid='" + ddlPackage.SelectedValue + "'";
dvopendates.RowFilter = filter;
dtall = dvopendates.ToTable();
}
DateTime str = blbooking._dtStartDate.AddDays(7);
DateTime end = blbooking._dtEndDate;
//var query = from row in dtall.AsEnumerable()
// // group row by new { ShortPackName=row.Field<string>("ShortPackName"), StartDate = row.Field<DateTime>("StartDate").Date, BoardingFrom= row.Field<string>("BordingFrom"),BoardingTo=row.Field<string>("BoadingTo") } into z
// group row by new { EndDate = row.Field<DateTime>("Edate").Date } into z
// select new
// {
// EndDate = z.Key.EndDate,
// // BoardingFrom=z.Key.BoardingFrom,
// // BoardingTo=z.Key.BoardingTo,
// // ShortPackName=z.Key.ShortPackName
// };
dtgroupby.Columns.Add(new DataColumn("EndDate", typeof(string)));
// dtgroupby.Columns.Add(new DataColumn("BordingFrom", typeof(string)));
// dtgroupby.Columns.Add(new DataColumn("BoadingTo", typeof(string)));
//dtgroupby.Columns.Add(new DataColumn("ShortPackName", typeof(string)));
dtgroupby.Columns.Add(new DataColumn("StartDate", typeof(string)));
for (DateTime i = blbooking._dtStartDate; i < end; i = i.AddDays(7))
{
string strtdate = i.ToShortDateString();
string enddate = i.AddDays(7).ToShortDateString();
DataRow row = dtgroupby.NewRow();
row["StartDate"] = strtdate;
row["EndDate"] = enddate;
dtgroupby.Rows.Add(row);
}
if (dtall.Rows.Count > 0)
{
string firstrow = dtall.Rows[0]["ShortPackName"].ToString();
if (firstrow == "Upstream")
{
DataView dvopendates = new DataView(dtall);
string filter = "ShortPackName='Upstream'";
dvopendates.RowFilter = filter;
dt = dvopendates.ToTable();
DataView dvopendates2 = new DataView(dtall);
string filter2 = "ShortPackName='Downstream'";
dvopendates2.RowFilter = filter2;
dt1 = dvopendates2.ToTable();
getUpstreamCalculation();
getDownstreamCalculation();
}
if (firstrow == "Downstream")
{
DataView dvopendates = new DataView(dtall);
string filter = "ShortPackName='Downstream'";
dvopendates.RowFilter = filter;
dt = dvopendates.ToTable();
DataView dvopendates2 = new DataView(dtall);
string filter2 = "ShortPackName='Upstream'";
dvopendates2.RowFilter = filter2;
dt1 = dvopendates2.ToTable();
getUpstreamCalculation2();
getDownstreamCalculation2();
}
}
Session["getdata"] = dt;
if (dt != null && dt.Rows.Count > 0)
{
}
}