public void BindGrid() { try { ReceiptPaymentBL objReceiptPaymentBL = new ReceiptPaymentBL(); ReceiptPaymentBO objReceiptPaymentBO = new ReceiptPaymentBO(); ApplicationResult objResultSelectAll = new ApplicationResult(); objResultSelectAll = objReceiptPaymentBL.ReceiptPayment_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(Session[ApplicationSession.FINANCIALYEAR]), Session[ApplicationSession.ACCOUNTFROMDATE].ToString(), Session[ApplicationSession.ACCOUNTTODATE].ToString(), "Payment"); if (objResultSelectAll != null) { DataTable dtSelectAll = new DataTable(); dtSelectAll = objResultSelectAll.resultDT; gvPayments.DataSource = dtSelectAll; gvPayments.DataBind(); } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { ReceiptPaymentBL objReceiptPaymentBL = new ReceiptPaymentBL(); ReceiptPaymentBO objReceiptPaymentBO = new ReceiptPaymentBO(); ApplicationResult objResultInsert = new ApplicationResult(); ApplicationResult objResultUpdate = new ApplicationResult(); DataTable dtResult = new DataTable(); double dbSum = 0.0; DateTime dtFromDate = Convert.ToDateTime(Session[ApplicationSession.ACCOUNTFROMDATE].ToString()); DateTime dtToDate = Convert.ToDateTime(Session[ApplicationSession.ACCOUNTTODATE].ToString()); DateTime dtCurrentDate = Convert.ToDateTime(txtDate.Text); if (ViewState["Mode"].ToString() == "Save") { int intvalidate = 0; for (int i = 0; i < gvPaymentsEntry.Rows.Count; i++) { string ddlVal = ((DropDownList)(gvPaymentsEntry.Rows[i].Cells[0].FindControl("ddlAccountName"))).SelectedItem.Value; string strDebitAmt = ((TextBox)(gvPaymentsEntry.Rows[i].Cells[1].FindControl("txtDebitAmount"))).Text; if (strDebitAmt != "") { if (ddlVal == "-1") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select General Ledger Account or enter amount before save Payment entry.');</script>"); return; } } else { intvalidate = intvalidate + 1; } if (gvPaymentsEntry.Rows.Count == intvalidate) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select General Ledger Account or enter amount before save Payment entry.');</script>"); return; } } if (txtDate.Text == "" || txtDate.Text == " ") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select Date First.');</script>"); } else if (ddlReceiptMode.SelectedValue == "-1" || ddlGeneralLedger.SelectedValue == "-1") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please select mode of Payment and General Ledger.');</script>"); } else { objReceiptPaymentBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objReceiptPaymentBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objReceiptPaymentBO.ReceiptPaymentDate = dtCurrentDate.ToShortDateString(); objReceiptPaymentBO.Year = Convert.ToInt32(Session[ApplicationSession.FINANCIALYEAR]); objReceiptPaymentBO.TransactionType = "Payment"; objReceiptPaymentBO.GeneralLedger = Convert.ToInt32(ddlGeneralLedger.SelectedValue); objReceiptPaymentBO.Narration = txtNarration.Text; objReceiptPaymentBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]); objReceiptPaymentBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy"); objReceiptPaymentBO.IsDeleted = 0; objReceiptPaymentBO.LastModifideDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy"); objReceiptPaymentBO.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); if (dtFromDate <= dtCurrentDate && dtCurrentDate <= dtToDate) { if (ddlReceiptMode.SelectedValue == "Cash") { objReceiptPaymentBO.TransactionMode = "Cash"; } else if (ddlReceiptMode.SelectedValue == "Bank" || ddlReceiptMode.SelectedValue == "ODCC") { objReceiptPaymentBO.TransactionMode = ddlReceiptMode.SelectedValue; if (txtChequeNo.Text.Length > 0) { objReceiptPaymentBO.ChequeNo = Convert.ToInt32(txtChequeNo.Text); } } for (int j = 0; j < gvPaymentsEntry.Rows.Count; j++) { GridViewRow row = gvPaymentsEntry.Rows[j]; TextBox txtCrAmount = (TextBox)row.FindControl("txtDebitAmount"); DropDownList ddlAccName = (DropDownList)row.FindControl("ddlAccountName"); if (txtCrAmount.Text == "" && ddlAccName.SelectedValue == "-1") { continue; } else if (txtCrAmount.Text == "" || ddlAccName.SelectedValue == "-1") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select Account Name or Amount');</script>"); break; } else { objReceiptPaymentBO.LedgerID = Convert.ToInt32(ddlAccName.SelectedValue); dbSum = Convert.ToDouble(txtCrAmount.Text); objReceiptPaymentBO.Amount = dbSum; } objResultInsert = objReceiptPaymentBL.ReceiptPayment_Insert(objReceiptPaymentBO); if (j == 0) { if (objResultInsert != null) { dtResult = objResultInsert.resultDT; if (dtResult.Rows.Count > 0) { if (dtResult.Rows[0][0].ToString() == "0") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Initialize Receipt Start No. For This Year.');</script>"); goto Exit; } else { ViewState["ReceiptNo"] = Convert.ToInt32(dtResult.Rows[0][0]); ViewState["ReceiptCode"] = dtResult.Rows[0][1].ToString(); objReceiptPaymentBO.ReceiptPaymentNo = Convert.ToInt32(ViewState["ReceiptNo"]); objReceiptPaymentBO.ReceiptPaymentCode = ViewState["ReceiptCode"].ToString(); } } } } else { objReceiptPaymentBO.ReceiptPaymentNo = Convert.ToInt32(ViewState["ReceiptNo"]); objReceiptPaymentBO.ReceiptPaymentCode = ViewState["ReceiptCode"].ToString(); } } ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Payment Saved Successfully. Payment No is " + ViewState["ReceiptCode"].ToString() + "');</script>"); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select Date according to your Accounting Period.');</script>"); } } BindGrid(); clear(); PanelVisibility(1); } else { int intvalidate = 0; for (int i = 0; i < gvPaymentsEntry.Rows.Count; i++) { string ddlVal = ((DropDownList)(gvPaymentsEntry.Rows[i].Cells[0].FindControl("ddlAccountName"))).SelectedItem.Value; string strDebitAmt = ((TextBox)(gvPaymentsEntry.Rows[i].Cells[1].FindControl("txtDebitAmount"))).Text; if (strDebitAmt != "") { if (ddlVal == "-1") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select General Ledger Account or enter amount before save Payment entry.');</script>"); return; } } else { intvalidate = intvalidate + 1; } if (gvPaymentsEntry.Rows.Count == intvalidate) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select General Ledger Account or enter amount before save Payment entry.');</script>"); return; } } ApplicationResult objResultDelete = new ApplicationResult(); if (txtDate.Text == "" || txtDate.Text == " ") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select Date First.');</script>"); } else if (ddlReceiptMode.SelectedValue == "-1" || ddlGeneralLedger.SelectedValue == "-1") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please select mode of Payment and General Ledger.');</script>"); } else { objReceiptPaymentBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objReceiptPaymentBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objReceiptPaymentBO.ReceiptPaymentDate = dtCurrentDate.ToShortDateString(); objReceiptPaymentBO.Year = Convert.ToInt32(Session[ApplicationSession.FINANCIALYEAR]); objReceiptPaymentBO.TransactionType = "Payment"; objReceiptPaymentBO.GeneralLedger = Convert.ToInt32(ddlGeneralLedger.SelectedValue); objReceiptPaymentBO.Narration = txtNarration.Text; objReceiptPaymentBO.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]); objReceiptPaymentBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy"); objReceiptPaymentBO.IsDeleted = 0; objReceiptPaymentBO.LastModifideDate = DateTime.UtcNow.AddHours(5.5).ToString("dd/MM/yyyy"); objReceiptPaymentBO.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objReceiptPaymentBO.ReceiptPaymentNo = Convert.ToInt32(txtVoucherCode.Text.Substring(6, txtVoucherCode.Text.Length - 6)); ; objReceiptPaymentBO.ReceiptPaymentCode = txtVoucherCode.Text; if (dtFromDate <= dtCurrentDate && dtCurrentDate <= dtToDate) { if (ddlReceiptMode.SelectedValue == "Cash") { objReceiptPaymentBO.TransactionMode = "Cash"; } else if (ddlReceiptMode.SelectedValue == "Bank" || ddlReceiptMode.SelectedValue == "ODCC") { objReceiptPaymentBO.TransactionMode = ddlReceiptMode.SelectedValue; if (txtChequeNo.Text.Length > 0) { objReceiptPaymentBO.ChequeNo = Convert.ToInt32(txtChequeNo.Text); } } DatabaseTransaction.OpenConnectionTransation(); objResultDelete = objReceiptPaymentBL.ReceiptPayment_Delete_Transaction(txtVoucherCode.Text, "Payment"); for (int j = 0; j < gvPaymentsEntry.Rows.Count; j++) { GridViewRow row = gvPaymentsEntry.Rows[j]; TextBox txtCrAmount = (TextBox)row.FindControl("txtDebitAmount"); DropDownList ddlAccName = (DropDownList)row.FindControl("ddlAccountName"); if (txtCrAmount.Text == "" && ddlAccName.SelectedValue == "-1") { continue; } else if (txtCrAmount.Text == "" || ddlAccName.SelectedValue == "-1") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select Account Name or Amount');</script>"); break; } else { objReceiptPaymentBO.LedgerID = Convert.ToInt32(ddlAccName.SelectedValue); dbSum = Convert.ToDouble(txtCrAmount.Text); objReceiptPaymentBO.Amount = dbSum; } objResultUpdate = objReceiptPaymentBL.ReceiptPayment_Update(objReceiptPaymentBO); } ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Payment Updated Successfully. Receipt No is " + ViewState["ReceiptCode"].ToString() + "');</script>"); DatabaseTransaction.CommitTransation(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select Date according to your Accounting Period.');</script>"); } } BindGrid(); clear(); PanelVisibility(1); } Exit :; } catch (Exception ex) { if (ViewState["Mode"].ToString() == "Edit") { DatabaseTransaction.RollbackTransation(); } logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } finally { DatabaseTransaction.connection.Close(); } }
protected void gvPayments_RowCommand(object sender, GridViewCommandEventArgs e) { try { ReceiptPaymentBL objReceiptPaymentBL = new ReceiptPaymentBL(); ReceiptPaymentBO objReceiptPaymentBO = new ReceiptPaymentBO(); ApplicationResult objResultSelect = new ApplicationResult(); ViewState["ReceiptCode"] = e.CommandArgument.ToString(); if (e.CommandName.ToString() == "Edit1") { gvPayments.SelectedIndex = -1; objResultSelect = objReceiptPaymentBL.ReceiptPayment_Select(ViewState["ReceiptCode"].ToString(), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResultSelect != null) { DataTable dtSelect = new DataTable(); dtSelect = objResultSelect.resultDT; if (dtSelect.Rows.Count > 0) { ViewState["ReceiptRow"] = dtSelect.Rows.Count; DataTable dt = new DataTable(); dt.Columns.Add("Number"); dt.Columns.Add("ReceiptPaymentID"); for (int i = 1; i <= Convert.ToInt32(ViewState["ReceiptRow"]); i++) { dt.Rows.Add(i.ToString(), "0"); } ViewState["ADDRow"] = dt; gvPaymentsEntry.DataSource = dt; gvPaymentsEntry.DataBind(); BindAccountGroup(); txtDate.Text = dtSelect.Rows[0]["ReceiptPaymentDate"].ToString(); ddlReceiptMode.SelectedValue = dtSelect.Rows[0]["TransactionMode"].ToString(); ddlReceiptMode_SelectedIndexChanged(sender, e); ddlGeneralLedger.SelectedValue = dtSelect.Rows[0]["GeneralLedger"].ToString(); txtVoucherCode.Text = ViewState["ReceiptCode"].ToString(); txtChequeNo.Text = dtSelect.Rows[0]["ChequeNo"].ToString(); txtNarration.Text = dtSelect.Rows[0]["Narration"].ToString(); for (int i = 0; i < dtSelect.Rows.Count; i++) { gvPaymentsEntry.Rows[i].Cells[0].Text = dtSelect.Rows[i][0].ToString(); ((DropDownList)gvPaymentsEntry.Rows[i].Cells[1].FindControl("ddlAccountName")).SelectedValue = dtSelect.Rows[i]["LedgerID"].ToString(); ((TextBox)gvPaymentsEntry.Rows[i].Cells[2].FindControl("txtDebitAmount")).Text = dtSelect.Rows[i]["Amount"].ToString(); } PanelVisibility(2); setControlScript(); getDebitCreditSum(); ViewState["Mode"] = "Edit"; fnOpeningBalance(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(ddlGeneralLedger.SelectedValue), txtDate.Text); } } } else if (e.CommandName.ToString() == "Delete1") { ApplicationResult objResultDelete = new ApplicationResult(); objResultDelete = objReceiptPaymentBL.ReceiptPayment_Delete(e.CommandArgument.ToString(), "Payment"); if (objResultDelete.status == ApplicationResult.CommonStatusType.SUCCESS) { BindGrid(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Deleted Successfully.');</script>"); } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
/// <summary> /// To Update details of ReceiptPayment in tbl_ReceiptPaymentDetail_M table /// Created By : Viral, 10/22/2014 /// Modified By : /// </summary> /// <param name="objReceiptPaymentBO"></param> /// <returns></returns> public ApplicationResult ReceiptPayment_Update(ReceiptPaymentBO objReceiptPaymentBO) { try { pSqlParameter = new SqlParameter[20]; //pSqlParameter[0] = new SqlParameter("@ReceiptPaymentID",SqlDbType.Int); //pSqlParameter[0].Direction = ParameterDirection.Input; //pSqlParameter[0].Value = objReceiptPaymentBO.ReceiptPaymentID; pSqlParameter[0] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objReceiptPaymentBO.TrustMID; pSqlParameter[1] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objReceiptPaymentBO.SchoolMID; pSqlParameter[2] = new SqlParameter("@ReceiptPaymentNo", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objReceiptPaymentBO.ReceiptPaymentNo; pSqlParameter[3] = new SqlParameter("@ReceiptPaymentCode", SqlDbType.NVarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objReceiptPaymentBO.ReceiptPaymentCode; pSqlParameter[4] = new SqlParameter("@ReceiptPaymentDate", SqlDbType.NVarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objReceiptPaymentBO.ReceiptPaymentDate; pSqlParameter[5] = new SqlParameter("@Year", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objReceiptPaymentBO.Year; pSqlParameter[6] = new SqlParameter("@TransactionMode", SqlDbType.NVarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objReceiptPaymentBO.TransactionMode; pSqlParameter[7] = new SqlParameter("@TransactionType", SqlDbType.NVarChar); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objReceiptPaymentBO.TransactionType; pSqlParameter[8] = new SqlParameter("@GeneralLedger", SqlDbType.Int); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objReceiptPaymentBO.GeneralLedger; pSqlParameter[9] = new SqlParameter("@LedgerID", SqlDbType.Int); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objReceiptPaymentBO.LedgerID; pSqlParameter[10] = new SqlParameter("@Amount", SqlDbType.Float); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objReceiptPaymentBO.Amount; pSqlParameter[11] = new SqlParameter("@BankName", SqlDbType.NVarChar); pSqlParameter[11].Direction = ParameterDirection.Input; pSqlParameter[11].Value = objReceiptPaymentBO.BankName; pSqlParameter[12] = new SqlParameter("@BranchName", SqlDbType.NVarChar); pSqlParameter[12].Direction = ParameterDirection.Input; pSqlParameter[12].Value = objReceiptPaymentBO.BranchName; pSqlParameter[13] = new SqlParameter("@ChequeNo", SqlDbType.Int); pSqlParameter[13].Direction = ParameterDirection.Input; pSqlParameter[13].Value = objReceiptPaymentBO.ChequeNo; pSqlParameter[14] = new SqlParameter("@Narration", SqlDbType.NChar); pSqlParameter[14].Direction = ParameterDirection.Input; pSqlParameter[14].Value = objReceiptPaymentBO.Narration; pSqlParameter[15] = new SqlParameter("@CreatedDate", SqlDbType.NVarChar); pSqlParameter[15].Direction = ParameterDirection.Input; pSqlParameter[15].Value = objReceiptPaymentBO.CreatedDate; pSqlParameter[16] = new SqlParameter("@CreatedBy", SqlDbType.Int); pSqlParameter[16].Direction = ParameterDirection.Input; pSqlParameter[16].Value = objReceiptPaymentBO.CreatedBy; pSqlParameter[17] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[17].Direction = ParameterDirection.Input; pSqlParameter[17].Value = objReceiptPaymentBO.IsDeleted; pSqlParameter[18] = new SqlParameter("@LastModifideUserID", SqlDbType.Int); pSqlParameter[18].Direction = ParameterDirection.Input; pSqlParameter[18].Value = objReceiptPaymentBO.LastModifideUserID; pSqlParameter[19] = new SqlParameter("@LastModifideDate", SqlDbType.NVarChar); pSqlParameter[19].Direction = ParameterDirection.Input; pSqlParameter[19].Value = objReceiptPaymentBO.LastModifideDate; sSql = "usp_tbl_ReceiptPaymentDetail_M_Update"; int iResult = DatabaseTransaction.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objReceiptPaymentBO = null; } }