private void functionalButton1_Click(object sender, EventArgs e) { // if (fiscalPrinter.foundPrinter()) // fiscalPrinter.ClearPrinting(); // change by mithu Int64 startDate = new DateTime(dtpStart.Value.Year, dtpStart.Value.Month, dtpStart.Value.Day, 0, 0, 0).Ticks; DateTime dtTemp = dtpEnd.Value.AddDays(1); Int64 endDate = new DateTime(dtTemp.Year, dtTemp.Month, dtTemp.Day, 0, 0, 0).Ticks; ViewReportAmount v = new ViewReportAmount(); SystemManager sysManager = new SystemManager(); v.aCSearchOrderInfos = sysManager.GetOrderInfo2(startDate, endDate); v.startDate = dtpStart.Value; v.endDate = dtTemp.Date; v.endDate = v.endDate.AddSeconds(-1); List<DatewiseTotal> aDatewiseTotals = new List<DatewiseTotal>(); try { while (v.startDate.Date <= v.endDate.Date) { DatewiseTotal aTotal = new DatewiseTotal(); aTotal.CashTotal = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.CashPaid).Sum(); aTotal.Covers = (int) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.Covers).Sum(); aTotal.DiscountTotal = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.Discount).Sum(); aTotal.EFTTotal = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.EFTPaid).Sum(); aTotal.DueTotal = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.DuePaid).Sum(); aTotal.FoodTotal = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.FoodTotal).Sum(); aTotal.NoonFoodTotal = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.NonfoodTotal).Sum(); aTotal.OrderTotal = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.OrderTotal).Sum(); aTotal.ServiceChargeTotal = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.ServiceChargeCash).Sum(); aTotal.TotalIncV = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.TotalPaidIncludingVat).Sum(); aTotal.VatTotal = (double) (from search in v.aCSearchOrderInfos where search.OrderDateTime.Date == v.startDate.Date select search.VatPaid).Sum(); aTotal.Date = v.startDate.Date; aDatewiseTotals.Add(aTotal); v.startDate = v.startDate.AddDays(1); } } catch (Exception) { } v.DatewiseTotals = aDatewiseTotals; v.reportdataGridView.DataSource = aDatewiseTotals; v.Show(); }
private void showAllData(Int64 startDate, Int64 endDate) { SystemManager sysManager = new SystemManager(); oItemList = new List<CSearchOrderInfo>(); oItemList = sysManager.GetOrderInfo2(startDate, endDate); oItemList = CheckBeetweenTime(oItemList); // New added // Change by Mithu if (radioButtonCheat.Checked) { if (ManualCheatReport()) { txtBoxCheatPercent.Visible = false; oItemList = getManulCheatOrderList(oItemList); } else { oItemList = getAutoCheatOrderList(oItemList); } } if (chkTerminalName.Checked) { var filter = from searchItem in oItemList where searchItem.TerminalID == pcInfoList[cmbTerminalName.SelectedIndex].PcID.ToString() select searchItem; oItemList = filter.ToList(); } if (rbtnTable.Checked) { var filter = from searchItem in oItemList where searchItem.OrderType == "Table" || searchItem.OrderType == "Token" select searchItem; oItemList = filter.ToList(); } if (rbtnTakeAway.Checked) { var filter = from searchItem in oItemList where searchItem.OrderType == "TakeAway" select searchItem; oItemList = filter.ToList(); } if (dueTotalradioButton1.Checked) { var filter = from searchItem in oItemList where searchItem.DuePaid >0 select searchItem; oItemList = filter.ToList(); } if (txtBoxSerialNumber.Text != string.Empty) { var filter = from searchItem in oItemList where searchItem.SerialNumber == txtBoxSerialNumber.Text select searchItem; oItemList = filter.ToList(); } if(complementoryRadioButton.Checked) { var filter = from searchItem in oItemList where searchItem.ComplementoryMessage.Length!=0 select searchItem; oItemList = filter.ToList(); } if (dueRadioButton.Checked) { var filter = from searchItem in oItemList where searchItem.DueMessage.Length != 0 select searchItem; oItemList = filter.ToList(); } if (orderComplementoryRadioButton.Checked) { var filter = from searchItem in oItemList where searchItem.ComplementoryPaid > 0 select searchItem; oItemList = filter.ToList(); } int totalCovers = (from item in oItemList select item.Covers).Sum(); lelGuest_Value.Text = totalCovers.ToString(); decimal totalFood = (from item in oItemList select item.FoodTotal).Sum(); lelFoodPrice_Value.Text = totalFood.ToString(); decimal totalNonFood = (from item in oItemList select item.NonfoodTotal).Sum(); lelNonfoodPrice_Value.Text = totalNonFood.ToString(); decimal totaltableFood = (from item in oItemList where item.OrderType == "Table" select item.FoodTotal).Sum(); lelTableFoodPrice_Value.Text = totaltableFood.ToString(); decimal totaltableNonFood = (from item in oItemList where item.OrderType == "Table" select item.NonfoodTotal).Sum(); lelTableNonfoodPrice_Value.Text = totaltableNonFood.ToString(); decimal totalTakeWayFood = (from item in oItemList where item.OrderType == "TakeAway" select item.FoodTotal).Sum(); lelTakeAwayFoodPrice_Value.Text = totalTakeWayFood.ToString(); decimal totalTakeWayNonFood = (from item in oItemList where item.OrderType == "TakeAway" select item.NonfoodTotal).Sum(); lelTakeAwayNonfoodPrice_Value.Text = totalTakeWayNonFood.ToString(); /*decimal totalbarWayFood = (from item in oItemList where item.OrderType == "Bars" select item.FoodTotal).Sum(); lelTabsFoodPrice_Value.Text = totalbarWayFood.ToString(); decimal totalBarWayNonFood = (from item in oItemList where item.OrderType == "Bars" select item.NonfoodTotal).Sum(); lelTabsNonfoodPrice_Value.Text = totalBarWayNonFood.ToString();*/ decimal totalDisCount = (from item in oItemList select item.Discount).Sum(); lelDiscount_Value.Text = totalDisCount.ToString(); decimal totalSerViceCharge = (from item in oItemList select item.ServiceChargeCash).Sum(); lelServiceCharge_Value.Text = totalSerViceCharge.ToString(); decimal totalOrderTotal = (from item in oItemList select item.OrderTotal).Sum(); lelOrderTotal_Value.Text = totalOrderTotal.ToString(); decimal totalpaidExvat = (from item in oItemList select item.TotalPaidExcludingVat).Sum(); lelTotalpaidEXVAT_value.Text = totalpaidExvat.ToString(); decimal totalpaidIncvat = (from item in oItemList select item.TotalPaidIncludingVat).Sum(); lelTotalpaidIncVAT_value.Text = totalpaidIncvat.ToString(); decimal totalpaidvat = (from item in oItemList select item.VatPaid).Sum(); lelVat_Value.Text = totalpaidvat.ToString(); decimal totalcash = (from item in oItemList select item.CashPaid).Sum(); lelCashTotal_value.Text = totalcash.ToString(); decimal totaleft = (from item in oItemList select item.EFTPaid).Sum(); lelEftTotal_value.Text = totaleft.ToString(); double totalCost = (from item in oItemList select item.TotalCost).Sum(); double profit = (double)totalpaidExvat - totalCost; profitlebel.Text = profit.ToString("F02"); double itemDiscount = (from item in oItemList select item.ItemDiscount).Sum(); itemDiscountlabel.Text = itemDiscount.ToString(); if(waiterradioButton.Checked) { string sr = waitercomboBox.Text; oItemList = (from oitemList in oItemList where oitemList.Waiter == sr select oitemList).ToList(); } else if (tableNumberradioButton.Checked) { try { int tablenumber = Convert.ToInt32(tableNumbertextBox.Text); oItemList = (from oitemList in oItemList where oitemList.TableNumber == tablenumber select oitemList).ToList(); } catch (Exception) { } } decimal dueBill = oItemList.Sum(a => a.DuePaid); dueTotalLabel.Text = dueBill.ToString("F02"); decimal complementoryBill = oItemList.Sum(a => a.ComplementoryPaid); complementorylabel.Text = complementoryBill.ToString("F02"); dataGridView1.DataSource = oItemList; dataGridView1.Columns["Vat_stat"].Visible = false; }