protected void btnSaveFeesGroup_Click(object sender, EventArgs e) { try { FeesGroupBo objFeesGroupBO = new FeesGroupBo(); FeesGroupBl objFeesGroupBL = new FeesGroupBl(); ApplicationResult objResults = new ApplicationResult(); Controls objControls = new Controls(); objFeesGroupBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objFeesGroupBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objFeesGroupBO.FeeGroupName = txtFeesGroupName.Text.Trim(); objFeesGroupBO.Description = txtDescription.Text.Trim(); if (ViewState["Mode"].ToString() == "Save") { objFeesGroupBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objFeesGroupBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objResults = objFeesGroupBL.FeesGroup_Insert(objFeesGroupBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Group Created Successfully.');</script>"); BindFeesGroup(); PanelGrid_VisibilityMode(1); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Group Name already Exists.');</script>"); } } else { objFeesGroupBO.FeesGroupID = Convert.ToInt32(ViewState["FeesGroupID"].ToString()); objFeesGroupBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objFeesGroupBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objResults = objFeesGroupBL.FeesGroup_Update(objFeesGroupBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Fees Group updated successfully.');</script>"); BindFeesGroup(); ClearAll(); ViewState["Mode"] = "Save"; // btnSave.Text = "Save"; } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Fees Group Name already Exists.');</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 FeesGroup in tbl_FeesGroup_M table /// Created By : Nafisa, 19-03-2015 /// Modified By : /// </summary> /// <param name="objFeesGroupBO"></param> /// <returns></returns> public ApplicationResult FeesGroup_Update(FeesGroupBo objFeesGroupBO) { try { pSqlParameter = new SqlParameter[7]; pSqlParameter[0] = new SqlParameter("@FeesGroupID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objFeesGroupBO.FeesGroupID; pSqlParameter[1] = new SqlParameter("@FeeGroupName", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objFeesGroupBO.FeeGroupName; pSqlParameter[2] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objFeesGroupBO.TrustMID; pSqlParameter[3] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objFeesGroupBO.SchoolMID; pSqlParameter[4] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objFeesGroupBO.LastModifiedUserID; pSqlParameter[5] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objFeesGroupBO.LastModifiedDate; pSqlParameter[6] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objFeesGroupBO.Description; sSql = "usp_tbl_FeesGroup_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 { objFeesGroupBO = null; } }