void AddFooter(ref DsReports.DailySalesDataTable dt ,DateTime d1,bool isdate,bool useconstr=false,string newconstr="p")
{
var cprice = isdate ? GetSumCprice(d1, useconstr, newconstr) : GetSumCprice(useconstr, newconstr);
var sprice = isdate ? GetSumSprice(d1, useconstr, newconstr) : GetSumSprice(useconstr, newconstr);
var begcas = GetLastClosingAmt(d1,isdate);
var cashonhand = 0m;
foreach (DataRow d in dt.Rows)
{
if (d["Ctype"].ToString() == "1")
if(!string.IsNullOrEmpty(d["TOTAL"].ToString()))
cashonhand = decimal.Parse(d["TOTAL"].ToString());
}
var ndr = dt.NewRow();
ndr["Ctype"] = 11;
ndr["Shift1"] = cprice;
ndr["Shift3"] = "Sale value";
ndr["TOTAL"] = sprice;
dt.Rows.Add(ndr);
//dt.Rows.InsertAt(ndr, 12);
//ndr = dt.NewRow();
//ndr["Ctype"] = 12;
//ndr["Shift1"] = sprice;
//dt.Rows.Add(ndr);
//dt.Rows.InsertAt(ndr, 13);
ndr = dt.NewRow();
ndr["Ctype"] = 13;
ndr["Shift1"] = begcas;
ndr["Shift3"] = "Cash on hand";
ndr["TOTAL"] = cashonhand + begcas;
dt.Rows.Add(ndr);
//dt.Rows.InsertAt(ndr, 14);
//ndr = dt.NewRow();
// ndr["Ctype"] = 14;
// ndr["Shift1"] = cashonhand + begcas;
// dt.Rows.Add(ndr);
// dt.Rows.InsertAt(ndr, 15);
}
void CreateFixDailySales(ref DsReports.DailySalesDataTable dt)
{
for (int i = 1; i < 11; i++)
{
var dr = dt.NewRow();
dr["Ctype"] = i;
dt.Rows.Add(dr);
}
}
