public int OpenAmountDetailsInsertUpdateMaster(OpenAmountDetails objOpenAmountDetails) { Hashtable htparams = new Hashtable { { "@ClientTypeId", objOpenAmountDetails.ClientTypeId }, { "@ClientNameId", objOpenAmountDetails.ClientNameId }, { "@ReceiptAmount", objOpenAmountDetails.ReceiptAmount }, { "@PrvOpenAmount", objOpenAmountDetails.PrvOpenAmount }, { "@AlocatedAmount", objOpenAmountDetails.AlocatedAmount }, { "@ReceiptOpenAmount", objOpenAmountDetails.ReceiptOpenAmount }, { "@SourceRef", objOpenAmountDetails.SourceRef }, { "@ReceiptType", objOpenAmountDetails.ReceiptType }, { "@FromAccount", objOpenAmountDetails.FromAccount }, { "@ToAccount", objOpenAmountDetails.ToAccount }, { "@CreatedBy", objOpenAmountDetails.CreatedBy } }; return(ExecuteNonQuery("OpenAmountDetails_insert", htparams)); }
protected void btnSave_Click(object sender, EventArgs e) { if (ChkAllocate.Checked == false) { ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "Msg", "alert('Please Allocate Current Amount');", true); } else { try { int Allocatedcount = 0; int result = 0; decimal ReceiptAmountAfterpaid = 0.0M; decimal PreviousAmountAfterpaid = 0.0M; foreach (GridViewRow row in gvData.Rows) { if (row.RowType == DataControlRowType.DataRow) { TextBox txtThisEntry = row.FindControl("txtThisEntry") as TextBox; 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") { Allocatedcount = Allocatedcount + 1; TransactionMaster objTransactionMaster = new TransactionMaster(); objTransactionMaster.InvoiceId = Convert.ToInt32(hfInvId.Value); objTransactionMaster.Divission = ddlDivision.SelectedValue; objTransactionMaster.ReceiptType = ddlReceiptType.SelectedValue; objTransactionMaster.AutoDepositeId = Convert.ToInt32(ddlAutoDepositeAccount.SelectedItem.Value); objTransactionMaster.AutoDepositeAccountNo = ddlAutoDepositeAccount.SelectedItem.Text; objTransactionMaster.ClientTypeId = Convert.ToInt32(ddlClientType.SelectedValue); objTransactionMaster.ClientAccountNo = ddlAccountNo.SelectedItem.Text; objTransactionMaster.ClientAccountNoID = Convert.ToInt32(ddlAccountNo.SelectedValue); objTransactionMaster.PayeeDetails = txtPayeeDetails.Text; objTransactionMaster.PrvClientOpenAmount = Convert.ToDecimal(lblPrvClientOpenAmount.Text); objTransactionMaster.AllocatedAmount = txtThisEntry.Text != "" ? Convert.ToDecimal(txtThisEntry.Text) : 0; objTransactionMaster.InvoiceBalanceAmount = Convert.ToDecimal(row.Cells[7].Text); objTransactionMaster.Details = txtDetails.Text; objTransactionMaster.Messages = txtMessage.Text; objTransactionMaster.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); objTransactionMaster.PaymentSourceRef = txtSourceRef.Text; objTransactionMaster.SuspenseAccId = 83; if (txtThisEntry.Text != "" || txtThisEntry.Text != "0" || txtThisEntry.Text != "0.00") { if (ReceiptAmountAfterpaid != 0 || ReceiptAmountAfterpaid != 0.0M) { objTransactionMaster.ReceiptAmount = ReceiptAmountAfterpaid; } else { objTransactionMaster.ReceiptAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0; } if (PreviousAmountAfterpaid != 0 || PreviousAmountAfterpaid != 0.0M) { objTransactionMaster.PrvClientOpenAmount = PreviousAmountAfterpaid; } else { objTransactionMaster.PrvClientOpenAmount = Convert.ToDecimal(lblPrvClientOpenAmount.Text); } if (objTransactionMaster.PrvClientOpenAmount > objTransactionMaster.AllocatedAmount) { objTransactionMaster.ReceiptAmountAfterPaid = objTransactionMaster.ReceiptAmount; PreviousAmountAfterpaid = Math.Abs(objTransactionMaster.PrvClientOpenAmount - objTransactionMaster.AllocatedAmount); } else { objTransactionMaster.ReceiptAmountAfterPaid = Math.Abs(objTransactionMaster.ReceiptAmount + objTransactionMaster.PrvClientOpenAmount - objTransactionMaster.AllocatedAmount); PreviousAmountAfterpaid = 0.0M; } ReceiptAmountAfterpaid = objTransactionMaster.ReceiptAmountAfterPaid; objTransactionMaster.ReceiptBalanceAmount = ReceiptAmountAfterpaid + PreviousAmountAfterpaid; } else { //objTransactionMaster.ReceiptAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0; ////if (objTransactionMaster.PrvClientOpenAmount != 0 || objTransactionMaster.PrvClientOpenAmount != 0.0M) ////{ //// objTransactionMaster.ReceiptAmount = objTransactionMaster.ReceiptAmount + objTransactionMaster.PrvClientOpenAmount; ////} //objTransactionMaster.ReceiptAmountAfterPaid =Math.Abs( objTransactionMaster.ReceiptAmount - objTransactionMaster.AllocatedAmount); ////objTransactionMaster.ReceiptAmountAfterPaid = objTransactionMaster.ReceiptAmountAfterPaid + objTransactionMaster.PrvClientOpenAmount != 0.0M ? Convert.ToDecimal(objTransactionMaster.PrvClientOpenAmount) : 0; //ReceiptAmountAfterpaid = objTransactionMaster.ReceiptAmountAfterPaid; //objTransactionMaster.ReceiptBalanceAmount = ReceiptAmountAfterpaid; } result = _objBALTransactions.ReceivedTransactionInsert(objTransactionMaster); } } } if (Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue) != 0) { Transaction objTransaction = new Transaction(); objTransaction.FmAccountNoId = Convert.ToInt32(ddlAccountNo.SelectedValue); objTransaction.ReferenceAccountNoId = Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue); string category = ""; DataSet ds = _objBALTransactions.Transaction_GetAccountsData(Convert.ToInt32(ddlAccountNo.SelectedValue), Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue), "RT", category); string FmAcccode = ""; string FmMainAccCode = ""; string RefMainAcc = ""; string RefAccCode = ""; if (ds.Tables[0].Rows.Count > 0) { FmAcccode = ds.Tables[0].Rows[0]["AccCode"].ToString(); FmMainAccCode = ds.Tables[0].Rows[0]["MainAccCode"].ToString(); } if (ds.Tables[1].Rows.Count > 0) { RefAccCode = ds.Tables[1].Rows[0]["BankGiAccount"].ToString(); RefMainAcc = ds.Tables[1].Rows[0]["MainAccCode"].ToString(); } objTransaction.DebitAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0; objTransaction.FmAccountNO = FmAcccode; objTransaction.FmMainAccount = FmMainAccCode; objTransaction.ReferenceAccountNO = RefAccCode; objTransaction.CreditAmount = 0; objTransaction.ReferenceNo = txtSourceRef.Text; objTransaction.ToMainAccount = RefMainAcc; // objTransaction.InvoiceId = Convert.ToInt32(hfInvId.Value); // objTransaction.InvoiceNo = ""; objTransaction.ReferenceType = "RT"; objTransaction.CreatedBy = 0; objTransaction.BalanceAmount = txtAmount.Text != "" ? Convert.ToDecimal(txtAmount.Text) : 0; _objBALTransactions.TransactionInsert(objTransaction); } //objTransaction.CreditAmount = lblAllocatedAmount.Text != "" ? Convert.ToDecimal(lblAllocatedAmount.Text) : 0; //objTransaction.FmAccountNO = RefAccCode; //objTransaction.MainAccount = RefMainAcc; //objTransaction.ReferenceAccountNO = FmAcccode; //objTransaction.DebitAmount = 0; //objTransaction.ReferenceNo = txtSourceRef.Text; //objTransaction.ReferenceType = "RT"; //objTransaction.CreatedBy = 0; //objTransaction.BalanceAmount = Convert.ToDecimal(lblReceiptOpenAmount.Text); //_objBALTransactions.TransactionInsert(objTransaction); if (ddlAutoDepositeAccount.SelectedValue != "0") { EmDepositMaster objEmDepositMaster = new EmDepositMaster(); objEmDepositMaster.DepositDate = Convert.ToDateTime(txtDate.Text); objEmDepositMaster.DepositClientPrefix = Convert.ToInt32(ddlClientType.SelectedValue); objEmDepositMaster.DepositComments = ""; objEmDepositMaster.DepositConsultant = Session["UserLoginId"].ToString(); objEmDepositMaster.DepositRecieptType = Convert.ToInt32(ddlReceiptType.SelectedValue); objEmDepositMaster.DepositSourceRef = txtSourceRef.Text; objEmDepositMaster.TotalRecieptsDeposited = Convert.ToInt32(Allocatedcount); objEmDepositMaster.TotalDepositAmount = Convert.ToDecimal(lblAllocatedAmount.Text); objEmDepositMaster.DepositAcId = Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue); BADepositTransaction objBADepositTransaction = new BADepositTransaction(); int DepositInsert = objBADepositTransaction.insertDepositMaster(objEmDepositMaster); if (DepositInsert > 0) { lblMsg.Text = _objBOUtiltiy.ShowMessage("success", "Success", "Deposit Added Successfully"); // clearcontrols(); foreach (GridViewRow Row in gvData.Rows) { if (Row.RowType == DataControlRowType.DataRow) { TextBox txtThisEntry = Row.FindControl("txtThisEntry") as TextBox; HiddenField hfInvId = Row.FindControl("hfInvId") as HiddenField; EMDepositChild objEMDepositChild = new EMDepositChild(); objEMDepositChild.ReceiptId = Convert.ToInt32(result); objEMDepositChild.RecieptDate = Convert.ToDateTime(txtDate.Text); objEMDepositChild.ReceiptType = ddlReceiptType.SelectedItem.Text; objEMDepositChild.ReciptClient = (ddlClientType.SelectedItem.Text); objEMDepositChild.ReceiptAmount = txtThisEntry.Text != "" ? Convert.ToDecimal(txtThisEntry.Text) : 0;; objEMDepositChild.InvoiceId = Convert.ToInt32(hfInvId.Value); objEMDepositChild.DepositAcId = Convert.ToInt32(ddlAutoDepositeAccount.SelectedValue); objEMDepositChild.DepositTransMasterId = DepositInsert; int childResult = objBADepositTransaction.insertDepositChild(objEMDepositChild); if (childResult > 0) { lblMsg.Text = _objBOUtiltiy.ShowMessage("success", "Success", "Deposit Added Successfully"); } else { lblMsg.Text = _objBOUtiltiy.ShowMessage("info", "Info", " Child Deposit Was not Added Successfully"); } } //objEMDepositChild.RecieptDate = Convert.ToDateTime(gvReciptData.Rows[i].Cells[2].Text); //objEMDepositChild.RecieptDate = Convert.ToDateTime(gvReciptData.Rows[i].Cells[2].Text); } } } else { } OpenAmountDetails objOpenAmountDetails = new OpenAmountDetails(); objOpenAmountDetails.ClientTypeId = Convert.ToInt32(ddlClientType.SelectedValue); objOpenAmountDetails.ClientNameId = 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.ReceiptOpenAmount = lblReceiptOpenAmount.Text != "" ? Convert.ToDecimal(lblReceiptOpenAmount.Text) : 0; objOpenAmountDetails.SourceRef = txtSourceRef.Text; objOpenAmountDetails.ReceiptType = ddlReceiptType.SelectedValue; objOpenAmountDetails.FromAccount = ddlAccountNo.SelectedValue; objOpenAmountDetails.ToAccount = ddlAccountNo.SelectedValue; objOpenAmountDetails.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); int ChildResult = _objBALTransactions.OpenAmountDetailsInsertUpdateMaster(objOpenAmountDetails); if (ChildResult > 0) { Response.Redirect("ReceiptsList.aspx"); } } catch (Exception ex) { lblMsg.Text = _objBOUtiltiy.ShowMessage("danger", "error", ex.Message); ExceptionLogging.SendExcepToDB(ex); } } }
public int OpenAmountDetailsInsertUpdateMaster(OpenAmountDetails objOpenAmountDetails) { return(_objDALTransactions.OpenAmountDetailsInsertUpdateMaster(objOpenAmountDetails)); }