private void ChkBillBtn_Click(object sender, EventArgs e) { try { if (aPurchaseDataRow["IsChecked"].ToString() == "0") { string ChkdBy = TellerUserNameLbl.Text; string ChkDate = DateTime.Now.ToShortDateString(); string ChkTime = DateTime.Now.ToShortTimeString(); if (!PurchaseVoucherGeneralMgmt.UpdateVoucherChecked(ChkdBy, ChkDate, ChkTime, int.Parse(PurchaseVoucherNumTxtBox.Text))) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [DB-ERROR-EditBill-ChkBillBtn_Click] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } else { MessageBox.Show(MsgTxt.CheckedSuccesfullyTxt, MsgTxt.AddedSuccessfully, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } else { MessageBox.Show(MsgTxt.AlreadyCheckedTxt, MsgTxt.WarningCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditVoucher-ChkBillBtn_Click] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } }
private void DebitDGView_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (PrivilegesManager.GetEventStatues(Calcium_RMS.Events.EditVouchers) == EventStatus.Permit) { if (e.RowIndex < 0) { return; } DataTable aDataTableToPass = PurchaseVoucherDetailedMgmt.SelectVoucherByVoucherNumber(int.Parse(DebitDGView.Rows[e.RowIndex].Cells["VoucherNumber"].Value.ToString())); EditVoucher aEditVoucher = new EditVoucher(); aEditVoucher.AddDGView(aDataTableToPass); DataRow aGeneralVoucherDataRow = PurchaseVoucherGeneralMgmt.SelectGeneralVoucherByNumber(int.Parse(DebitDGView.Rows[e.RowIndex].Cells["VoucherNumber"].Value.ToString())); aEditVoucher.UpdateVariables(aGeneralVoucherDataRow); // aEditVoucher.MdiParent = Helper.Instance.ActiveMainWindow; aEditVoucher.Show(); } else { MessageBox.Show(MsgTxt.PrivUserNotAllowedTxt, MsgTxt.InformationCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void ListVouchersDGView_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (PrivilegesManager.GetEventStatues(Calcium_RMS.Events.EditVouchers) == EventStatus.Permit) { if (e.RowIndex < 0) { return; } DataTable aDataTableToPass = PurchaseVoucherDetailedMgmt.SelectVoucherByVoucherNumber(int.Parse(ListVouchersDGView.Rows[e.RowIndex].Cells["VoucherNumber"].Value.ToString())); if (aDataTableToPass == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListVouchersDGView_CellDoubleClick:DB-ERROR aDataTableToPass=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DataRow aGeneralVoucherDataRow = PurchaseVoucherGeneralMgmt.SelectGeneralVoucherByNumber(int.Parse(ListVouchersDGView.Rows[e.RowIndex].Cells["VoucherNumber"].Value.ToString())); if (aDataTableToPass == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListVouchersDGView_CellDoubleClick:DB-ERROR aDataTableToPass=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } EditVoucher aEditVoucher = new EditVoucher(); aEditVoucher.AddDGView(aDataTableToPass); aEditVoucher.UpdateVariables(aGeneralVoucherDataRow); //aEditVoucher.TopLevel = true; aEditVoucher.TopMost = true; aEditVoucher.Show(); } else { MessageBox.Show(MsgTxt.PrivUserNotAllowedTxt, MsgTxt.InformationCaption, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void ListDCBtn_Click(object sender, EventArgs e) { int FilterVendorID = int.Parse(VendorNameComboBox.SelectedValue.ToString()); aCurrencyTable = CurrencyMgmt.SelectAll(); aUsersTable = UsersMgmt.SelectAllUsers(); aAccountsTable = AccountsMgmt.SelectAll(); aPaymentMethodTable = PaymentMethodMgmt.SelectAll(); aAccountsTable = AccountsMgmt.SelectAll(); aVendorTable = VendorsMgmt.SelectAllVendors(); DebitDGView.Rows.Clear(); CreditDGView.Rows.Clear(); int FilterTellerNameID = 0; if (TellerNameChkBox.Checked) { FilterTellerNameID = int.Parse(TellerNameComboBox.SelectedValue.ToString()); } string FilterDateFrom = ""; string FilterDateTo = ""; if (DateCheckBox.Checked) { FilterDateFrom = DateFrompicker.Value.ToShortDateString(); FilterDateTo = DateToPicker.Value.ToShortDateString(); } bool FilterCheckedBills = CheckChkBox.Checked; bool FilterIsRevised = RevisedChkBox.Checked; bool FilterUnCheckedBills = UnCheckedChkBox.Checked; bool FilterUnRevisedBills = UnRevisedChkBox.Checked; bool FilterBillCashCredit = CreditBillsChkBox.Checked; //LISTING BILLS aPurchaseVoucherTable = PurchaseVoucherGeneralMgmt.SelectAllVouchers(FilterTellerNameID, FilterDateFrom, FilterDateTo, FilterCheckedBills, FilterIsRevised, FilterUnCheckedBills, FilterUnRevisedBills, FilterVendorID, FilterBillCashCredit); TotalITemsTxtBoxDebit.Text = aPurchaseVoucherTable.Rows.Count.ToString(); TotalDebitPriceTxtBox.Text = "0"; if (aPurchaseVoucherTable.Rows.Count > 0) { double TotalDebitPrice = 0; for (int i = 0; i < aPurchaseVoucherTable.Rows.Count; i++) { TotalDebitPrice += double.Parse(aPurchaseVoucherTable.Rows[i]["TotalCost"].ToString()); } TotalDebitPriceTxtBox.Text = TotalDebitPrice.ToString(); RowNumDebit = 0; if (DebitDGView.Rows.Count < ItemsPerPageDebit) { //TestingFor Paging pagesnumberDebit = (int)aPurchaseVoucherTable.Rows.Count / ItemsPerPageDebit; if ((double.Parse(aPurchaseVoucherTable.Rows.Count.ToString()) / ItemsPerPageDebit - int.Parse(aPurchaseVoucherTable.Rows.Count.ToString()) / ItemsPerPageDebit) > 0) { pagesnumberDebit++; } foreach (DataRow r in aPurchaseVoucherTable.Rows) { if (DebitDGView.Rows.Count < ItemsPerPageDebit) { DebitDGView.Rows.Add(); DebitDGView.Rows[RowNumDebit].Cells["VoucherNumber"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["VoucherNumber"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["Date"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Date"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["Time"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Time"].ToString(); for (int i = 0; i < aVendorTable.Rows.Count; i++) { if (int.Parse(aVendorTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["VendorID"].ToString())) { DebitDGView.Rows[RowNumDebit].Cells["Vendor"].Value = aVendorTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNumDebit]["TellerID"].ToString(); break; } } DebitDGView.Rows[RowNumDebit].Cells["TotalFreeITemsQty"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalFreeITemsQty"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["TotalTax"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalTax"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["Subtotal"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Subtotal"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["DiscountPerc"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["DiscountPerc"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["TotalItemsDiscount"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalItemsDiscount"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["TotalDiscount"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalDiscount"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["TotalCost"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalCost"].ToString(); for (int i = 0; i < aPaymentMethodTable.Rows.Count; i++) { if (int.Parse(aPaymentMethodTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["PaymentMethodID"].ToString())) { DebitDGView.Rows[RowNumDebit].Cells["PaymentMethod"].Value = aPaymentMethodTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNumDebit]["TellerID"].ToString(); break; } } DebitDGView.Rows[RowNumDebit].Cells["Comments"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Comments"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["CreditCardInfo"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CreditCardInfo"].ToString(); for (int i = 0; i < aCurrencyTable.Rows.Count; i++) { if (int.Parse(aCurrencyTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["CurrencyID"].ToString())) { DebitDGView.Rows[RowNumDebit].Cells["Currency"].Value = aCurrencyTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNumDebit]["TellerID"].ToString(); break; } } for (int i = 0; i < aAccountsTable.Rows.Count; i++) { if (int.Parse(aAccountsTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["AccountID"].ToString())) { DebitDGView.Rows[RowNumDebit].Cells["Currency"].Value = aAccountsTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNumDebit]["TellerID"].ToString(); break; } } for (int i = 0; i < aUsersTable.Rows.Count; i++) { if (int.Parse(aUsersTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["TellerID"].ToString())) { DebitDGView.Rows[RowNumDebit].Cells["Teller"].Value = aUsersTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString(); break; } } DebitDGView.Rows[RowNumDebit].Cells["CheckNumber"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CheckNumber"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["IsCashCredit"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["IsCashCredit"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["VendorAccountAmountOld"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["VendorAccountAmountOld"].ToString(); if (aPurchaseVoucherTable.Rows[RowNumDebit]["IsChecked"].ToString() == "0") { DebitDGView.Rows[RowNumDebit].Cells["IsChecked"].Value = "NO";//aBillTable.Rows[RowNumDebit]["IsChecked"].ToString(); } else { DebitDGView.Rows[RowNumDebit].Cells["IsChecked"].Value = "YES"; } DebitDGView.Rows[RowNumDebit].Cells["CheckedBy"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CheckedBy"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["CheckDate"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CheckDate"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["CheckTime"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CheckTime"].ToString(); if (aPurchaseVoucherTable.Rows[RowNumDebit]["IsRevised"].ToString() == "0") { DebitDGView.Rows[RowNumDebit].Cells["IsRevised"].Value = "NO";//aBillTable.Rows[RowNumDebit]["IsChecked"].ToString(); } else { DebitDGView.Rows[RowNumDebit].Cells["IsRevised"].Value = "YES"; } DebitDGView.Rows[RowNumDebit].Cells["RevisedBy"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["RevisedBy"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["ReviseDate"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["ReviseDate"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["ReviseTime"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["ReviseTime"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["ReviseLoss"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["ReviseLoss"].ToString(); DebitDGView.Rows[RowNumDebit].Cells["Fees"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Fees"].ToString(); RowNumDebit++; } } PageOfTotalTxtBoxDebit.Text = "1/" + pagesnumberDebit.ToString(); currentpageDebit = 1; } } //LISTING PAYMENTS //LISTING PAYMENTS CREDIT aVendorPaymentTable = VendorsPaymentsMgmt.SelectAll(FilterTellerNameID, FilterDateFrom, FilterDateTo, FilterCheckedBills, FilterIsRevised, FilterUnCheckedBills, FilterUnRevisedBills, FilterVendorID); TotalITemsTxtBoxCredit.Text = aVendorPaymentTable.Rows.Count.ToString(); TotalCreditTxtBox.Text = "0"; if (aVendorPaymentTable.Rows.Count > 0) { double TotalCredit = 0; for (int i = 0; i < aVendorPaymentTable.Rows.Count; i++) { TotalCredit += double.Parse(aVendorPaymentTable.Rows[i]["Amount"].ToString()); } TotalCreditTxtBox.Text = TotalCredit.ToString(); RowNumCredit = 0; if (CreditDGView.Rows.Count < ItemsPerPageCredit) { //TestingFor Paging pagesnumberCredit = (int)aVendorPaymentTable.Rows.Count / ItemsPerPageCredit; if ((double.Parse(aVendorPaymentTable.Rows.Count.ToString()) / ItemsPerPageCredit - int.Parse(aVendorPaymentTable.Rows.Count.ToString()) / ItemsPerPageCredit) > 0) { pagesnumberCredit++; } foreach (DataRow r in aVendorPaymentTable.Rows) { if (CreditDGView.Rows.Count < ItemsPerPageCredit) { CreditDGView.Rows.Add(); CreditDGView.Rows[RowNumCredit].Cells["PaymentNumber"].Value = aVendorPaymentTable.Rows[RowNumCredit]["PaymentNumber"].ToString(); for (int i = 0; i < aVendorTable.Rows.Count; i++) { if (int.Parse(aVendorTable.Rows[i]["ID"].ToString()) == int.Parse(aVendorPaymentTable.Rows[RowNumCredit]["VendorID"].ToString())) { CreditDGView.Rows[RowNumCredit].Cells["VendorIDCredit"].Value = aVendorTable.Rows[i]["Name"].ToString(); break; } } CreditDGView.Rows[RowNumCredit].Cells["DateCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["Date"].ToString(); CreditDGView.Rows[RowNumCredit].Cells["TimeCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["Time"].ToString(); for (int i = 0; i < aUsersTable.Rows.Count; i++) { if (int.Parse(aUsersTable.Rows[i]["ID"].ToString()) == int.Parse(aVendorPaymentTable.Rows[RowNumCredit]["TellerID"].ToString())) { CreditDGView.Rows[RowNumCredit].Cells["TellerCredit"].Value = aUsersTable.Rows[i]["UserName"].ToString(); break; } } CreditDGView.Rows[RowNumCredit].Cells["AmountCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["Amount"].ToString(); CreditDGView.Rows[RowNumCredit].Cells["OldAmountCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["OldVendorAccountAmount"].ToString(); CreditDGView.Rows[RowNumCredit].Cells["CommentsCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["Comments"].ToString(); if (aVendorPaymentTable.Rows[RowNumCredit]["IsChecked"].ToString() == "0") { CreditDGView.Rows[RowNumCredit].Cells["IsCheckedCredit"].Value = "NO";//aBillsDataTable.Rows[RowNum]["IsChecked"].ToString(); } else { CreditDGView.Rows[RowNumCredit].Cells["IsCheckedCredit"].Value = "YES"; } if (aVendorPaymentTable.Rows[RowNumCredit]["IsRevised"].ToString() == "0") { CreditDGView.Rows[RowNumCredit].Cells["IsRevisedCredit"].Value = "NO";//aBillsDataTable.Rows[RowNum]["IsRevised"].ToString(); } else { CreditDGView.Rows[RowNumCredit].Cells["IsRevisedCredit"].Value = "YES"; } CreditDGView.Rows[RowNumCredit].Cells["CheckDateCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["CheckDate"].ToString(); CreditDGView.Rows[RowNumCredit].Cells["CheckTimeCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["CheckTime"].ToString(); CreditDGView.Rows[RowNumCredit].Cells["CheckedByCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["CheckedBy"].ToString(); CreditDGView.Rows[RowNumCredit].Cells["ReviseDateCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["ReviseDate"].ToString(); CreditDGView.Rows[RowNumCredit].Cells["ReviseTimeCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["ReviseTime"].ToString(); CreditDGView.Rows[RowNumCredit].Cells["RevisedByCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["RevisedBy"].ToString(); RowNumCredit++; } PageOfTotalTxtBoxCredit.Text = "1/" + pagesnumberCredit.ToString(); currentpageCredit = 1; } } } }
private void ListVouchersBtn_Click(object sender, EventArgs e) { try { int FilterVendorID = -1; if (ByVendorNameChkBox.Checked && VendorsComboBox.SelectedValue != null) { FilterVendorID = int.Parse(VendorsComboBox.SelectedValue.ToString());//VendorsMgmt.SelectVendorIDByName(VendorNameTxtBox.Text); // CustomerMgmt.SelectCustomerIDByPhone1(CustomerPhoneTxtBox.Text); if (FilterVendorID == -1) { MessageBox.Show(MsgTxt.UnexpectedError + " " + MsgTxt.VendorTxt + " " + VendorsComboBox.Text + " " + MsgTxt.NotFoundTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } aVendorTable = VendorsMgmt.SelectAllVendors(); if (aVendorTable == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListVouchersBtn_Click:DB-ERROR aVendorTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } aCurrencyTable = CurrencyMgmt.SelectAll(); if (aCurrencyTable == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aCurrencyTable:DB-ERROR aCurrencyTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } aUsersTable = UsersMgmt.SelectAllUsers(); if (aUsersTable == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aUsersTable:DB-ERROR aUsersTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } aAccountsTable = AccountsMgmt.SelectAll(); if (aAccountsTable == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aAccountsTable:DB-ERROR aAccountsTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } aPaymentMethodTable = PaymentMethodMgmt.SelectAll(); if (aPaymentMethodTable == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aPaymentMethodTable:DB-ERROR aPaymentMethodTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //aVouchersTable = PurchaseVoucherGeneralMgmt.SelectAllVouchers(); int FilterTellerID = 0; if (TellerNameChkBox.Checked && TellerNameComboBox.SelectedValue != null) { FilterTellerID = int.Parse(TellerNameComboBox.SelectedValue.ToString()); } string FilterDateFrom = ""; string FilterDateTo = ""; if (DateCheckBox.Checked) { FilterDateFrom = DateFrompicker.Value.ToShortDateString(); FilterDateTo = DateToPicker.Value.ToShortDateString(); } bool FilterChecked = CheckedChkBox.Checked; bool FilterRevised = IsRevisedChkBox.Checked; bool FilterUnChecked = UncheckedVouchersChkBox.Checked; bool FilterUnRevised = UnRevisedChkBox.Checked; aVouchersTable = PurchaseVoucherGeneralMgmt.SelectAllVouchers(FilterTellerID, FilterDateFrom, FilterDateTo, FilterChecked, FilterRevised, FilterUnChecked, FilterUnRevised, FilterVendorID, false); if (aVouchersTable == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aVouchersTable:DB-ERROR aVouchersTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } TotalITemsTxtBox.Text = aVouchersTable.Rows.Count.ToString(); ListVouchersDGView.Rows.Clear(); if (aVouchersTable.Rows.Count > 0) { RowNum = 0; if (ListVouchersDGView.Rows.Count < ItemsPerPage) { //TestingFor Paging pagesnumber = (int)aVouchersTable.Rows.Count / ItemsPerPage; if ((double.Parse(aVouchersTable.Rows.Count.ToString()) / ItemsPerPage - int.Parse(aVouchersTable.Rows.Count.ToString()) / ItemsPerPage) > 0) { pagesnumber++; } foreach (DataRow r in aVouchersTable.Rows) { if (ListVouchersDGView.Rows.Count < ItemsPerPage) { ListVouchersDGView.Rows.Add(); ListVouchersDGView.Rows[RowNum].Cells["VoucherNumber"].Value = aVouchersTable.Rows[RowNum]["VoucherNumber"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["Date"].Value = aVouchersTable.Rows[RowNum]["Date"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["Time"].Value = aVouchersTable.Rows[RowNum]["Time"].ToString(); for (int i = 0; i < aVendorTable.Rows.Count; i++) { if (int.Parse(aVendorTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["VendorID"].ToString())) { ListVouchersDGView.Rows[RowNum].Cells["Vendor"].Value = aVendorTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString(); break; } } ListVouchersDGView.Rows[RowNum].Cells["TotalFreeITemsQty"].Value = aVouchersTable.Rows[RowNum]["TotalFreeITemsQty"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["TotalTax"].Value = aVouchersTable.Rows[RowNum]["TotalTax"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["Subtotal"].Value = aVouchersTable.Rows[RowNum]["Subtotal"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["DiscountPerc"].Value = aVouchersTable.Rows[RowNum]["DiscountPerc"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["TotalItemsDiscount"].Value = aVouchersTable.Rows[RowNum]["TotalItemsDiscount"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["TotalDiscount"].Value = aVouchersTable.Rows[RowNum]["TotalDiscount"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["TotalCost"].Value = aVouchersTable.Rows[RowNum]["TotalCost"].ToString(); for (int i = 0; i < aPaymentMethodTable.Rows.Count; i++) { if (int.Parse(aPaymentMethodTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["PaymentMethodID"].ToString())) { ListVouchersDGView.Rows[RowNum].Cells["PaymentMethod"].Value = aPaymentMethodTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString(); break; } } ListVouchersDGView.Rows[RowNum].Cells["Comments"].Value = aVouchersTable.Rows[RowNum]["Comments"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["CreditCardInfo"].Value = aVouchersTable.Rows[RowNum]["CreditCardInfo"].ToString(); for (int i = 0; i < aCurrencyTable.Rows.Count; i++) { if (int.Parse(aCurrencyTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["CurrencyID"].ToString())) { ListVouchersDGView.Rows[RowNum].Cells["Currency"].Value = aCurrencyTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString(); break; } } for (int i = 0; i < aAccountsTable.Rows.Count; i++) { if (int.Parse(aAccountsTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["AccountID"].ToString())) { ListVouchersDGView.Rows[RowNum].Cells["Currency"].Value = aAccountsTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString(); break; } } for (int i = 0; i < aUsersTable.Rows.Count; i++) { if (int.Parse(aUsersTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["TellerID"].ToString())) { ListVouchersDGView.Rows[RowNum].Cells["Teller"].Value = aUsersTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString(); break; } } ListVouchersDGView.Rows[RowNum].Cells["CheckNumber"].Value = aVouchersTable.Rows[RowNum]["CheckNumber"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["IsCashCredit"].Value = aVouchersTable.Rows[RowNum]["IsCashCredit"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["VendorAccountAmountOld"].Value = aVouchersTable.Rows[RowNum]["VendorAccountAmountOld"].ToString(); if (aVouchersTable.Rows[RowNum]["IsChecked"].ToString() == "0") { ListVouchersDGView.Rows[RowNum].Cells["IsChecked"].Value = "NO";//aBillTable.Rows[RowNum]["IsChecked"].ToString(); } else { ListVouchersDGView.Rows[RowNum].Cells["IsChecked"].Value = "YES"; } ListVouchersDGView.Rows[RowNum].Cells["CheckedBy"].Value = aVouchersTable.Rows[RowNum]["CheckedBy"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["CheckDate"].Value = aVouchersTable.Rows[RowNum]["CheckDate"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["CheckTime"].Value = aVouchersTable.Rows[RowNum]["CheckTime"].ToString(); if (aVouchersTable.Rows[RowNum]["IsRevised"].ToString() == "0") { ListVouchersDGView.Rows[RowNum].Cells["IsRevised"].Value = "NO";//aBillTable.Rows[RowNum]["IsChecked"].ToString(); } else { ListVouchersDGView.Rows[RowNum].Cells["IsRevised"].Value = "YES"; } ListVouchersDGView.Rows[RowNum].Cells["RevisedBy"].Value = aVouchersTable.Rows[RowNum]["RevisedBy"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["ReviseDate"].Value = aVouchersTable.Rows[RowNum]["ReviseDate"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["ReviseTime"].Value = aVouchersTable.Rows[RowNum]["ReviseTime"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["ReviseLoss"].Value = aVouchersTable.Rows[RowNum]["ReviseLoss"].ToString(); ListVouchersDGView.Rows[RowNum].Cells["Fees"].Value = aVouchersTable.Rows[RowNum]["Fees"].ToString(); RowNum++; } } PageOfTotalTxtBox.Text = "1/" + pagesnumber.ToString(); currentpage = 1; } } } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListVouchersBtn_Click] \n Exception: \n" + ex.ToString(), MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw; } }
private void ReviseBillBtn_Click(object sender, EventArgs e) { try { if (aPurchaseDataRow["IsRevised"].ToString() == "0") { if (CashMethodComboBox.SelectedIndex == 1)//iscredit { int VendorID = VendorsMgmt.SelectVendorIDByName(VendorsComboBox.Text); DataRow aVendorAccount = VendorsAccountsMgmt.SelectVendorAccountRowByVendorID(VendorID); double OldAmount = double.Parse(aVendorAccount["Amount"].ToString()); double NewAmount = OldAmount - double.Parse(TotalTxtBox.Text); int AccountID = int.Parse(aVendorAccount["ID"].ToString()); VendorsAccountsMgmt.UpdateAccountAmountByAccountID(AccountID, NewAmount); } else { int AccountID = int.Parse(aPurchaseDataRow["AccountID"].ToString()); DataRow aAccountRow = AccountsMgmt.SelectAccountRowByID(AccountID); double OldAmount = double.Parse(aAccountRow["Amount"].ToString()); double NewAmount = OldAmount + double.Parse(TotalTxtBox.Text);; AccountsMgmt.UpdateAccountAmountByAccountID(AccountID, NewAmount); } //Mark the check (if any) as revised DataRow aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(aPurchaseDataRow["PaymentMethodID"].ToString())); if (aMethodRow["IsCheck"].ToString() == "1") { ChecksMgmt.MakeCheckRevised(int.Parse(aPurchaseDataRow["CheckNumber"].ToString()), DateTime.Now.ToShortDateString()); } //Now Update AvgUnitCost double CostLoss = 0; foreach (DataGridViewRow r in TeldgView.Rows) { if (!r.IsNewRow) { int ItemID = ItemsMgmt.SelectItemIDByBarcode(TeldgView.Rows[r.Index].Cells["Barcode"].Value.ToString()); double ItemCost = PurchaseVoucherDetailedMgmt.SelectItemCostByNumber(ItemID, int.Parse(aPurchaseDataRow["VoucherNumber"].ToString())); double ReturnQty = double.Parse(TeldgView.Rows[r.Index].Cells["Qty"].Value.ToString()); double CurrentAvgUnitCost = ItemsMgmt.SelectItemCostByBarcode(TeldgView.Rows[r.Index].Cells["Barcode"].Value.ToString()); double CurrentAvaQty = ItemsMgmt.SelectItemQtyByID(ItemID); double NewAvgUnitCost = ((CurrentAvgUnitCost * CurrentAvaQty) + (ReturnQty * ItemCost)) / (ReturnQty + CurrentAvaQty); ItemsMgmt.UpdateItemQtyandAvgUnitCostByID(ItemID, (ReturnQty + CurrentAvaQty), NewAvgUnitCost); PurchaseVoucherDetailedMgmt.MakeItemAsRevised(int.Parse(aPurchaseDataRow["VoucherNumber"].ToString()), ItemID); } } //Now we should mark the bill general as reversed if (!PurchaseVoucherGeneralMgmt.UpdateVoucherToRevised(TellerUserNameLbl.Text, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), int.Parse(aPurchaseDataRow["VoucherNumber"].ToString()), CostLoss)) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [DB-ERROR-EditBill-ReviseBillBtn_Click] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } else { MessageBox.Show(MsgTxt.ReversedSuccessfullyTxt, MsgTxt.AddedSuccessfully, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } else { MessageBox.Show(MsgTxt.AlreadyReversedTxt, MsgTxt.WarningCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditVoucher-ReviseBillBtn_Click] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); throw; } }
private void Add1000PurchaseVoucherBtn_Click(object sender, EventArgs e) { Random randAmount = new Random(); int cnt = 1; var Vendors = VendorsMgmt.SelectAllVendors(); int userId = int.Parse(UsersMgmt.SelectAllUsers().Rows[0]["ID"].ToString()); while (cnt++ < NumberOfPurchases) { try { PurchaseVoucherGeneral aPurchaseGeneral = new PurchaseVoucherGeneral(); aPurchaseGeneral.AccountID = 1; aPurchaseGeneral.Comments = ""; aPurchaseGeneral.CurrencyID = 1; aPurchaseGeneral.Date = DateTime.Now.Subtract(TimeSpan.FromDays(randAmount.Next(1, 2000))).ToShortDateString(); aPurchaseGeneral.DiscountPerc = 0; aPurchaseGeneral.Fees = 10; aPurchaseGeneral.IsCashCredit = 0; aPurchaseGeneral.IsChecked = 0; aPurchaseGeneral.IsRevised = 0; aPurchaseGeneral.PaymentMethodID = 1; aPurchaseGeneral.Subtotal = 100; aPurchaseGeneral.TellerID = userId; aPurchaseGeneral.Time = DateTime.Now.ToShortTimeString(); aPurchaseGeneral.TotalCost = 90; aPurchaseGeneral.TotalDiscount = 0; aPurchaseGeneral.TotalFreeItemsQty = 0; aPurchaseGeneral.TotalItemsDiscount = 0; aPurchaseGeneral.TotalTax = 10; aPurchaseGeneral.VendorAccountAmountOld = 0; aPurchaseGeneral.VendorID = int.Parse(Vendors.Rows[(int)NumberOfPurchases % Vendors.Rows.Count]["ID"].ToString()); aPurchaseGeneral.VoucherNumber = PurchaseVoucherGeneralMgmt.NextVoucherNumber(); aPurchaseGeneral.CreditCardInfo = ""; int NumofDetailed = randAmount.Next(1, 20); if (PurchaseVoucherGeneralMgmt.AddVoucher(aPurchaseGeneral)) { while (NumofDetailed > 0) { PurchaseVoucherDetailed aPurchaseDetailed = new PurchaseVoucherDetailed(); string aBarcode = "Test Item " + randAmount.Next(1, (int)NumberOfItems).ToString(); DataTable aItemRow = ItemsMgmt.SelectItemByBarCode(aBarcode); if (aItemRow.Rows.Count != 0) { aPurchaseDetailed.Purchase_Voucher_Detailed_ItemID = int.Parse(aItemRow.Rows[0]["ID"].ToString()); aPurchaseDetailed.Purchase_Voucher_Detailed_VoucherNumber = aPurchaseGeneral.VoucherNumber; aPurchaseDetailed.Purchase_Voucher_Detailed_IsRevised = 0; aPurchaseDetailed.Purchase_Voucher_Detailed_ItemCost = double.Parse(aItemRow.Rows[0]["AvgUnitCost"].ToString()); aPurchaseDetailed.Purchase_Voucher_Detailed_OldAvaQty = double.Parse(aItemRow.Rows[0]["Qty"].ToString()); aPurchaseDetailed.Purchase_Voucher_Detailed_Qty = NumofDetailed; aPurchaseDetailed.Purchase_Voucher_Detailed_Discount = 0; // = double.Parse(aItemRow.Rows[0]["SellPrice"].ToString()); aPurchaseDetailed.Purchase_Voucher_Detailed_FreeItemsQty = 0; // aBillDetailed.Bill_Detailed_TotalPerUnit = aBillDetailed.Bill_Detailed_Qty * aBillDetailed.Bill_Detailed_SellPrice; PurchaseVoucherDetailedMgmt.AddItem(aPurchaseDetailed); } NumofDetailed--; } } if (cnt % 100 == 0) { label1.Text = $"Adding Purchase Order {cnt}/{NumberOfPurchases} ... ({(cnt / NumberOfPurchases) * 100 })%"; Application.DoEvents(); } } catch (Exception ex) { MessageBox.Show($"Error in {cnt} \n {ex}"); } } }
public string EndOfPeriodReport(string TellerName, int FilterTellerNameID, string FilterDateFrom, string FilterDateTo, bool TableBorder = false, bool Preview = true, bool PrintToThermal = false, bool ExportToPdf = false, bool ExportToExcel = false, string ExportPath = "", bool colored = false) { /**************************************** END OF PERIOD *********************************/ /* For Teller : Teller Name (s) Date From ----------> To * Printed On : Date::Time * Printed By : Current User Name * ************************************************************************************* * [CASH] * ---------------------------------------- |-------------------------------------------- * | TYPE | AMOUNT (JOD) | * -------------------------------------------------------------------------------------- * | CASH SALES | XXXXXX.XXX | * -------------------------------------------------------------------------------------- * |_______________TOTAL____________________|_______________XXXXXX.XXX__________________| * */ List <DataTable> aDTList = new List <DataTable>(); DataTable aTempTable = null; DataRow aTempRow = null; /*Row Used For filling the datatables*/ #region REPORT HEADER string RCV = "<b>" + Text.ReportsText.ReceivedRepTxt + "</b>"; string REV = "<b>" + Text.ReportsText.ReversedRepTxt + "</b>"; List <string> aStringList = ReportsHelper.ImportReportHeader(0, 1); List <string> aFooterList = ReportsHelper.ImportReportHeader(1, 1); aStringList.Add(SharedVariables.Line_Solid_10px_Black); aStringList.Add(Text.ReportsNames.EndOfPeriodRepNm); aStringList.Add("<h2>" + Text.ReportsText.TellerRepTxt + ": <b>" + TellerName + "</b></h2>"); aStringList.Add("<h2>" + Text.ReportsText.DateRepTxt + " " + Text.ReportsText.FromRepTxt + " : " + FilterDateFrom + " " + Text.ReportsText.ToRepTxt + " :" + FilterDateTo + "</h2>"); aStringList.Add("<h2>" + Text.ReportsText.PrintedOnrepTxt + " : " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + "</h2>"); aStringList.Add("<h2>" + Text.ReportsText.PrintedByrepTxt + ": <b>" + SharedFunctions.ReturnLoggedUserName() + "</b></h2>"); aStringList.Add(SharedVariables.Line_Solid_10px_Black); #endregion REPORT HEADER #region CASH_HANDLING { /*cash scope*/ double CashSalesDiscount = BillGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 0); double CashSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 0); /*Cash Sales Amount*/ double ReversedCashSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 0); double CashSalesReturns = ReturnItemsCustGeneralMGMT.SelectCustomersReturns(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, -1); double NetTotalCashSales = CashSales - ReversedCashSales - CashSalesReturns; /*discount removed since it is in the added to the sales*/ #region CASH_HANDLING_SALES DataTable aCashTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashTableHeader.Columns.Add(Text.ReportsText.CashSalesRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashTableHeader); /*Receieved Cash Sales Handling*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CshSalesRepTxt;/*Cash Sales*/ aTempRow[1] = CashSales + CashSalesDiscount; /*Reversed Cash Sales Handling*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevCashSalesRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedCashSales; /*Cash Sales Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashSalesDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = CashSalesDiscount; /*Cash Sales Returns*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashSalesReturnsRepTxt; /*Cash Sales Returns;*/ aTempRow[1] = CashSalesReturns; /*NET Cash Sales*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalCashSales + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CASH_HANDLING_SALES double CashCustPayment = CustomersPaymentsMgmt.SelectCustomerPayments(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, PaymentMethodMgmt.CASH_PAYMENT_METHOD); double CashVendorPayment = VendorsPaymentsMgmt.SelectCustomerPayments(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, PaymentMethodMgmt.CASH_PAYMENT_METHOD); double NetCashPayments = CashCustPayment - CashVendorPayment; #region CASH_HANDLING_PAYMENTS DataTable aPaymentsTableHeader = new DataTable(); /*Only Header For Cash section*/ aPaymentsTableHeader.Columns.Add(Text.ReportsText.CashPaymentsRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aPaymentsTableHeader); /*Cash Customer Payments*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashCustPaymentsRepTxt;/*Cash Sales*/ aTempRow[1] = CashCustPayment; /*Cash Vendors Payments*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashVendPaymentsRepTxt;/*Cash Sales*/ aTempRow[1] = CashVendorPayment; /*Net Cash Payments*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetCashPayments + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CASH_HANDLING_PAYMENTS double CashPurchaseDiscount = PurchaseVoucherGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, -1); double CashPurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 0);/*Cash Sales Amount*/ double ReversedCashPurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, -1); double CashPurchaseReturns = ReturnItemsVendorGeneralMgmt.SelectVendorReturns(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, -1); double NetTotalCashPurchase = -CashPurchase + ReversedCashPurchase + CashPurchaseReturns; /*discount removed since it is in the added to the sales*/ #region CASH_HANDLING_PURCHASE DataTable aCashPurchaseTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashPurchaseTableHeader.Columns.Add(Text.ReportsText.CashPurchaseRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashPurchaseTableHeader); /*CASH PURCHASES*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashPurchaseRepTxt; aTempRow[1] = CashPurchase + CashPurchaseDiscount; /*REVERSED CASH PURCHASES*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevCashPurchaseRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedCashPurchase; /*Cash Purchase Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashPurchaseDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = CashPurchaseDiscount; /*Cash Purchase Returns*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CashPurchaseReturnRepTxt; /*Cash Sales Returns;*/ aTempRow[1] = CashPurchaseReturns; /*NET Cash Purchase*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalCashPurchase + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CASH_HANDLING_PURCHASE double TotalCash = NetTotalCashSales + NetCashPayments - NetTotalCashPurchase; DataTable aFinalCashTable = new DataTable(); aFinalCashTable.Columns.Add(Text.ReportsText.TotalCashAmountTxt + " " + TotalCash.ToString() + " JOD <hr/>"); aDTList.Add(aFinalCashTable); }/*end cash scope*/ #endregion CASH_HANDLING #region INVOICE_CARD_HANDLING { /*Invoice Scope*/ double InvoiceSalesDiscount = BillGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); double InvoiceSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); /*Cash Sales Amount*/ double ReversedInvoiceSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); double NetTotalInvoiceSales = InvoiceSales - ReversedInvoiceSales; /*discount removed since it is in the added to the sales*/ #region INVOICE_HANDLING_SALES DataTable aCashTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashTableHeader.Columns.Add(Text.ReportsText.InvoiceSalesRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashTableHeader); /*Receieved Cash Sales Handling*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.InvoiceSalesRepTxt;/*Cash Sales*/ aTempRow[1] = InvoiceSalesDiscount + InvoiceSales; /*Reversed Cash Sales Handling*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevInvoiceSalesRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedInvoiceSales; /*Cash Sales Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.InvoiceDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = InvoiceSalesDiscount; /*NET Cash Sales*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalInvoiceSales + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion INVOICE_HANDLING_SALES double InvoicePurchaseDiscount = PurchaseVoucherGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); double InvoicePurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); /*Cash Sales Amount*/ double ReversedInvoicePurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CASH_PAYMENT_METHOD, 1); double NetTotalInvoicePurchase = -InvoicePurchase + ReversedInvoicePurchase; /*discount removed since it is in the added to the sales*/ #region Invoice_HANDLING_PURCHASE DataTable aCashPurchaseTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashPurchaseTableHeader.Columns.Add(Text.ReportsText.InvoicePurchaseRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashPurchaseTableHeader); /*CASH PURCHASES*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.InvoicePurchaseRepTxt; aTempRow[1] = InvoicePurchase + InvoicePurchaseDiscount; /*REVERSED CASH PURCHASES*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevInvoicePurchaseRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedInvoicePurchase; /*Cash Purchase Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.InvoicePurchaseDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = InvoicePurchaseDiscount; /*NET Cash Purchase*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalInvoicePurchase + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion Invoice_HANDLING_PURCHASE double TotalInvoice = NetTotalInvoiceSales - NetTotalInvoicePurchase; DataTable aFinalInvoiceTable = new DataTable(); aFinalInvoiceTable.Columns.Add(Text.ReportsText.TotalInvoiceAmountTxt + " " + TotalInvoice.ToString() + " JOD <hr/>"); aDTList.Add(aFinalInvoiceTable); }/*End Invoice Scope*/ #endregion INVOICE_CARD_HANDLING #region CREDIT_CARD_HANDLING { /*Credit Scope*/ double CreditSalesDiscount = BillGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); double CreditSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); /*Cash Sales Amount*/ double ReversedCreditSales = BillGeneralMgmt.SelectSalesAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); double NetTotalCreditSales = CreditSales - ReversedCreditSales; /*discount removed since it is in the added to the sales*/ #region CREDIT_HANDLING_SALES DataTable aCashTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashTableHeader.Columns.Add(Text.ReportsText.CreditSalesRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashTableHeader); /*Receieved Cash Sales Handling*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditSalesRepTxt;/*Cash Sales*/ aTempRow[1] = CreditSales + CreditSalesDiscount; /*Reversed Cash Sales Handling*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevCreditSalesRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedCreditSales; /*Cash Sales Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditSalesDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = CreditSalesDiscount; /*NET Cash Sales*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalCreditSales + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CREDIT_HANDLING_SALES double CreditCustPayment = CustomersPaymentsMgmt.SelectCustomerPayments(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD); double CreditVendorPayment = VendorsPaymentsMgmt.SelectCustomerPayments(FilterDateFrom, FilterDateTo, FilterTellerNameID, 0, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD); double NetCreditPayments = CreditCustPayment - CreditVendorPayment; #region CREDIT_HANDLING_PAYMENTS DataTable aPaymentsTableHeader = new DataTable(); /*Only Header For Cash section*/ aPaymentsTableHeader.Columns.Add(Text.ReportsText.CreditPaymentsRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aPaymentsTableHeader); /*Cash Customer Payments*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditCustPaymentsRepTxt;/*Cash Sales*/ aTempRow[1] = CreditCustPayment; /*Cash Vendors Payments*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditVendPaymentsRepTxt;/*Cash Sales*/ aTempRow[1] = CreditVendorPayment; /*Net Cash Payments*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetCreditPayments + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CREDIT_HANDLING_PAYMENTS double CreditPurchaseDiscount = PurchaseVoucherGeneralMgmt.SelectTotalDiscount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); double CreditPurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, -1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); /*Cash Sales Amount*/ double ReversedCreditPurchase = PurchaseVoucherGeneralMgmt.SelectPurchaseAmount(FilterDateFrom, FilterDateTo, FilterTellerNameID, 1, PaymentMethodMgmt.CREDITCARD_PAYMENT_METHOD, -1); double NetTotalCreditPurchase = -CreditPurchase + ReversedCreditPurchase; /*discount removed since it is in the added to the sales*/ #region CREDIT_HANDLING_PURCHASE DataTable aCashPurchaseTableHeader = new DataTable(); /*Only Header For Cash section*/ aCashPurchaseTableHeader.Columns.Add(Text.ReportsText.CreditPurchaseRepTxt); /*Title Only row, this is empty datatable*/ aDTList.Add(aCashPurchaseTableHeader); /*CASH PURCHASES*/ aTempTable = GetEndOfPeriodInnerTable(TableBorder); aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditPurchaseRepTxt; aTempRow[1] = CreditPurchase + CreditPurchaseDiscount; /*REVERSED CASH PURCHASES*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.RevCreditPurchaseRepTxt;/*ReversedCash Sales*/ aTempRow[1] = ReversedCreditPurchase; /*Cash Purchase Discounts*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = Text.ReportsText.CreditPurchaseDiscountRepTxt;/*ReversedCash Sales*/ aTempRow[1] = CreditPurchaseDiscount; /*NET Cash Purchase*/ aTempRow = aTempTable.Rows.Add(); aTempRow[0] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.MANUAL_TD_OPTION_END + ReportsHelper.MANUAL_TD_END; aTempRow[1] = ReportsHelper.MANUAL_TD_OPTION_START + ReportsHelper.NOBORDER + ReportsHelper.UNDERLINE + ReportsHelper.BOLD + ReportsHelper.MANUAL_TD_OPTION_END + Text.ReportsText.TotalTxt + " " + NetTotalCreditPurchase + ReportsHelper.MANUAL_TD_END; aDTList.Add(aTempTable); #endregion CREDIT_HANDLING_PURCHASE double TotalCredit = NetTotalCreditSales + NetCreditPayments - NetTotalCreditPurchase; DataTable aFinalCreditTable = new DataTable(); aFinalCreditTable.Columns.Add(Text.ReportsText.TotalCreditAmountTxt + " " + TotalCredit.ToString() + " JOD <hr/>"); aDTList.Add(aFinalCreditTable); }/*End Credit Scope*/ #endregion CREDIT_HANDLING_PURCHASE #region SENDING_FOR_PRINTING_MANAGER if (Preview) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, false, false, "", false, "", colored); return("True"); } else if (ExportToPdf) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, false, false, true, ExportPath, false, "", colored); return("True"); } else if (ExportToExcel) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, false, false, false, "", ExportToExcel, ExportPath, colored); return("True"); } else if (PrintToThermal) { PrintingManager.Instance.PrintTables(aDTList, aStringList, aFooterList, ReportsHelper.TempOutputPath, ReportsHelper.TempOutputPath, PrintToThermal, true); return("True"); } else { return("ERROR"); } #endregion SENDING_FOR_PRINTING_MANAGER }