public void BindGrid() { try { GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL(); GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO(); ApplicationResult objResultSelectAll = new ApplicationResult(); objResultSelectAll = objGeneralLedgerBL.GeneralLedger_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResultSelectAll != null) { DataTable dtSelectAll = new DataTable(); dtSelectAll = objResultSelectAll.resultDT; if (dtSelectAll.Rows.Count > 0) { gvGeneralLedger.DataSource = dtSelectAll; gvGeneralLedger.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 gvGeneralLedger_RowCommand(object sender, GridViewCommandEventArgs e) { try { GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL(); GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO(); ApplicationResult objResultSelect = new ApplicationResult(); ApplicationResult objResultDelete = new ApplicationResult(); ViewState["LedgerID"] = e.CommandArgument.ToString(); if (e.CommandName.ToString() == "Edit1") { objResultSelect = objGeneralLedgerBL.GeneralLedger_Select(Convert.ToInt32(ViewState["LedgerID"].ToString()), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResultSelect != null) { DataTable dtResult = objResultSelect.resultDT; if (dtResult.Rows.Count > 0) { BindAccountGroup(); txtAccountName.Text = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_ACCOUNTNAME].ToString(); ddlAccountGroup.SelectedValue = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_ACCOUNTGROUPID].ToString(); txtOpeningBalance.Text = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_OPENINGBALANCE].ToString(); if (dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_BALANCETYPE].ToString() != "") { ddlBalanceType.SelectedValue = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_BALANCETYPE].ToString(); } txtDescription.Text = dtResult.Rows[0][GeneralLedgerBO.GENERALLEDGER_DESCRIPTION].ToString(); PanelVisibility(2); ViewState["Mode"] = "Edit"; } } } else if (e.CommandName.ToString() == "Delete1") { objResultDelete = objGeneralLedgerBL.GeneralLedger_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.USERID]), DateTime.UtcNow.AddHours(5.5).ToString(), "Ledger"); if (objResultDelete.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>"); PanelVisibility(1); BindGrid(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You cannot delete this record because it is in used.');</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>"); } }
public void BindAccountGroup() { GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL(); GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO(); ApplicationResult objResultSelectAll = new ApplicationResult(); DropDownList ddlAccountName = new DropDownList(); objResultSelectAll = objGeneralLedgerBL.GeneralLedger_SelectAll_JournalEntry(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResultSelectAll != null) { DataTable dtSelectAll = new DataTable(); dtSelectAll = objResultSelectAll.resultDT; for (int i = 0; i < gvPaymentsEntry.Rows.Count; i++) { ddlAccountName = (DropDownList)gvPaymentsEntry.Rows[i].Cells[0].FindControl("ddlAccountName"); if (ddlAccountName != null) { objControl.BindDropDown_ListBox(dtSelectAll, ddlAccountName, "AccountName", "LedgerID"); ddlAccountName.Items.Insert(0, new ListItem("", "-1")); } } } }
protected void ddlReceiptMode_SelectedIndexChanged(object sender, EventArgs e) { try { divlblBalance.Visible = false; if (ddlReceiptMode.SelectedValue != "") { GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL(); GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO(); ApplicationResult objResultSelect = new ApplicationResult(); DataTable dtSelect = new DataTable(); if (ddlReceiptMode.SelectedValue == "Cash") { txtChequeNo.Text = ""; txtChequeNo.Enabled = false; ddlGeneralLedger.ClearSelection(); objResultSelect = objGeneralLedgerBL.GeneralLedger_Select_Receipt_Payment(1, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResultSelect != null) { dtSelect = objResultSelect.resultDT; objControl.BindDropDown_ListBox(dtSelect, ddlGeneralLedger, "AccountName", "LedgerID"); ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", "")); } } else if (ddlReceiptMode.SelectedValue == "Bank") { txtChequeNo.Text = ""; txtChequeNo.Enabled = true; ddlGeneralLedger.ClearSelection(); objResultSelect = objGeneralLedgerBL.GeneralLedger_Select_Receipt_Payment(2, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResultSelect != null) { dtSelect = objResultSelect.resultDT; objControl.BindDropDown_ListBox(dtSelect, ddlGeneralLedger, "AccountName", "LedgerID"); ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", "")); } } else { txtChequeNo.Text = ""; txtChequeNo.Enabled = true; ddlGeneralLedger.ClearSelection(); objResultSelect = objGeneralLedgerBL.GeneralLedger_Select_Receipt_Payment(3, Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResultSelect != null) { dtSelect = objResultSelect.resultDT; objControl.BindDropDown_ListBox(dtSelect, ddlGeneralLedger, "AccountName", "LedgerID"); ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", "")); } } } else { ddlGeneralLedger.Items.Clear(); ddlGeneralLedger.Items.Insert(0, new ListItem("--Select--", "")); } } catch (Exception ex) { } }
/// <summary> /// To Update details of GeneralLedger in tbl_GeneralLedger_M table /// Created By : Viral, 10/7/2014 /// Modified By : /// </summary> /// <param name="objGeneralLedgerBO"></param> /// <returns></returns> public ApplicationResult GeneralLedger_Update(GeneralLedgerBO objGeneralLedgerBO, string strFromDate) { try { pSqlParameter = new SqlParameter[14]; pSqlParameter[0] = new SqlParameter("@LedgerID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objGeneralLedgerBO.LedgerID; pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objGeneralLedgerBO.TrustMID; pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objGeneralLedgerBO.SchoolMID; pSqlParameter[3] = new SqlParameter("@AccountName", SqlDbType.NVarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objGeneralLedgerBO.AccountName; pSqlParameter[4] = new SqlParameter("@AccountGroupID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objGeneralLedgerBO.AccountGroupID; pSqlParameter[5] = new SqlParameter("@OpeningBalance", SqlDbType.Float); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objGeneralLedgerBO.OpeningBalance; pSqlParameter[6] = new SqlParameter("@BalanceType", SqlDbType.NVarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objGeneralLedgerBO.BalanceType; pSqlParameter[7] = new SqlParameter("@Description", SqlDbType.NVarChar); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objGeneralLedgerBO.Description; pSqlParameter[8] = new SqlParameter("@CreatedDate", SqlDbType.NVarChar); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objGeneralLedgerBO.CreatedDate; pSqlParameter[9] = new SqlParameter("@CreatedUserID", SqlDbType.Int); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objGeneralLedgerBO.CreatedUserID; pSqlParameter[10] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objGeneralLedgerBO.IsDeleted; pSqlParameter[11] = new SqlParameter("@LastModifideUserID", SqlDbType.Int); pSqlParameter[11].Direction = ParameterDirection.Input; pSqlParameter[11].Value = objGeneralLedgerBO.LastModifideUserID; pSqlParameter[12] = new SqlParameter("@LastModifideDate", SqlDbType.NVarChar); pSqlParameter[12].Direction = ParameterDirection.Input; pSqlParameter[12].Value = objGeneralLedgerBO.LastModifideDate; pSqlParameter[13] = new SqlParameter("@FromDate", SqlDbType.VarChar); pSqlParameter[13].Direction = ParameterDirection.Input; pSqlParameter[13].Value = strFromDate; sSql = "usp_tbl_GeneralLedger_M_Update"; int iResult = Database.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 { objGeneralLedgerBO = null; } }
protected void btnSave_Click(object sender, EventArgs e) { try { GeneralLedgerBL objGeneralLedgerBL = new GeneralLedgerBL(); GeneralLedgerBO objGeneralLedgerBO = new GeneralLedgerBO(); ApplicationResult objResultValidate = new ApplicationResult(); int intLedgerID = 0; objGeneralLedgerBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objGeneralLedgerBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objGeneralLedgerBO.AccountName = txtAccountName.Text; objGeneralLedgerBO.AccountGroupID = Convert.ToInt32(ddlAccountGroup.SelectedValue); if (txtOpeningBalance.Text.Length > 0) { objGeneralLedgerBO.OpeningBalance = Convert.ToDouble(txtOpeningBalance.Text); } if (ddlBalanceType.SelectedValue != "") { objGeneralLedgerBO.BalanceType = ddlBalanceType.SelectedValue; } objGeneralLedgerBO.Description = txtDescription.Text; objGeneralLedgerBO.CreatedDate = System.DateTime.UtcNow.AddHours(5.5).ToString(); objGeneralLedgerBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objGeneralLedgerBO.IsDeleted = 0; objGeneralLedgerBO.LastModifideDate = System.DateTime.UtcNow.AddHours(5.5).ToString(); objGeneralLedgerBO.LastModifideUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); //Code For Validate Department Name if (ViewState["Mode"].ToString() == "Save") { intLedgerID = -1; } else if (ViewState["Mode"].ToString() == "Edit") { intLedgerID = Convert.ToInt32(ViewState["LedgerID"].ToString()); objGeneralLedgerBO.LedgerID = Convert.ToInt32(ViewState["LedgerID"].ToString()); } objResultValidate = objGeneralLedgerBL.GeneralLedger_ValidateName(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), txtAccountName.Text, intLedgerID); if (objResultValidate != null) { DataTable dtValidate = new DataTable(); dtValidate = objResultValidate.resultDT; if (dtValidate.Rows.Count > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Ledger name already exist.');</script>"); } else { if (ViewState["Mode"].ToString() == "Save") { ApplicationResult objResultSave = new ApplicationResult(); objResultSave = objGeneralLedgerBL.GeneralLedger_Insert(objGeneralLedgerBO, Convert.ToInt32(Session[ApplicationSession.FINANCIALYEAR])); if (objResultSave.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Saved successfully.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { ApplicationResult objResultUpdate = new ApplicationResult(); objResultUpdate = objGeneralLedgerBL.GeneralLedger_Update(objGeneralLedgerBO, Session[ApplicationSession.ACCOUNTFROMDATE].ToString()); if (objResultUpdate.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>"); } } ClearAll(); BindGrid(); PanelVisibility(1); } } } 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>"); } }