public ItemReportForm(Int64 fromOID, Int64 toOID, DateTime fromDate, DateTime toDate, int orderCount, bool showAll, string _dateRangeText)
{
InitializeComponent();
// fiscalPrinter = new FiscalPrinter();
tempPrintMethods = new CPrintMethodsEXT();
this.fromDate = fromDate;
this.toDate = toDate;
dateRangeText = _dateRangeText;
_showAll = showAll;
lblDate.Text += " " + fromDate.ToLongDateString() + " to: " + toDate.ToLongDateString();
lblOrderCount.Text += orderCount;
SystemManager sysManager = new SystemManager();
dtFood = sysManager.GetItemWiseSales(fromOID, toOID, "Food", Convert.ToByte(showAll));
gridViewFood.DataSource = dtFood;
dtNonFood = sysManager.GetItemWiseSales(fromOID, toOID, "NonFood", Convert.ToByte(showAll));
gridViewNonFood.DataSource = dtNonFood;
if (dtFood != null && dtNonFood != null)
{
int query =
(from order in dtFood.AsEnumerable()
select order.Field<Int32>("QuantitySold")).Sum();
lblQtySoldFood.Text += " " + query;
int query2 =
(from order in dtNonFood.AsEnumerable()
select order.Field<Int32>("QuantitySold")).Sum();
lblQtySoldNonFood.Text += " " + query2;
lblQtySoldTotal.Text += " " + (query2 + query);
Double P1 = 0;
Double P2 = 0;
foreach (DataRow row in dtFood.Rows)
{
P1 += Convert.ToDouble(row["TotalPrice"].ToString());
}
foreach (DataRow row in dtNonFood.Rows)
{
P2 += Convert.ToDouble(row["TotalPrice"].ToString());
}
lblPriceFood.Text += " " + P1.ToString("F02");
lblPriceNonFood.Text += " " + P2.ToString("F02");
lblPriceTotal.Text += " " + (P1 + P2).ToString("F02");
}
}
