private void CloseCashierPeriodUI_Load(object sender, EventArgs e) { this.BackColor = Color.FromArgb(int.Parse(GlobalVariables.FormBackColor)); GlobalVariables.CashierId = "0"; GlobalVariables.CashierName = ""; foreach (DataRow _dr in loCashier.getCashierDetails(GlobalVariables.UserId).Rows) { GlobalVariables.CashierId = _dr[0].ToString(); GlobalVariables.CashierName = _dr[2].ToString(); } if (GlobalVariables.CashierId == "0") { MessageBoxUI _mb = new MessageBoxUI("Only Cashier can close a Cashier Period!", GlobalVariables.Icons.Error, GlobalVariables.Buttons.OK); _mb.showDialog(); this.Close(); } else { decimal _cashDeposit = 0; decimal _totalSales = 0; decimal _totalReturn = 0; decimal _discountAmount = 0; decimal _noncashsales = 0; decimal _cashsales = 0; foreach (DataRow _dr in loCashierPeriod.getAllData("", GlobalVariables.CashierPeriodId, "").Rows) { _cashDeposit = decimal.Parse(_dr["Cash Deposit"].ToString()); } foreach (DataRow _dr in loPOSTransaction.getTotalSalesByCashierPeriod(GlobalVariables.CashierPeriodId).Rows) { _totalSales = decimal.Parse(_dr[0].ToString()); } foreach (DataRow _dr in loPOSTransaction.getTotalReturnedByCashierPeriod(GlobalVariables.CashierPeriodId).Rows) { _totalReturn = decimal.Parse(_dr[0].ToString()); } foreach (DataRow _dr in loPOSTransaction.getTotalDiscountByCashierPeriod(GlobalVariables.CashierPeriodId).Rows) { _discountAmount = decimal.Parse(_dr[0].ToString()); } foreach (DataRow _dr in loPOSTransaction.getSalesByCashierPeriod(GlobalVariables.CashierPeriodId).Rows) { if (_dr[0].ToString() == "Non-Cash") { _noncashsales = decimal.Parse(_dr[1].ToString()); } else { _cashsales = decimal.Parse(_dr[1].ToString()); } } lblCashDeposit.Text = string.Format("{0:n}", _cashDeposit); lblTotalSales.Text = string.Format("{0:n}", _totalSales); lblReturnedItemTotal.Text = string.Format("{0:n}", _totalReturn); lblTotalDiscount.Text = string.Format("{0:n}", _discountAmount); lblNetSales.Text = string.Format("{0:n}", _totalSales - (_totalReturn + _discountAmount)); lblNonCashSales.Text = string.Format("{0:n}", _noncashsales); lblCashSales.Text = string.Format("{0:n}", _cashsales); lblNetCashSales.Text = string.Format("{0:n}", (_cashsales + _cashDeposit) - _totalReturn); txtCashCount.Text = "0.00"; lblVariance.Text = "0.00"; txtRemarks.Clear(); txtCashCount.Focus(); } }