private void SaveCashPayment(Data.Payment pvtclsPayment, ArrayList pvtarrCashPaymentDetails) { int itemIndex = 0; Data.CashPaymentDetails[] CashPaymentDetails = new Data.CashPaymentDetails[0]; if (pvtarrCashPaymentDetails != null) { CashPaymentDetails = new Data.CashPaymentDetails[pvtarrCashPaymentDetails.Count]; pvtarrCashPaymentDetails.CopyTo(CashPaymentDetails); } foreach (Data.CashPaymentDetails det in CashPaymentDetails) { string strRemarks = "PAID BY:" + mclsCustomerDetails.ContactName + " PAYMENTTYPE:Cash 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) { InsertCashPayment(pvtclsPayment, lngTransactionID, strTransactionNo, decBalance, strRemarks); dgItems.Select(itemIndex); dr["CreditPaid"] = decBalance.ToString("#,##0.#0"); dr["Balance"] = "0.00"; decRemainingAmountPaid -= decBalance; } else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance) { InsertCashPayment(pvtclsPayment, lngTransactionID, strTransactionNo, decRemainingAmountPaid, 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 InsertCashPayment(Data.Payment pvtclsPayment, long pvtlngTransactionID, string pvtstrTransactionNo, decimal pvtdecAmount, string pvtstrRemarks) { Data.CashPaymentDetails Details = new Data.CashPaymentDetails(); Details.TransactionID = pvtlngTransactionID; Details.TransactionNo = pvtstrTransactionNo; Details.Amount = pvtdecAmount; Details.Remarks = pvtstrRemarks; pvtclsPayment.InsertCashPayment(Details); pvtclsPayment.UpdateCredit(mclsCustomerDetails.ContactID, pvtlngTransactionID, pvtstrTransactionNo, pvtdecAmount, pvtstrRemarks); }
private void InsertCashPayment(Data.Payment clsPayment, Int64 intTransactionID, string strTransactionNo, decimal decAmount, string strRemarks) { Data.CashPaymentDetails Details = new Data.CashPaymentDetails(); Details.BranchDetails = mclsTerminalDetails.BranchDetails; Details.TerminalNo = mclsTerminalDetails.TerminalNo; Details.TransactionID = intTransactionID; Details.TransactionNo = strTransactionNo; Details.Amount = decAmount; Details.Remarks = strRemarks; new Data.CashPayments(clsPayment.Connection, clsPayment.Transaction).Insert(Details); clsPayment.UpdateCredit(mclsCustomerDetails.ContactID, intTransactionID, strTransactionNo, decAmount, strRemarks); }
private void SaveCashPayment(Data.Payment clsPayment, ArrayList pvtarrCashPaymentDetails) { Data.CashPaymentDetails[] CashPaymentDetails = new Data.CashPaymentDetails[0]; if (pvtarrCashPaymentDetails != null) { CashPaymentDetails = new Data.CashPaymentDetails[pvtarrCashPaymentDetails.Count]; pvtarrCashPaymentDetails.CopyTo(CashPaymentDetails); } foreach (Data.CashPaymentDetails det in CashPaymentDetails) { string strRemarks = "PAID BY:" + mclsCustomerDetails.ContactName + " PAYMENTTYPE:Cash 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) { InsertCashPayment(clsPayment, lngTransactionID, strTransactionNo, decBalance, strRemarks); dr.Cells["CreditPaid"].Value = decBalance; dr.Cells["Balance"].Value = 0; decRemainingAmountPaid -= decBalance; } else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance) { InsertCashPayment(clsPayment, lngTransactionID, strTransactionNo, decRemainingAmountPaid, strRemarks); //dgvItems.Select(itemIndex); dr.Cells["CreditPaid"].Value = decRemainingAmountPaid; dr.Cells["Balance"].Value = decBalance - decRemainingAmountPaid; decRemainingAmountPaid = 0; break; } } } }
public CashPaymentDetails setDetails(System.Data.DataRow dr) { Data.CashPaymentDetails Details = new Data.CashPaymentDetails(); 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.CashPaymentID = Int64.Parse(dr["CashPaymentID"].ToString()); Details.TransactionID = Int64.Parse(dr["TransactionID"].ToString()); Details.Amount = decimal.Parse(dr["Amount"].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()); 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 SaveCashPayment(Data.Payment pvtclsPayment, ArrayList pvtarrCashPaymentDetails) { int itemIndex = 0; Data.CashPaymentDetails[] CashPaymentDetails = new Data.CashPaymentDetails[0]; if (pvtarrCashPaymentDetails != null) { CashPaymentDetails = new Data.CashPaymentDetails[pvtarrCashPaymentDetails.Count]; pvtarrCashPaymentDetails.CopyTo(CashPaymentDetails); } foreach (Data.CashPaymentDetails det in CashPaymentDetails) { string strRemarks = "PAID BY:" + mclsCustomerDetails.ContactName + " PAYMENTTYPE:Cash 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) { InsertCashPayment(pvtclsPayment, lngTransactionID, strTransactionNo, decBalance, strRemarks); dgItems.Select(itemIndex); dr["CreditPaid"] = decBalance.ToString("#,##0.#0"); dr["Balance"] = "0.00"; decRemainingAmountPaid -= decBalance; } else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance) { InsertCashPayment(pvtclsPayment, lngTransactionID, strTransactionNo, decRemainingAmountPaid, 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 SaveCashPayment(Data.Payment clsPayment, ArrayList pvtarrCashPaymentDetails) { Data.CashPaymentDetails[] CashPaymentDetails = new Data.CashPaymentDetails[0]; if (pvtarrCashPaymentDetails != null) { CashPaymentDetails = new Data.CashPaymentDetails[pvtarrCashPaymentDetails.Count]; pvtarrCashPaymentDetails.CopyTo(CashPaymentDetails); } foreach (Data.CashPaymentDetails det in CashPaymentDetails) { string strRemarks = "PAID BY:" + mclsCustomerDetails.ContactName + " PAYMENTTYPE:Cash 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) { InsertCashPayment(clsPayment, lngTransactionID, strTransactionNo, decBalance, strRemarks); dr.Cells["CreditPaid"].Value = decBalance; dr.Cells["Balance"].Value = 0; decRemainingAmountPaid -= decBalance; } else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance) { InsertCashPayment(clsPayment, lngTransactionID, strTransactionNo, decRemainingAmountPaid, strRemarks); //dgvItems.Select(itemIndex); dr.Cells["CreditPaid"].Value = decRemainingAmountPaid; dr.Cells["Balance"].Value = decBalance - decRemainingAmountPaid; decRemainingAmountPaid = 0; break; } } } }
public CashPaymentDetails setDetails(System.Data.DataRow dr) { Data.CashPaymentDetails Details = new Data.CashPaymentDetails(); 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.CashPaymentID = Int64.Parse(dr["CashPaymentID"].ToString()); Details.TransactionID = Int64.Parse(dr["TransactionID"].ToString()); Details.Amount = decimal.Parse(dr["Amount"].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()); return Details; }