protected void BindData() { try { List <SaleHeaderDTO> lst = new List <SaleHeaderDTO>(); List <SaleHeaderDTO> lstMod = new List <SaleHeaderDTO>(); 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, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")).AddDays(1); //DateTime date = string.IsNullOrEmpty(txtDate.Text) ? DateTime.MinValue : DateTime.ParseExact(txtDate.Text, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US")); string AccName = txtCustName.Text; string SN = txtSN.Text; string Tel = txtTel.Text; Int32 ItemID = 0; ItemID = ToInt32(ddlItem.SelectedItem.Value); using (BillingEntities cre = new BillingEntities()) { //lst = (from h in cre.TransSaleHeaders // join d in cre.TransSaleDetails on h.SaleHeaderID equals d.SaleHeaderID into dnull // from d in dnull.DefaultIfEmpty() // join i in cre.MasItems on d.ItemID equals i.ItemID into inull // from i in inull.DefaultIfEmpty() // where h.CustomerName.Contains(AccName) // //&& d.SerialNumber.Contains(SN) // && h.ReceivedDate >= dateFrom && h.ReceivedDate < dateTo // //date == DateTime.MinValue ? true : h.ReceivedDate.HasValue ? h.ReceivedDate.Value == date : true // select new SaleHeaderDTO() // { // SaleHeaderID = h.SaleHeaderID, // CustomerName = h.CustomerName, // ReceivedDate = h.ReceivedDate, // ReceivedBy = h.ReceivedBy, // SaleNumber = h.SaleNumber, // ItemCode = i.ItemCode, // ItemName = i.ItemName, // ItemID = i.ItemID, // dAmount = d.Amount, // ItemPrice = d.ItemPrice.HasValue ? d.ItemPrice.Value : 0, // Discount = d.Discount.HasValue ? d.Discount.Value : 0, // SerialNumber = d.SerialNumber, // }).ToList(); lst = (from d in cre.GetTransSaleList(dateFrom, dateTo) select new SaleHeaderDTO() { SaleHeaderID = d.SaleHeaderID, CustomerName = d.CustomerName, Tel = d.tel, ReceivedDate = d.ReceivedDate, ReceivedBy = d.ReceivedBy, SaleNumber = d.SaleNumber, ItemCode = d.ItemCode, ItemName = d.ItemName, ItemID = d.ItemID.HasValue ? d.ItemID.Value : 0, dAmount = d.Amount, ItemPrice = d.ItemPrice.HasValue ? d.ItemPrice.Value : 0, Discount = d.Discount.HasValue ? d.Discount.Value : 0, SerialNumber = d.SerialNumber, BillType = d.BillType, }).ToList(); }; if (lst != null && lst.Count > 0) { if (AccName != "") { lst = lst.Where(w => w.CustomerName.Contains(AccName)).ToList(); } if (Tel != "") { lst = lst.Where(w => !string.IsNullOrEmpty(w.Tel) && w.Tel.Contains(Tel)).ToList(); } if (SN != "") { lst = lst.Where(w => !string.IsNullOrEmpty(w.SerialNumber) && w.SerialNumber.Contains(SN)).ToList(); } if (ItemID != 0) { lst = lst.Where(w => w.ItemID.Equals(ItemID)).ToList(); } if (lst != null && lst.Count > 0) { lstMod = ModDataFromSale(lst); gv.DataSource = lstMod; } if (ItemID != 0 || SN != "") { gv.Columns[5].Visible = false; } else { gv.Columns[5].Visible = true; } } else { gv.DataSource = null; } gv.DataBind(); } catch (Exception ex) { SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod()); } }