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) { } }