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; } } } }