public CreditCardPaymentDetails setDetails(System.Data.DataRow dr)
{
Data.CreditCardPaymentDetails Details = new Data.CreditCardPaymentDetails();
Details.BranchDetails = new Branch(base.Connection, base.Transaction).Details(Int32.Parse(dr["BranchID"].ToString()));
Details.TerminalNo = dr["TerminalNo"].ToString();
Details.SyncID = Int64.Parse(dr["SyncID"].ToString());
Details.CreditCardPaymentID = Int64.Parse(dr["CreditCardPaymentID"].ToString());
Details.TransactionID = Int64.Parse(dr["TransactionID"].ToString());
Details.TransactionDate = DateTime.Parse(dr["TransactionDate"].ToString());
Details.Amount = decimal.Parse(dr["Amount"].ToString());
Details.AdditionalCharge = decimal.Parse(dr["AdditionalCharge"].ToString());
Details.ContactID = Int64.Parse(dr["ContactID"].ToString());
Details.GuarantorID = Int64.Parse(dr["GuarantorID"].ToString());
Details.CardTypeID = Int16.Parse(dr["CardTypeID"].ToString());
Details.CardTypeCode = dr["CardTypeCode"].ToString();
Details.CardTypeName = dr["CardTypeName"].ToString();
Details.CardNo = dr["CardNo"].ToString();
Details.CardHolder = dr["CardHolder"].ToString();
Details.ValidityDates = dr["ValidityDates"].ToString();
Details.Remarks = dr["Remarks"].ToString();
Details.TransactionNo = dr["TransactionNo"].ToString();
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
Details.CardTypeDetails = new CardType(base.Connection, base.Transaction).Details(Details.CardTypeID);
Details.CreditorDetails = new Contacts(base.Connection, base.Transaction).Details(Details.ContactID);
return(Details);
}
private void SaveCreditCardPayment(Data.Payment pvtclsPayment, ArrayList pvtarrCreditCardPaymentDetails)
{
int itemIndex = 0;
Data.CreditCardPaymentDetails[] CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[0];
if (pvtarrCreditCardPaymentDetails != null)
{
CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[pvtarrCreditCardPaymentDetails.Count];
pvtarrCreditCardPaymentDetails.CopyTo(CreditCardPaymentDetails);
}
foreach (Data.CreditCardPaymentDetails det in CreditCardPaymentDetails)
{
string strRemarks = "PAID BY:" + mclsCustomerDetails.ContactName + " PAYMENTTYPE:CreditCard DATE:" + DateTime.Now.ToString("MM-dd-yyyy hh:mm:ss tt");
if (det.Remarks != null)
{
strRemarks += Environment.NewLine + det.Remarks;
}
decimal decRemainingAmountPaid = det.Amount;
System.Data.DataTable dt = (System.Data.DataTable)dgItems.DataSource;
foreach (System.Data.DataRow dr in dt.Rows)
{
long lngTransactionID = Convert.ToInt64(dr["TransactionID"]);
string strTransactionNo = dr["TransactionNo"].ToString();
decimal decBalance = Convert.ToDecimal(dr["Balance"]);
if (decRemainingAmountPaid >= decBalance)
{
InsertCreditCardPayment(pvtclsPayment, lngTransactionID, strTransactionNo, decBalance, det.CardTypeID, det.CardNo, det.CardHolder, det.ValidityDates, strRemarks);
dgItems.Select(itemIndex);
dr["CreditPaid"] = decBalance.ToString("#,##0.#0");
dr["Balance"] = "0.00";
decRemainingAmountPaid -= decBalance;
}
else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance)
{
InsertCreditCardPayment(pvtclsPayment, lngTransactionID, strTransactionNo, decRemainingAmountPaid, det.CardTypeID, det.CardNo, det.CardHolder, det.ValidityDates, strRemarks);
dgItems.Select(itemIndex);
dr["CreditPaid"] = decRemainingAmountPaid.ToString("#,##0.#0");
dr["Balance"] = Convert.ToDecimal(decBalance - decRemainingAmountPaid).ToString("#,##0.#0");
decRemainingAmountPaid = 0;
break;
}
itemIndex++;
}
this.dgStyle.MappingName = dt.TableName;
dgItems.DataSource = dt;
if (dt.Rows.Count > 0)
{
dgItems.Select(0);
dgItems.CurrentRowIndex = 0;
}
}
}
private void SaveCreditCardPayment(Data.Payment clsPayment, ArrayList pvtarrCreditCardPaymentDetails)
{
Data.CreditCardPaymentDetails[] CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[0];
if (pvtarrCreditCardPaymentDetails != null)
{
CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[pvtarrCreditCardPaymentDetails.Count];
pvtarrCreditCardPaymentDetails.CopyTo(CreditCardPaymentDetails);
}
foreach (Data.CreditCardPaymentDetails det in CreditCardPaymentDetails)
{
string strRemarks = "PAID BY:" + mclsCustomerDetails.ContactName + " PAYMENTTYPE:CreditCard DATE:" + DateTime.Now.ToString("MM-dd-yyyy hh:mm:ss tt");
if (det.Remarks != null)
{
strRemarks += Environment.NewLine + det.Remarks;
}
decimal decRemainingAmountPaid = det.Amount;
foreach (DataGridViewRow dr in dgvItems.SelectedRows)
{
Int64 lngTransactionID = Convert.ToInt64(dr.Cells["TransactionID"].Value.ToString());
string strTransactionNo = dr.Cells["TransactionNo"].Value.ToString();
decimal decBalance = Convert.ToDecimal(dr.Cells["Balance"].Value.ToString());
if (decRemainingAmountPaid >= decBalance)
{
InsertCreditCardPayment(clsPayment, lngTransactionID, strTransactionNo, decBalance, det.CardTypeID, det.CardNo, det.CardHolder, det.ValidityDates, strRemarks);
//dgItems.Select(itemIndex);
dr.Cells["CreditPaid"].Value = decBalance;
dr.Cells["Balance"].Value = 0;
decRemainingAmountPaid -= decBalance;
}
else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance)
{
InsertCreditCardPayment(clsPayment, lngTransactionID, strTransactionNo, decRemainingAmountPaid, det.CardTypeID, det.CardNo, det.CardHolder, det.ValidityDates, strRemarks);
//dgItems.Select(itemIndex);
dr.Cells["CreditPaid"].Value = decRemainingAmountPaid;
dr.Cells["Balance"].Value = decBalance - decRemainingAmountPaid;
decRemainingAmountPaid = 0;
break;
}
}
}
}
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 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);
}
public CreditCardPaymentDetails setDetails(System.Data.DataRow dr)
{
Data.CreditCardPaymentDetails Details = new Data.CreditCardPaymentDetails();
Details.BranchDetails = new Branch(base.Connection, base.Transaction).Details(Int32.Parse(dr["BranchID"].ToString()));
Details.TerminalNo = dr["TerminalNo"].ToString();
Details.SyncID = Int64.Parse(dr["SyncID"].ToString());
Details.CreditCardPaymentID = Int64.Parse(dr["CreditCardPaymentID"].ToString());
Details.TransactionID = Int64.Parse(dr["TransactionID"].ToString());
Details.TransactionDate = DateTime.Parse(dr["TransactionDate"].ToString());
Details.Amount = decimal.Parse(dr["Amount"].ToString());
Details.AdditionalCharge = decimal.Parse(dr["AdditionalCharge"].ToString());
Details.ContactID = Int64.Parse(dr["ContactID"].ToString());
Details.GuarantorID = Int64.Parse(dr["GuarantorID"].ToString());
Details.CardTypeID = Int16.Parse(dr["CardTypeID"].ToString());
Details.CardTypeCode = dr["CardTypeCode"].ToString();
Details.CardTypeName = dr["CardTypeName"].ToString();
Details.CardNo = dr["CardNo"].ToString();
Details.CardHolder = dr["CardHolder"].ToString();
Details.ValidityDates = dr["ValidityDates"].ToString();
Details.Remarks = dr["Remarks"].ToString();
Details.TransactionNo = dr["TransactionNo"].ToString();
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
Details.CardTypeDetails = new CardType(base.Connection, base.Transaction).Details(Details.CardTypeID);
Details.CreditorDetails = new Contacts(base.Connection, base.Transaction).Details(Details.ContactID);
return Details;
}
public Data.PaymentDetails AssignArrayListPayments(ArrayList arrCashPaymentDetails, ArrayList arrChequePaymentDetails, ArrayList arrCreditCardPaymentDetails, ArrayList arrCreditPaymentDetails, ArrayList arrDebitPaymentDetails)
{
Data.CashPaymentDetails[] CashPaymentDetails = new Data.CashPaymentDetails[0];
if (arrCashPaymentDetails.Count > 0)
{
CashPaymentDetails = new Data.CashPaymentDetails[arrCashPaymentDetails.Count];
arrCashPaymentDetails.CopyTo(CashPaymentDetails);
}
Data.ChequePaymentDetails[] ChequePaymentDetails = new Data.ChequePaymentDetails[0];
if (arrChequePaymentDetails.Count > 0)
{
ChequePaymentDetails = new Data.ChequePaymentDetails[arrChequePaymentDetails.Count];
arrChequePaymentDetails.CopyTo(ChequePaymentDetails);
}
Data.CreditCardPaymentDetails[] CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[0];
if (arrCreditCardPaymentDetails.Count > 0)
{
CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[arrCreditCardPaymentDetails.Count];
arrCreditCardPaymentDetails.CopyTo(CreditCardPaymentDetails);
}
Data.CreditPaymentDetails[] CreditPaymentDetails = new Data.CreditPaymentDetails[0];
if (arrCreditPaymentDetails != null && arrCreditPaymentDetails.Count > 0)
{
CreditPaymentDetails = new Data.CreditPaymentDetails[arrCreditPaymentDetails.Count];
arrCreditPaymentDetails.CopyTo(CreditPaymentDetails);
}
Data.DebitPaymentDetails[] DebitPaymentDetails = new Data.DebitPaymentDetails[0];
if (arrDebitPaymentDetails != null && arrDebitPaymentDetails.Count > 0)
{
DebitPaymentDetails = new Data.DebitPaymentDetails[arrDebitPaymentDetails.Count];
arrDebitPaymentDetails.CopyTo(DebitPaymentDetails);
}
if (arrCashPaymentDetails.Count > 0)
for (Int32 i = 0; i < arrCashPaymentDetails.Count;i++ )
{
CashPaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
CashPaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
CashPaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
CashPaymentDetails[i].TerminalNo = mclsSalesTransactionDetails.TerminalNo;
}
if (arrChequePaymentDetails.Count > 0)
for (Int32 i = 0; i < arrChequePaymentDetails.Count; i++)
{
ChequePaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
ChequePaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
ChequePaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
ChequePaymentDetails[i].TerminalNo = mclsTerminalDetails.TerminalNo;
}
if (arrCreditCardPaymentDetails.Count > 0)
for (Int32 i = 0; i < arrCreditCardPaymentDetails.Count; i++)
{
CreditCardPaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
CreditCardPaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
CreditCardPaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
CreditCardPaymentDetails[i].TerminalNo = mclsTerminalDetails.TerminalNo;
}
if (arrCreditPaymentDetails != null && arrCreditPaymentDetails.Count > 0)
for (Int32 i = 0; i < arrCreditPaymentDetails.Count; i++)
{
CreditPaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
CreditPaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
CreditPaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
CreditPaymentDetails[i].TerminalNo = mclsTerminalDetails.TerminalNo;
}
if (arrDebitPaymentDetails != null && arrDebitPaymentDetails.Count > 0)
for (Int32 i = 0; i < arrDebitPaymentDetails.Count; i++)
{
DebitPaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
DebitPaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
DebitPaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
DebitPaymentDetails[i].TerminalNo = mclsTerminalDetails.TerminalNo;
}
Data.PaymentDetails Details = new Data.PaymentDetails();
Details.BranchID = mclsTerminalDetails.BranchDetails.BranchID;
Details.TransactionID = mclsSalesTransactionDetails.TransactionID;
Details.arrCashPaymentDetails = CashPaymentDetails;
Details.arrChequePaymentDetails = ChequePaymentDetails;
Details.arrCreditCardPaymentDetails = CreditCardPaymentDetails;
Details.arrCreditPaymentDetails = CreditPaymentDetails;
Details.arrDebitPaymentDetails = DebitPaymentDetails;
return Details;
}
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 SaveCreditCardPayment(Data.Payment pvtclsPayment, ArrayList pvtarrCreditCardPaymentDetails)
{
int itemIndex = 0;
Data.CreditCardPaymentDetails[] CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[0];
if (pvtarrCreditCardPaymentDetails != null)
{
CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[pvtarrCreditCardPaymentDetails.Count];
pvtarrCreditCardPaymentDetails.CopyTo(CreditCardPaymentDetails);
}
foreach (Data.CreditCardPaymentDetails det in CreditCardPaymentDetails)
{
string strRemarks = "PAID BY:" + mclsCustomerDetails.ContactName + " PAYMENTTYPE:CreditCard DATE:" + DateTime.Now.ToString("MM-dd-yyyy hh:mm:ss tt");
if (det.Remarks != null) strRemarks += Environment.NewLine + det.Remarks;
decimal decRemainingAmountPaid = det.Amount;
System.Data.DataTable dt = (System.Data.DataTable) dgItems.DataSource;
foreach(System.Data.DataRow dr in dt.Rows)
{
long lngTransactionID = Convert.ToInt64(dr["TransactionID"]);
string strTransactionNo = dr["TransactionNo"].ToString();
decimal decBalance = Convert.ToDecimal(dr["Balance"]);
if (decRemainingAmountPaid >= decBalance)
{
InsertCreditCardPayment(pvtclsPayment, lngTransactionID, strTransactionNo, decBalance, det.CardTypeID, det.CardNo, det.CardHolder, det.ValidityDates, strRemarks);
dgItems.Select(itemIndex);
dr["CreditPaid"] = decBalance.ToString("#,##0.#0");
dr["Balance"] = "0.00";
decRemainingAmountPaid -= decBalance;
}
else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance)
{
InsertCreditCardPayment(pvtclsPayment, lngTransactionID, strTransactionNo, decRemainingAmountPaid, det.CardTypeID, det.CardNo, det.CardHolder, det.ValidityDates, strRemarks);
dgItems.Select(itemIndex);
dr["CreditPaid"] = decRemainingAmountPaid.ToString("#,##0.#0");
dr["Balance"] = Convert.ToDecimal(decBalance - decRemainingAmountPaid).ToString("#,##0.#0");
decRemainingAmountPaid =0;
break;
}
itemIndex++;
}
this.dgStyle.MappingName = dt.TableName;
dgItems.DataSource = dt;
if (dt.Rows.Count > 0)
{
dgItems.Select(0);
dgItems.CurrentRowIndex=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 SaveCreditCardPayment(Data.Payment clsPayment, ArrayList pvtarrCreditCardPaymentDetails)
{
Data.CreditCardPaymentDetails[] CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[0];
if (pvtarrCreditCardPaymentDetails != null)
{
CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[pvtarrCreditCardPaymentDetails.Count];
pvtarrCreditCardPaymentDetails.CopyTo(CreditCardPaymentDetails);
}
foreach (Data.CreditCardPaymentDetails det in CreditCardPaymentDetails)
{
string strRemarks = "PAID BY:" + mclsCustomerDetails.ContactName + " PAYMENTTYPE:CreditCard DATE:" + DateTime.Now.ToString("MM-dd-yyyy hh:mm:ss tt");
if (det.Remarks != null) strRemarks += Environment.NewLine + det.Remarks;
decimal decRemainingAmountPaid = det.Amount;
foreach(DataGridViewRow dr in dgvItems.SelectedRows)
{
Int64 lngTransactionID = Convert.ToInt64(dr.Cells["TransactionID"].Value.ToString());
string strTransactionNo = dr.Cells["TransactionNo"].Value.ToString();
decimal decBalance = Convert.ToDecimal(dr.Cells["Balance"].Value.ToString());
if (decRemainingAmountPaid >= decBalance)
{
InsertCreditCardPayment(clsPayment, lngTransactionID, strTransactionNo, decBalance, det.CardTypeID, det.CardNo, det.CardHolder, det.ValidityDates, strRemarks);
//dgItems.Select(itemIndex);
dr.Cells["CreditPaid"].Value = decBalance;
dr.Cells["Balance"].Value = 0;
decRemainingAmountPaid -= decBalance;
}
else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance)
{
InsertCreditCardPayment(clsPayment, lngTransactionID, strTransactionNo, decRemainingAmountPaid, det.CardTypeID, det.CardNo, det.CardHolder, det.ValidityDates, strRemarks);
//dgItems.Select(itemIndex);
dr.Cells["CreditPaid"].Value = decRemainingAmountPaid;
dr.Cells["Balance"].Value = decBalance - decRemainingAmountPaid;
decRemainingAmountPaid =0;
break;
}
}
}
}
