private void CheckPaymentBtn_Click(object sender, EventArgs e)
{
try
{
if (aVendorPaymentRowGlobal["IsChecked"].ToString() == "0")
{
string CheckedBy = SharedFunctions.ReturnLoggedUserName();
string ChkDate = DateTime.Now.ToShortDateString();
string ChkTime = DateTime.Now.ToShortTimeString();
int PaymentNumber = int.Parse(aVendorPaymentRowGlobal["PaymentNumber"].ToString());
if (!VendorsPaymentsMgmt.UpdatePaymentToChecked(CheckedBy, ChkDate, ChkTime, PaymentNumber))
{
throw new Exception(" IN [DB-ERROR-EditVendorPayment-CheckPaymentBtn_Click] ");
}
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 [EditVendorPayment-CheckPaymentBtn_Click] \n Exception: \n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
private void CreditDGView_CellDoubleClick_1(object sender, DataGridViewCellEventArgs e)
{
DataRow aVendorPaymentToPass = VendorsPaymentsMgmt.SelectPaymentRow(int.Parse(CreditDGView.Rows[e.RowIndex].Cells["PaymentNumber"].Value.ToString()));
EditVendorPayments aEditVendorPayment = new EditVendorPayments();
// aEditVendorPayment.MdiParent = Helper.Instance.ActiveMainWindow;
aEditVendorPayment.Show();
aEditVendorPayment.UpdateVariables(aVendorPaymentToPass);
}
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 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 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);
}
}
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
}
