private void UpdateBtn_Click(object sender, EventArgs e) { try { double NewAmount = 0; if (double.TryParse(AmountTxtBox.Text, out NewAmount) && AccountComboBox.SelectedValue != null) { int AccountID = int.Parse(AccountComboBox.SelectedValue.ToString()); AccountsMgmt.UpdateAccountAmountByAccountID(AccountID, NewAmount); MessageBox.Show(MsgTxt.UpdateSuccessfully, MsgTxt.UpdateSuccessfully, MessageBoxButtons.OK, MessageBoxIcon.Information); AmountTxtBox.BackColor = AmountBGColor; } else { MessageBox.Show(MsgTxt.ErrorPleaseEnterCorrectAmount, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); AmountTxtBox.BackColor = SharedVariables.TxtBoxRequiredColor; AmountTxtBox.Focus(); } } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [UpdateBtn_Click] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } }
private void PaymentMethodCheckBox_SelectedValueChanged(object sender, EventArgs e) { if (PaymentMethodCheckBox.SelectedValue != null) { DataRow aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); AccountComboBox.SelectedValue = int.Parse(aMethodRow["DefaultAccountID"].ToString()); //PaymentMethodMgmt.SelectDefaultAccountIDByMethodID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); AccountDescriptionTxtBox.Text = AccountsMgmt.SelectAccountDescriptionByID(int.Parse(aMethodRow["DefaultAccountID"].ToString())); PaymentMethodDescripTxtBox.Text = aMethodRow["Description"].ToString(); //PaymentMethodMgmt.SelectDescriptionByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); if (aMethodRow["IsCash"].ToString() == "1") { CashPaymentGB.Show(); CashPaymentGB.BringToFront(); PayInVisaGB.Hide(); CheckGB.Hide(); } else if (aMethodRow["IsCredit"].ToString() == "1") { PayInVisaGB.Show(); PayInVisaGB.BringToFront(); CashPaymentGB.Hide(); CheckGB.Hide(); } else { CheckGB.Show(); CheckGB.BringToFront(); CashPaymentGB.Hide(); PayInVisaGB.Hide(); CheckNumberTxtBox.Text = ChecksMgmt.NextCheckNumber().ToString(); } } }
private void RevisePaymentBtn_Click(object sender, EventArgs e) { try { if (aVendorPaymentRowGlobal["IsRevised"].ToString() == "0") { string RevisedBy = SharedFunctions.ReturnLoggedUserName(); string ReviseDate = DateTime.Now.ToShortDateString(); string ReviseTime = DateTime.Now.ToShortTimeString(); int PaymentNumber = int.Parse(aVendorPaymentRowGlobal["PaymentNumber"].ToString()); DataRow aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(aVendorPaymentRowGlobal["PaymentMethodID"].ToString())); if (aMethodRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectMethodRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditVendorPayment-aMethodRow Returned Null"); } if (!VendorsPaymentsMgmt.UpdatePaymentToRevised(RevisedBy, ReviseDate, ReviseTime, PaymentNumber)) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [DB-ERROR-EditVendorPayment-UpdatePaymentToRevised-FUNC:UpdatePaymentToRevised] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } if (aMethodRow["IsCheck"].ToString() == "1") { ChecksMgmt.MakeCheckRevised(int.Parse(aVendorPaymentRowGlobal["CheckNumber"].ToString()), DateTime.Now.ToShortDateString()); } double Amount = double.Parse(aVendorPaymentRowGlobal["Amount"].ToString()); double CurrentAmount = double.Parse(aVendorAccount["Amount"].ToString()); int AccountID = int.Parse(aVendorAccount["ID"].ToString()); double NewAmount = CurrentAmount + Amount; VendorsAccountsMgmt.UpdateAccountAmountByAccountID(AccountID, NewAmount); double MyOldAccountAmount = double.Parse(aAccount["Amount"].ToString()); double MyNewAccountAmount = MyOldAccountAmount + Amount; int MyAccountID = int.Parse(aAccount["ID"].ToString()); if (!AccountsMgmt.UpdateAccountAmountByAccountID(MyAccountID, MyNewAccountAmount)) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [DB-ERROR-EditcustomerPayment-RevisePaymentBtn_Click-FUNC:UpdateAccountAmountByAccountID] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } 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 [EditVendorPayment-RevisePaymentBtn_Click] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); throw; } }
private void AccountComboBox_SelectedValueChanged(object sender, EventArgs e) { try { if (AccountComboBox.SelectedValue != null) { DataRow aAccountRow = AccountsMgmt.SelectAccountRowByID(int.Parse(AccountComboBox.SelectedValue.ToString())); if (AccountsMgmt.SelectAccountPaymentMethodByID(int.Parse(AccountComboBox.SelectedValue.ToString())) == int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())) { if (aAccountRow["CurrencyID"].ToString() != "1") { AccountNotJOD = true; } else { AccountNotJOD = false; } AccountDescriptionTxtBox.Text = AccountsMgmt.SelectAccountDescriptionByID(int.Parse(aAccountRow["ID"].ToString())); } else { MessageBox.Show(MsgTxt.AccountTxt + "\n[" + AccountComboBox.Text + "]\n" + MsgTxt.DoNotAcceptTxt + "\n" + PaymentMethodCheckBox.Text, MsgTxt.WarningCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); //Same As Function on value change for the payment method combo box DataRow aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); AccountComboBox.SelectedValue = int.Parse(aMethodRow["DefaultAccountID"].ToString()); //PaymentMethodMgmt.SelectDefaultAccountIDByMethodID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); PaymentMethodDescripTxtBox.Text = aMethodRow["Description"].ToString(); //PaymentMethodMgmt.SelectDescriptionByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); if (aMethodRow["IsCash"].ToString() == "1") { CashPaymentGB.Show(); CashPaymentGB.BringToFront(); PayInVisaGB.Hide(); CheckGB.Hide(); } else if (aMethodRow["IsCredit"].ToString() == "1") { PayInVisaGB.Show(); PayInVisaGB.BringToFront(); CashPaymentGB.Hide(); CheckGB.Hide(); } else { CheckGB.Show(); CheckGB.BringToFront(); CashPaymentGB.Hide(); PayInVisaGB.Hide(); } } } } catch (Exception ex) //Unexpected Error { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [AccountComboBox_SelectedValueChanged] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } }
private void AccountComboBox_SelectedValueChanged(object sender, EventArgs e) { if (AccountComboBox.SelectedValue != null) { try { DataRow aAccountRow = AccountsMgmt.SelectAccountRowByID(int.Parse(AccountComboBox.SelectedValue.ToString())); AccountDescriptionTxtBox.Text = aAccountRow["Description"].ToString(); AmountTxtBox.Text = aAccountRow["Amount"].ToString(); } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [AccountComboBox_SelectedValueChanged] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } } }
private void PaymentMethodCheckBox_SelectedValueChanged(object sender, EventArgs e) { try { //no need to lock because this changes the account table which needed to be updated if (PaymentMethodCheckBox.SelectedValue != null) { aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); AccountComboBox.SelectedValue = int.Parse(aMethodRow["DefaultAccountID"].ToString()); AccountDescriptionTxtBox.Text = AccountsMgmt.SelectAccountDescriptionByID(int.Parse(aMethodRow["DefaultAccountID"].ToString())); PaymentMethodDescripTxtBox.Text = aMethodRow["Description"].ToString(); if (aMethodRow["IsCash"].ToString() == "1") { PayInVisaGB.Hide(); CheckGB.Hide(); } else if (aMethodRow["IsCredit"].ToString() == "1") { PayInVisaGB.Show(); PayInVisaGB.BringToFront(); CheckGB.Hide(); } else { CheckGB.Show(); CheckGB.BringToFront(); PayInVisaGB.Hide(); CheckNumberTxtBox.Text = ChecksMgmt.NextCheckNumber().ToString(); } } else { } } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [PaymentMethodCheckBox_SelectedValueChanged] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } }
private void AddVendorPayment_Load(object sender, EventArgs e) { try { IsLoading = true; int PaymentNumber = VendorsPaymentsMgmt.NextPaymentNumber(); if (PaymentNumber == 0) { throw new Exception("Payment Number ==0"); } else { PaymentNumberTxtBox.Text = PaymentNumber.ToString(); DataRow aPaymentMethodRow = PaymentMethodMgmt.SelectDefaultPaymentMethod(); if (aPaymentMethodRow == null) { throw new Exception("aPaymentMethodRow ==null"); } else { PaymentMethodCheckBox.Text = aPaymentMethodRow["Name"].ToString(); PaymentMethodCheckBox.SelectedValue = aPaymentMethodRow["ID"].ToString(); PaymentMethodDescripTxtBox.Text = aPaymentMethodRow["Description"].ToString(); AccountComboBox.SelectedValue = int.Parse(aPaymentMethodRow["DefaultAccountID"].ToString());//PaymentMethodMgmt.SelectDefaultAccountIDByMethodID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); AccountDescriptionTxtBox.Text = AccountsMgmt.SelectAccountDescriptionByID(int.Parse(aPaymentMethodRow["DefaultAccountID"].ToString())); IsLoading = false; } } } catch (Exception ex) { IsLoading = false; MessageBox.Show(MsgTxt.ErrorLoadingFrom + "\nException: IN[AddVendorPayment_Load] \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Dispose(); } }
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; } }
public void UpdateVariables(DataRow aGeneralVoucherDataRow) { try { aPurchaseDataRow = aGeneralVoucherDataRow; PurchaseVoucherNumTxtBox.Text = aGeneralVoucherDataRow["VoucherNumber"].ToString(); aVendorDataRow = VendorsMgmt.SelectVendorRowByID(int.Parse(aGeneralVoucherDataRow["VendorID"].ToString())); if (aVendorDataRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectCustomerRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditVoucher-SelectVendorRowByID Returned Null"); } VendorsComboBox.Text = aVendorDataRow["Name"].ToString(); VendorDescriptionTxtBox.Text = aVendorDataRow["Company"].ToString(); //account amount is latered to iscredit DateLbl.Text = DateTime.Parse(aGeneralVoucherDataRow["Date"].ToString()).ToShortDateString(); TimeLbl.Text = DateTime.Parse(aGeneralVoucherDataRow["Time"].ToString()).ToShortTimeString(); TellerLbl.Text = UsersMgmt.SelectUserNameByID(int.Parse(aGeneralVoucherDataRow["TellerID"].ToString())); if (TellerLbl.Text == null) { //MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-UsersMgmt.UsrById Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("[EditVoucher-UsersMgmt.UsrById Returned Null]"); } //DOWN RIGHT SubtotalTxtBox.Text = aGeneralVoucherDataRow["Subtotal"].ToString(); DiscountPercTxtBox.Text = aGeneralVoucherDataRow["DiscountPerc"].ToString(); DiscountTxtBox.Text = (float.Parse(SubtotalTxtBox.Text) * float.Parse(DiscountPercTxtBox.Text) / 100).ToString(); ItemsDiscountTxtBox.Text = aGeneralVoucherDataRow["TotalItemsDiscount"].ToString(); TotalDiscountTxtBox.Text = aGeneralVoucherDataRow["TotalDiscount"].ToString(); TotalTaxTxtBox.Text = aGeneralVoucherDataRow["TotalTax"].ToString(); FeesTxtBox.Text = aGeneralVoucherDataRow["Fees"].ToString(); TotalTxtBox.Text = aGeneralVoucherDataRow["TotalCost"].ToString(); //GroupBox1 Elements if (aPurchaseDataRow["IsRevised"].ToString() == "1") { ReviseInfoGB.Show(); ReviseDatelbl.Text = DateTime.Parse(aPurchaseDataRow["ReviseDate"].ToString()).ToShortDateString(); ReviseTime.Text = DateTime.Parse(aPurchaseDataRow["ReviseTime"].ToString()).ToShortTimeString(); RevisedBylbl.Text = aPurchaseDataRow["RevisedBy"].ToString(); IsRevisedLbl.Visible = true; ReviseLossProfitLbl.Text = aPurchaseDataRow["ReviseLoss"].ToString(); } else { ReviseInfoGB.Hide(); } if (aPurchaseDataRow["IsChecked"].ToString() == "1") { ChkedByUserNameLbl.Text = aPurchaseDataRow["CheckedBy"].ToString(); ChkDateLbl.Text = DateTime.Parse(aPurchaseDataRow["CheckDate"].ToString()).ToShortDateString(); CheckTime.Text = DateTime.Parse(aPurchaseDataRow["CheckTime"].ToString()).ToShortTimeString(); CheckInfoGB.Show(); } else { CheckInfoGB.Hide(); } //PaymentInformation DataRow aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(aPurchaseDataRow["PaymentMethodID"].ToString())); if (aMethodRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectMethodRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditVoucher-SelectMethodRowByID Returned Null"); } PaymentMethodCheckBox.Text = aMethodRow["Name"].ToString(); PaymentMethodDescripTxtBox.Text = aMethodRow["Description"].ToString();//PaymentMethodMgmt.SelectDescriptionByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); if (aMethodRow["IsCash"].ToString() == "1") { CashPaymentGB.Show(); CashPaymentGB.BringToFront(); PayInVisaGB.Hide(); CheckGB.Hide(); } else if (aMethodRow["IsCredit"].ToString() == "1") { PayInVisaGB.Show(); PayInVisaGB.BringToFront(); CashPaymentGB.Hide(); CheckGB.Hide(); } else { CheckGB.Show(); CheckGB.BringToFront(); CashPaymentGB.Hide(); PayInVisaGB.Hide(); CheckNumberTxtBox.Text = aPurchaseDataRow["CheckNumber"].ToString(); DataRow aCheckDataRow = ChecksMgmt.SelectCheckRowByNumber(int.Parse(aPurchaseDataRow["CheckNumber"].ToString())); if (aCheckDataRow == null) { //MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectCheckRowByNumber Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditVoucher-SelectCheckRowByNumber Returned Null"); } HolderNameTxtBox.Text = aCheckDataRow["HolderName"].ToString(); CheckCommentsTxtBox.Text = aCheckDataRow["Comments"].ToString(); CheckDatePicker.Text = aCheckDataRow["PaymentDate"].ToString(); } DataRow aAccountRow = AccountsMgmt.SelectAccountRowByID(int.Parse(aPurchaseDataRow["AccountID"].ToString())); if (aAccountRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectAccountRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditBill-SelectAccountRowByID Returned Null"); } else { AccountComboBox.Text = aAccountRow["Name"].ToString(); AccountDescriptionTxtBox.Text = aAccountRow["Description"].ToString(); CurrencyComboBox.Text = CurrencyMgmt.SelectCurrencyNameByID(int.Parse(aAccountRow["CurrencyID"].ToString())); if (CurrencyComboBox.Text == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditVoucher-SelectCurrencyNameByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } CreditCardInfoTxtBox.Text = aPurchaseDataRow["CreditCardInfo"].ToString(); } if (aPurchaseDataRow["IsCashCredit"].ToString() == "1") { CashMethodComboBox.SelectedIndex = 1; VendorAccountAmountTxtBox.Show(); VendorAccountAmountTxtBox.Text = aPurchaseDataRow["VendorAccountAmountOld"].ToString(); AccountComboBox.Hide(); AccountLbl.Hide(); CashInTxtBox.Hide(); ExchangeTxtBox.Hide(); CashInLbl.Hide(); ExchangeLbl.Hide(); JODstatic.Hide(); CurrencyLbl.Hide(); IsCreditLbl.Show(); } else { CashMethodComboBox.SelectedIndex = 0; VendorAccountAmountTxtBox.Hide(); AccountComboBox.Show(); AccountLbl.Show(); CashInTxtBox.Show(); ExchangeTxtBox.Show(); CashInLbl.Show(); ExchangeLbl.Show(); JODstatic.Show(); CurrencyLbl.Show(); IsCreditLbl.Hide(); } } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditVoucher-UpdateVariables] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } }
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; } }
public void UpdateVariables(DataRow aGeneralBillDataRow) { try { aBillGeneralRow = aGeneralBillDataRow; InvoiceNumTxtBox.Text = aGeneralBillDataRow["Number"].ToString(); DateLbl.Text = DateTime.Parse(aGeneralBillDataRow["Date"].ToString()).ToShortDateString(); TimeLbl.Text = aGeneralBillDataRow["BillTime"].ToString(); TellerLbl.Text = UsersMgmt.SelectUserNameByID(int.Parse(aGeneralBillDataRow["TellerID"].ToString())); if (TellerLbl.Text == null) { //MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-UsersMgmt.UsrById Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("[EditBill-UsersMgmt.UsrById Returned Null]"); } aUserDataRow = CustomerMgmt.SelectCustomerRowByID(int.Parse(aGeneralBillDataRow["CustomerID"].ToString())); if (aUserDataRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectCustomerRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditBill-SelectCustomerRowByID Returned Null"); } PriceLevelComboBox.Text = PriceLevelsMgmt.SelectPriceLevelNameByID(int.Parse(aGeneralBillDataRow["PriceLevelID"].ToString())); if (PriceLevelComboBox.Text == null) { //MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectPriceLevelNameByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditBill-SelectPriceLevelNameByID Returned Null"); } PhoneTxtBox.Text = aUserDataRow["Phone1"].ToString(); CustomerNameTxtBox.Text = aUserDataRow["Name"].ToString(); CommentsTxtBox.Text = aGeneralBillDataRow["Comments"].ToString(); PriceLevelDiscount.Text = aGeneralBillDataRow["SalesDiscount"].ToString(); DiscountPercTxtBox.Text = aGeneralBillDataRow["DiscountPerc"].ToString(); SubtotalTxtBox.Text = aGeneralBillDataRow["Subtotal"].ToString(); NetAmountTxtBox.Text = aGeneralBillDataRow["NetAmount"].ToString(); TaxTxtBox.Text = aGeneralBillDataRow["TotalTax"].ToString(); DiscountBillTxtBox.Text = (double.Parse(DiscountPercTxtBox.Text) / 100 * double.Parse(NetAmountTxtBox.Text)).ToString(); TotalDiscountTxtBox.Text = aGeneralBillDataRow["TotalDiscount"].ToString(); TotalTxtBox.Text = aGeneralBillDataRow["TotalPrice"].ToString(); if (aGeneralBillDataRow["IsRevised"].ToString() == "1") { ReviseInfoGB.Show(); ReviseDatelbl.Text = DateTime.Parse(aGeneralBillDataRow["ReviseDate"].ToString()).ToShortDateString(); RevisedBylbl.Text = aGeneralBillDataRow["RevisedBy"].ToString(); IsRevisedLbl.Visible = true; ReviseLossProfitLbl.Text = aGeneralBillDataRow["ReviseLoss"].ToString(); } else { ReviseInfoGB.Hide(); } if (aGeneralBillDataRow["IsChecked"].ToString() == "1") { ChkedByUserNameLbl.Text = aGeneralBillDataRow["CheckedBy"].ToString(); ChkDateLbl.Text = DateTime.Parse(aGeneralBillDataRow["CheckedDate"].ToString()).ToShortDateString(); CheckInfoGB.Show(); } else { CheckInfoGB.Hide(); } //PaymentInformation DataRow aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(aGeneralBillDataRow["PaymentMethodID"].ToString())); if (aMethodRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectMethodRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditBill-SelectMethodRowByID Returned Null"); } PaymentMethodCheckBox.Text = aMethodRow["Name"].ToString(); PaymentMethodDescripTxtBox.Text = aMethodRow["Description"].ToString();//PaymentMethodMgmt.SelectDescriptionByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); if (aMethodRow["IsCash"].ToString() == "1") { CashPaymentGB.Show(); CashPaymentGB.BringToFront(); PayInVisaGB.Hide(); CheckGB.Hide(); } else if (aMethodRow["IsCredit"].ToString() == "1") { PayInVisaGB.Show(); PayInVisaGB.BringToFront(); CashPaymentGB.Hide(); CheckGB.Hide(); } else { CheckGB.Show(); CheckGB.BringToFront(); CashPaymentGB.Hide(); PayInVisaGB.Hide(); CheckNumberTxtBox.Text = aGeneralBillDataRow["CheckNumber"].ToString(); DataRow aCheckDataRow = ChecksMgmt.SelectCheckRowByNumber(int.Parse(aGeneralBillDataRow["CheckNumber"].ToString())); if (aCheckDataRow == null) { //MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectCheckRowByNumber Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditBill-SelectCheckRowByNumber Returned Null"); } HolderNameTxtBox.Text = aCheckDataRow["HolderName"].ToString(); CheckCommentsTxtBox.Text = aCheckDataRow["Comments"].ToString(); CheckDatePicker.Text = aCheckDataRow["PaymentDate"].ToString(); } DataRow aAccountRow = AccountsMgmt.SelectAccountRowByID(int.Parse(aGeneralBillDataRow["AccountID"].ToString())); if (aAccountRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectAccountRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditBill-SelectAccountRowByID Returned Null"); } else { AccountComboBox.Text = aAccountRow["Name"].ToString(); AccountDescriptionTxtBox.Text = aAccountRow["Description"].ToString(); CurrencyComboBox.Text = CurrencyMgmt.SelectCurrencyNameByID(int.Parse(aGeneralBillDataRow["CurrencyID"].ToString())); if (CurrencyComboBox.Text == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectCurrencyNameByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } CashInCurrency.Text = CurrencyComboBox.Text; CashInTxtBox.Text = aGeneralBillDataRow["CashIn"].ToString(); BuyRateTxtBox.Text = CurrencyMgmt.SelectBuyRateByID(int.Parse(aGeneralBillDataRow["CurrencyID"].ToString())).ToString(); SellRateTxtBox.Text = CurrencyMgmt.SelectSellRateByID(int.Parse(aGeneralBillDataRow["CurrencyID"].ToString())).ToString(); ExchangeTxtBox.Text = (double.Parse(CashInTxtBox.Text) * double.Parse(BuyRateTxtBox.Text) - double.Parse(TotalTxtBox.Text)).ToString(); CreditCardInfoTxtBox.Text = aGeneralBillDataRow["CreditCardInfo"].ToString(); } if (aBillGeneralRow["IsCashCredit"].ToString() == "1") { CashMethodComboBox.SelectedIndex = 1; //CustomerAccountAmountlbl.Show(); CustomerAccountAmountTxtBox.Show(); CustomersAccountAmount.Show(); CustomerAccountAmountTxtBox.Text = aBillGeneralRow["CustomerAccountAmountOld"].ToString(); CashInTxtBox.Hide(); ExchangeTxtBox.Hide(); CashInLbl.Hide(); ExchangeLbl.Hide(); JODstatic.Hide(); CurrencyLbl.Hide(); IsCreditLbl.Show(); } else { CashMethodComboBox.SelectedIndex = 0; //CustomerAccountAmountlbl.Hide(); CustomerAccountAmountTxtBox.Hide(); CustomersAccountAmount.Hide(); CashInTxtBox.Show(); ExchangeTxtBox.Show(); CashInLbl.Show(); ExchangeLbl.Show(); JODstatic.Show(); CurrencyLbl.Show(); IsCreditLbl.Hide(); } } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-UpdateVariables] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } }
public void UpdateVariables(DataRow aCustomerPaymentRow) { try { PaymentNumberTxtBox.Text = aCustomerPaymentRow["PaymentNumber"].ToString(); aCustomerPaymentRowGlobal = aCustomerPaymentRow; DateLbl.Text = DateTime.Parse(aCustomerPaymentRow["Date"].ToString()).ToShortDateString(); TimeLbl.Text = aCustomerPaymentRow["Time"].ToString(); TellerLbl.Text = UsersMgmt.SelectUserNameByID(int.Parse(aCustomerPaymentRow["TellerID"].ToString())); if (TellerLbl.Text == null) { //MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-UsersMgmt.UsrById Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("[EditCustomerPayment-UsersMgmt.UsrById Returned Null]"); } DataRow aCustomerRow = CustomerMgmt.SelectCustomerRowByID(int.Parse(aCustomerPaymentRow["CustomerID"].ToString())); if (aCustomerRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectCustomerRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditCustomerPayment-SelectCustomerRowByID Returned Null"); } CustomerPhoneTxtBox.Text = aCustomerRow["Phone1"].ToString(); CustomerNameTxtBox.Text = aCustomerRow["Name"].ToString(); double OldBalance = double.Parse(aCustomerPaymentRow["OldUsrAccountAmount"].ToString()); double Amount = double.Parse(aCustomerPaymentRow["Amount"].ToString()); double NewBalance = OldBalance - Amount; CustomerBalanceTxtBox.Text = OldBalance.ToString(); NewBalanceTxtBox.Text = NewBalance.ToString(); aCustomerAccount = CustomersAccountsMgmt.SelectCustomerAccountRowByCusID(int.Parse(aCustomerPaymentRow["CustomerID"].ToString())); if (aCustomerAccount == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectCustomerRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditCustomerPayment-SelectCustomerAccountRowByCusID Returned Null"); } CurrentBalanceTxtBox.Text = double.Parse(aCustomerAccount["Amount"].ToString()).ToString(); PaymentAmountTxtBox.Text = Amount.ToString(); CommentsTxtBox.Text = aCustomerPaymentRow["Comments"].ToString(); if (aCustomerPaymentRow["IsRevised"].ToString() == "1") { ReviseInfoGB.Show(); ReviseDatelbl.Text = DateTime.Parse(aCustomerPaymentRow["ReviseDate"].ToString()).ToShortDateString(); ReviseTime.Text = aCustomerPaymentRow["ReviseTime"].ToString(); RevisedBylbl.Text = aCustomerPaymentRow["RevisedBy"].ToString(); IsRevisedLbl.Visible = true; } else { ReviseInfoGB.Hide(); } if (aCustomerPaymentRow["IsChecked"].ToString() == "1") { ChkedByUserNameLbl.Text = aCustomerPaymentRow["CheckedBy"].ToString(); ChkDateLbl.Text = DateTime.Parse(aCustomerPaymentRow["CheckDate"].ToString()).ToShortDateString(); CheckTime.Text = aCustomerPaymentRow["CheckTime"].ToString(); CheckInfoGB.Show(); } else { CheckInfoGB.Hide(); } //PaymentInformation DataRow aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(aCustomerPaymentRow["PaymentMethodID"].ToString())); if (aMethodRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectMethodRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditCustomerPayment-SelectMethodRowByID Returned Null"); } PaymentMethodCheckBox.Text = aMethodRow["Name"].ToString(); PaymentMethodDescripTxtBox.Text = aMethodRow["Description"].ToString();//PaymentMethodMgmt.SelectDescriptionByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); if (aMethodRow["IsCash"].ToString() == "1") { CashPaymentGB.Show(); CashPaymentGB.BringToFront(); PayInVisaGB.Hide(); CheckGB.Hide(); } else if (aMethodRow["IsCredit"].ToString() == "1") { PayInVisaGB.Show(); PayInVisaGB.BringToFront(); CashPaymentGB.Hide(); CheckGB.Hide(); } else { CheckGB.Show(); CheckGB.BringToFront(); CashPaymentGB.Hide(); PayInVisaGB.Hide(); CheckNumberTxtBox.Text = aCustomerPaymentRow["CheckNumber"].ToString(); DataRow aCheckDataRow = ChecksMgmt.SelectCheckRowByNumber(int.Parse(aCustomerPaymentRow["CheckNumber"].ToString())); if (aCheckDataRow == null) { //MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectCheckRowByNumber Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditCustomerPayment-SelectCheckRowByNumber Returned Null"); } HolderNameTxtBox.Text = aCheckDataRow["HolderName"].ToString(); BanksComboBox.Text = aCheckDataRow["BankName"].ToString(); CheckCommentsTxtBox.Text = aCheckDataRow["Comments"].ToString(); CheckDatePicker.Text = aCheckDataRow["PaymentDate"].ToString(); } DataRow aAccountRow = AccountsMgmt.SelectAccountRowByID(int.Parse(aCustomerPaymentRow["AccountID"].ToString())); if (aAccountRow == null) { // MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditBill-SelectAccountRowByID Returned Null] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw new Exception("EditCustomerPayment-SelectAccountRowByID Returned Null"); } else { AccountComboBox.Text = aAccountRow["Name"].ToString(); AccountDescriptionTxtBox.Text = aAccountRow["Description"].ToString(); CreditCardInfoTxtBox.Text = aCustomerPaymentRow["CreditCardInfo"].ToString(); AccountBalanceTxtBox.Text = aAccountRow["Amount"].ToString(); } } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EditCustomerPayment-UpdateVariables] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } }
public void UpdateVariables(DataRow aVendorPaymentRow) { try { PaymentNumberTxtBox.Text = aVendorPaymentRow["PaymentNumber"].ToString(); aVendorPaymentRowGlobal = aVendorPaymentRow; DateLbl.Text = DateTime.Parse(aVendorPaymentRow["Date"].ToString()).ToShortDateString(); TimeLbl.Text = aVendorPaymentRow["Time"].ToString(); TellerLbl.Text = UsersMgmt.SelectUserNameByID(int.Parse(aVendorPaymentRow["TellerID"].ToString())); DataRow aVendorRow = VendorsMgmt.SelectVendorRowByID(int.Parse(aVendorPaymentRow["VendorID"].ToString())); if (aVendorRow == null) { throw new Exception("LOWER in aVendorRow==null"); } VendorNameTxtBox.Text = aVendorRow["Name"].ToString(); VendorCompanyTxtBox.Text = aVendorRow["Company"].ToString(); double OldBalance = double.Parse(aVendorPaymentRow["OldVendorAccountAmount"].ToString()); double Amount = double.Parse(aVendorPaymentRow["Amount"].ToString()); double NewBalance = OldBalance - Amount;//+ because its reversed VendorAccountBalanceTxtBox.Text = OldBalance.ToString(); NewBalanceTxtBox.Text = NewBalance.ToString(); aAccount = AccountsMgmt.SelectAccountRowByID(int.Parse(aVendorPaymentRow["MyAccountID"].ToString())); if (aAccount == null) { throw new Exception("LOWER in aAccount == null"); } AccountDescriptionTxtBox.Text = aAccount["Description"].ToString(); aVendorAccount = VendorsAccountsMgmt.SelectVendorAccountRowByVendorID(int.Parse(aVendorPaymentRow["VendorID"].ToString())); if (aVendorAccount == null) { throw new Exception("LOWER in aVendorAccount == null"); } CurrentBalanceTxtBox.Text = double.Parse(aVendorAccount["Amount"].ToString()).ToString(); PaymentAmountTxtBox.Text = Amount.ToString(); CommentsTxtBox.Text = aVendorPaymentRow["Comments"].ToString(); if (aVendorPaymentRow["IsRevised"].ToString() == "1") { ReviseInfoGB.Show(); ReviseDatelbl.Text = DateTime.Parse(aVendorPaymentRow["ReviseDate"].ToString()).ToShortDateString(); ReviseTime.Text = aVendorPaymentRow["ReviseTime"].ToString(); RevisedBylbl.Text = aVendorPaymentRow["RevisedBy"].ToString(); IsRevisedLbl.Visible = true; } else { ReviseInfoGB.Hide(); } if (aVendorPaymentRow["IsChecked"].ToString() == "1") { ChkedByUserNameLbl.Text = aVendorPaymentRow["CheckedBy"].ToString(); ChkDateLbl.Text = DateTime.Parse(aVendorPaymentRow["CheckDate"].ToString()).ToShortDateString(); CheckTime.Text = aVendorPaymentRow["CheckTime"].ToString(); CheckInfoGB.Show(); } else { CheckInfoGB.Hide(); } //PaymentInformation DataRow aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(aVendorPaymentRow["PaymentMethodID"].ToString())); if (aMethodRow == null) { throw new Exception("LOWER in aMethodRow == null"); } PaymentMethodCheckBox.Text = aMethodRow["Name"].ToString(); PaymentMethodDescripTxtBox.Text = aMethodRow["Description"].ToString();//PaymentMethodMgmt.SelectDescriptionByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); if (aMethodRow["IsCash"].ToString() == "1") { CashPaymentGB.Show(); CashPaymentGB.BringToFront(); PayInVisaGB.Hide(); CheckGB.Hide(); } else if (aMethodRow["IsCredit"].ToString() == "1") { PayInVisaGB.Show(); PayInVisaGB.BringToFront(); CashPaymentGB.Hide(); CheckGB.Hide(); } else { CheckGB.Show(); CheckGB.BringToFront(); CashPaymentGB.Hide(); PayInVisaGB.Hide(); CheckNumberTxtBox.Text = aVendorPaymentRow["CheckNumber"].ToString(); DataRow aCheckDataRow = ChecksMgmt.SelectCheckRowByNumber(int.Parse(aVendorPaymentRow["CheckNumber"].ToString())); if (aCheckDataRow == null) { throw new Exception("LOWER in aCheckDataRow == null"); } HolderNameTxtBox.Text = aCheckDataRow["HolderName"].ToString(); CheckCommentsTxtBox.Text = aCheckDataRow["Comments"].ToString(); CheckDatePicker.Text = DateTime.Parse(aCheckDataRow["PaymentDate"].ToString()).ToShortDateString(); } DataRow aAccountRow = AccountsMgmt.SelectAccountRowByID(int.Parse(aVendorPaymentRow["MyAccountID"].ToString())); if (aAccountRow == null) { throw new Exception("LOWER in aAccountRow == null"); } AccountComboBox.Text = aAccountRow["Name"].ToString(); AccountDescriptionTxtBox.Text = aAccountRow["Description"].ToString(); CreditCardInfoTxtBox.Text = aVendorPaymentRow["CreditCardInfo"].ToString(); AccountBalanceTxtBox.Text = aAccountRow["Amount"].ToString(); } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [EDIT Vendor Payment: UpdateVariables] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); throw; } }
private bool AddPayment() { try { semaphore = true; int NextCheckNumber = -1; double Amount = 0; if (VendorDoNotHaveAccount || AccountNotJOD) { MessageBox.Show(MsgTxt.PleaseSelectTxt + "\n 1)" + MsgTxt.VendorTxt + "\n2)" + MsgTxt.ValidAccountTxt, MsgTxt.WarningCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); semaphore = false; return(false); } else { if (!double.TryParse(PaymentAmountTxtBox.Text, out Amount)) { MessageBox.Show(MsgTxt.PleaseSelectCorrectAmountTxt, MsgTxt.WarningCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); PaymentAmountTxtBox.BackColor = SharedVariables.TxtBoxRequiredColor; return(false); } else if (Amount == 0) { MessageBox.Show(MsgTxt.PleaseSelectCorrectAmountTxt, MsgTxt.WarningCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning); PaymentAmountTxtBox.BackColor = SharedVariables.TxtBoxRequiredColor; return(false); } else { PaymentAmountTxtBox.BackColor = PaymentAmountTxtBoxCOLOR; DataRow aMethodRow = PaymentMethodMgmt.SelectMethodRowByID(int.Parse(PaymentMethodCheckBox.SelectedValue.ToString())); if (aMethodRow == null) { throw new Exception("aMethodRow==null"); } aVendorAccountRow = VendorsAccountsMgmt.SelectVendorAccountRowByVendorID(VendorID); Balance = Double.Parse(aVendorAccountRow["Amount"].ToString()); aVendorPayment = new VendorsPayments(); int PaymentNumber = VendorsPaymentsMgmt.NextPaymentNumber(); aVendorPayment.Vendor_Payment_PaymentNumber = PaymentNumber; aVendorPayment.Vendor_Payment_VendorID = VendorID; aVendorPayment.Vendor_Payment_Date = DateTime.Now.ToShortDateString(); aVendorPayment.Vendor_Payment_Time = DateTime.Now.ToShortTimeString(); int TellerID = UsersMgmt.SelectUserIDByUserName(SharedFunctions.ReturnLoggedUserName()); aVendorPayment.Vendor_Payment_TellerID = TellerID; aVendorPayment.Vendor_Payment_OldAmount = Balance; aVendorPayment.PaymentMethodID = int.Parse(PaymentMethodCheckBox.SelectedValue.ToString()); aVendorPayment.Vendor_Payment_Comments = CommentsTxtBox.Text; aVendorPayment.MyAccountID = int.Parse(AccountComboBox.SelectedValue.ToString()); aVendorPayment.Vendor_Payment_Amount = double.Parse(PaymentAmountTxtBox.Text); Checks aCheck = new Checks(); if (aMethodRow["IsCash"].ToString() == "1") { aVendorPayment.IsCreditCard = 0; aVendorPayment.CreditCardInfo = "NOT-CREDIT"; VendorsPaymentsMgmt.AddVendorPayment(aVendorPayment); //IS REVISED AND IS CHECKED ADDED TO ZERO IN QUERY int VenAccountID = int.Parse(aVendorAccountRow["ID"].ToString()); double NewAmount = Balance - aVendorPayment.Vendor_Payment_Amount; VendorsAccountsMgmt.UpdateAccountAmountByAccountID(VenAccountID, NewAmount); double MyOldAmount = AccountsMgmt.SelectAccountAmountByID(int.Parse(AccountComboBox.SelectedValue.ToString())); AccountsMgmt.UpdateAccountAmountByAccountID(int.Parse(AccountComboBox.SelectedValue.ToString()), MyOldAmount - aVendorPayment.Vendor_Payment_Amount); } else if (aMethodRow["IsCredit"].ToString() == "1") { aVendorPayment.IsCreditCard = 1; aVendorPayment.CreditCardInfo = CreditCardInfoTxtBox.Text; VendorsPaymentsMgmt.AddVendorPayment(aVendorPayment); //IS REVISED AND IS CHECKED ADDED TO ZERO IN QUERY int VenAccountID = int.Parse(aVendorAccountRow["ID"].ToString()); double NewAmount = Balance - aVendorPayment.Vendor_Payment_Amount; VendorsAccountsMgmt.UpdateAccountAmountByAccountID(VenAccountID, NewAmount); int AccountID = int.Parse(AccountComboBox.SelectedValue.ToString()); DataRow aAccountRow = AccountsMgmt.SelectAccountRowByID(AccountID); double OldAmount = double.Parse(aAccountRow["Amount"].ToString()); double NewAmount2 = OldAmount - aVendorPayment.Vendor_Payment_Amount; AccountsMgmt.UpdateAccountAmountByAccountID(AccountID, NewAmount2); } else { aVendorPayment.IsCreditCard = 0; aVendorPayment.CreditCardInfo = "NOT-CREDIT"; NextCheckNumber = ChecksMgmt.NextCheckNumber(); aVendorPayment.CheckNumber = NextCheckNumber; VendorsPaymentsMgmt.AddVendorPayment(aVendorPayment); aCheck.Chekcs_HolderName = HolderNameTxtBox.Text; aCheck.Chekcs_PaymentDate = CheckDatePicker.Value.ToShortDateString(); aCheck.Chekcs_IsBill = 0; aCheck.Chekcs_IsPurchaseVoucher = 0; aCheck.Chekcs_AccountID = 0; aCheck.Chekcs_Comments = CheckCommentsTxtBox.Text; aCheck.Chekcs_Amount = aVendorPayment.Vendor_Payment_Amount; aCheck.Chekcs_IsPaid = 0; aCheck.CheckNumber = NextCheckNumber; aCheck.AddingDate = DateTime.Now.ToShortDateString(); aCheck.Chekcs_PaymentDate = CheckDatePicker.Text; aCheck.Chekcs_IsVendorPayment = 1; aCheck.Chekcs_VendorPaymentNumber = aVendorPayment.Vendor_Payment_PaymentNumber; aCheck.Chekcs_IsCustomerPayment = 0; if (!ChecksMgmt.InsertCheck(aCheck)) { VendorsPaymentsMgmt.DeleteVendorPayment(aVendorPayment); MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [DataBase Error: CANNOT ADD CHECK] \n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); semaphore = false; //ReloadForm(); return(false); } } MessageBox.Show(MsgTxt.AddedSuccessfully, MsgTxt.AddedSuccessfully, MessageBoxButtons.OK, MessageBoxIcon.Information); semaphore = false; return(true); } } } catch (Exception ex) { semaphore = false; MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [AddPaymentBtn_Click] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); return(false); } }
private void ListBillsBtn_Click(object sender, EventArgs e) { try { int FilterCustomerID = -1; if (CustomerNameChkBox.Checked) { FilterCustomerID = CustomerMgmt.SelectCustomerIDByPhone1(CustomerPhoneTxtBox.Text); if (FilterCustomerID == -1) { MessageBox.Show("Customer Not Found"); } } aCustomerTable = CustomerMgmt.SelectAllCustomers(); aCurrencyTable = CurrencyMgmt.SelectAll(); aUsersTable = UsersMgmt.SelectAllUsers(); aAccountsTable = AccountsMgmt.SelectAll(); aPriceLevelTable = PriceLevelsMgmt.SelectAll(); aPaymentMethodTable = PaymentMethodMgmt.SelectAll(); ListBillsDGView.Rows.Clear(); int FilterTellerNameID = 0; if (TellerNameChkBox.Checked && TellerNameComboBox.SelectedValue != null) { FilterTellerNameID = int.Parse(TellerNameComboBox.SelectedValue.ToString()); } string FilterDateFrom = ""; string FilterDateTo = ""; if (DateCheckBox.Checked) { FilterDateFrom = DateFrompicker.Value.ToShortDateString(); FilterDateTo = DateToPicker.Value.ToShortDateString(); } bool FilterCheckedBills = CkeckedBillsChkBox.Checked; bool FilterIsRevised = IsRevisedChkBox.Checked; bool FilterUnCheckedBills = UncheckedBillChkBox.Checked; bool FilterUnRevisedBills = UnRevisedChkBox.Checked; bool FilterCashCreditBills = CreditBillsChkBox.Checked; aBillTable = BillGeneralMgmt.SelectAllBills(FilterTellerNameID, FilterDateFrom, FilterDateTo, FilterCheckedBills, FilterIsRevised, FilterUnCheckedBills, FilterUnRevisedBills, FilterCustomerID, FilterCashCreditBills); if (aBillTable == null) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListBillsBtn_Click:DB-ERROR aBillTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } TotalITemsTxtBox.Text = aBillTable.Rows.Count.ToString(); if (aBillTable.Rows.Count > 0) { RowNum = 0; if (ListBillsDGView.Rows.Count < ItemsPerPage) { //TestingFor Paging pagesnumber = (int)aBillTable.Rows.Count / ItemsPerPage; if ((double.Parse(aBillTable.Rows.Count.ToString()) / ItemsPerPage - int.Parse(aBillTable.Rows.Count.ToString()) / ItemsPerPage) > 0) { pagesnumber++; } foreach (DataRow r in aBillTable.Rows) { if (ListBillsDGView.Rows.Count < ItemsPerPage) { ListBillsDGView.Rows.Add(); ListBillsDGView.Rows[RowNum].Cells["Number"].Value = aBillTable.Rows[RowNum]["Number"].ToString(); ListBillsDGView.Rows[RowNum].Cells["Date"].Value = aBillTable.Rows[RowNum]["Date"].ToString(); ListBillsDGView.Rows[RowNum].Cells["BillTime"].Value = aBillTable.Rows[RowNum]["BillTime"].ToString(); ListBillsDGView.Rows[RowNum].Cells["TotalItems"].Value = aBillTable.Rows[RowNum]["TotalItems"].ToString(); ListBillsDGView.Rows[RowNum].Cells["TotalTax"].Value = aBillTable.Rows[RowNum]["TotalTax"].ToString(); ListBillsDGView.Rows[RowNum].Cells["TotalPrice"].Value = aBillTable.Rows[RowNum]["TotalPrice"].ToString(); for (int i = 0; i < aUsersTable.Rows.Count; i++) { if (int.Parse(aUsersTable.Rows[i]["ID"].ToString()) == int.Parse(aBillTable.Rows[RowNum]["TellerID"].ToString())) { ListBillsDGView.Rows[RowNum].Cells["TellerID"].Value = aUsersTable.Rows[i]["UserName"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString(); break; } } for (int i = 0; i < aCustomerTable.Rows.Count; i++) { if (int.Parse(aCustomerTable.Rows[i]["ID"].ToString()) == int.Parse(aBillTable.Rows[RowNum]["CustomerID"].ToString())) { ListBillsDGView.Rows[RowNum].Cells["CustomerID"].Value = aCustomerTable.Rows[i]["Name"].ToString(); break; } } for (int i = 0; i < aPriceLevelTable.Rows.Count; i++) { if (int.Parse(aPriceLevelTable.Rows[i]["ID"].ToString()) == int.Parse(aBillTable.Rows[RowNum]["PriceLevelID"].ToString())) { ListBillsDGView.Rows[RowNum].Cells["PriceLevelID"].Value = aPriceLevelTable.Rows[i]["Name"].ToString(); break; } } for (int i = 0; i < aPaymentMethodTable.Rows.Count; i++) { if (int.Parse(aPaymentMethodTable.Rows[i]["ID"].ToString()) == int.Parse(aBillTable.Rows[RowNum]["PaymentMethodID"].ToString())) { ListBillsDGView.Rows[RowNum].Cells["PaymentMethodID"].Value = aPaymentMethodTable.Rows[i]["Name"].ToString(); break; } } ListBillsDGView.Rows[RowNum].Cells["TotalCost"].Value = aBillTable.Rows[RowNum]["TotalCost"].ToString(); ListBillsDGView.Rows[RowNum].Cells["Comments"].Value = aBillTable.Rows[RowNum]["Comments"].ToString(); ListBillsDGView.Rows[RowNum].Cells["SalesDiscount"].Value = aBillTable.Rows[RowNum]["SalesDiscount"].ToString(); ListBillsDGView.Rows[RowNum].Cells["DiscountPerc"].Value = aBillTable.Rows[RowNum]["DiscountPerc"].ToString(); ListBillsDGView.Rows[RowNum].Cells["CashIn"].Value = aBillTable.Rows[RowNum]["CashIn"].ToString(); ListBillsDGView.Rows[RowNum].Cells["TotalDiscount"].Value = aBillTable.Rows[RowNum]["TotalDiscount"].ToString(); if (aBillTable.Rows[RowNum]["IsChecked"].ToString() == "0") { ListBillsDGView.Rows[RowNum].Cells["IsChecked"].Value = UiText.NoTxt; } else { ListBillsDGView.Rows[RowNum].Cells["IsChecked"].Value = UiText.YesTxt; } if (aBillTable.Rows[RowNum]["IsRevised"].ToString() == "0") { ListBillsDGView.Rows[RowNum].Cells["IsRevised"].Value = UiText.NoTxt; } else { ListBillsDGView.Rows[RowNum].Cells["IsRevised"].Value = UiText.YesTxt; } ListBillsDGView.Rows[RowNum].Cells["CheckedDate"].Value = aBillTable.Rows[RowNum]["CheckedDate"].ToString(); ListBillsDGView.Rows[RowNum].Cells["CheckedBy"].Value = aBillTable.Rows[RowNum]["CheckedBy"].ToString(); ListBillsDGView.Rows[RowNum].Cells["ReviseDate"].Value = aBillTable.Rows[RowNum]["ReviseDate"].ToString(); ListBillsDGView.Rows[RowNum].Cells["RevisedBy"].Value = aBillTable.Rows[RowNum]["RevisedBy"].ToString(); ListBillsDGView.Rows[RowNum].Cells["ReviseLoss"].Value = aBillTable.Rows[RowNum]["ReviseLoss"].ToString(); RowNum++; } } PageOfTotalTxtBox.Text = "1/" + pagesnumber.ToString(); currentpage = 1; } } } catch (Exception ex) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListBillsBtn_Click] \n Exception: \n" + ex.ToString(), MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); throw; } }
private void ReviseBillBtn_Click(object sender, EventArgs e) { try { if (aBillGeneralRow["IsRevised"].ToString() == "0") { if (CashMethodComboBox.SelectedIndex == 1)//iscredit { int CustomerID = CustomerMgmt.SelectCustomerIDByPhone1(PhoneTxtBox.Text); DataRow aCustomerAccount = CustomersAccountsMgmt.SelectCustomerAccountRowByCusID(CustomerID); double OldAmount = double.Parse(aCustomerAccount["Amount"].ToString()); double NewAmount = OldAmount - double.Parse(TotalTxtBox.Text); int AccountID = int.Parse(aCustomerAccount["ID"].ToString()); CustomersAccountsMgmt.UpdateAccountAmountByAccountID(AccountID, NewAmount); } else {//int.Parse(AccountComboBox.SelectedValue.ToString()); int AccountID = int.Parse(aBillGeneralRow["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(aBillGeneralRow["PaymentMethodID"].ToString())); if (aMethodRow["IsCheck"].ToString() == "1") { ChecksMgmt.MakeCheckRevised(int.Parse(aBillGeneralRow["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 OldAvgUnitCost = BillDetailedMgmt.SelectOldAvgUnitCostByID(ItemID, int.Parse(aBillGeneralRow["Number"].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; if ((ReturnQty + CurrentAvaQty) != 0) //to avoid division by zero { NewAvgUnitCost = ((CurrentAvgUnitCost * CurrentAvaQty) + (ReturnQty * OldAvgUnitCost)) / (ReturnQty + CurrentAvaQty); } CostLoss += (NewAvgUnitCost - OldAvgUnitCost) * BillDetailedMgmt.SelectAllItemsSoldAfterBillNumber(ItemID, int.Parse(aBillGeneralRow["Number"].ToString())); ItemsMgmt.UpdateItemQtyandAvgUnitCostByID(ItemID, (ReturnQty + CurrentAvaQty), NewAvgUnitCost); BillDetailedMgmt.MakeItemAsRevised(int.Parse(aBillGeneralRow["Number"].ToString()), ItemID); } } //Now we should mark the bill general as reversed if (!BillGeneralMgmt.UpdateBillToRevised(SharedFunctions.ReturnLoggedUserName(), DateTime.Now.ToShortDateString(), int.Parse(aBillGeneralRow["Number"].ToString()), CostLoss)) { MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [DB-ERROR-EditBill-ReviseBillBtn_Click] " + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } 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 [EditBill-ReviseBillBtn_Click] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); throw; } }