private void LoadData()
{
grpContactDetails.Visible = true;
grpBillingDetails.Visible = true;
txtCustomerName.Text = CreditorDetails.ContactName;
txtCreditLimit.Text = CreditorDetails.CreditLimit.ToString("#,##0.#0");
txtCredit.Text = CreditorDetails.Credit.ToString("#,##0.#0");
txtAvailableCredit.Text = (CreditorDetails.CreditLimit - CreditorDetails.Credit).ToString("#,##0.#0");
Data.Billing clsBilling = new Data.Billing();
Data.BillingDetails clsBillingDetails = clsBilling.Details(CreditorDetails.ContactID, CreditorDetails.CreditDetails.Last2BillingDate);
Data.BillingDetails clsCurrBillingDetails = clsBilling.Details(CreditorDetails.ContactID, CreditorDetails.CreditDetails.LastBillingDate);
clsBilling.CommitAndDispose();
grpBillingDetails.Tag = "0";
if (clsBillingDetails.BillingDate == CreditorDetails.CreditDetails.Last2BillingDate)
{
grpBillingDetails.Tag = clsBillingDetails.CreditBillHeaderID;
txtBeginningBalance.Text = clsBillingDetails.BeginningBalance.ToString("#,##0.#0");
txtCurrentDue.Text = clsBillingDetails.Prev1MoCurrentDueAmount.ToString("#,##0.#0");
txtPayments.Text = clsBillingDetails.CurrMonthAmountPaid.ToString("#,##0.#0");
//if (clsBillingDetails.Prev1MoCurrentDueAmount <= 0)
//else
// txtPayments.Text = "-" + clsBillingDetails.CurrMonthAmountPaid.ToString("#,##0.#0");
txtBalance.Text = clsBillingDetails.RunningCreditAmt.ToString("#,##0.#0");
txtPenalty.Text = clsBillingDetails.TotalBillCharges.ToString("#,##0.#0");
txtPurchases.Text = clsBillingDetails.CurrentPurchaseAmt.ToString("#,##0.#0");
txtAmountDue.Text = clsBillingDetails.CurrMonthCreditAmt.ToString("#,##0.#0");
txtTotalAmountDue.Text = clsBillingDetails.CurrentDueAmount.ToString("#,##0.#0");
txtEndingBalance.Text = clsBillingDetails.EndingBalance.ToString("#,##0.#0");
grpBillingDetails.Visible = true;
}
else { grpBillingDetails.Visible = false; }
grpCurrBilling.Tag = "0";
if (clsCurrBillingDetails.BillingDate == CreditorDetails.CreditDetails.LastBillingDate)
{
grpCurrBilling.Tag = clsCurrBillingDetails.CreditBillHeaderID;
txtCurrBeginningBalance.Text = clsCurrBillingDetails.BeginningBalance.ToString("#,##0.#0");
txtCurrCurrentDue.Text = clsCurrBillingDetails.Prev1MoCurrentDueAmount.ToString("#,##0.#0");
txtCurrPayments.Text = clsCurrBillingDetails.CurrMonthAmountPaid.ToString("#,##0.#0");
//if (clsCurrBillingDetails.Prev1MoCurrentDueAmount <= 0)
// txtCurrPayments.Text = clsCurrBillingDetails.CurrMonthAmountPaid.ToString("#,##0.#0");
//else
// txtCurrPayments.Text = "-" + clsCurrBillingDetails.CurrMonthAmountPaid.ToString("#,##0.#0");
txtCurrBalance.Text = clsCurrBillingDetails.RunningCreditAmt.ToString("#,##0.#0");
txtCurrPenalty.Text = clsCurrBillingDetails.TotalBillCharges.ToString("#,##0.#0");
txtCurrPurchases.Text = clsCurrBillingDetails.CurrentPurchaseAmt.ToString("#,##0.#0");
txtCurrAmountDue.Text = clsCurrBillingDetails.CurrMonthCreditAmt.ToString("#,##0.#0");
txtCurrTotalAmountDue.Text = clsCurrBillingDetails.CurrentDueAmount.ToString("#,##0.#0");
txtCurrEndingBalance.Text = clsCurrBillingDetails.EndingBalance.ToString("#,##0.#0");
grpCurrBilling.Visible = true;
}
else { grpCurrBilling.Visible = false; }
}
private void SetDataSource(ReportDocument Report)
{
DateTime dteRetValue = Constants.C_DATE_MIN_VALUE;
ReportDataset rptds = new ReportDataset();
Data.Contacts clsContacts;
System.Data.DataTable dt;
switch (cboReportType.SelectedItem.Value)
{
case ReportTypes.CREDITS_Purchases:
#region purchases
CreditPaymentDetails clsCreditPaymentDetails = new CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = new BranchDetails()
{
BranchID = Int32.Parse(cboBranch.SelectedItem.Value)
};
clsCreditPaymentDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentDetails.PurchaseDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.PurchaseDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.CreditType = CreditType.Individual;
clsCreditPaymentDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPurchasesAsDataTable(clsCreditPaymentDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPurchases.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPurchases.Columns)
{
drNew[dc] = "" + dr[dc.ColumnName];
}
rptds.ContactCreditPurchases.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_Payments:
#region payments
CreditPaymentCashDetails clsCreditPaymentCashDetails = new CreditPaymentCashDetails();
clsCreditPaymentCashDetails.BranchDetails = new BranchDetails()
{
BranchID = Int32.Parse(cboBranch.SelectedItem.Value)
};
clsCreditPaymentCashDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentCashDetails.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.CreditType = CreditType.Individual;
clsCreditPaymentCashDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentCashDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentCashDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPaymentCashDetailedAsDataTable(clsCreditPaymentCashDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPaymentCash.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPaymentCash.Columns)
{
drNew[dc] = "" + dr[dc.ColumnName];
}
rptds.ContactCreditPaymentCash.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_CreditorsLedgerSummary:
#region ledger summary
Data.Billing clsBilling = new Data.Billing();
dt = clsBilling.ListAsDataTable(GuarantorID: 0, CreditCardTypeID: Int16.Parse(cboCreditType.SelectedItem.Value), CreditType: CreditType.Individual, BillingDate: DateTime.Parse(cboBillingDate.SelectedItem.Value), CheckIsBillPrinted: false, SortField: "GUA.ContactName, CUS.ContactName", SortOrder: System.Data.SqlClient.SortOrder.Descending);
clsBilling.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Data.DataRow drNew = rptds.CreditBillHeader.NewRow();
foreach (System.Data.DataColumn dc in rptds.CreditBillHeader.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CreditBillHeader.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CustomerCreditSummarizedStatistics:
#region CustomerCreditSummarizedStatistics
Data.ContactCreditCardInfos clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
dt = clsContactCreditCardInfos.IHCreditCardSummarizedStatistics(false);
clsContactCreditCardInfos.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CCISummary.NewRow();
foreach (DataColumn dc in rptds.CCISummary.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CCISummary.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private static void PrintORsWG(System.Data.DataTable dtGuarantors, Data.CardTypeDetails clsCreditCardTypeInfo)
{
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.ContactDetails clsGuarantorDetails;
System.Data.DataTable dtCreditors;
try
{
foreach (System.Data.DataRow dr in dtGuarantors.Rows)
{
clsGuarantorDetails = clsContacts.Details(Int64.Parse(dr["ContactID"].ToString()));
dtCreditors = clsBilling.ListAsDataTable(GuarantorID: clsGuarantorDetails.ContactID, CreditCardTypeID: clsCreditCardTypeInfo.CardTypeID, CreditType: CreditType.Group, BillingDate: clsCreditCardTypeInfo.BillingDate, CheckIsBillPrinted: true, IsBillPrinted: false, SortField: "CUS.ContactName", SortOrder: System.Data.SqlClient.SortOrder.Descending);
if (dtCreditors.Rows.Count > 0)
{
WriteProcessToMonitor("Printing SOA of Guarantor: " + clsGuarantorDetails.ContactName + "...");
if (!bool.Parse(dtCreditors.Rows[0]["isBillPrinted"].ToString()))
{
WriteProcessToMonitor("[" + clsGuarantorDetails.ContactName + "] CurrentDueAmount : " + clsGuarantorDetails.ContactGroupName);
WriteProcessToMonitor("[" + clsGuarantorDetails.ContactName + "] NoOfCreditors : " + dtCreditors.Rows.Count.ToString("#,##0"));
WriteProcessToMonitor("[" + clsGuarantorDetails.ContactName + "] Credit Status : " + clsGuarantorDetails.CreditDetails.CreditCardStatus.ToString("G") + " (" + (clsGuarantorDetails.CreditDetails.CreditActive ? "Active" : "InActive") + ")");
string strOR = "";
string CreditBillerPrinter = "Normal";
if (System.Configuration.ConfigurationManager.AppSettings["CreditBillerPrinter"] != null)
CreditBillerPrinter = System.Configuration.ConfigurationManager.AppSettings["CreditBillerPrinter"].ToString();
if (CreditBillerPrinter.ToUpper() != "LX")
strOR = PrintCreditBillWG(clsGuarantorDetails, dtCreditors, clsCreditCardTypeInfo);
else
strOR = PrintCreditBillWGLX(clsGuarantorDetails, dtCreditors, clsCreditCardTypeInfo);
if (strOR != "")
{
WriteProcessToMonitor("[" + clsGuarantorDetails.ContactName + "] Bill createad @ " + strOR);
clsBilling.SetBillingAsPrinted(CreditType.Group, clsGuarantorDetails.ContactID, clsCreditCardTypeInfo.BillingDate, strOR);
}
WriteProcessToMonitor("[" + clsGuarantorDetails.ContactName + "] Done.");
}
else
{
WriteProcessToMonitor("[" + clsGuarantorDetails.ContactName + "] Done. did not print SOA, already printed @ " + dtCreditors.Rows[0]["BillingFile"].ToString());
}
}
}
}
catch (Exception ex)
{
WriteProcessToMonitor("PLEASE CALL RETAILPLUS IMMEDIATELY... PRINTING-CreditBillWithGuarantor error:" + Environment.NewLine + ex.ToString());
clsBilling.ThrowException(ex);
}
finally
{
clsBilling.CommitAndDispose();
}
}
private void LoadData()
{
try
{
DateTime dteRetValue = DateTime.MinValue;
DateTime dtePaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : DateTime.Now.AddYears(-2);
DateTime dtePaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : DateTime.Now;
Data.SalesTransactions clsTransactions = new Data.SalesTransactions();
System.Data.DataTable dt;
switch (mclsSysConfigDetails.CreditPaymentType)
{
case CreditPaymentType.Houseware:
dt = clsTransactions.ListForPaymentDataTable(mclsCustomerDetails.ContactID, "Balance, TransactionID", System.Data.SqlClient.SortOrder.Descending);
break;
case CreditPaymentType.MPC:
case CreditPaymentType.Normal:
default:
dt = clsTransactions.ListForPaymentDataTable(mclsCustomerDetails.ContactID, "TransactionNo", System.Data.SqlClient.SortOrder.Ascending, 0, dtePaymentDateFrom, dtePaymentDateTo);
break;
}
//Data.Billing clsBilling = new Data.Billing(clsTransactions.Connection, clsTransactions.Transaction);
//Data.BillingDetails clsBillingDetails = clsBilling.Details(mclsCustomerDetails.ContactID, false);
clsTransactions.CommitAndDispose();
dgvItems.MultiSelect = true;
dgvItems.AutoGenerateColumns = true;
dgvItems.AutoSize = false;
dgvItems.DataSource = dt.TableName;
dgvItems.DataSource = dt;
foreach (DataGridViewTextBoxColumn dc in dgvItems.Columns)
{
dc.Visible = false;
}
dgvItems.Columns["TransactionNo"].Visible = true;
dgvItems.Columns["TransactionDate"].Visible = true;
switch (mclsSysConfigDetails.CreditPaymentType)
{
case CreditPaymentType.Houseware:
dgvItems.Columns["CreditReason"].Visible = true;
break;
case CreditPaymentType.MPC:
case CreditPaymentType.Normal:
default:
dgvItems.Columns["Terms"].Visible = true;
dgvItems.Columns["ModeOfTermsCode"].Visible = true;
dgvItems.Columns["AgingDate"].Visible = true;
dgvItems.Columns["AgeTerms"].Visible = true;
break;
}
//
dgvItems.Columns["SubTotal"].Visible = true;
dgvItems.Columns["Credit"].Visible = true;
dgvItems.Columns["CreditPaid"].Visible = true;
dgvItems.Columns["Balance"].Visible = true;
dgvItems.Columns["TransactionNo"].Width = 120;
dgvItems.Columns["TransactionDate"].Width = 120;
// do an override
int iWidth = 100;
switch (mclsSysConfigDetails.CreditPaymentType)
{
case CreditPaymentType.Houseware:
if (dt.Rows.Count < 14) dgvItems.Columns["CreditReason"].Width = 240; else dgvItems.Columns["CreditReason"].Width = 210;
iWidth = (dgvItems.Width - dgvItems.Columns["TransactionNo"].Width - dgvItems.Columns["TransactionDate"].Width - dgvItems.Columns["CreditReason"].Width) / 4;
if (dt.Rows.Count >= 14) iWidth = iWidth - 5;
break;
case CreditPaymentType.MPC:
case CreditPaymentType.Normal:
default:
dgvItems.Columns["Terms"].Width = 60;
dgvItems.Columns["ModeOfTermsCode"].Width = 75;
dgvItems.Columns["AgingDate"].Width = 120;
if (dt.Rows.Count < 14) dgvItems.Columns["AgeTerms"].Width = 90; else dgvItems.Columns["AgeTerms"].Width = 60;
iWidth = (dgvItems.Width - dgvItems.Columns["TransactionNo"].Width - dgvItems.Columns["TransactionDate"].Width - dgvItems.Columns["Terms"].Width - dgvItems.Columns["ModeOfTermsCode"].Width - dgvItems.Columns["AgingDate"].Width - dgvItems.Columns["AgeTerms"].Width) / 4;
if (dt.Rows.Count >= 14) iWidth = iWidth - 5;
break;
}
dgvItems.Columns["SubTotal"].Width = iWidth;
dgvItems.Columns["Credit"].Width = iWidth;
dgvItems.Columns["CreditPaid"].Width = iWidth;
dgvItems.Columns["Balance"].Width = iWidth;
dgvItems.Columns["TransactionNo"].HeaderText = "Trans. No";
dgvItems.Columns["TransactionDate"].HeaderText = "Trans. Date";
switch (mclsSysConfigDetails.CreditPaymentType)
{
case CreditPaymentType.Houseware:
dgvItems.Columns["CreditReason"].HeaderText = "Description";
break;
case CreditPaymentType.MPC:
case CreditPaymentType.Normal:
default:
dgvItems.Columns["Terms"].HeaderText = "Terms";
dgvItems.Columns["ModeOfTermsCode"].HeaderText = "ModeOfTerms";
dgvItems.Columns["AgingDate"].HeaderText = "Due Date";
dgvItems.Columns["AgeTerms"].HeaderText = "Age";
dgvItems.Columns["Terms"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Terms"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Terms"].DefaultCellStyle.Format = "#,##0";
dgvItems.Columns["AgingDate"].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm tt";
dgvItems.Columns["AgeTerms"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["AgeTerms"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["AgeTerms"].DefaultCellStyle.Format = "#,##0";
break;
}
dgvItems.Columns["SubTotal"].HeaderText = "Subtotal";
dgvItems.Columns["Credit"].HeaderText = "Credit";
dgvItems.Columns["CreditPaid"].HeaderText = "Credit Paid";
dgvItems.Columns["Balance"].HeaderText = "Balance";
dgvItems.Columns["SubTotal"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Credit"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["CreditPaid"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Balance"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["SubTotal"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Credit"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["CreditPaid"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Balance"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["TransactionDate"].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm tt";
dgvItems.Columns["SubTotal"].DefaultCellStyle.Format = "#,##0.#0";
dgvItems.Columns["Credit"].DefaultCellStyle.Format = "#,##0.#0";
dgvItems.Columns["CreditPaid"].DefaultCellStyle.Format = "#,##0.#0";
dgvItems.Columns["Balance"].DefaultCellStyle.Format = "#,##0.#0";
dgvItems.ReadOnly = true;
dgvItems.Select();
lblHeader.Text = mclsCustomerDetails.ContactName;
lblBalance.Text = mclsCustomerDetails.Credit.ToString("#,##0.#0");
switch (mclsSysConfigDetails.CreditPaymentType)
{
case CreditPaymentType.Houseware:
// sort this so that the least amount will be on top
// for HP
dgvItems.Sort(dgvItems.Columns["Balance"], ListSortDirection.Descending);
dgvItems.SelectAll();
dgvItems_RowStateChanged(null, null);
dgvItems.Enabled = false;
Data.Billing clsBilling = new Data.Billing();
Data.BillingDetails clsBillingDetails = clsBilling.Details(mclsCustomerDetails.ContactID, mclsCustomerDetails.CreditDetails.LastBillingDate, false);
clsBilling.CommitAndDispose();
lblAmountDue.Visible = true;
labelAmountDue.Visible = true;
lblAmountDue.Text = "0.00";
if (clsBillingDetails.ContactID != 0)
{
if (mclsCustomerDetails.CreditDetails.CardTypeDetails.WithGuarantor)
{
labelAmountDue.Text = "Amount Due";
if (decimal.Parse(lblBalance.Text) < clsBillingDetails.CurrentDueAmount)
{
lblAmountDue.Text = lblBalance.Text;
}
else
{
lblAmountDue.Text = clsBillingDetails.CurrentDueAmount.ToString("#,##0.#0");
}
}
else
{
labelAmountDue.Text = "Minimum Amount Due";
if (decimal.Parse(lblBalance.Text) < clsBillingDetails.MinimumAmountDue)
{
lblAmountDue.Text = lblBalance.Text;
}
else
{
lblAmountDue.Text = clsBillingDetails.MinimumAmountDue.ToString("#,##0.#0");
}
}
}
break;
case CreditPaymentType.Normal:
case CreditPaymentType.MPC:
default:
lblAmountDue.Visible = true;
labelAmountDue.Visible = true;
labelAmountDue.Text = "SubTotal Amount";
lblAmountDue.Text = mclsCustomerDetails.Credit.ToString("#,##0.#0");
decimal decTemp = 0;
decimal decTotalPayable = 0;
foreach (DataGridViewRow dr in dgvItems.Rows)
{
decTemp = 0;
decimal.TryParse(dr.Cells["Balance"].Value.ToString(), out decTemp);
decTotalPayable += decTemp;
}
lblAmountDue.Text = decTotalPayable.ToString("#,##0.#0");
labelAmountDue.Location = new Point(116, 475);
lblAmountDue.Location = new Point(700, 477);
lblBalanceName.Location = new Point(116, 553);
lblBalance.Location = new Point(705, 555);
break;
}
grpSearch.Visible = false;
dgvItems.Focus();
cmdEnter.Text = "Enter";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
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();
}
}
protected static string PrintCreditBillLX(Data.BillingDetails clsBillingDetails)
{
Data.Billing clsBilling = new Data.Billing(mConnection, mTransaction);
mConnection = clsBilling.Connection; mTransaction = clsBilling.Transaction;
System.Data.DataTable dt = clsBilling.ListDetailsAsDataTable(clsBillingDetails.CreditBillHeaderID);
clsBilling.CommitAndDispose();
CreditBiller.CRSReports.BillingLX rpt = new CreditBiller.CRSReports.BillingLX();
CreditBiller.ReportDataset rptds = new CreditBiller.ReportDataset();
System.Data.DataRow drNew;
foreach (System.Data.DataRow dr in dt.Rows)
{
drNew = rptds.CreditBillDetail.NewRow();
foreach (System.Data.DataColumn dc in rptds.CreditBillDetail.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CreditBillDetail.Rows.Add(drNew);
}
rpt.SetDataSource(rptds);
CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinition paramField;
CrystalDecisions.Shared.ParameterValues currentValues;
CrystalDecisions.Shared.ParameterDiscreteValue discreteParam;
paramField = rpt.DataDefinition.ParameterFields["CompanyName"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = CompanyDetails.CompanyNameNoG;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["BillingDate"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.BillingDate;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["PaymentDueDate"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.CreditPaymentDueDate;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["CompanyAddress"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = CompanyDetails.Address1 +
Environment.NewLine + CompanyDetails.Address2 + ", " + CompanyDetails.City + " " + CompanyDetails.Country +
Environment.NewLine + "Tel #: " + CompanyDetails.OfficePhone + " Fax #:" + CompanyDetails.FaxPhone +
Environment.NewLine + "TIN : " + CompanyDetails.TIN + " VAT Reg.";
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["ContactName"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.CustomerDetails.ContactName;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["ContactCode"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.CustomerDetails.ContactCode;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["ContactAddress"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.CustomerDetails.Address;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["CreditCardNo"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.CustomerDetails.CreditDetails.CreditCardNo;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["CreditLimit"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.CrediLimit;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["CurrentDueAmount"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.CurrentDueAmount;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["MinimumAmountDue"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.MinimumAmountDue;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["PrevMoCurrentDueAmount"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.Prev1MoCurrentDueAmount + clsBillingDetails.Prev2MoCurrentDueAmount;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["CreditPurcStartDateToProcess"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.CreditPurcStartDateToProcess;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
paramField = rpt.DataDefinition.ParameterFields["CreditPurcEndDateToProcess"];
discreteParam = new CrystalDecisions.Shared.ParameterDiscreteValue();
discreteParam.Value = clsBillingDetails.CreditPurcEndDateToProcess;
currentValues = new CrystalDecisions.Shared.ParameterValues();
currentValues.Add(discreteParam);
paramField.ApplyCurrentValues(currentValues);
string strRetValue = "";
try
{
string logsdir = System.Configuration.ConfigurationManager.AppSettings["billingdir"].ToString();
logsdir += logsdir.EndsWith("/") ? "" : "/";
if (!Directory.Exists(logsdir + "woutg"))
{
Directory.CreateDirectory(logsdir + "woutg");
}
string logFile = logsdir + "woutg/OR_" + clsBillingDetails.ContactID.ToString() + clsBillingDetails.BillingDate.ToString("yyyyMMdd") + ".doc";
if (File.Exists(logFile))
{
MoveCreditBillToNextFile(logFile, 1);
}
bool boPrintToPDF = false;
if (System.Configuration.ConfigurationManager.AppSettings["PrintToPDF"] != null)
boPrintToPDF = bool.Parse(System.Configuration.ConfigurationManager.AppSettings["PrintToPDF"].ToString());
if (boPrintToPDF) rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, logFile.Replace(".doc", ".pdf"));
rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.WordForWindows, logFile);
strRetValue = "OR_" + clsBillingDetails.ContactID.ToString() + clsBillingDetails.BillingDate.ToString("yyyyMMdd") + ".doc";
}
catch { }
try
{
bool boCreditBillerWillPrintORs = false;
if (System.Configuration.ConfigurationManager.AppSettings["CreditBillerWillPrintORs"] != null)
boCreditBillerWillPrintORs = bool.Parse(System.Configuration.ConfigurationManager.AppSettings["CreditBillerWillPrintORs"].ToString());
if (boCreditBillerWillPrintORs)
{
string strCreditBillerPrinterName = "";
if (System.Configuration.ConfigurationManager.AppSettings["CreditBillerPrinterName"] != null)
strCreditBillerPrinterName = System.Configuration.ConfigurationManager.AppSettings["CreditBillerPrinterName"].ToString();
System.Drawing.Printing.PrintDocument printDoc = new System.Drawing.Printing.PrintDocument();
int i;
int rawKind = 0;
for (i = 0; i < printDoc.PrinterSettings.PaperSizes.Count; i++)
{
if (printDoc.PrinterSettings.PaperSizes[i].PaperName == "RetailPlusLXHalfSize")
{
rawKind = (int)PrinterHelper.GetField(printDoc.PrinterSettings.PaperSizes[i], "kind");
break;
}
}
if (PrinterHelper.isPrinterOnline(strCreditBillerPrinterName))
{
rpt.PrintOptions.PaperSize = (CrystalDecisions.Shared.PaperSize)rawKind;
rpt.PrintOptions.PrinterName = strCreditBillerPrinterName;
rpt.PrintToPrinter(1, false, 0, 0);
}
else
{
WriteProcessToMonitor("will not print sales invoice. '" + strCreditBillerPrinterName + "' printer is offline.");
}
}
}
catch { }
rpt.Close();
rpt.Dispose();
return strRetValue;
}
private static void PrintORs(List<Data.BillingDetails> lstBillingDetails)
{
Data.Billing clsBilling = new Data.Billing(mConnection, mTransaction);
mConnection = clsBilling.Connection; mTransaction = clsBilling.Transaction;
try
{
foreach (Data.BillingDetails clsBillingDetails in lstBillingDetails)
{
WriteProcessToMonitor("Printing SOA of " + clsBillingDetails.CustomerDetails.ContactName + "...");
if (!clsBillingDetails.isBillPrinted)
{
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] CrediLimit : " + clsBillingDetails.CrediLimit.ToString(Constants.C_FE_DEFAULT_DECIMAL_FORMAT));
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] Credit : " + clsBillingDetails.CurrentDueAmount.ToString(Constants.C_FE_DEFAULT_DECIMAL_FORMAT));
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] CurrentDueAmount : " + clsBillingDetails.CurrentDueAmount.ToString(Constants.C_FE_DEFAULT_DECIMAL_FORMAT));
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] TotalBillCharges : " + clsBillingDetails.TotalBillCharges.ToString(Constants.C_FE_DEFAULT_DECIMAL_FORMAT));
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] CurrMonthAmountPaid : " + clsBillingDetails.CurrMonthAmountPaid.ToString(Constants.C_FE_DEFAULT_DECIMAL_FORMAT));
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] MinimumAmountDue : " + clsBillingDetails.MinimumAmountDue.ToString(Constants.C_FE_DEFAULT_DECIMAL_FORMAT));
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] Prev1MoCurrentDueAmount : " + clsBillingDetails.Prev1MoCurrentDueAmount.ToString(Constants.C_FE_DEFAULT_DECIMAL_FORMAT));
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] Prev2MoCurrentDueAmount : " + clsBillingDetails.Prev2MoCurrentDueAmount.ToString(Constants.C_FE_DEFAULT_DECIMAL_FORMAT));
string strOR = "";
string CreditBillerPrinter = "Normal";
if (System.Configuration.ConfigurationManager.AppSettings["CreditBillerPrinter"] != null)
CreditBillerPrinter = System.Configuration.ConfigurationManager.AppSettings["CreditBillerPrinter"].ToString();
if (CreditBillerPrinter.ToUpper() != "LX")
strOR = PrintCreditBill(clsBillingDetails);
else
strOR = PrintCreditBillLX(clsBillingDetails);
if (strOR != "")
{
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] Bill createad @ " + strOR);
clsBilling.SetBillingAsPrinted(CreditType.Individual, clsBillingDetails.ContactID, clsBillingDetails.BillingDate, strOR);
}
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] Done.");
}
else
{
WriteProcessToMonitor("[" + clsBillingDetails.CustomerDetails.ContactName + "] Done. did not print SOA, already printed @ " + clsBillingDetails.BillingFile);
}
}
}
catch (Exception ex)
{
WriteProcessToMonitor("PLEASE CALL RETAILPLUS IMMEDIATELY... PRINTING-CreditBillWoutGuarantor error:" + Environment.NewLine + ex.ToString());
clsBilling.ThrowException(ex);
}
finally
{
clsBilling.CommitAndDispose();
}
}
private void LoadData()
{
mboIsLoading = true;
grpContactDetails.Visible = true;
grpBillingDetails.Visible = true;
txtCustomerName.Text = CreditorDetails.ContactName;
txtCreditLimit.Text = CreditorDetails.CreditLimit.ToString("#,##0.#0");
txtCredit.Text = CreditorDetails.Credit.ToString("#,##0.#0");
txtAvailableCredit.Text = (CreditorDetails.CreditLimit - CreditorDetails.Credit).ToString("#,##0.#0");
Data.Billing clsBilling = new Data.Billing();
Data.BillingDetails clsBillingDetails = clsBilling.Details(CreditorDetails.ContactID, CreditorDetails.CreditDetails.Last2BillingDate);
Data.BillingDetails clsCurrBillingDetails = clsBilling.Details(CreditorDetails.ContactID, CreditorDetails.CreditDetails.LastBillingDate);
clsBilling.CommitAndDispose();
grpBillingDetails.Tag = "0";
if (clsBillingDetails.BillingDate == CreditorDetails.CreditDetails.Last2BillingDate)
{
grpBillingDetails.Tag = clsBillingDetails.CreditBillHeaderID;
txtLastPrev2MoCurrentDueAmount.Text = clsBillingDetails.Prev2MoCurrentDueAmount.ToString("#,##0.#0");
txtLastPrev1MoCurrentDueAmount.Text = clsBillingDetails.Prev1MoCurrentDueAmount.ToString("#,##0.#0");
txtLastPreviousBalance.Text = (clsBillingDetails.Prev2MoCurrentDueAmount + clsBillingDetails.Prev1MoCurrentDueAmount).ToString("#,##0.#0");
txtLastCurrMonthAmountPaid.Text = clsBillingDetails.CurrMonthAmountPaid.ToString("#,##0.#0");
//txtBalance.Text = clsBillingDetails.RunningCreditAmt.ToString("#,##0.#0");
txtLastTotalBillCharges.Text = clsBillingDetails.TotalBillCharges.ToString("#,##0.#0");
txtLastCurrentPurchaseAmt.Text = clsBillingDetails.CurrentPurchaseAmt.ToString("#,##0.#0");
txtLastMinimumAmountDue.Text = clsBillingDetails.MinimumAmountDue.ToString("#,##0.#0");
txtLastCurrentDueAmount.Text = clsBillingDetails.CurrentDueAmount.ToString("#,##0.#0");
grpBillingDetails.Visible = true;
}
else { grpBillingDetails.Visible = false; }
grpCurrBilling.Tag = "0";
if (clsCurrBillingDetails.BillingDate == CreditorDetails.CreditDetails.LastBillingDate)
{
grpCurrBilling.Tag = clsCurrBillingDetails.CreditBillHeaderID;
txtPrev2MoCurrentDueAmount.Text = clsCurrBillingDetails.Prev2MoCurrentDueAmount.ToString("#,##0.#0");
txtPrev1MoCurrentDueAmount.Text = clsCurrBillingDetails.Prev1MoCurrentDueAmount.ToString("#,##0.#0");
txtPreviousBalance.Text = (clsCurrBillingDetails.Prev2MoCurrentDueAmount + clsCurrBillingDetails.Prev1MoCurrentDueAmount).ToString("#,##0.#0");
txtCurrMonthAmountPaid.Text = clsCurrBillingDetails.CurrMonthAmountPaid.ToString("#,##0.#0");
//txtBalance.Text = clsCurrBillingDetails.RunningCreditAmt.ToString("#,##0.#0");
txtTotalBillCharges.Text = clsCurrBillingDetails.TotalBillCharges.ToString("#,##0.#0");
txtCurrentPurchaseAmt.Text = clsCurrBillingDetails.CurrentPurchaseAmt.ToString("#,##0.#0");
txtMinimumAmountDue.Text = clsCurrBillingDetails.MinimumAmountDue.ToString("#,##0.#0");
txtCurrentDueAmount.Text = clsCurrBillingDetails.CurrentDueAmount.ToString("#,##0.#0");
grpCurrBilling.Visible = true;
}
else { grpCurrBilling.Visible = false; }
mboIsLoading = false;
}
private void SetDataSource(ReportDocument Report)
{
DateTime dteRetValue = Constants.C_DATE_MIN_VALUE;
ReportDataset rptds = new ReportDataset();
Data.Contacts clsContacts;
System.Data.DataTable dt;
switch (cboReportType.SelectedItem.Value)
{
case ReportTypes.CREDITS_Purchases:
#region purchases
CreditPaymentDetails clsCreditPaymentDetails = new CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = new BranchDetails() { BranchID = Int32.Parse(cboBranch.SelectedItem.Value) };
clsCreditPaymentDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentDetails.PurchaseDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.PurchaseDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.CreditType = CreditType.Individual;
clsCreditPaymentDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPurchasesAsDataTable(clsCreditPaymentDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPurchases.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPurchases.Columns)
drNew[dc] = "" + dr[dc.ColumnName];
rptds.ContactCreditPurchases.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_Payments:
#region payments
CreditPaymentCashDetails clsCreditPaymentCashDetails = new CreditPaymentCashDetails();
clsCreditPaymentCashDetails.BranchDetails = new BranchDetails() { BranchID = Int32.Parse(cboBranch.SelectedItem.Value) };
clsCreditPaymentCashDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentCashDetails.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.CreditType = CreditType.Individual;
clsCreditPaymentCashDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentCashDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentCashDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPaymentCashDetailedAsDataTable(clsCreditPaymentCashDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPaymentCash.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPaymentCash.Columns)
drNew[dc] = "" + dr[dc.ColumnName];
rptds.ContactCreditPaymentCash.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_CreditorsLedgerSummary:
#region ledger summary
Data.Billing clsBilling = new Data.Billing();
dt = clsBilling.ListAsDataTable(GuarantorID: 0, CreditCardTypeID: Int16.Parse(cboCreditType.SelectedItem.Value), CreditType: CreditType.Individual, BillingDate: DateTime.Parse(cboBillingDate.SelectedItem.Value), CheckIsBillPrinted: false, SortField: "GUA.ContactName, CUS.ContactName", SortOrder: System.Data.SqlClient.SortOrder.Descending);
clsBilling.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Data.DataRow drNew = rptds.CreditBillHeader.NewRow();
foreach (System.Data.DataColumn dc in rptds.CreditBillHeader.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CreditBillHeader.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CustomerCreditSummarizedStatistics:
#region CustomerCreditSummarizedStatistics
Data.ContactCreditCardInfos clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
dt = clsContactCreditCardInfos.IHCreditCardSummarizedStatistics(false);
clsContactCreditCardInfos.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CCISummary.NewRow();
foreach (DataColumn dc in rptds.CCISummary.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CCISummary.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
