private void LoadOptions()
{
cboReportType.Items.Clear();
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION, ReportTypes.REPORT_SELECTION));
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.CREDITS_Purchases, ReportTypes.CREDITS_Purchases));
cboReportType.Items.Add(new ListItem(ReportTypes.CREDITS_Payments, ReportTypes.CREDITS_Payments));
cboReportType.Items.Add(new ListItem(ReportTypes.CREDITS_CreditorsLedgerSummary, ReportTypes.CREDITS_CreditorsLedgerSummary));
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.CustomerCreditSummarizedStatistics, ReportTypes.CustomerCreditSummarizedStatistics));
cboReportType.SelectedIndex = 0;
if (Request.QueryString["reporttype"] != null)
{
lblReportType.Text = Common.Decrypt(Request.QueryString["reporttype"].ToString(), Session.SessionID);
switch (lblReportType.Text.ToLower())
{
case "purchases": cboReportType.SelectedIndex = cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.CREDITS_Purchases)); break;
case "payments": cboReportType.SelectedIndex = cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.CREDITS_Payments)); break;
case "ledger": cboReportType.SelectedIndex = cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.CREDITS_CreditorsLedgerSummary)); break;
case "stat": cboReportType.SelectedIndex = cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.CustomerCreditSummarizedStatistics)); break;
default:
break;
}
}
Data.CardType clsCardType = new Data.CardType();
cboCreditType.Items.Clear();
cboCreditType.DataTextField = "CardTypeCode";
cboCreditType.DataValueField = "CardTypeID";
cboCreditType.DataSource = clsCardType.ListAsDataTable(new CardTypeDetails(CreditCardTypes.Internal, false)).DefaultView;
cboCreditType.DataBind();
cboCreditType.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboCreditType.SelectedIndex = cboCreditType.Items.Count >= 2 ? 1 : 0;
Branch clsBranch = new Branch(clsCardType.Connection, clsCardType.Transaction);
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable().DefaultView;
cboBranch.DataBind();
cboBranch.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboBranch.SelectedIndex = 0;
Billing clsBilling = new Billing(clsCardType.Connection, clsCardType.Transaction);
cboBillingDate.DataTextField = "BillingDate";
cboBillingDate.DataValueField = "BillingDate";
cboBillingDate.DataSource = clsBilling.ListBillingDateAsDataTable(CreditType.Individual, CreditCardTypeID: Int16.Parse(cboCreditType.SelectedItem.Value)).DefaultView;
cboBillingDate.DataBind();
cboBillingDate.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.C_DATE_MIN_VALUE_STRING));
cboBillingDate.SelectedIndex = cboBillingDate.Items.Count >= 2 ? 1 : 0;
clsCardType.CommitAndDispose();
txtTrxStartDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
txtTrxEndDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
cboReportType_SelectedIndexChanged(null, null);
}
private void cboCardType_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboCardType.Text == "No available cards to issue")
{
grpCardInfo.Visible = false;
}
else
{
Data.CardType clsCardType = new Data.CardType();
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(cboCardType.Text);
clsCardType.CommitAndDispose();
if (clsCardTypeDetails.CardTypeID == 0)
{
grpCardInfo.Visible = false;
CardTypeDetails = new Data.CardTypeDetails();
}
else
{
grpCardInfo.Visible = true;
grpCardInfo.Text = cboCardType.Text + " Information";
lblCardTypeCode.Text = clsCardTypeDetails.CardTypeCode;
lblFinanceCharge.Text = clsCardTypeDetails.CreditFinanceCharge.ToString("##0.#0");
lblPenaltyCharge.Text = clsCardTypeDetails.CreditLatePenaltyCharge.ToString("##0.#0");
lblMinimumPercentageDue.Text = clsCardTypeDetails.CreditMinimumPercentageDue.ToString("##0.#0");
lblMinimumAmountDue.Text = clsCardTypeDetails.CreditMinimumAmountDue.ToString("##0.#0");
lblFinanceCharge15th.Text = clsCardTypeDetails.CreditFinanceCharge15th.ToString("##0.#0");
lblPenaltyCharge15th.Text = clsCardTypeDetails.CreditLatePenaltyCharge15th.ToString("##0.#0");
lblMinimumPercentageDue15th.Text = clsCardTypeDetails.CreditMinimumPercentageDue15th.ToString("##0.#0");
lblMinimumAmountDue15th.Text = clsCardTypeDetails.CreditMinimumAmountDue15th.ToString("##0.#0");
chkWithGuarantor.Checked = clsCardTypeDetails.WithGuarantor;
CardTypeDetails = clsCardTypeDetails;
if (!clsCardTypeDetails.WithGuarantor)
{
groupBox1.Height = 248;
grpCardInfo.Height = 125; //this height should hide the 15th charges
//mclsGuarantor = new Data.ContactDetails();
}
else
{
groupBox1.Height = 300;
grpCardInfo.Height = 180;
}
}
}
}
private void LoadOptions()
{
cboCreditCardStatus.Items.Clear();
foreach (CreditCardStatus selection in Enum.GetValues(typeof(CreditCardStatus)))
{
cboCreditCardStatus.Items.Add(new ListItem(selection.ToString("G"), selection.ToString("d")));
}
cboCreditCardStatus.SelectedIndex = cboCreditCardStatus.Items.IndexOf(cboCreditCardStatus.Items.FindByValue(CreditCardStatus.All.ToString("d")));
Data.CardType clsCardType = new Data.CardType();
cboCreditType.Items.Clear();
cboCreditType.DataTextField = "CardTypeCode";
cboCreditType.DataValueField = "CardTypeID";
cboCreditType.DataSource = clsCardType.ListAsDataTable(new CardTypeDetails(CreditCardTypes.Internal, false)).DefaultView;
cboCreditType.DataBind();
clsCardType.CommitAndDispose();
cboCreditType.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboCreditType.SelectedIndex = 1;
}
private void InsertCreditCardPayment(Data.Payment pvtclsPayment, long pvtlngTransactionID, string pvtstrTransactionNo, decimal pvtdecAmount, Int16 pvtintCardTypeID, string pvtstrCardNo, string pvtstrCardHolder, string pvtstrValidityDates, string pvtstrRemarks)
{
Data.CardType clsCardType = new Data.CardType(pvtclsPayment.Connection, pvtclsPayment.Transaction);
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(pvtintCardTypeID);
Data.CreditCardPaymentDetails Details = new Data.CreditCardPaymentDetails();
Details.TransactionID = pvtlngTransactionID;
Details.TransactionNo = pvtstrTransactionNo;
Details.Amount = pvtdecAmount;
Details.CardTypeID = pvtintCardTypeID;
Details.CardNo = pvtstrCardNo;
Details.CardTypeCode = clsCardTypeDetails.CardTypeCode;
Details.CardTypeName = clsCardTypeDetails.CardTypeName;
Details.CardHolder = pvtstrCardHolder;
Details.ValidityDates = pvtstrValidityDates;
Details.Remarks = pvtstrRemarks;
pvtclsPayment.InsertCreditCardPayment(Details);
pvtclsPayment.UpdateCredit(mclsCustomerDetails.ContactID, pvtlngTransactionID, pvtstrTransactionNo, pvtdecAmount, pvtstrRemarks);
}
private void LoadOptions()
{
lblBalanceAmount.Text = mdecBalanceAmount.ToString("#,##0.#0");
txtAmount.Text = mdecBalanceAmount.ToString("#,##0.#0");
txtAmount.SelectAll();
lblCreditCard.Text = "Card Amount (" + CompanyDetails.Currency + "):";
cboCardType.Items.Clear();
Data.CardType clsCardType = new Data.CardType();
foreach (System.Data.DataRow dr in clsCardType.DataList("CardTypeID", SortOption.Ascending).Rows)
{
cboCardType.Items.Add(dr["CardTypeName"]);
}
clsCardType.CommitAndDispose();
if (cboCardType.Items.Count > 0)
{
cboCardType.SelectedIndex = 0;
}
}
private void LoadOptions()
{
cboCardType.Items.Clear();
Data.CardType clsCardType = new Data.CardType();
foreach (System.Data.DataRow dr in clsCardType.ListAsDataTable(new Data.CardTypeDetails(CreditCardTypes.Internal), "CardTypeName", SortOption.Ascending).Rows)
{
cboCardType.Items.Add(dr["CardTypeName"]);
}
clsCardType.CommitAndDispose();
if (cboCardType.Items.Count > 0)
{
cboCardType.SelectedIndex = 0;
}
else
{
cboCardType.Items.Add("No available cards to issue");
}
cboCardType_SelectedIndexChanged(null, null);
}
private void cboCardType_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboCardType.Text == "No available cards to issue")
{
grpCardInfo.Visible = false;
}
else
{
Data.CardType clsCardType = new Data.CardType();
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(cboCardType.Text);
clsCardType.CommitAndDispose();
if (clsCardTypeDetails.CardTypeID == 0)
{
grpCardInfo.Visible = false;
CardTypeDetails = new Data.CardTypeDetails();
}
else
{
grpCardInfo.Visible = true;
lblCardTypeCode.Text = clsCardTypeDetails.CardTypeCode;
lblFinanceCharge.Text = clsCardTypeDetails.CreditFinanceCharge.ToString("##0.#0");
lblPenaltyCharge.Text = clsCardTypeDetails.CreditLatePenaltyCharge.ToString("##0.#0");
lblMinimumPercentageDue.Text = clsCardTypeDetails.CreditMinimumPercentageDue.ToString("##0.#0");
lblMinimumAmountDue.Text = clsCardTypeDetails.CreditMinimumAmountDue.ToString("##0.#0");
chkWithGuarantor.Checked = clsCardTypeDetails.WithGuarantor;
CardTypeDetails = clsCardTypeDetails;
if (!clsCardTypeDetails.WithGuarantor)
{
mclsGuarantor = new Data.ContactDetails();
}
else
{
}
}
}
}
private void InsertCreditCardPayment(Data.Payment clsPayment, Int64 intTransactionID, string strTransactionNo, decimal decAmount, Int16 intCardTypeID, string strCardNo, string strCardHolder, string strValidityDates, string strRemarks)
{
Data.CardType clsCardType = new Data.CardType(clsPayment.Connection, clsPayment.Transaction);
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(intCardTypeID);
Data.CreditCardPaymentDetails Details = new Data.CreditCardPaymentDetails();
Details.BranchDetails = mclsTerminalDetails.BranchDetails;
Details.TerminalNo = mclsTerminalDetails.TerminalNo;
Details.TransactionID = intTransactionID;
Details.TransactionNo = strTransactionNo;
Details.Amount = decAmount;
Details.CardTypeID = intCardTypeID;
Details.CardNo = strCardNo;
Details.CardTypeCode = clsCardTypeDetails.CardTypeCode;
Details.CardTypeName = clsCardTypeDetails.CardTypeName;
Details.CardHolder = strCardHolder;
Details.ValidityDates = strValidityDates;
Details.Remarks = strRemarks;
new Data.CreditCardPayments(clsPayment.Connection, clsPayment.Transaction).Insert(Details);
clsPayment.UpdateCredit(mclsCustomerDetails.ContactID, intTransactionID, strTransactionNo, decAmount, strRemarks);
}
static void Main(string[] args)
{
WriteProcessToMonitor("Starting RetailPlus Credit Biller tool...");
// check if it's already running
if (System.Diagnostics.Process.GetProcessesByName(System.IO.Path.GetFileNameWithoutExtension(System.Reflection.Assembly.GetEntryAssembly().Location)).Count() > 1)
{
WriteProcessToMonitor(" already running. Press any key to continue...");
Console.ReadLine();
return;
}
WriteProcessToMonitor(" ok");
back:
try
{
WriteProcessToMonitor("Checking process start time...");
DateTime _CreditBillerProcessStartTime = DateTime.TryParse(DateTime.Now.ToString("yyyy-MM-dd") + " " + System.Configuration.ConfigurationManager.AppSettings["ProcessStartTime"].ToString(), out _CreditBillerProcessStartTime) ? _CreditBillerProcessStartTime : DateTime.MinValue;
if (DateTime.Now < _CreditBillerProcessStartTime)
{
WriteProcessToMonitor(" cannot process will process next day-starttime:" + _CreditBillerProcessStartTime.ToString("hh:mm tt"));
Wait();
goto back;
}
WriteProcessToMonitor("Checking process end time...");
DateTime _CreditBillerProcessEndTime = DateTime.TryParse(DateTime.Now.ToString("yyyy-MM-dd") + " " + System.Configuration.ConfigurationManager.AppSettings["ProcessEndTime"].ToString(), out _CreditBillerProcessEndTime) ? _CreditBillerProcessEndTime : DateTime.MinValue;
if (DateTime.Now > _CreditBillerProcessEndTime)
{
WriteProcessToMonitor(" cannot process will process next day-endtime:" + _CreditBillerProcessEndTime.ToString("hh:mm tt"));
Wait();
goto back;
}
WriteProcessToMonitor("Checking connections to server.");
if (IPAddress.IsOpen(AceSoft.RetailPlus.DBConnection.ServerIP(), DBConnection.DBPort()) == false)
{
WriteProcessToMonitor(" cannot connect to server please check.");
Wait();
goto exit;
}
WriteProcessToMonitor(" ok");
WriteProcessToMonitor("Checking connections to database.");
Data.Database clsDatabase = new Data.Database();
mConnection = clsDatabase.Connection; mTransaction = clsDatabase.Transaction;
try
{
bool boIsDBAlive = clsDatabase.IsAlive();
WriteProcessToMonitor(" connected to '" + clsDatabase.Connection.ConnectionString.Split(';')[0].ToString().Replace("Data Source=", "") + "'");
}
catch (Exception ex)
{
WriteProcessToMonitor(" ERROR connecting to database. Exception: " + ex.ToString());
clsDatabase.CommitAndDispose();
return;
}
WriteProcessToMonitor("Checking credit billings with guarantor to process...");
WriteProcessToMonitor(" done checking...");
Data.CardType clsCardType = new Data.CardType(mConnection, mTransaction);
mConnection = clsCardType.Connection; mTransaction = clsCardType.Transaction;
System.Data.DataTable dt = clsCardType.ListAsDataTable(new Data.CardTypeDetails() { CreditCardType = CreditCardTypes.Internal, CheckGuarantor = true, WithGuarantor = true });
clsCardType.CommitAndDispose();
clsDatabase.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
WriteProcessToMonitor("Processing " + dr["CardTypeName"].ToString() + "...");
ProcessCreditBillWG(dr["CardTypeName"].ToString());
}
WriteProcessToMonitor("Checking credit billings to process...");
WriteProcessToMonitor(" done checking...");
// processing of Internal WithOutGuarantor
clsCardType = new Data.CardType(mConnection, mTransaction);
mConnection = clsCardType.Connection; mTransaction = clsCardType.Transaction;
dt = clsCardType.ListAsDataTable(new Data.CardTypeDetails() { CreditCardType = CreditCardTypes.Internal, CheckGuarantor = true, WithGuarantor = false });
clsCardType.CommitAndDispose();
clsDatabase.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
WriteProcessToMonitor("Processing " + dr["CardTypeName"].ToString() + "...");
ProcessCreditBill(dr["CardTypeName"].ToString());
}
// redo this checking before processing creditbill with Guarantor
WriteProcessToMonitor("Checking process start time...");
if (DateTime.Now < _CreditBillerProcessStartTime)
{
WriteProcessToMonitor(" cannot process will process next day-starttime:" + _CreditBillerProcessStartTime.ToString("hh:mm tt"));
goto exit;
}
WriteProcessToMonitor("Checking process end time...");
if (DateTime.Now > _CreditBillerProcessEndTime)
{
WriteProcessToMonitor(" cannot process will process next day-endtime:" + _CreditBillerProcessEndTime.ToString("hh:mm tt"));
goto exit;
}
// end-redo this checking before processing creditbill with Guarantor
Wait();
goto back;
exit:
WriteProcessToMonitor("Sytem terminated.");
Console.ReadLine();
}
catch (Exception ex)
{
WriteProcessToMonitor("PLEASE CALL RETAILPLUS IMMEDIATELY... error:" + ex.ToString());
goto back;
}
}
private void LoadOptions()
{
cboCardType.Items.Clear();
Data.CardType clsCardType = new Data.CardType();
foreach (System.Data.DataRow dr in clsCardType.ListAsDataTable(new Data.CardTypeDetails(CreditCardTypes.Internal), "CardTypeName", SortOption.Ascending).Rows)
{
cboCardType.Items.Add(dr["CardTypeName"]);
}
clsCardType.CommitAndDispose();
if (cboCardType.Items.Count > 0)
cboCardType.SelectedIndex = 0;
else
cboCardType.Items.Add("No available cards to issue");
cboCardType_SelectedIndexChanged(null, null);
}
private void cboCardType_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboCardType.Text == "No available cards to issue")
grpCardInfo.Visible = false;
else
{
Data.CardType clsCardType = new Data.CardType();
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(cboCardType.Text);
clsCardType.CommitAndDispose();
if (clsCardTypeDetails.CardTypeID == 0)
{
grpCardInfo.Visible = false;
CardTypeDetails = new Data.CardTypeDetails();
}
else
{
grpCardInfo.Visible = true;
grpCardInfo.Text = cboCardType.Text + " Information";
lblCardTypeCode.Text = clsCardTypeDetails.CardTypeCode;
lblFinanceCharge.Text = clsCardTypeDetails.CreditFinanceCharge.ToString("##0.#0");
lblPenaltyCharge.Text = clsCardTypeDetails.CreditLatePenaltyCharge.ToString("##0.#0");
lblMinimumPercentageDue.Text = clsCardTypeDetails.CreditMinimumPercentageDue.ToString("##0.#0");
lblMinimumAmountDue.Text = clsCardTypeDetails.CreditMinimumAmountDue.ToString("##0.#0");
lblFinanceCharge15th.Text = clsCardTypeDetails.CreditFinanceCharge15th.ToString("##0.#0");
lblPenaltyCharge15th.Text = clsCardTypeDetails.CreditLatePenaltyCharge15th.ToString("##0.#0");
lblMinimumPercentageDue15th.Text = clsCardTypeDetails.CreditMinimumPercentageDue15th.ToString("##0.#0");
lblMinimumAmountDue15th.Text = clsCardTypeDetails.CreditMinimumAmountDue15th.ToString("##0.#0");
chkWithGuarantor.Checked = clsCardTypeDetails.WithGuarantor;
CardTypeDetails = clsCardTypeDetails;
if (!clsCardTypeDetails.WithGuarantor)
{
groupBox1.Height = 248;
grpCardInfo.Height = 125; //this height should hide the 15th charges
//mclsGuarantor = new Data.ContactDetails();
}
else
{
groupBox1.Height = 300;
grpCardInfo.Height = 180;
}
}
}
}
private void LoadOptions()
{
cboReportType.Items.Clear();
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION, ReportTypes.REPORT_SELECTION));
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.CREDITS_Purchases, ReportTypes.CREDITS_Purchases));
cboReportType.Items.Add(new ListItem(ReportTypes.CREDITS_Payments, ReportTypes.CREDITS_Payments));
cboReportType.Items.Add(new ListItem(ReportTypes.CREDITS_CreditorsLedgerSummary, ReportTypes.CREDITS_CreditorsLedgerSummary));
cboReportType.Items.Add(new ListItem(ReportTypes.REPORT_SELECTION_SEPARATOR, ReportTypes.REPORT_SELECTION_SEPARATOR));
cboReportType.Items.Add(new ListItem(ReportTypes.CustomerCreditSummarizedStatistics, ReportTypes.CustomerCreditSummarizedStatistics));
cboReportType.SelectedIndex = 0;
if (Request.QueryString["reporttype"] != null)
{
lblReportType.Text = Common.Decrypt(Request.QueryString["reporttype"].ToString(), Session.SessionID);
switch (lblReportType.Text.ToLower())
{
case "purchases": cboReportType.SelectedIndex = cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.CREDITS_Purchases)); break;
case "payments": cboReportType.SelectedIndex = cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.CREDITS_Payments)); break;
case "ledger": cboReportType.SelectedIndex = cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.CREDITS_CreditorsLedgerSummary)); break;
case "stat": cboReportType.SelectedIndex = cboReportType.Items.IndexOf(cboReportType.Items.FindByValue(ReportTypes.CustomerCreditSummarizedStatistics)); break;
default:
break;
}
}
Data.CardType clsCardType = new Data.CardType();
cboCreditType.Items.Clear();
cboCreditType.DataTextField = "CardTypeCode";
cboCreditType.DataValueField = "CardTypeID";
cboCreditType.DataSource = clsCardType.ListAsDataTable(new CardTypeDetails(CreditCardTypes.Internal, false)).DefaultView;
cboCreditType.DataBind();
cboCreditType.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboCreditType.SelectedIndex = cboCreditType.Items.Count >= 2 ? 1 : 0;
Branch clsBranch = new Branch(clsCardType.Connection, clsCardType.Transaction);
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable().DefaultView;
cboBranch.DataBind();
cboBranch.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboBranch.SelectedIndex = 0;
Billing clsBilling = new Billing(clsCardType.Connection, clsCardType.Transaction);
cboBillingDate.DataTextField = "BillingDate";
cboBillingDate.DataValueField = "BillingDate";
cboBillingDate.DataSource = clsBilling.ListBillingDateAsDataTable(CreditType.Individual, CreditCardTypeID: Int16.Parse(cboCreditType.SelectedItem.Value)).DefaultView;
cboBillingDate.DataBind();
cboBillingDate.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.C_DATE_MIN_VALUE_STRING));
cboBillingDate.SelectedIndex = cboBillingDate.Items.Count >= 2 ? 1 : 0;
clsCardType.CommitAndDispose();
txtTrxStartDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
txtTrxEndDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
cboReportType_SelectedIndexChanged(null, null);
}
private void LoadOptions()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
lblContactID.Text = iID.ToString();
ContactGroups clsContactGroup = new ContactGroups();
cboGroup.DataTextField = "ContactGroupName";
cboGroup.DataValueField = "ContactGroupID";
cboGroup.DataSource = clsContactGroup.ListAsDataTable(ContactGroupCategory.CUSTOMER).DefaultView;
cboGroup.DataBind();
cboGroup.SelectedIndex = cboGroup.Items.Count - 1;
Department clsDepartment = new Department(clsContactGroup.Connection, clsContactGroup.Transaction);
cboDepartment.DataTextField = "DepartmentName";
cboDepartment.DataValueField = "DepartmentID";
cboDepartment.DataSource = clsDepartment.ListAsDataTable().DefaultView;
cboDepartment.DataBind();
cboDepartment.SelectedIndex = 0;
Positions clsPosition = new Positions(clsContactGroup.Connection, clsContactGroup.Transaction);
cboPosition.DataTextField = "PositionName";
cboPosition.DataValueField = "PositionID";
cboPosition.DataSource = clsPosition.ListAsDataTable("PositionName", SortOption.Ascending, 0).DefaultView;
cboPosition.DataBind();
cboPosition.SelectedIndex = 0;
cboCreditCardStatus.Items.Clear();
foreach (CreditCardStatus selection in Enum.GetValues(typeof(CreditCardStatus)))
{
cboCreditCardStatus.Items.Add(new ListItem(selection.ToString("G"), selection.ToString("d")));
}
cboCreditCardStatus.SelectedIndex = cboCreditCardStatus.Items.IndexOf(cboCreditCardStatus.Items.FindByValue(CreditCardStatus.All.ToString("d")));
Data.CardType clsCardType = new Data.CardType(clsContactGroup.Connection, clsContactGroup.Transaction);
cboCreditCardType.Items.Clear();
cboCreditCardType.DataTextField = "CardTypeName";
cboCreditCardType.DataValueField = "CardTypeID";
cboCreditCardType.DataSource = clsCardType.ListAsDataTable(new CardTypeDetails(CreditCardTypes.Internal)).DefaultView;
cboCreditCardType.DataBind();
cboCreditCardType.SelectedIndex = 0;
Billing clsBilling = new Billing(clsContactGroup.Connection, clsContactGroup.Transaction);
cboBillingDate.DataTextField = "BillingDate";
cboBillingDate.DataValueField = "BillingFile";
cboBillingDate.DataSource = clsBilling.ListBillingDateAsDataTable(CreditType.Group, long.Parse(lblContactID.Text), limit: 10).DefaultView;
cboBillingDate.DataBind();
cboBillingDate.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.PLEASE_SELECT));
cboBillingDate.SelectedIndex = 0;
Salutation clsSalutation = new Salutation(clsContactGroup.Connection, clsContactGroup.Transaction);
cboSalutation.DataTextField = "SalutationName";
cboSalutation.DataValueField = "SalutationCode";
cboSalutation.DataSource = clsSalutation.ListAsDataTable().DefaultView;
cboSalutation.DataBind();
cboSalutation.SelectedIndex = 0;
cboSalutation.SelectedIndex = cboSalutation.Items.IndexOf(cboSalutation.Items.FindByValue("MR"));
clsContactGroup.CommitAndDispose();
if (Request.QueryString["showbills"] != null)
{
if (!bool.Parse(Common.Decrypt(Request.QueryString["showbills"].ToString(), Session.SessionID)))
{
lblBillingSeparator.Visible = false;
labelBilling.Visible = false;
cboBillingDate.Visible = false;
imgPrintBilling.Visible = false;
cmdPrintBilling.Visible = false;
}
}
}
private void cboCardType_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboCardType.Text == "No available cards to issue")
grpCardInfo.Visible = false;
else
{
Data.CardType clsCardType = new Data.CardType();
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(cboCardType.Text);
clsCardType.CommitAndDispose();
if (clsCardTypeDetails.CardTypeID == 0)
{
grpCardInfo.Visible = false;
CardTypeDetails = new Data.CardTypeDetails();
}
else
{
grpCardInfo.Visible = true;
lblCardTypeCode.Text = clsCardTypeDetails.CardTypeCode;
lblFinanceCharge.Text = clsCardTypeDetails.CreditFinanceCharge.ToString("##0.#0");
lblPenaltyCharge.Text = clsCardTypeDetails.CreditLatePenaltyCharge.ToString("##0.#0");
lblMinimumPercentageDue.Text = clsCardTypeDetails.CreditMinimumPercentageDue.ToString("##0.#0");
lblMinimumAmountDue.Text = clsCardTypeDetails.CreditMinimumAmountDue.ToString("##0.#0");
chkWithGuarantor.Checked = clsCardTypeDetails.WithGuarantor;
CardTypeDetails = clsCardTypeDetails;
if (!clsCardTypeDetails.WithGuarantor)
{
mclsGuarantor = new Data.ContactDetails();
}
else
{
}
}
}
}
private bool isValuesAssigned()
{
decimal mdecAmount = 0;
try
{
mdecAmount = Convert.ToDecimal(txtAmount.Text);
}
catch
{
txtAmount.Focus();
MessageBox.Show("Sorry you have entered an invalid amount for credit card payment." +
"Please type a valid credit amount.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
if (txtCardNo.Text == null || txtCardNo.Text == "")
{
txtCardNo.Focus();
MessageBox.Show("Please type a valid Card No.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
if (txtCardHolder.Text == null || txtCardHolder.Text == "")
{
txtCardHolder.Focus();
MessageBox.Show("Please type a valid Card Holder.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
DateTime ValidityDate = DateTime.MinValue;
if (txtValidityDates.Text == null || txtValidityDates.Text == "")
{
txtValidityDates.Focus();
MessageBox.Show("Please type a valid Validity Date.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
else if (txtValidityDates.Text != null && txtValidityDates.Text != "")
{
try
{
string Month = txtValidityDates.Text.Substring(0, 2);
string Year = "20" + txtValidityDates.Text.Substring(2, 2);
string Day = DateTime.DaysInMonth(Convert.ToInt32(Year), Convert.ToInt32(Month)).ToString();
ValidityDate = new DateTime(int.Parse(Year), int.Parse(Month), int.Parse(Day));
}
catch
{
txtValidityDates.Focus();
MessageBox.Show("Please type a valid Validity Date. Format must be mmyy", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
if (ValidityDate < DateTime.Now)
{
txtValidityDates.Focus();
MessageBox.Show("Card has been expired, please ask for a valid credit card.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
Data.CardType clsCardType = new Data.CardType();
Data.CardTypeDetails cardtypedetails = clsCardType.Details(cboCardType.Text);
clsCardType.CommitAndDispose();
mDetails.BranchDetails = mclsTerminalDetails.BranchDetails;
mDetails.TerminalNo = mclsTerminalDetails.TerminalNo;
mDetails.TransactionID = mclsSalesTransactionDetails.TransactionID;
mDetails.TransactionNo = mclsSalesTransactionDetails.TransactionNo;
mDetails.Amount = mdecAmount;
mDetails.CardTypeID = cardtypedetails.CardTypeID;
mDetails.CardTypeCode = cardtypedetails.CardTypeCode;
mDetails.CardTypeName = cardtypedetails.CardTypeName;
mDetails.CardNo = txtCardNo.Text;
mDetails.CardHolder = txtCardHolder.Text;
mDetails.ValidityDates = ValidityDate.ToString("MMddyy");
mDetails.Remarks = txtRemarks.Text;
return(true);
}
private bool isValuesAssigned()
{
decimal mdecAmount = 0;
try
{
mdecAmount = Convert.ToDecimal(txtAmount.Text);
}
catch
{
txtAmount.Focus();
MessageBox.Show("Sorry you have entered an invalid amount for credit card payment." +
"Please type a valid credit amount.","RetailPlus",MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
if (txtCardNo.Text == null || txtCardNo.Text == "")
{
txtCardNo.Focus();
MessageBox.Show("Please type a valid Card No.","RetailPlus",MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
if (txtCardHolder.Text == null || txtCardHolder.Text == "")
{
txtCardHolder.Focus();
MessageBox.Show("Please type a valid Card Holder.","RetailPlus",MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
DateTime ValidityDate = DateTime.MinValue;
if (txtValidityDates.Text == null || txtValidityDates.Text == "")
{
txtValidityDates.Focus();
MessageBox.Show("Please type a valid Validity Date.","RetailPlus",MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
else if (txtValidityDates.Text != null && txtValidityDates.Text != "")
{
try
{
string Month = txtValidityDates.Text.Substring(0,2);
string Year = txtValidityDates.Text.Substring(2,2);
string Day = DateTime.DaysInMonth(Convert.ToInt32(Year), Convert.ToInt32(Month)).ToString();
ValidityDate = Convert.ToDateTime(Month + "/" + Day + "/" + Year);
}
catch
{
txtValidityDates.Focus();
MessageBox.Show("Please type a valid Validity Date. Format must be mmddyy","RetailPlus",MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
if (ValidityDate < DateTime.Now)
{
txtValidityDates.Focus();
MessageBox.Show("Card has been expired, please ask for a valid credit card.","RetailPlus",MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
}
Data.CardType clsCardType = new Data.CardType();
Data.CardTypeDetails cardtypedetails = clsCardType.Details(cboCardType.Text);
clsCardType.CommitAndDispose();
mDetails.TransactionID = mclsSalesTransactionDetails.TransactionID;
mDetails.TransactionNo = mclsSalesTransactionDetails.TransactionNo;
mDetails.Amount = mdecAmount;
mDetails.CardTypeID = cardtypedetails.CardTypeID;
mDetails.CardTypeCode = cardtypedetails.CardTypeCode;
mDetails.CardTypeName = cardtypedetails.CardTypeName;
mDetails.CardNo = txtCardNo.Text;
mDetails.CardHolder = txtCardHolder.Text;
mDetails.ValidityDates = ValidityDate.ToString("MMddyy");
mDetails.Remarks = txtRemarks.Text;
return true;
}
private void LoadOptions()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
lblContactID.Text = iID.ToString();
ContactGroups clsContactGroup = new ContactGroups();
cboGroup.DataTextField = "ContactGroupName";
cboGroup.DataValueField = "ContactGroupID";
cboGroup.DataSource = clsContactGroup.ListAsDataTable().DefaultView;
cboGroup.DataBind();
cboGroup.SelectedIndex = cboGroup.Items.Count - 1;
Department clsDepartment = new Department(clsContactGroup.Connection, clsContactGroup.Transaction);
cboDepartment.DataTextField = "DepartmentName";
cboDepartment.DataValueField = "DepartmentID";
cboDepartment.DataSource = clsDepartment.ListAsDataTable().DefaultView;
cboDepartment.DataBind();
cboDepartment.SelectedIndex = 0;
Positions clsPosition = new Positions(clsContactGroup.Connection, clsContactGroup.Transaction);
cboPosition.DataTextField = "PositionName";
cboPosition.DataValueField = "PositionID";
cboPosition.DataSource = clsPosition.ListAsDataTable("PositionName", SortOption.Ascending, 0).DefaultView;
cboPosition.DataBind();
cboPosition.SelectedIndex = 0;
cboCreditCardStatus.Items.Clear();
foreach (CreditCardStatus selection in Enum.GetValues(typeof(CreditCardStatus)))
{
cboCreditCardStatus.Items.Add(new ListItem(selection.ToString("G"), selection.ToString("d")));
}
cboCreditCardStatus.SelectedIndex = cboCreditCardStatus.Items.IndexOf(cboCreditCardStatus.Items.FindByValue(CreditCardStatus.All.ToString("d")));
Data.CardType clsCardType = new Data.CardType(clsContactGroup.Connection, clsContactGroup.Transaction);
cboCreditCardType.Items.Clear();
cboCreditCardType.DataTextField = "CardTypeName";
cboCreditCardType.DataValueField = "CardTypeID";
cboCreditCardType.DataSource = clsCardType.ListAsDataTable(new CardTypeDetails(CreditCardTypes.Internal)).DefaultView;
cboCreditCardType.DataBind();
cboCreditCardType.SelectedIndex = 0;
Billing clsBilling = new Billing(clsContactGroup.Connection, clsContactGroup.Transaction);
cboBillingDate.DataTextField = "BillingDate";
cboBillingDate.DataValueField = "BillingFile";
cboBillingDate.DataSource = clsBilling.ListBillingDateAsDataTable(CreditType.Individual, long.Parse(lblContactID.Text), limit: 10).DefaultView;
cboBillingDate.DataBind();
cboBillingDate.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.PLEASE_SELECT));
cboBillingDate.SelectedIndex = 0;
Salutation clsSalutation = new Salutation(clsContactGroup.Connection, clsContactGroup.Transaction);
cboSalutation.DataTextField = "SalutationName";
cboSalutation.DataValueField = "SalutationCode";
cboSalutation.DataSource = clsSalutation.ListAsDataTable().DefaultView;
cboSalutation.DataBind();
cboSalutation.SelectedIndex = 0;
cboSalutation.SelectedIndex = cboSalutation.Items.IndexOf(cboSalutation.Items.FindByValue("MR"));
clsContactGroup.CommitAndDispose();
}
private static void ProcessCreditBillWG(string CardTypeName)
{
Event clsEvent = new Event();
clsEvent.AddEventLn("");
Console.WriteLine(ConsoleMonitor() + "");
LocalDB clsLocalDB = new LocalDB();
clsLocalDB.GetConnection(ConnectionTimeOut: 100000);
mConnection = clsLocalDB.Connection; mTransaction = clsLocalDB.Transaction;
Data.Billing clsBilling = new Data.Billing(mConnection, mTransaction);
mConnection = clsBilling.Connection; mTransaction = clsBilling.Transaction;
Data.Contacts clsContacts = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction;
Data.SysConfig clsSysConfig = new Data.SysConfig(mConnection, mTransaction);
mConnection = clsSysConfig.Connection; mTransaction = clsSysConfig.Transaction;
bool boWillProcessCreditBillerInProgram = clsSysConfig.get_WillProcessCreditBillerInProgram();
Data.CardType clsCardType = new Data.CardType(mConnection, mTransaction);
mConnection = clsCardType.Connection; mTransaction = clsCardType.Transaction;
Data.CardTypeDetails clsCreditCardTypeInfo = clsCardType.Details(CardTypeName);
// check billingdate
Data.ContactColumns clsContactColumns = new Data.ContactColumns() { ContactID = true, ContactCode = true, ContactName = true, CreditDetails = true };
Data.ContactColumns clsSearchColumns = new Data.ContactColumns() { ContactCode = true, ContactName = true };
System.Data.DataTable dtGuarantors;
try
{
if (clsCreditCardTypeInfo.BillingDate == Constants.C_DATE_MIN_VALUE)
{
clsLocalDB.CommitAndDispose();
WriteProcessToMonitor("Will not process group credit bill. There is no BillingDate set in the database. Please contact your System Administrator.");
return;
}
else if (clsCreditCardTypeInfo.BillingDate >= DateTime.Now)
{
WriteProcessToMonitor("Will not process group credit bill. Next processing date must be after BillingDate: [" + clsCreditCardTypeInfo.BillingDate.ToString("dd-MMM-yyyy") + "]. System will only process after billing date.");
WriteProcessToMonitor("Printing unprinted OR's instead. ");
clsContacts = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction;
foreach (Data.CardTypeDetails clsCardTypeDetails in clsBilling.ListUnPrintedCreditCardTypes(CreditType.Group))
{
dtGuarantors = clsContacts.Guarantors(clsContactColumns, CreditCardTypeID: clsCardTypeDetails.CardTypeID);
PrintORsWG(dtGuarantors, clsCardTypeDetails);
}
clsLocalDB.CommitAndDispose();
return;
}
// Check PurchaseEndDate if lower than today then do not execute.
if (clsCreditCardTypeInfo.CreditPurcEndDateToProcess >= DateTime.Now)
{
WriteProcessToMonitor("Will not process group credit bill. CreditPurcEndDateToProcess: " + clsCreditCardTypeInfo.CreditPurcEndDateToProcess.ToString("dd-MMM-yyyy") + " should be lower than current date.");
WriteProcessToMonitor("Printing unprinted OR's instead. ");
clsContacts = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction;
foreach (Data.CardTypeDetails clsCardTypeDetails in clsBilling.ListUnPrintedCreditCardTypes(CreditType.Group))
{
dtGuarantors = clsContacts.Guarantors(clsContactColumns, CreditCardTypeID: clsCardTypeDetails.CardTypeID);
PrintORsWG(dtGuarantors, clsCardTypeDetails);
}
clsLocalDB.CommitAndDispose();
return;
}
// 19Feb2015 : ByPass execution, put in the event instead. Just put the printing here.
if (boWillProcessCreditBillerInProgram)
{
WriteProcessToMonitor("Processing group credit bill for BillingDate: [" + clsCreditCardTypeInfo.BillingDate.ToString("dd-MMM-yyyy") + "]. ");
clsBilling.ProcessCurrentBill(CreditType.Group, clsCreditCardTypeInfo.CardTypeCode);
// print SOA first before closing the billing date to make sure all are printed
clsContacts = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction;
dtGuarantors = clsContacts.Guarantors(clsContactColumns, CreditCardTypeID: clsCreditCardTypeInfo.CardTypeID);
clsBilling.CommitAndDispose();
PrintORsWG(dtGuarantors, clsCreditCardTypeInfo);
WriteProcessToMonitor("Closing group current billing date...");
clsBilling = new Data.Billing(mConnection, mTransaction);
mConnection = clsBilling.Connection; mTransaction = clsBilling.Transaction;
clsBilling.CloseCurrentBill(CreditType.Group, clsCreditCardTypeInfo.CardTypeCode);
WriteProcessToMonitor("Done.");
}
else
{
WriteProcessToMonitor("Will not process group credit bill. WillProcessCreditBillerInProgram : false");
WriteProcessToMonitor("Done.");
}
}
catch (Exception ex)
{
WriteProcessToMonitor("PLEASE CALL RETAILPLUS IMMEDIATELY... PROCESS-CreditBillWithGuarantor error:" + Environment.NewLine + ex.ToString());
clsLocalDB.ThrowException(ex);
}
finally
{
clsLocalDB.CommitAndDispose();
}
}
private void LoadOptions()
{
lblBalanceAmount.Text = mdecBalanceAmount.ToString("#,##0.#0");
txtAmount.Text = mdecBalanceAmount.ToString("#,##0.#0");
txtAmount.SelectAll();
lblCreditCard.Text = "Card Amount (" + CompanyDetails.Currency + "):";
cboCardType.Items.Clear();
Data.CardType clsCardType = new Data.CardType();
foreach (System.Data.DataRow dr in clsCardType.DataList("CardTypeID", SortOption.Ascending).Rows)
{
cboCardType.Items.Add(dr["CardTypeName"]);
}
clsCardType.CommitAndDispose();
if (cboCardType.Items.Count > 0)
cboCardType.SelectedIndex = 0;
}
private void InsertCreditCardPayment(Data.Payment clsPayment, Int64 intTransactionID, string strTransactionNo, decimal decAmount, Int16 intCardTypeID, string strCardNo, string strCardHolder, string strValidityDates, string strRemarks)
{
Data.CardType clsCardType = new Data.CardType(clsPayment.Connection, clsPayment.Transaction);
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(intCardTypeID);
Data.CreditCardPaymentDetails Details = new Data.CreditCardPaymentDetails();
Details.BranchDetails = mclsTerminalDetails.BranchDetails;
Details.TerminalNo = mclsTerminalDetails.TerminalNo;
Details.TransactionID = intTransactionID;
Details.TransactionNo = strTransactionNo;
Details.Amount = decAmount;
Details.CardTypeID = intCardTypeID;
Details.CardNo = strCardNo;
Details.CardTypeCode = clsCardTypeDetails.CardTypeCode;
Details.CardTypeName = clsCardTypeDetails.CardTypeName;
Details.CardHolder = strCardHolder;
Details.ValidityDates = strValidityDates;
Details.Remarks = strRemarks;
new Data.CreditCardPayments(clsPayment.Connection, clsPayment.Transaction).Insert(Details);
clsPayment.UpdateCredit(mclsCustomerDetails.ContactID, intTransactionID, strTransactionNo, decAmount, strRemarks);
}
private void InsertCreditCardPayment(Data.Payment pvtclsPayment, long pvtlngTransactionID, string pvtstrTransactionNo, decimal pvtdecAmount, Int16 pvtintCardTypeID, string pvtstrCardNo, string pvtstrCardHolder, string pvtstrValidityDates, string pvtstrRemarks)
{
Data.CardType clsCardType = new Data.CardType(pvtclsPayment.Connection, pvtclsPayment.Transaction);
Data.CardTypeDetails clsCardTypeDetails = clsCardType.Details(pvtintCardTypeID);
Data.CreditCardPaymentDetails Details = new Data.CreditCardPaymentDetails();
Details.TransactionID = pvtlngTransactionID;
Details.TransactionNo = pvtstrTransactionNo;
Details.Amount = pvtdecAmount;
Details.CardTypeID = pvtintCardTypeID;
Details.CardNo = pvtstrCardNo;
Details.CardTypeCode = clsCardTypeDetails.CardTypeCode;
Details.CardTypeName = clsCardTypeDetails.CardTypeName;
Details.CardHolder = pvtstrCardHolder;
Details.ValidityDates = pvtstrValidityDates;
Details.Remarks = pvtstrRemarks;
pvtclsPayment.InsertCreditCardPayment(Details);
pvtclsPayment.UpdateCredit(mclsCustomerDetails.ContactID, pvtlngTransactionID, pvtstrTransactionNo, pvtdecAmount, pvtstrRemarks);
}
private void LoadOptions()
{
lblBalanceAmount.Text = mdecBalanceAmount.ToString("#,##0.#0");
txtAmount.Text = mdecBalanceAmount.ToString("#,##0.#0");
txtAmount.SelectAll();
lblCreditCard.Text = "Card Amount (" + CompanyDetails.Currency + "):";
cboCardType.Items.Clear();
Data.CardType clsCardType = new Data.CardType();
foreach (System.Data.DataRow dr in clsCardType.ListAsDataTable(new Data.CardTypeDetails(CreditCardTypes.Both), "CardTypeName", SortOption.Ascending).Rows)
{
cboCardType.Items.Add(dr["CardTypeName"]);
}
clsCardType.CommitAndDispose();
if (cboCardType.Items.Count > 0) cboCardType.SelectedIndex = 0;
if (!string.IsNullOrEmpty(mclsCreditorDetails.CreditDetails.CreditCardNo)
&& mclsCreditorDetails.IsCreditAllowed)
{
txtScan.Text = mclsCreditorDetails.CreditDetails.CreditCardNo;
//txtScan_TextChanged(null, null);
}
else
{
txtScan.Text = "put the cursor here to scan credit card";
}
txtAmount.Focus();
}
private void cboCardType_SelectedIndexChanged(object sender, EventArgs e)
{
Data.CardType clsCardType = new Data.CardType();
mclsCardTypeDetails = clsCardType.Details(cboCardType.Text);
clsCardType.CommitAndDispose();
}
private void LoadOptions()
{
cboCreditCardStatus.Items.Clear();
foreach (CreditCardStatus selection in Enum.GetValues(typeof(CreditCardStatus)))
{
cboCreditCardStatus.Items.Add(new ListItem(selection.ToString("G"), selection.ToString("d")));
}
cboCreditCardStatus.SelectedIndex = cboCreditCardStatus.Items.IndexOf(cboCreditCardStatus.Items.FindByValue(CreditCardStatus.All.ToString("d")));
Data.CardType clsCardType = new Data.CardType();
cboCreditType.Items.Clear();
cboCreditType.DataTextField = "CardTypeCode";
cboCreditType.DataValueField = "CardTypeID";
cboCreditType.DataSource = clsCardType.ListAsDataTable(new CardTypeDetails(CreditCardTypes.Internal, true)).DefaultView;
cboCreditType.DataBind();
clsCardType.CommitAndDispose();
cboCreditType.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboCreditType.SelectedIndex = 1;
}
