/// <summary> /// To Update details of SubjectM in tbl_Subject_M table /// Created By : Darshan, 09/02/2014 /// Modified By : /// </summary> /// <param name="objSubjectMBO"></param> /// <returns></returns> public ApplicationResult SubjectM_Update(SubjectMBO objSubjectMBO) { try { pSqlParameter = new SqlParameter[6]; pSqlParameter[0] = new SqlParameter("@SubjectMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objSubjectMBO.SubjectMID; pSqlParameter[1] = new SqlParameter("@NameEng", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objSubjectMBO.NameEng; pSqlParameter[2] = new SqlParameter("@NameGuj", SqlDbType.NVarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objSubjectMBO.NameGuj; pSqlParameter[3] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objSubjectMBO.Description; pSqlParameter[4] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objSubjectMBO.LastModifiedUserID; pSqlParameter[5] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objSubjectMBO.LastModifiedDate; sSql = "usp_tbl_Subject_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 { objSubjectMBO = null; } }
protected void btnSaveClass_OnClick(object sender, EventArgs e) { try { SubjectMBO objSubjectMBO = new SubjectMBO(); SubjectMBL objSubjectMBL = new SubjectMBL(); ApplicationResult objResult = new ApplicationResult(); DataTable dtResult = new DataTable(); int intSubjectID = 0; objSubjectMBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objSubjectMBO.NameEng = txtSubjectNameENG.Text.Trim(); objSubjectMBO.NameGuj = txtSubjectNameGUJ.Text.Trim(); objSubjectMBO.Description = txtDescription.Text.Trim(); objSubjectMBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objSubjectMBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); //Code For Validate SubjectM Name if (ViewState["Mode"].ToString() == "Save") { intSubjectID = -1; } else if (ViewState["Mode"].ToString() == "Edit") { intSubjectID = Convert.ToInt32(ViewState["SubjectMID"].ToString()); } objResult = objSubjectMBL.SubjectM_ValidateName(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), intSubjectID, objSubjectMBO.NameEng); if (objResult != null) { dtResult = objResult.resultDT; if (dtResult.Rows.Count > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Subject name already exist.');</script>"); } else { if (ViewState["Mode"].ToString() == "Save") { objSubjectMBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objSubjectMBO.CreatedDate = System.DateTime.UtcNow.AddHours(5.5).ToString(); objResult = objSubjectMBL.SubjectM_Insert(objSubjectMBO); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { objSubjectMBO.SubjectMID = Convert.ToInt32(ViewState["SubjectMID"].ToString()); objResult = objSubjectMBL.SubjectM_Update(objSubjectMBO); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>"); } } ClearAll(); BindSubject(); 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>"); } }