Exemplo n.º 1
0
        public int OpenAmountsupplDetailsInsertUpdateMaster(ReceivedTransaction objOpenAmountDetails)
        {
            Hashtable htparams = new Hashtable
            {
                { "@SupplTypeId", objOpenAmountDetails.SupplTypeId },
                { "@SupplNameId", objOpenAmountDetails.SupplNameId },
                { "@ReceiptAmount", objOpenAmountDetails.ReceiptAmount },
                { "@PrvOpenAmount", objOpenAmountDetails.PrvOpenAmount },
                { "@AlocatedAmount", objOpenAmountDetails.AlocatedAmount },
                { "@PaymentOpenAmount", objOpenAmountDetails.PaymentOpenAmount },
                { "@SourceRef", objOpenAmountDetails.SourceRef },
                { "@PaymentType", objOpenAmountDetails.PaymentType },
                { "@FromAccount", objOpenAmountDetails.FromAccount },
                { "@ToAccount", objOpenAmountDetails.ToAccount },
                { "@CreatedBy", objOpenAmountDetails.CreatedBy }
            };

            return(ExecuteNonQuery("OpenAmountSupplDetails_insert", htparams));
        }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            foreach (GridViewRow row in gvData.Rows)
            {
                if (row.RowType == DataControlRowType.DataRow)
                {
                    TextBox     txtThisEntry = row.FindControl("txtThisEntry") as TextBox;
                    HiddenField hfTicketId   = row.FindControl("hfTicketId") as HiddenField;
                    HiddenField hfInvId      = row.FindControl("hfInvId") as HiddenField;


                    if (!_objBOUtiltiy.TryParseCheckValue(txtThisEntry.Text, "Decimal"))
                    {
                        txtThisEntry.Text = "0";
                    }

                    if (txtThisEntry.Text != "" && txtThisEntry.Text != "0" && txtThisEntry.Text != "0.00")
                    {
                        PaymentTransaction objTransactionMaster = new PaymentTransaction();

                        objTransactionMaster.TicketId               = Convert.ToInt32(hfTicketId.Value);
                        objTransactionMaster.InvoiceId              = Convert.ToInt32(hfInvId.Value);
                        objTransactionMaster.Divission              = ddlDivision.SelectedValue;
                        objTransactionMaster.PaymentType            = ddlPaymentType.SelectedValue;
                        objTransactionMaster.AutoDepositeId         = Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue);
                        objTransactionMaster.AutoDepositeAccountNo  = ddlAutoDepositeAccount.SelectedItem.Text;
                        objTransactionMaster.ClientSupplTypeId      = Convert.ToInt32(ddlAccType.SelectedValue);
                        objTransactionMaster.ClientSupplAccountNo   = ddlAccountNo.SelectedItem.Text;
                        objTransactionMaster.ClientSupplAccountNoID = Convert.ToInt32(ddlAccountNo.SelectedValue);
                        objTransactionMaster.PayeeDetails           = txtPayeeDetails.Text;
                        objTransactionMaster.PaymentAmount          = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;
                        objTransactionMaster.PrvClientOpenAmount    = Convert.ToDecimal(lblPrvClientOpenAmount.Text);
                        objTransactionMaster.PaymentBalanceAmount   = Convert.ToDecimal(lblReceiptOpenAmount.Text);
                        objTransactionMaster.AllocatedAmount        = txtThisEntry.Text != "" ? Convert.ToDecimal(txtThisEntry.Text) : 0;
                        objTransactionMaster.InvoiceBalanceAmount   = Convert.ToDecimal(row.Cells[6].Text);
                        objTransactionMaster.Details  = txtDetails.Text;
                        objTransactionMaster.Messages = txtMessage.Text;

                        objTransactionMaster.CreatedBy        = Convert.ToInt32(Session["UserLoginId"]);
                        objTransactionMaster.PaymentSourceRef = txtSourceRef.Text;
                        objTransactionMaster.categoryName     = ddlAccType.SelectedItem.Text;
                        _objBALTransactions.PaymentTransactionInsert(objTransactionMaster);
                    }
                }
            }



            ReceivedTransaction objOpenAmountDetails = new ReceivedTransaction();
            objOpenAmountDetails.SupplTypeId       = Convert.ToInt32(ddlAccType.SelectedValue);
            objOpenAmountDetails.SupplNameId       = Convert.ToInt32(ddlAccountNo.SelectedValue);
            objOpenAmountDetails.ReceiptAmount     = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;;
            objOpenAmountDetails.PrvOpenAmount     = lblPrvClientOpenAmount.Text != "" ? Convert.ToDecimal(lblPrvClientOpenAmount.Text) : 0;
            objOpenAmountDetails.AlocatedAmount    = lblAllocatedAmount.Text != "" ? Convert.ToDecimal(lblAllocatedAmount.Text) : 0;
            objOpenAmountDetails.PaymentOpenAmount = lblReceiptOpenAmount.Text != "" ? Convert.ToDecimal(lblReceiptOpenAmount.Text) : 0;
            objOpenAmountDetails.SourceRef         = txtSourceRef.Text;
            objOpenAmountDetails.PaymentType       = ddlPaymentType.SelectedItem.Text;
            objOpenAmountDetails.FromAccount       = ddlAutoDepositeAccount.SelectedItem.Text;
            objOpenAmountDetails.ToAccount         = ddlAccountNo.SelectedItem.Text;
            objOpenAmountDetails.CreatedBy         = Convert.ToInt32(Session["UserLoginId"]);
            int result = _objBALTransactions.OpenAmountSupplDetailsInsertUpdateMaster(objOpenAmountDetails);
            if (result > 0)
            {
                Response.Redirect("PaymentTransactionList.aspx");
            }
            PaymentTransactionClear();
        }
        catch (Exception ex)
        {
            lblMsg.Text = _objBOUtiltiy.ShowMessage("danger", "error", ex.Message);
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            foreach (GridViewRow row in gvData.Rows)
            {
                if (row.RowType == DataControlRowType.DataRow)
                {
                    TextBox     txtThisEntry = row.FindControl("txtThisEntry") as TextBox;
                    HiddenField hfTicketId   = row.FindControl("hfTicketId") as HiddenField;
                    HiddenField hfInvId      = row.FindControl("hfInvId") as HiddenField;



                    if (!_objBOUtiltiy.TryParseCheckValue(txtThisEntry.Text, "Decimal"))
                    {
                        txtThisEntry.Text = "0";
                    }

                    if (txtThisEntry.Text != "" && txtThisEntry.Text != "0" && txtThisEntry.Text != "0.00")
                    {
                        PaymentTransaction objTransactionMaster = new PaymentTransaction();

                        objTransactionMaster.TicketId              = Convert.ToInt32(hfTicketId.Value);
                        objTransactionMaster.InvoiceId             = Convert.ToInt32(hfInvId.Value);
                        objTransactionMaster.Divission             = ddlDivision.SelectedValue;
                        objTransactionMaster.PaymentType           = ddlPaymentType.SelectedValue;
                        objTransactionMaster.AutoDepositeId        = Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue);
                        objTransactionMaster.AutoDepositeAccountNo = ddlAutoDepositeAccount.SelectedItem.Text;
                        objTransactionMaster.ClientSupplTypeId     = Convert.ToInt32(ddlAccType.SelectedValue);
                        if (Convert.ToInt32(ddlAccountNo.SelectedValue) == 0)
                        {
                            objTransactionMaster.ClientSupplAccountNo = " ";
                        }
                        else
                        {
                            objTransactionMaster.ClientSupplAccountNo = ddlAccountNo.SelectedItem.Text;
                        }

                        objTransactionMaster.ClientSupplAccountNoID = Convert.ToInt32(ddlAccountNo.SelectedValue);
                        objTransactionMaster.PayeeDetails           = txtPayeeDetails.Text;
                        objTransactionMaster.PaymentAmount          = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;
                        objTransactionMaster.PrvClientOpenAmount    = Convert.ToDecimal(lblPrvClientOpenAmount.Text);
                        objTransactionMaster.PaymentBalanceAmount   = Convert.ToDecimal(lblReceiptOpenAmount.Text);
                        objTransactionMaster.AllocatedAmount        = txtThisEntry.Text != "" ? Convert.ToDecimal(txtThisEntry.Text) : 0;
                        objTransactionMaster.InvoiceBalanceAmount   = Convert.ToDecimal(row.Cells[6].Text);
                        objTransactionMaster.Details          = txtDetails.Text;
                        objTransactionMaster.Messages         = txtMessage.Text;
                        objTransactionMaster.CreatedBy        = Convert.ToInt32(Session["UserLoginId"]);
                        objTransactionMaster.PaymentSourceRef = txtSourceRef.Text;
                        objTransactionMaster.categoryName     = ddlAccType.SelectedItem.Text;
                        objTransactionMaster.MainAccount      = lblMainAcc.Text;
                        objTransactionMaster.CategoryId       = Convert.ToInt32(ddlAccType.SelectedValue.ToString());
                        _objBALTransactions.PaymentTransactionInsert(objTransactionMaster);
                    }
                }
            }


            Transaction objTransaction = new Transaction();
            int         FmAccountNoId  = 0;
            objTransaction.FmAccountNoId        = 0;
            objTransaction.ReferenceAccountNoId = Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue);
            string  category = ddlAccType.SelectedItem.Text;
            DataSet ds       = _objBALTransactions.Transaction_GetAccountsData(FmAccountNoId, Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue), "PT", category);

            List <string> FmAcccode     = new List <string>();
            List <string> FmMainAccCode = new List <string>();
            List <string> RefMainAcc    = new List <string>();
            List <string> RefAccCode    = new List <string>();
            List <string> AllocateAmt   = new List <string>();

            if (ds.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow dtlRow in ds.Tables[0].Rows)
                {
                    FmAcccode.Add(dtlRow["AccCode"].ToString());
                    FmMainAccCode.Add(dtlRow["MainAccCode"].ToString());
                    AllocateAmt.Add(dtlRow["AllocatedAmount"].ToString());
                }
            }
            if (ds.Tables[1].Rows.Count > 0)
            {
                foreach (DataRow dtlRow in ds.Tables[1].Rows)
                {
                    RefAccCode.Add(dtlRow["BankAcNo"].ToString());
                    RefMainAcc.Add(dtlRow["MainAccCode"].ToString());
                }
            }
            int count = FmAcccode.Count;

            for (int i = 0; i <= count - 1; i++)
            {
                objTransaction.DebitAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;
                objTransaction.FmAccountNO = FmAcccode[i].ToString();
                //objTransaction.MainAccount = FmMainAccCode[i].ToString();
                objTransaction.ReferenceAccountNO = RefAccCode[i].ToString();
                objTransaction.CreditAmount       = 0;
                objTransaction.ReferenceNo        = txtSourceRef.Text;
                // objTransaction.InvoiceId = Convert.ToInt32(hfInvId.Value);
                // objTransaction.InvoiceNo = "";

                objTransaction.ReferenceType = "PT";
                objTransaction.CreatedBy     = 0;

                objTransaction.BalanceAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;
                _objBALTransactions.TransactionInsert(objTransaction);



                objTransaction.CreditAmount = Convert.ToDecimal(AllocateAmt[i].ToString());
                objTransaction.FmAccountNO  = RefAccCode[i].ToString();
                // objTransaction.MainAccount = RefMainAcc[i].ToString();
                objTransaction.ReferenceAccountNO = FmAcccode[i].ToString();
                objTransaction.DebitAmount        = 0;
                objTransaction.ReferenceNo        = txtSourceRef.Text;

                objTransaction.ReferenceType = "PT";
                objTransaction.CreatedBy     = 0;

                objTransaction.BalanceAmount = Convert.ToDecimal(lblReceiptOpenAmount.Text);
                _objBALTransactions.TransactionInsert(objTransaction);
            }



            ReceivedTransaction objOpenAmountDetails = new ReceivedTransaction();
            objOpenAmountDetails.SupplTypeId       = Convert.ToInt32(ddlAccType.SelectedValue);
            objOpenAmountDetails.SupplNameId       = Convert.ToInt32(ddlAccountNo.SelectedValue);
            objOpenAmountDetails.ReceiptAmount     = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;;
            objOpenAmountDetails.PrvOpenAmount     = lblPrvClientOpenAmount.Text != "" ? Convert.ToDecimal(lblPrvClientOpenAmount.Text) : 0;
            objOpenAmountDetails.AlocatedAmount    = lblAllocatedAmount.Text != "" ? Convert.ToDecimal(lblAllocatedAmount.Text) : 0;
            objOpenAmountDetails.PaymentOpenAmount = lblReceiptOpenAmount.Text != "" ? Convert.ToDecimal(lblReceiptOpenAmount.Text) : 0;
            objOpenAmountDetails.SourceRef         = txtSourceRef.Text;
            objOpenAmountDetails.PaymentType       = ddlPaymentType.SelectedItem.Text;
            objOpenAmountDetails.FromAccount       = ddlAutoDepositeAccount.SelectedItem.Text;
            objOpenAmountDetails.ToAccount         = ddlAccountNo.SelectedItem.Text;
            objOpenAmountDetails.CreatedBy         = Convert.ToInt32(Session["UserLoginId"]);
            int result = _objBALTransactions.OpenAmountSupplDetailsInsertUpdateMaster(objOpenAmountDetails);
            if (result > 0)
            {
                Response.Redirect("PaymentTransactionList.aspx");
            }
            PaymentTransactionClear();
        }
        catch (Exception ex)
        {
            lblMsg.Text = _objBOUtiltiy.ShowMessage("danger", "error", ex.Message);
            ExceptionLogging.SendExcepToDB(ex);
        }
    }
