private void ListAdjustsBtn_Click(object sender, EventArgs e)
{
try
{
aAdjustList = AdjustInventoryGeneralMgmt.SelectAllAdjustsGeneral(-1, string.Empty, string.Empty);
aAdjustDetailedSumVal = AdjustInventoryDetailedMgmt.SelectAllAdjustsDetailedSUMValue(-1, -1);
aUsersTable = UsersMgmt.SelectAllUsers();
page(1);
}
catch (Exception ex)
{ MessageBox.Show("ERROR IN LIST ADJUST ITEMS" + ex.ToString(), MsgTxt.UnexpectedError, MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
private void ListUsersBtn_Click(object sender, EventArgs e)
{
try
{
int RowNum = 0;
DataTable UsersTable = UsersMgmt.SelectAllUsers();
if (UsersTable == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListUsers:DB-ERROR UsersTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (UsersTable.Rows.Count > 0)
{
RowNum = 0;
ListUsersDgView.Rows.Clear();
foreach (DataRow r in UsersTable.Rows)
{
ListUsersDgView.Rows.Add();
ListUsersDgView.Rows[RowNum].Cells["Namecol"].Value = UsersTable.Rows[RowNum]["Name"].ToString();
ListUsersDgView.Rows[RowNum].Cells["Address"].Value = UsersTable.Rows[RowNum]["Address"].ToString();
ListUsersDgView.Rows[RowNum].Cells["Phone1"].Value = UsersTable.Rows[RowNum]["Phone1"].ToString();
ListUsersDgView.Rows[RowNum].Cells["Phone2"].Value = UsersTable.Rows[RowNum]["Phone2"].ToString();
ListUsersDgView.Rows[RowNum].Cells["UserName"].Value = UsersTable.Rows[RowNum]["UserName"].ToString();
ListUsersDgView.Rows[RowNum].Cells["Password"].Value = UsersTable.Rows[RowNum]["Password"].ToString();
ListUsersDgView.Rows[RowNum].Cells["Description"].Value = UsersTable.Rows[RowNum]["Description"].ToString();
RowNum++;
}
}
}
catch (Exception ex)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListUsersBtn_Click] \n Exception: \n" + ex.ToString(), MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
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 ListDCBtn_Click(object sender, EventArgs e)
{
int FilterVendorID = int.Parse(VendorNameComboBox.SelectedValue.ToString());
aCurrencyTable = CurrencyMgmt.SelectAll();
aUsersTable = UsersMgmt.SelectAllUsers();
aAccountsTable = AccountsMgmt.SelectAll();
aPaymentMethodTable = PaymentMethodMgmt.SelectAll();
aAccountsTable = AccountsMgmt.SelectAll();
aVendorTable = VendorsMgmt.SelectAllVendors();
DebitDGView.Rows.Clear();
CreditDGView.Rows.Clear();
int FilterTellerNameID = 0;
if (TellerNameChkBox.Checked)
{
FilterTellerNameID = int.Parse(TellerNameComboBox.SelectedValue.ToString());
}
string FilterDateFrom = "";
string FilterDateTo = "";
if (DateCheckBox.Checked)
{
FilterDateFrom = DateFrompicker.Value.ToShortDateString();
FilterDateTo = DateToPicker.Value.ToShortDateString();
}
bool FilterCheckedBills = CheckChkBox.Checked;
bool FilterIsRevised = RevisedChkBox.Checked;
bool FilterUnCheckedBills = UnCheckedChkBox.Checked;
bool FilterUnRevisedBills = UnRevisedChkBox.Checked;
bool FilterBillCashCredit = CreditBillsChkBox.Checked;
//LISTING BILLS
aPurchaseVoucherTable = PurchaseVoucherGeneralMgmt.SelectAllVouchers(FilterTellerNameID, FilterDateFrom, FilterDateTo, FilterCheckedBills, FilterIsRevised, FilterUnCheckedBills, FilterUnRevisedBills, FilterVendorID, FilterBillCashCredit);
TotalITemsTxtBoxDebit.Text = aPurchaseVoucherTable.Rows.Count.ToString();
TotalDebitPriceTxtBox.Text = "0";
if (aPurchaseVoucherTable.Rows.Count > 0)
{
double TotalDebitPrice = 0;
for (int i = 0; i < aPurchaseVoucherTable.Rows.Count; i++)
{
TotalDebitPrice += double.Parse(aPurchaseVoucherTable.Rows[i]["TotalCost"].ToString());
}
TotalDebitPriceTxtBox.Text = TotalDebitPrice.ToString();
RowNumDebit = 0;
if (DebitDGView.Rows.Count < ItemsPerPageDebit)
{
//TestingFor Paging
pagesnumberDebit = (int)aPurchaseVoucherTable.Rows.Count / ItemsPerPageDebit;
if ((double.Parse(aPurchaseVoucherTable.Rows.Count.ToString()) / ItemsPerPageDebit - int.Parse(aPurchaseVoucherTable.Rows.Count.ToString()) / ItemsPerPageDebit) > 0)
{
pagesnumberDebit++;
}
foreach (DataRow r in aPurchaseVoucherTable.Rows)
{
if (DebitDGView.Rows.Count < ItemsPerPageDebit)
{
DebitDGView.Rows.Add();
DebitDGView.Rows[RowNumDebit].Cells["VoucherNumber"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["VoucherNumber"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["Date"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Date"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["Time"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Time"].ToString();
for (int i = 0; i < aVendorTable.Rows.Count; i++)
{
if (int.Parse(aVendorTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["VendorID"].ToString()))
{
DebitDGView.Rows[RowNumDebit].Cells["Vendor"].Value = aVendorTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNumDebit]["TellerID"].ToString();
break;
}
}
DebitDGView.Rows[RowNumDebit].Cells["TotalFreeITemsQty"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalFreeITemsQty"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["TotalTax"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalTax"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["Subtotal"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Subtotal"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["DiscountPerc"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["DiscountPerc"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["TotalItemsDiscount"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalItemsDiscount"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["TotalDiscount"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalDiscount"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["TotalCost"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["TotalCost"].ToString();
for (int i = 0; i < aPaymentMethodTable.Rows.Count; i++)
{
if (int.Parse(aPaymentMethodTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["PaymentMethodID"].ToString()))
{
DebitDGView.Rows[RowNumDebit].Cells["PaymentMethod"].Value = aPaymentMethodTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNumDebit]["TellerID"].ToString();
break;
}
}
DebitDGView.Rows[RowNumDebit].Cells["Comments"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Comments"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["CreditCardInfo"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CreditCardInfo"].ToString();
for (int i = 0; i < aCurrencyTable.Rows.Count; i++)
{
if (int.Parse(aCurrencyTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["CurrencyID"].ToString()))
{
DebitDGView.Rows[RowNumDebit].Cells["Currency"].Value = aCurrencyTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNumDebit]["TellerID"].ToString();
break;
}
}
for (int i = 0; i < aAccountsTable.Rows.Count; i++)
{
if (int.Parse(aAccountsTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["AccountID"].ToString()))
{
DebitDGView.Rows[RowNumDebit].Cells["Currency"].Value = aAccountsTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNumDebit]["TellerID"].ToString();
break;
}
}
for (int i = 0; i < aUsersTable.Rows.Count; i++)
{
if (int.Parse(aUsersTable.Rows[i]["ID"].ToString()) == int.Parse(aPurchaseVoucherTable.Rows[RowNumDebit]["TellerID"].ToString()))
{
DebitDGView.Rows[RowNumDebit].Cells["Teller"].Value = aUsersTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString();
break;
}
}
DebitDGView.Rows[RowNumDebit].Cells["CheckNumber"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CheckNumber"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["IsCashCredit"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["IsCashCredit"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["VendorAccountAmountOld"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["VendorAccountAmountOld"].ToString();
if (aPurchaseVoucherTable.Rows[RowNumDebit]["IsChecked"].ToString() == "0")
{
DebitDGView.Rows[RowNumDebit].Cells["IsChecked"].Value = "NO";//aBillTable.Rows[RowNumDebit]["IsChecked"].ToString();
}
else
{
DebitDGView.Rows[RowNumDebit].Cells["IsChecked"].Value = "YES";
}
DebitDGView.Rows[RowNumDebit].Cells["CheckedBy"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CheckedBy"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["CheckDate"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CheckDate"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["CheckTime"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["CheckTime"].ToString();
if (aPurchaseVoucherTable.Rows[RowNumDebit]["IsRevised"].ToString() == "0")
{
DebitDGView.Rows[RowNumDebit].Cells["IsRevised"].Value = "NO";//aBillTable.Rows[RowNumDebit]["IsChecked"].ToString();
}
else
{
DebitDGView.Rows[RowNumDebit].Cells["IsRevised"].Value = "YES";
}
DebitDGView.Rows[RowNumDebit].Cells["RevisedBy"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["RevisedBy"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["ReviseDate"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["ReviseDate"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["ReviseTime"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["ReviseTime"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["ReviseLoss"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["ReviseLoss"].ToString();
DebitDGView.Rows[RowNumDebit].Cells["Fees"].Value = aPurchaseVoucherTable.Rows[RowNumDebit]["Fees"].ToString();
RowNumDebit++;
}
}
PageOfTotalTxtBoxDebit.Text = "1/" + pagesnumberDebit.ToString();
currentpageDebit = 1;
}
}
//LISTING PAYMENTS
//LISTING PAYMENTS CREDIT
aVendorPaymentTable = VendorsPaymentsMgmt.SelectAll(FilterTellerNameID, FilterDateFrom, FilterDateTo, FilterCheckedBills, FilterIsRevised, FilterUnCheckedBills, FilterUnRevisedBills, FilterVendorID);
TotalITemsTxtBoxCredit.Text = aVendorPaymentTable.Rows.Count.ToString();
TotalCreditTxtBox.Text = "0";
if (aVendorPaymentTable.Rows.Count > 0)
{
double TotalCredit = 0;
for (int i = 0; i < aVendorPaymentTable.Rows.Count; i++)
{
TotalCredit += double.Parse(aVendorPaymentTable.Rows[i]["Amount"].ToString());
}
TotalCreditTxtBox.Text = TotalCredit.ToString();
RowNumCredit = 0;
if (CreditDGView.Rows.Count < ItemsPerPageCredit)
{
//TestingFor Paging
pagesnumberCredit = (int)aVendorPaymentTable.Rows.Count / ItemsPerPageCredit;
if ((double.Parse(aVendorPaymentTable.Rows.Count.ToString()) / ItemsPerPageCredit - int.Parse(aVendorPaymentTable.Rows.Count.ToString()) / ItemsPerPageCredit) > 0)
{
pagesnumberCredit++;
}
foreach (DataRow r in aVendorPaymentTable.Rows)
{
if (CreditDGView.Rows.Count < ItemsPerPageCredit)
{
CreditDGView.Rows.Add();
CreditDGView.Rows[RowNumCredit].Cells["PaymentNumber"].Value = aVendorPaymentTable.Rows[RowNumCredit]["PaymentNumber"].ToString();
for (int i = 0; i < aVendorTable.Rows.Count; i++)
{
if (int.Parse(aVendorTable.Rows[i]["ID"].ToString()) == int.Parse(aVendorPaymentTable.Rows[RowNumCredit]["VendorID"].ToString()))
{
CreditDGView.Rows[RowNumCredit].Cells["VendorIDCredit"].Value = aVendorTable.Rows[i]["Name"].ToString();
break;
}
}
CreditDGView.Rows[RowNumCredit].Cells["DateCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["Date"].ToString();
CreditDGView.Rows[RowNumCredit].Cells["TimeCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["Time"].ToString();
for (int i = 0; i < aUsersTable.Rows.Count; i++)
{
if (int.Parse(aUsersTable.Rows[i]["ID"].ToString()) == int.Parse(aVendorPaymentTable.Rows[RowNumCredit]["TellerID"].ToString()))
{
CreditDGView.Rows[RowNumCredit].Cells["TellerCredit"].Value = aUsersTable.Rows[i]["UserName"].ToString();
break;
}
}
CreditDGView.Rows[RowNumCredit].Cells["AmountCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["Amount"].ToString();
CreditDGView.Rows[RowNumCredit].Cells["OldAmountCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["OldVendorAccountAmount"].ToString();
CreditDGView.Rows[RowNumCredit].Cells["CommentsCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["Comments"].ToString();
if (aVendorPaymentTable.Rows[RowNumCredit]["IsChecked"].ToString() == "0")
{
CreditDGView.Rows[RowNumCredit].Cells["IsCheckedCredit"].Value = "NO";//aBillsDataTable.Rows[RowNum]["IsChecked"].ToString();
}
else
{
CreditDGView.Rows[RowNumCredit].Cells["IsCheckedCredit"].Value = "YES";
}
if (aVendorPaymentTable.Rows[RowNumCredit]["IsRevised"].ToString() == "0")
{
CreditDGView.Rows[RowNumCredit].Cells["IsRevisedCredit"].Value = "NO";//aBillsDataTable.Rows[RowNum]["IsRevised"].ToString();
}
else
{
CreditDGView.Rows[RowNumCredit].Cells["IsRevisedCredit"].Value = "YES";
}
CreditDGView.Rows[RowNumCredit].Cells["CheckDateCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["CheckDate"].ToString();
CreditDGView.Rows[RowNumCredit].Cells["CheckTimeCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["CheckTime"].ToString();
CreditDGView.Rows[RowNumCredit].Cells["CheckedByCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["CheckedBy"].ToString();
CreditDGView.Rows[RowNumCredit].Cells["ReviseDateCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["ReviseDate"].ToString();
CreditDGView.Rows[RowNumCredit].Cells["ReviseTimeCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["ReviseTime"].ToString();
CreditDGView.Rows[RowNumCredit].Cells["RevisedByCredit"].Value = aVendorPaymentTable.Rows[RowNumCredit]["RevisedBy"].ToString();
RowNumCredit++;
}
PageOfTotalTxtBoxCredit.Text = "1/" + pagesnumberCredit.ToString();
currentpageCredit = 1;
}
}
}
}
private void ListVouchersBtn_Click(object sender, EventArgs e)
{
try
{
int FilterVendorID = -1;
if (ByVendorNameChkBox.Checked && VendorsComboBox.SelectedValue != null)
{
FilterVendorID = int.Parse(VendorsComboBox.SelectedValue.ToString());//VendorsMgmt.SelectVendorIDByName(VendorNameTxtBox.Text);
// CustomerMgmt.SelectCustomerIDByPhone1(CustomerPhoneTxtBox.Text);
if (FilterVendorID == -1)
{
MessageBox.Show(MsgTxt.UnexpectedError + " " + MsgTxt.VendorTxt + " " + VendorsComboBox.Text + " " + MsgTxt.NotFoundTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
aVendorTable = VendorsMgmt.SelectAllVendors();
if (aVendorTable == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListVouchersBtn_Click:DB-ERROR aVendorTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
aCurrencyTable = CurrencyMgmt.SelectAll();
if (aCurrencyTable == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aCurrencyTable:DB-ERROR aCurrencyTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
aUsersTable = UsersMgmt.SelectAllUsers();
if (aUsersTable == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aUsersTable:DB-ERROR aUsersTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
aAccountsTable = AccountsMgmt.SelectAll();
if (aAccountsTable == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aAccountsTable:DB-ERROR aAccountsTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
aPaymentMethodTable = PaymentMethodMgmt.SelectAll();
if (aPaymentMethodTable == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aPaymentMethodTable:DB-ERROR aPaymentMethodTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//aVouchersTable = PurchaseVoucherGeneralMgmt.SelectAllVouchers();
int FilterTellerID = 0;
if (TellerNameChkBox.Checked && TellerNameComboBox.SelectedValue != null)
{
FilterTellerID = int.Parse(TellerNameComboBox.SelectedValue.ToString());
}
string FilterDateFrom = "";
string FilterDateTo = "";
if (DateCheckBox.Checked)
{
FilterDateFrom = DateFrompicker.Value.ToShortDateString();
FilterDateTo = DateToPicker.Value.ToShortDateString();
}
bool FilterChecked = CheckedChkBox.Checked;
bool FilterRevised = IsRevisedChkBox.Checked;
bool FilterUnChecked = UncheckedVouchersChkBox.Checked;
bool FilterUnRevised = UnRevisedChkBox.Checked;
aVouchersTable = PurchaseVoucherGeneralMgmt.SelectAllVouchers(FilterTellerID, FilterDateFrom, FilterDateTo, FilterChecked, FilterRevised, FilterUnChecked, FilterUnRevised, FilterVendorID, false);
if (aVouchersTable == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [aVouchersTable:DB-ERROR aVouchersTable=null] \n \n", MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
TotalITemsTxtBox.Text = aVouchersTable.Rows.Count.ToString();
ListVouchersDGView.Rows.Clear();
if (aVouchersTable.Rows.Count > 0)
{
RowNum = 0;
if (ListVouchersDGView.Rows.Count < ItemsPerPage)
{
//TestingFor Paging
pagesnumber = (int)aVouchersTable.Rows.Count / ItemsPerPage;
if ((double.Parse(aVouchersTable.Rows.Count.ToString()) / ItemsPerPage - int.Parse(aVouchersTable.Rows.Count.ToString()) / ItemsPerPage) > 0)
{
pagesnumber++;
}
foreach (DataRow r in aVouchersTable.Rows)
{
if (ListVouchersDGView.Rows.Count < ItemsPerPage)
{
ListVouchersDGView.Rows.Add();
ListVouchersDGView.Rows[RowNum].Cells["VoucherNumber"].Value = aVouchersTable.Rows[RowNum]["VoucherNumber"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["Date"].Value = aVouchersTable.Rows[RowNum]["Date"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["Time"].Value = aVouchersTable.Rows[RowNum]["Time"].ToString();
for (int i = 0; i < aVendorTable.Rows.Count; i++)
{
if (int.Parse(aVendorTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["VendorID"].ToString()))
{
ListVouchersDGView.Rows[RowNum].Cells["Vendor"].Value = aVendorTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString();
break;
}
}
ListVouchersDGView.Rows[RowNum].Cells["TotalFreeITemsQty"].Value = aVouchersTable.Rows[RowNum]["TotalFreeITemsQty"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["TotalTax"].Value = aVouchersTable.Rows[RowNum]["TotalTax"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["Subtotal"].Value = aVouchersTable.Rows[RowNum]["Subtotal"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["DiscountPerc"].Value = aVouchersTable.Rows[RowNum]["DiscountPerc"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["TotalItemsDiscount"].Value = aVouchersTable.Rows[RowNum]["TotalItemsDiscount"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["TotalDiscount"].Value = aVouchersTable.Rows[RowNum]["TotalDiscount"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["TotalCost"].Value = aVouchersTable.Rows[RowNum]["TotalCost"].ToString();
for (int i = 0; i < aPaymentMethodTable.Rows.Count; i++)
{
if (int.Parse(aPaymentMethodTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["PaymentMethodID"].ToString()))
{
ListVouchersDGView.Rows[RowNum].Cells["PaymentMethod"].Value = aPaymentMethodTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString();
break;
}
}
ListVouchersDGView.Rows[RowNum].Cells["Comments"].Value = aVouchersTable.Rows[RowNum]["Comments"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["CreditCardInfo"].Value = aVouchersTable.Rows[RowNum]["CreditCardInfo"].ToString();
for (int i = 0; i < aCurrencyTable.Rows.Count; i++)
{
if (int.Parse(aCurrencyTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["CurrencyID"].ToString()))
{
ListVouchersDGView.Rows[RowNum].Cells["Currency"].Value = aCurrencyTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString();
break;
}
}
for (int i = 0; i < aAccountsTable.Rows.Count; i++)
{
if (int.Parse(aAccountsTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["AccountID"].ToString()))
{
ListVouchersDGView.Rows[RowNum].Cells["Currency"].Value = aAccountsTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString();
break;
}
}
for (int i = 0; i < aUsersTable.Rows.Count; i++)
{
if (int.Parse(aUsersTable.Rows[i]["ID"].ToString()) == int.Parse(aVouchersTable.Rows[RowNum]["TellerID"].ToString()))
{
ListVouchersDGView.Rows[RowNum].Cells["Teller"].Value = aUsersTable.Rows[i]["Name"].ToString();//aBillTable.Rows[RowNum]["TellerID"].ToString();
break;
}
}
ListVouchersDGView.Rows[RowNum].Cells["CheckNumber"].Value = aVouchersTable.Rows[RowNum]["CheckNumber"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["IsCashCredit"].Value = aVouchersTable.Rows[RowNum]["IsCashCredit"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["VendorAccountAmountOld"].Value = aVouchersTable.Rows[RowNum]["VendorAccountAmountOld"].ToString();
if (aVouchersTable.Rows[RowNum]["IsChecked"].ToString() == "0")
{
ListVouchersDGView.Rows[RowNum].Cells["IsChecked"].Value = "NO";//aBillTable.Rows[RowNum]["IsChecked"].ToString();
}
else
{
ListVouchersDGView.Rows[RowNum].Cells["IsChecked"].Value = "YES";
}
ListVouchersDGView.Rows[RowNum].Cells["CheckedBy"].Value = aVouchersTable.Rows[RowNum]["CheckedBy"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["CheckDate"].Value = aVouchersTable.Rows[RowNum]["CheckDate"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["CheckTime"].Value = aVouchersTable.Rows[RowNum]["CheckTime"].ToString();
if (aVouchersTable.Rows[RowNum]["IsRevised"].ToString() == "0")
{
ListVouchersDGView.Rows[RowNum].Cells["IsRevised"].Value = "NO";//aBillTable.Rows[RowNum]["IsChecked"].ToString();
}
else
{
ListVouchersDGView.Rows[RowNum].Cells["IsRevised"].Value = "YES";
}
ListVouchersDGView.Rows[RowNum].Cells["RevisedBy"].Value = aVouchersTable.Rows[RowNum]["RevisedBy"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["ReviseDate"].Value = aVouchersTable.Rows[RowNum]["ReviseDate"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["ReviseTime"].Value = aVouchersTable.Rows[RowNum]["ReviseTime"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["ReviseLoss"].Value = aVouchersTable.Rows[RowNum]["ReviseLoss"].ToString();
ListVouchersDGView.Rows[RowNum].Cells["Fees"].Value = aVouchersTable.Rows[RowNum]["Fees"].ToString();
RowNum++;
}
}
PageOfTotalTxtBox.Text = "1/" + pagesnumber.ToString();
currentpage = 1;
}
}
}
catch (Exception ex)
{
MessageBox.Show(MsgTxt.UnexpectedError + "\n IN [ListVouchersBtn_Click] \n Exception: \n" + ex.ToString(), MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
throw;
}
}
private void Add1000PurchaseVoucherBtn_Click(object sender, EventArgs e)
{
Random randAmount = new Random();
int cnt = 1;
var Vendors = VendorsMgmt.SelectAllVendors();
int userId = int.Parse(UsersMgmt.SelectAllUsers().Rows[0]["ID"].ToString());
while (cnt++ < NumberOfPurchases)
{
try
{
PurchaseVoucherGeneral aPurchaseGeneral = new PurchaseVoucherGeneral();
aPurchaseGeneral.AccountID = 1;
aPurchaseGeneral.Comments = "";
aPurchaseGeneral.CurrencyID = 1;
aPurchaseGeneral.Date = DateTime.Now.Subtract(TimeSpan.FromDays(randAmount.Next(1, 2000))).ToShortDateString();
aPurchaseGeneral.DiscountPerc = 0;
aPurchaseGeneral.Fees = 10;
aPurchaseGeneral.IsCashCredit = 0;
aPurchaseGeneral.IsChecked = 0;
aPurchaseGeneral.IsRevised = 0;
aPurchaseGeneral.PaymentMethodID = 1;
aPurchaseGeneral.Subtotal = 100;
aPurchaseGeneral.TellerID = userId;
aPurchaseGeneral.Time = DateTime.Now.ToShortTimeString();
aPurchaseGeneral.TotalCost = 90;
aPurchaseGeneral.TotalDiscount = 0;
aPurchaseGeneral.TotalFreeItemsQty = 0;
aPurchaseGeneral.TotalItemsDiscount = 0;
aPurchaseGeneral.TotalTax = 10;
aPurchaseGeneral.VendorAccountAmountOld = 0;
aPurchaseGeneral.VendorID =
int.Parse(Vendors.Rows[(int)NumberOfPurchases % Vendors.Rows.Count]["ID"].ToString());
aPurchaseGeneral.VoucherNumber = PurchaseVoucherGeneralMgmt.NextVoucherNumber();
aPurchaseGeneral.CreditCardInfo = "";
int NumofDetailed = randAmount.Next(1, 20);
if (PurchaseVoucherGeneralMgmt.AddVoucher(aPurchaseGeneral))
{
while (NumofDetailed > 0)
{
PurchaseVoucherDetailed aPurchaseDetailed = new PurchaseVoucherDetailed();
string aBarcode = "Test Item " + randAmount.Next(1, (int)NumberOfItems).ToString();
DataTable aItemRow = ItemsMgmt.SelectItemByBarCode(aBarcode);
if (aItemRow.Rows.Count != 0)
{
aPurchaseDetailed.Purchase_Voucher_Detailed_ItemID =
int.Parse(aItemRow.Rows[0]["ID"].ToString());
aPurchaseDetailed.Purchase_Voucher_Detailed_VoucherNumber =
aPurchaseGeneral.VoucherNumber;
aPurchaseDetailed.Purchase_Voucher_Detailed_IsRevised = 0;
aPurchaseDetailed.Purchase_Voucher_Detailed_ItemCost =
double.Parse(aItemRow.Rows[0]["AvgUnitCost"].ToString());
aPurchaseDetailed.Purchase_Voucher_Detailed_OldAvaQty =
double.Parse(aItemRow.Rows[0]["Qty"].ToString());
aPurchaseDetailed.Purchase_Voucher_Detailed_Qty = NumofDetailed;
aPurchaseDetailed.Purchase_Voucher_Detailed_Discount = 0;
// = double.Parse(aItemRow.Rows[0]["SellPrice"].ToString());
aPurchaseDetailed.Purchase_Voucher_Detailed_FreeItemsQty = 0;
// aBillDetailed.Bill_Detailed_TotalPerUnit = aBillDetailed.Bill_Detailed_Qty * aBillDetailed.Bill_Detailed_SellPrice;
PurchaseVoucherDetailedMgmt.AddItem(aPurchaseDetailed);
}
NumofDetailed--;
}
}
if (cnt % 100 == 0)
{
label1.Text = $"Adding Purchase Order {cnt}/{NumberOfPurchases} ... ({(cnt / NumberOfPurchases) * 100 })%";
Application.DoEvents();
}
}
catch (Exception ex) { MessageBox.Show($"Error in {cnt} \n {ex}"); }
}
}
private void Add1000Sale_Click(object sender, EventArgs e)
{
int cnt = 1;
DateTime date = DateTime.Now;
var randAmount = new Random();
int userId = int.Parse(UsersMgmt.SelectAllUsers().Rows[0]["ID"].ToString());
while (cnt++ < NumberOfBills)
{
try
{
int numofDetailed = randAmount.Next(1, 20);
var aBillGeneral = new BillGeneral();
aBillGeneral.Bill_General_AccountID = 1;
aBillGeneral.Bill_General_CashIn = 100;
aBillGeneral.Bill_General_Currency = "JOD";
aBillGeneral.Bill_General_CurrencyID = 1;
aBillGeneral.Bill_General_CustomerID = 1;
aBillGeneral.Bill_General_Date = date.Subtract(TimeSpan.FromDays(randAmount.Next(1, 2000))).ToShortDateString();
aBillGeneral.Bill_General_DiscountPerc = 0;
aBillGeneral.Bill_General_IsCashCredit = 0;
aBillGeneral.Bill_General_NetAmount = 100;
aBillGeneral.Bill_General_Number = BillGeneralMgmt.NextBillNumber();
aBillGeneral.Bill_General_PaymentMethodID = 1;
aBillGeneral.Bill_General_PriceLevel = 1;
aBillGeneral.Bill_General_SalesDiscount = 0;
aBillGeneral.Bill_General_SubTotal = 100;
aBillGeneral.Bill_General_TellerID = userId;
aBillGeneral.Bill_General_Time =
DateTime.Now.ToShortTimeString();
aBillGeneral.Bill_General_TotalCost = randAmount.Next(50, 99);
aBillGeneral.Bill_General_TotalDiscount = 0;
aBillGeneral.Bill_General_TotalItems = numofDetailed;
aBillGeneral.Bill_General_TotalPrice = 100;
aBillGeneral.Bill_General_TotalTax = 16;
aBillGeneral.CustomerAccountAmountOld = 0;
aBillGeneral.Bill_General_Comments = "Test Sale";
aBillGeneral.Bill_General_CreditCardInfo = "NotCredit";
Random aRandom = new Random();
if (BillGeneralMgmt.InsertBill(aBillGeneral))
{
while (numofDetailed > 0)
{
BillDetailed aBillDetailed = new BillDetailed();
string aBarcode = "Test Item " + aRandom.Next(1, (int)NumberOfItems);
DataTable aItemRow = ItemsMgmt.SelectItemByBarCode(aBarcode);
if (aItemRow.Rows.Count != 0)
{
aBillDetailed.Bill_Detailed_ItemDescription = aItemRow.Rows[0]["Description"].ToString();
aBillDetailed.Bill_Detailed_ItemID = int.Parse(aItemRow.Rows[0]["ID"].ToString());
aBillDetailed.Bill_Detailed_Number = aBillGeneral.Bill_General_Number;
aBillDetailed.Bill_Detailed_OldAvaQty = double.Parse(aItemRow.Rows[0]["Qty"].ToString());
aBillDetailed.Bill_Detailed_OldAvgUnitCost =
double.Parse(aItemRow.Rows[0]["AvgUnitCost"].ToString());
aBillDetailed.Bill_Detailed_Qty = numofDetailed;
aBillDetailed.Bill_Detailed_SellPrice = double.Parse(aItemRow.Rows[0]["SellPrice"].ToString());
aBillDetailed.Bill_Detailed_TotalPerUnit = aBillDetailed.Bill_Detailed_Qty *
aBillDetailed.Bill_Detailed_SellPrice;
BillDetailedMgmt.InsertItem(aBillDetailed);
}
numofDetailed--;
}
}
if (cnt % 100 == 0)
{
label1.Text = $"Adding Bill {cnt}/{NumberOfBills} ... ({(cnt / NumberOfBills) * 100 })%";
Application.DoEvents();
}
}
catch (Exception ex)
{
MessageBox.Show($"Error in {cnt} \n {ex}");
}
}
}