private void LoadContact()
{
Data.ContactColumns clsContactColumns = new Data.ContactColumns();
clsContactColumns.ContactName = true;
Data.ContactColumns clsSearchColumns = new Data.ContactColumns();
clsContactColumns.ContactName = true;
clsContactColumns.ContactCode = true;
Data.Contacts clsContact = new Data.Contacts();
cboSupplier.DataTextField = Data.ContactColumnNames.ContactName;
cboSupplier.DataValueField = Data.ContactColumnNames.ContactID;
cboSupplier.DataSource = clsContact.Suppliers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsSearchColumns, txtSupplier.Text, 100, false, Data.ContactColumnNames.ContactName, System.Data.SqlClient.SortOrder.Ascending).DefaultView;
cboSupplier.DataBind();
clsContact.CommitAndDispose();
cboSupplier.Items.Add(new ListItem("All Suppliers", "0"));
cboSupplier.SelectedIndex = cboSupplier.Items.Count - 1;
}
private void LoadContact()
{
Data.ContactColumns clsContactColumns = new Data.ContactColumns();
clsContactColumns.ContactName = true;
Data.ContactColumns clsSearchColumns = new Data.ContactColumns();
clsContactColumns.ContactName = true;
clsContactColumns.ContactCode = true;
Data.Contacts clsContact = new Data.Contacts();
cboSupplier.DataTextField = Data.ContactColumnNames.ContactName;
cboSupplier.DataValueField = Data.ContactColumnNames.ContactID;
cboSupplier.DataSource = clsContact.Suppliers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsSearchColumns, txtSupplier.Text, 100, false, Data.ContactColumnNames.ContactName, System.Data.SqlClient.SortOrder.Ascending).DefaultView;
cboSupplier.DataBind();
clsContact.CommitAndDispose();
cboSupplier.Items.Add(new ListItem("All Suppliers", "0"));
cboSupplier.SelectedIndex = cboSupplier.Items.Count - 1;
}
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();
}
}