Exemplo n.º 4
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        if (lblTotalAvailable.Text != "")
        {
            try
            {
                string categoryname = ddlAccType.SelectedItem.Text;


                foreach (GridViewRow row in gvCustomers.Rows)
                {
                    if (row.RowType == DataControlRowType.DataRow)
                    {
                        TextBox     txtThisEntry = row.FindControl("txtThisEntry") as TextBox;
                        HiddenField hfTicketId   = row.FindControl("hfTicketId") as HiddenField;
                        HiddenField hfInvId      = row.FindControl("hfInvId") as HiddenField;

                        string   s             = hfTicketId.Value;
                        string   invid         = hfInvId.Value;
                        string[] values        = s.Split(',');
                        string[] InvidValue    = invid.Split(',');
                        decimal  paymentamount = 0;
                        paymentamount = Convert.ToDecimal(txtAmount.Text);

                        for (int i = 0; i < values.Length; i++)
                        {
                            for (int j = i; j < InvidValue.Length; j++)
                            {
                                values[i]     = values[i].Trim();
                                InvidValue[j] = InvidValue[j].Trim();

                                if (!_objBOUtiltiy.TryParseCheckValue(txtThisEntry.Text, "Decimal"))
                                {
                                    txtThisEntry.Text = "0";
                                }

                                if (txtThisEntry.Text != "" && txtThisEntry.Text != "0" && txtThisEntry.Text != "0.00")
                                {
                                    PaymentTransaction objTransactionMaster = new PaymentTransaction();
                                    int status = 0;


                                    DataSet dsobj = _objBALInvoice.GetSupplierOpeningAmount(Convert.ToInt32(values[i].ToString()), Convert.ToInt32(InvidValue[j].ToString()), status, categoryname);
                                    decimal openingAmount = 0; decimal duetoBsp = 0;
                                    if (dsobj.Tables.Count > 0 && dsobj.Tables[0].Rows.Count > 0)
                                    {
                                        openingAmount = Convert.ToDecimal(dsobj.Tables[0].Rows[0]["SupplOpeningAmount"].ToString());
                                        duetoBsp      = Convert.ToDecimal(dsobj.Tables[0].Rows[0]["Bsp"].ToString());



                                        if (openingAmount <= paymentamount)
                                        {
                                            objTransactionMaster.AllocatedAmount      = openingAmount;
                                            objTransactionMaster.InvoiceBalanceAmount = openingAmount - openingAmount;

                                            paymentamount = paymentamount - openingAmount;
                                            objTransactionMaster.PaymentBalanceAmount = paymentamount;
                                        }
                                        else if (Convert.ToDecimal(txtThisEntry.Text) >= paymentamount)
                                        {
                                            objTransactionMaster.AllocatedAmount = paymentamount;

                                            objTransactionMaster.InvoiceBalanceAmount = openingAmount - paymentamount;

                                            objTransactionMaster.PaymentBalanceAmount = paymentamount - paymentamount;
                                        }

                                        objTransactionMaster.TicketId              = Convert.ToInt32(values[i].ToString());
                                        objTransactionMaster.InvoiceId             = Convert.ToInt32(InvidValue[j].ToString());
                                        objTransactionMaster.Divission             = ddlDivision.SelectedValue;
                                        objTransactionMaster.PaymentType           = ddlPaymentType.SelectedValue;
                                        objTransactionMaster.AutoDepositeId        = Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue);
                                        objTransactionMaster.AutoDepositeAccountNo = ddlAutoDepositeAccount.SelectedItem.Text;
                                        objTransactionMaster.ClientSupplTypeId     = Convert.ToInt32(ddlAccType.SelectedValue);
                                        if (Convert.ToInt32(ddlAccountNo.SelectedValue) == 0)
                                        {
                                            objTransactionMaster.ClientSupplAccountNo = " ";
                                        }
                                        else
                                        {
                                            objTransactionMaster.ClientSupplAccountNo = ddlAccountNo.SelectedItem.Text;
                                        }

                                        objTransactionMaster.ClientSupplAccountNoID = Convert.ToInt32(ddlAccountNo.SelectedValue);
                                        objTransactionMaster.PayeeDetails           = txtPayeeDetails.Text;
                                        objTransactionMaster.PaymentAmount          = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;
                                        //objTransactionMaster.PrvClientOpenAmount = Convert.ToDecimal(lblPrvClientOpenAmount.Text);

                                        objTransactionMaster.Details          = txtDetails.Text;
                                        objTransactionMaster.Messages         = txtMessage.Text;
                                        objTransactionMaster.CreatedBy        = Convert.ToInt32(Session["UserLoginId"]);
                                        objTransactionMaster.PaymentSourceRef = txtSourceRef.Text;
                                        objTransactionMaster.categoryName     = ddlAccType.SelectedItem.Text;
                                        objTransactionMaster.MainAccount      = lblMainAcc.Text;
                                        objTransactionMaster.CategoryId       = Convert.ToInt32(ddlAccType.SelectedValue.ToString());
                                        _objBALTransactions.PaymentTransactionInsert(objTransactionMaster);
                                    }
                                }
                            }
                        }
                    }
                }


                Transaction objTransaction = new Transaction();

                objTransaction.FmAccountNoId        = Convert.ToInt32(ddlAutoDepositeAccount.SelectedItem.Value.ToString());
                objTransaction.ReferenceAccountNoId = Convert.ToInt32(ddlAccountNo.SelectedItem.Value.ToString());
                string  category = ddlAccType.SelectedItem.Text;
                DataSet ds       = _objBALTransactions.Transaction_GetAccountsData(Convert.ToInt32(ddlAutoDepositeAccount.SelectedItem.Value.ToString()),
                                                                                   Convert.ToInt32(ddlAccountNo.SelectedItem.Value.ToString()), "PT", category);
                string FmAcccode     = "";
                string FmMainAccCode = "";

                string RefMainAcc = "";
                string RefAccCode = "";

                if (ds.Tables[0].Rows.Count > 0)
                {
                    RefAccCode = ds.Tables[0].Rows[0]["AccCode"].ToString();
                    RefMainAcc = ds.Tables[0].Rows[0]["MainAccCode"].ToString();
                }

                if (ds.Tables[1].Rows.Count > 0)
                {
                    FmAcccode     = ds.Tables[1].Rows[0]["BankGiAccount"].ToString();
                    FmMainAccCode = ds.Tables[1].Rows[0]["MainAccCode"].ToString();
                }


                objTransaction.CreditAmount       = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;
                objTransaction.FmAccountNO        = FmAcccode;
                objTransaction.FmMainAccount      = FmMainAccCode;
                objTransaction.ReferenceAccountNO = RefAccCode;
                objTransaction.DebitAmount        = 0;
                objTransaction.ReferenceNo        = txtSourceRef.Text;
                objTransaction.ToMainAccount      = RefMainAcc;
                // objTransaction.InvoiceId = Convert.ToInt32(hfInvId.Value);
                // objTransaction.InvoiceNo = "";

                objTransaction.ReferenceType = "PT";
                objTransaction.CreatedBy     = 0;

                objTransaction.BalanceAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;
                _objBALTransactions.TransactionInsert(objTransaction);


                //Transaction objTransaction = new Transaction();
                //int FmAccountNoId = 0;
                //objTransaction.FmAccountNoId = Convert.ToInt32(ddlAutoDepositeAccount.SelectedItem.Value.ToString());
                //objTransaction.ReferenceAccountNoId = Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue);
                //string category = ddlAccType.SelectedItem.Text;
                //DataSet ds = _objBALTransactions.Transaction_GetAccountsData(FmAccountNoId, Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue), "PT", category);

                //List<string> FmAcccode = new List<string>();
                //List<string> FmMainAccCode = new List<string>();
                //List<string> RefMainAcc = new List<string>();
                //List<string> RefAccCode = new List<string>();
                //List<string> AllocateAmt = new List<string>();

                //if (ds.Tables[0].Rows.Count > 0)
                //{
                //    foreach (DataRow dtlRow in ds.Tables[0].Rows)
                //    {
                //        FmAcccode.Add(dtlRow["AccCode"].ToString());
                //        FmMainAccCode.Add(dtlRow["MainAccCode"].ToString());
                //        AllocateAmt.Add(dtlRow["AllocatedAmount"].ToString());
                //    }
                //}
                //if (ds.Tables[1].Rows.Count > 0)
                //{
                //    foreach (DataRow dtlRow in ds.Tables[1].Rows)
                //    {
                //        RefAccCode.Add(dtlRow["BankAcNo"].ToString());
                //        RefMainAcc.Add(dtlRow["MainAccCode"].ToString());
                //    }
                //}
                //int count = FmAcccode.Count;

                //for (int i = 0; i <= count - 1; i++)
                //{
                //    objTransaction.DebitAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;
                //    objTransaction.FmAccountNO = FmAcccode[i].ToString();
                //    objTransaction.MainAccount = FmMainAccCode[i].ToString();
                //    objTransaction.ReferenceAccountNO = RefAccCode[i].ToString();
                //    objTransaction.CreditAmount = 0;
                //    objTransaction.ReferenceNo = txtSourceRef.Text;
                //    // objTransaction.InvoiceId = Convert.ToInt32(hfInvId.Value);
                //    // objTransaction.InvoiceNo = "";

                //    objTransaction.ReferenceType = "PT";
                //    objTransaction.CreatedBy = 0;

                //    objTransaction.BalanceAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;
                //    _objBALTransactions.TransactionInsert(objTransaction);



                //    objTransaction.CreditAmount = Convert.ToDecimal(AllocateAmt[i].ToString());
                //    objTransaction.FmAccountNO = RefAccCode[i].ToString();
                //    objTransaction.MainAccount = RefMainAcc[i].ToString();
                //    objTransaction.ReferenceAccountNO = FmAcccode[i].ToString();
                //    objTransaction.DebitAmount = 0;
                //    objTransaction.ReferenceNo = txtSourceRef.Text;

                //    objTransaction.ReferenceType = "PT";
                //    objTransaction.CreatedBy = 0;

                //    objTransaction.BalanceAmount = Convert.ToDecimal(lblReceiptOpenAmount.Text);
                //    _objBALTransactions.TransactionInsert(objTransaction);


                //}


                ReceivedTransaction objOpenAmountDetails = new ReceivedTransaction();
                objOpenAmountDetails.SupplTypeId   = Convert.ToInt32(ddlAccType.SelectedValue);
                objOpenAmountDetails.SupplNameId   = Convert.ToInt32(ddlAccountNo.SelectedValue);
                objOpenAmountDetails.ReceiptAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0;;
                //  objOpenAmountDetails.PrvOpenAmount = lblPrvClientOpenAmount.Text != "" ? Convert.ToDecimal(lblPrvClientOpenAmount.Text) : 0;
                objOpenAmountDetails.AlocatedAmount    = lblAllocatedAmount.Text != "" ? Convert.ToDecimal(lblAllocatedAmount.Text) : 0;
                objOpenAmountDetails.PaymentOpenAmount = lblReceiptOpenAmount.Text != "" ? Convert.ToDecimal(lblReceiptOpenAmount.Text) : 0;
                objOpenAmountDetails.SourceRef         = txtSourceRef.Text;
                objOpenAmountDetails.PaymentType       = ddlPaymentType.SelectedItem.Text;
                objOpenAmountDetails.FromAccount       = ddlAutoDepositeAccount.SelectedItem.Text;
                objOpenAmountDetails.ToAccount         = ddlAccountNo.SelectedItem.Text;
                objOpenAmountDetails.CreatedBy         = Convert.ToInt32(Session["UserLoginId"]);
                int result = _objBALTransactions.OpenAmountSupplDetailsInsertUpdateMaster(objOpenAmountDetails);
                if (result > 0)
                {
                    Response.Redirect("PaymentTransactionList.aspx");
                }
                PaymentTransactionClear();
            }

            catch (Exception ex)
            {
                lblMsg.Text = _objBOUtiltiy.ShowMessage("danger", "error", ex.Message);
                ExceptionLogging.SendExcepToDB(ex);
            }
        }
        else
        {
            ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(),
                                                    "Msg", "alert('Please Allocate Current Amount');", true);
        }
    }
Exemplo n.º 5
0
 public int OpenAmountSupplDetailsInsertUpdateMaster(ReceivedTransaction objOpenAmountDetails)
 {
     return(_objDALTransactions.OpenAmountsupplDetailsInsertUpdateMaster(objOpenAmountDetails));
 }