protected void BindData() { try { List <ReportSaleItemDTO> lst = new List <ReportSaleItemDTO>(); DateTime dateFrom = string.IsNullOrEmpty(txtDateFrom.Text) ? DateTime.MinValue : DateTime.ParseExact(txtDateFrom.Text, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")); DateTime dateTo = string.IsNullOrEmpty(txtDateTo.Text) ? DateTime.MaxValue : DateTime.ParseExact(txtDateTo.Text + " 235959", "dd/MM/yyyy HHmmss", new System.Globalization.CultureInfo("en-US")); //Int32 itemID = ToInt32(ddlMItem.SelectedItem.Value); string ItemCode = "", Group = ""; //ItemCode = ddlItem.SelectedItem.Value; ItemCode = txtItemCode.Text; Group = chkShow.Checked ? "1" : ""; using (BillingEntities cre = new BillingEntities()) { lst = (from d in cre.GetReportSaleItem(dateFrom, dateTo, ItemCode, Group) select new ReportSaleItemDTO() { //HeaderID = h.SaleHeaderID, //CustomerName = h.CustomerName, //ReceivedDate = h.ReceivedDate, //SaleNumber = h.SaleNumber, ItemCode = d.ItemCode, ItemName = d.ItemName, ItemPrice = d.ItemPrice.Value, Amount = d.sumAmt.Value, }).OrderBy(od => od.ItemCode).ToList(); //lst = (from h in cre.TransSaleHeaders // join d in cre.TransSaleDetails on h.SaleHeaderID equals d.SaleHeaderID // join i in cre.MasItems on d.ItemID equals i.ItemID // where i.ItemCode.Contains(ItemCode) // && h.ReceivedDate > dateFrom && h.ReceivedDate < dateTo // //&& dateFrom == DateTime.MinValue ? true : h.ReceivedDate.HasValue ? h.ReceivedDate.Value == date : true // select new ReportSaleItemDTO() // { // //HeaderID = h.SaleHeaderID, // //CustomerName = h.CustomerName, // //ReceivedDate = h.ReceivedDate, // //SaleNumber = h.SaleNumber, // ItemCode = i.ItemCode, // ItemName = i.ItemName, // ItemPrice = d.ItemPrice.Value, // Discount = d.Discount.Value, // Amount = d.Amount.Value, // }).OrderBy(od => od.ItemCode).ToList(); }; if (Group == "1") { gv.Columns[3].Visible = true; gv.Columns[4].Visible = true; } else { gv.Columns[3].Visible = false; gv.Columns[4].Visible = false; } if (lst != null && lst.Count > 0) { //ModData(lst); gv.DataSource = lst; Session["ReportSaleItem"] = lst; } else { gv.DataSource = null; } gv.DataBind(); } catch (Exception ex) { SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }