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