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());
}
}
