public Int32 Save(CreditPaymentCashDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveCreditPaymentCash(@BranchID, @TerminalNo, @SyncID, @CreditPaymentCashID, @CreditPaymentID, @CPRefBranchID, @CPRefTerminalNo, @TransactionID, @Amount, @Remarks, @TransactionNo, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("BranchID", Details.BranchDetails.BranchID);
cmd.Parameters.AddWithValue("TerminalNo", Details.TerminalNo);
cmd.Parameters.AddWithValue("SyncID", Details.SyncID);
cmd.Parameters.AddWithValue("CreditPaymentCashID", Details.CreditPaymentCashID);
cmd.Parameters.AddWithValue("CreditPaymentID", Details.CreditPaymentID);
cmd.Parameters.AddWithValue("CPRefBranchID", Details.CPRefBranchID);
cmd.Parameters.AddWithValue("CPRefTerminalNo", Details.CPRefTerminalNo);
cmd.Parameters.AddWithValue("TransactionID", Details.TransactionID);
cmd.Parameters.AddWithValue("Amount", Details.Amount);
cmd.Parameters.AddWithValue("Remarks", Details.Remarks);
cmd.Parameters.AddWithValue("TransactionNo", Details.TransactionNo);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(CreditPaymentCashDetails Details)
{
try
{
Save(Details);
return Int64.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(CreditPaymentCashDetails Details)
{
try
{
Save(Details);
return(Int64.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
/// <summary>
/// Get the cash payment details of a certain transaction.
/// </summary>
/// <param name="BranchID"></param>
/// <param name="TerminalNo"></param>
/// <param name="SyncID">Same also as the TransactionID</param>
/// <returns></returns>
public CreditPaymentCashDetails[] Details(Int32 BranchID, string TerminalNo, Int64 TransactionID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE BranchID = @BranchID AND TerminalNo = @TerminalNo AND TransactionID = @TransactionID;";
cmd.Parameters.AddWithValue("BranchID", BranchID);
cmd.Parameters.AddWithValue("TerminalNo", TerminalNo);
cmd.Parameters.AddWithValue("TransactionID", TransactionID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
ArrayList items = new ArrayList();
foreach (System.Data.DataRow dr in dt.Rows)
{
items.Add(setDetails(dr));
}
CreditPaymentCashDetails[] arrCashDetails = new CreditPaymentCashDetails[0];
if (items != null)
{
arrCashDetails = new CreditPaymentCashDetails[items.Count];
items.CopyTo(arrCashDetails);
}
return(arrCashDetails);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(CreditPaymentCashDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveCreditPaymentCash(@BranchID, @TerminalNo, @SyncID, @CreditPaymentCashID, @CreditPaymentID, @CPRefBranchID, @CPRefTerminalNo, @TransactionID, @Amount, @Remarks, @TransactionNo, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("BranchID", Details.BranchDetails.BranchID);
cmd.Parameters.AddWithValue("TerminalNo", Details.TerminalNo);
cmd.Parameters.AddWithValue("SyncID", Details.SyncID);
cmd.Parameters.AddWithValue("CreditPaymentCashID", Details.CreditPaymentCashID);
cmd.Parameters.AddWithValue("CreditPaymentID", Details.CreditPaymentID);
cmd.Parameters.AddWithValue("CPRefBranchID", Details.CPRefBranchID);
cmd.Parameters.AddWithValue("CPRefTerminalNo", Details.CPRefTerminalNo);
cmd.Parameters.AddWithValue("TransactionID", Details.TransactionID);
cmd.Parameters.AddWithValue("Amount", Details.Amount);
cmd.Parameters.AddWithValue("Remarks", Details.Remarks);
cmd.Parameters.AddWithValue("TransactionNo", Details.TransactionNo);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
/// <summary>
/// Get the cash payment details of a certain transaction.
/// </summary>
/// <param name="BranchID"></param>
/// <param name="TerminalNo"></param>
/// <param name="SyncID">Same also as the TransactionID</param>
/// <returns></returns>
public CreditPaymentCashDetails[] Details(Int32 BranchID, string TerminalNo, Int64 TransactionID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE BranchID = @BranchID AND TerminalNo = @TerminalNo AND TransactionID = @TransactionID;";
cmd.Parameters.AddWithValue("BranchID", BranchID);
cmd.Parameters.AddWithValue("TerminalNo", TerminalNo);
cmd.Parameters.AddWithValue("TransactionID", TransactionID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
ArrayList items = new ArrayList();
foreach (System.Data.DataRow dr in dt.Rows)
{
items.Add(setDetails(dr));
}
CreditPaymentCashDetails[] arrCashDetails = new CreditPaymentCashDetails[0];
if (items != null)
{
arrCashDetails = new CreditPaymentCashDetails[items.Count];
items.CopyTo(arrCashDetails);
}
return arrCashDetails;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable CreditPaymentCashAsDataTable(CreditPaymentCashDetails SearchKeys, string SortField = "trx.CreatedOn", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procContactCreditPaymentSelect(@BranchID, @TerminalNo, @ContactID, @CreditType, @CreditCardTypeID, @PaymentDateFrom, @PaymentDateTo, " +
"@CreditorLastNameFrom, @CreditorLastnameTo, @GuaLastNameFrom, @GuaLastNameTo, @SortField, @SortOption, @limit);";
cmd.Parameters.AddWithValue("BranchID", SearchKeys.BranchDetails.BranchID);
cmd.Parameters.AddWithValue("TerminalNo", SearchKeys.TerminalNo);
cmd.Parameters.AddWithValue("ContactID", SearchKeys.ContactID);
cmd.Parameters.AddWithValue("CreditType", SearchKeys.CreditType.ToString("d"));
cmd.Parameters.AddWithValue("CreditCardTypeID", SearchKeys.CreditCardTypeID);
cmd.Parameters.AddWithValue("PaymentDateFrom", SearchKeys.PaymentDateFrom);
cmd.Parameters.AddWithValue("PaymentDateTo", SearchKeys.PaymentDateTo);
cmd.Parameters.AddWithValue("CreditorLastNameFrom", SearchKeys.CreditorLastnameFrom);
cmd.Parameters.AddWithValue("CreditorLastNameTo", SearchKeys.CreditorLastnameTo);
cmd.Parameters.AddWithValue("GuaLastNameFrom", SearchKeys.GuarantorLastnameFrom);
cmd.Parameters.AddWithValue("GuaLastNameTo", SearchKeys.GuarantorLastnameTo);
cmd.Parameters.AddWithValue("SortField", SortField);
cmd.Parameters.AddWithValue("SortOption", SortOrder == SortOption.Ascending ? "ASC" : "DESC");
cmd.Parameters.AddWithValue("limit", limit);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
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);
}
