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