protected void cmdContactSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
Data.Contacts clsContact = new Data.Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.Guarantors(new ContactColumns()
{
ContactName = true
}, CustomerCode_CreditCardNo: txtSearch.Text, SortField: "ContactName").DefaultView;
cboContact.DataBind();
clsContact.CommitAndDispose();
if (cboContact.Items.Count == 0)
{
cboContact.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
}
cboContact.SelectedIndex = 0;
cboContact_SelectedIndexChanged(null, null);
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadOptions()
{
Data.Contacts clsContact = new Data.Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.Guarantors(new ContactColumns()
{
ContactName = true
}, SortField: "ContactName").DefaultView;
cboContact.DataBind();
cboContact.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboContact.SelectedIndex = 0;
Data.CardType clsCardType = new CardType(clsContact.Connection, clsContact.Transaction);
cboCardType.DataTextField = "CardTypeCode";
cboCardType.DataValueField = "CardTypeID";
cboCardType.DataSource = clsCardType.ListAsDataTable(new CardTypeDetails()
{
CreditCardType = CreditCardTypes.Internal, CheckGuarantor = true, WithGuarantor = true
}).DefaultView;
cboCardType.DataBind();
cboCardType.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboCardType.SelectedIndex = 0;
clsContact.CommitAndDispose();
Int64 iGuarantorID = 0;
if (Request.QueryString["id"] != null)
{
try { iGuarantorID = Int64.TryParse(Common.Decrypt(Request.QueryString["id"].ToString(), Session.SessionID), out iGuarantorID) ? iGuarantorID : 0; }
catch { }
}
cboContact.ToolTip = iGuarantorID.ToString();
if (iGuarantorID == 0)
{
divGuarantorInfo.Visible = false;
}
else
{
cboContact.SelectedIndex = cboContact.Items.IndexOf(cboContact.Items.FindByValue(iGuarantorID.ToString()));
cboContact_SelectedIndexChanged(null, null);
}
}
private void LoadOptions()
{
Data.Contacts clsContact = new Data.Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.CustomersWithCredits(new ContactColumns()
{
ContactName = true
}, CheckCustomersGuarantor: true, WithGuarantorOnly: true, SortField: "ContactName").DefaultView;
cboContact.DataBind();
cboContact.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboContact.SelectedIndex = 0;
cboGuarantor.DataTextField = "ContactName";
cboGuarantor.DataValueField = "ContactID";
cboGuarantor.DataSource = clsContact.Guarantors(new ContactColumns()
{
ContactName = true
}, SortField: "ContactName").DefaultView;
cboGuarantor.DataBind();
cboGuarantor.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboGuarantor.SelectedIndex = 0;
clsContact.CommitAndDispose();
Int64 iContactID = 0;
if (Request.QueryString["id"] != null)
{
try { iContactID = Int64.TryParse(Common.Decrypt(Request.QueryString["id"].ToString(), Session.SessionID), out iContactID) ? iContactID : 0; }
catch { }
}
cboContact.ToolTip = iContactID.ToString();
if (iContactID == 0)
{
divContactInfo.Visible = false;
}
else
{
cboContact.SelectedIndex = cboContact.Items.IndexOf(cboContact.Items.FindByValue(iContactID.ToString()));
cboContact_SelectedIndexChanged(null, null);
}
}
protected void cmdContactSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
Data.Contacts clsContact = new Data.Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.Guarantors(new ContactColumns() { ContactName = true }, CustomerCode_CreditCardNo: txtSearch.Text, SortField: "ContactName").DefaultView;
cboContact.DataBind();
clsContact.CommitAndDispose();
if (cboContact.Items.Count == 0) cboContact.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboContact.SelectedIndex = 0;
cboContact_SelectedIndexChanged(null, null);
}
catch (Exception ex)
{
throw ex;
}
}
private void LoadOptions()
{
Data.Contacts clsContact = new Data.Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.CustomersWithCredits(new ContactColumns() { ContactName = true }, CheckCustomersGuarantor: true, WithGuarantorOnly: true, SortField: "ContactName").DefaultView;
cboContact.DataBind();
cboContact.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboContact.SelectedIndex = 0;
cboGuarantor.DataTextField = "ContactName";
cboGuarantor.DataValueField = "ContactID";
cboGuarantor.DataSource = clsContact.Guarantors(new ContactColumns() { ContactName = true }, SortField: "ContactName").DefaultView;
cboGuarantor.DataBind();
cboGuarantor.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboGuarantor.SelectedIndex = 0;
clsContact.CommitAndDispose();
Int64 iContactID = 0;
if (Request.QueryString["id"] != null)
{
try { iContactID = Int64.TryParse(Common.Decrypt(Request.QueryString["id"].ToString(), Session.SessionID), out iContactID) ? iContactID : 0; }
catch { }
}
cboContact.ToolTip = iContactID.ToString();
if (iContactID == 0)
{
divContactInfo.Visible = false;
}
else
{
cboContact.SelectedIndex = cboContact.Items.IndexOf(cboContact.Items.FindByValue(iContactID.ToString()));
cboContact_SelectedIndexChanged(null, null);
}
}
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()
{
Data.Contacts clsContact = new Data.Contacts();
cboContact.DataTextField = "ContactName";
cboContact.DataValueField = "ContactID";
cboContact.DataSource = clsContact.Guarantors(new ContactColumns() { ContactName = true }, SortField: "ContactName").DefaultView;
cboContact.DataBind();
cboContact.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboContact.SelectedIndex = 0;
Data.CardType clsCardType = new CardType(clsContact.Connection, clsContact.Transaction);
cboCardType.DataTextField = "CardTypeCode";
cboCardType.DataValueField = "CardTypeID";
cboCardType.DataSource = clsCardType.ListAsDataTable(new CardTypeDetails() { CreditCardType = CreditCardTypes.Internal, CheckGuarantor = true, WithGuarantor = true }).DefaultView;
cboCardType.DataBind();
cboCardType.Items.Insert(0, new ListItem(Constants.PLEASE_SELECT, Constants.ZERO_STRING));
cboCardType.SelectedIndex = 0;
clsContact.CommitAndDispose();
Int64 iGuarantorID = 0;
if (Request.QueryString["id"] != null)
{
try { iGuarantorID = Int64.TryParse(Common.Decrypt(Request.QueryString["id"].ToString(), Session.SessionID), out iGuarantorID) ? iGuarantorID : 0; }
catch { }
}
cboContact.ToolTip = iGuarantorID.ToString();
if (iGuarantorID == 0)
{
divGuarantorInfo.Visible = false;
}
else
{
cboContact.SelectedIndex = cboContact.Items.IndexOf(cboContact.Items.FindByValue(iGuarantorID.ToString()));
cboContact_SelectedIndexChanged(null, null);
}
}
