Exemple #1
0
        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;
                }
            }
        }
Exemple #2
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);
        }
Exemple #3
0
        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);
        }
Exemple #4
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;
                    }
                }
            }
        }
Exemple #5
0
        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;
        }
Exemple #7
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);
		}
Exemple #8
0
		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 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;
                    }
                }
			}
		}
Exemple #11
0
        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;
        }