public static string LoadDivision(int intClassMID, int intSchoolMID) { try { #region Bind Division DataTable dtDivision = new DataTable(); DivisionTBL objDivisionBL = new DivisionTBL(); DivisionTBO objDivisionBO = new DivisionTBO(); ApplicationResult objResultSection = new ApplicationResult(); objResultSection = objDivisionBL.Division_SelectAll_ClassWise_ForDropDown(intClassMID, intSchoolMID); if (objResultSection != null) { dtDivision = objResultSection.resultDT; if (dtDivision.Rows.Count > 0) { } } string res = ""; res = DataSetToJSON(dtDivision); return(res); #endregion } catch (Exception ex) { throw ex; } }
public void SaveClass_T() { ApplicationResult objResults = new ApplicationResult(); DivisionTBL objDivisionBl = new DivisionTBL(); DivisionTBO objDivisionBo = new DivisionTBO(); objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString()); objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); DataTable dtTask = (DataTable)ViewState["Division"]; for (int i = 0; i < dtTask.Rows.Count; i++) { objDivisionBo.DivisionName = dtTask.Rows[i]["DivisionName"].ToString(); objResults = objDivisionBl.DivisionT_Insert(objDivisionBo); } //if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) //{ //ClearAll(); //ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class updated successfully.');</script>"); //GridDataBind(); //PanelGrid_VisibilityMode(1); //} }
/// <summary> /// To Update details of DivisionT in tbl_Division_T table /// Created By : NafisaMulla, 11/7/2014 /// Modified By : /// </summary> /// <param name="objDivisionTBO"></param> /// <returns></returns> public ApplicationResult DivisionT_Update(DivisionTBO objDivisionTBO) { try { pSqlParameter = new SqlParameter[6]; pSqlParameter[0] = new SqlParameter("@DivisionTID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objDivisionTBO.DivisionTID; pSqlParameter[1] = new SqlParameter("@ClassMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objDivisionTBO.ClassMID; pSqlParameter[2] = new SqlParameter("@DivisionName", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objDivisionTBO.DivisionName; pSqlParameter[3] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objDivisionTBO.LastModifiedUserID; pSqlParameter[4] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objDivisionTBO.LastModifiedDate; pSqlParameter[5] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objDivisionTBO.IsDeleted; sSql = "usp_tbl_Division_T_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 { objDivisionTBO = null; } }
private DataTable FetchDivision(int intClassMID, int intSchoolMID) { //DataTable dtDivision = new DataTable(); DivisionTBL objDivisionBL = new DivisionTBL(); DivisionTBO objDivisionBO = new DivisionTBO(); ApplicationResult objResults = new ApplicationResult(); objResults = objDivisionBL.Division_SelectAll_ClassWise(intClassMID, intSchoolMID); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0) { } return(objResults.resultDT); }
protected void btnAdd_OnClick(object sender, EventArgs e) { try { int intflagsave = 0; int intflagedit = 0; DataTable dtTask = new DataTable(); dtTask = (DataTable)ViewState["Division"]; if (ViewState["DivisionMode"].ToString() == "Save") { if (dtTask.Rows.Count > 0) { string strFilter = "DivisionName = '" + txtDivisionName.Text.Trim() + "'"; DataRow[] results = dtTask.Select(strFilter); if (results.Length > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Division name already exist.');</script>"); intflagsave = 1; } } if (intflagsave == 0) { if (ViewState["Mode"].ToString() == "Save") { int i = 0; if (dtTask.Rows.Count > 0) { i = dtTask.Rows.Count; } i = i + 1; dtTask.Rows.Add(i, txtDivisionName.Text); ViewState["Division"] = dtTask; gvDivision.DataSource = dtTask; gvDivision.DataBind(); txtDivisionName.Text = ""; } else if (ViewState["Mode"].ToString() == "Edit") { ApplicationResult objResults = new ApplicationResult(); DivisionTBL objDivisionBl = new DivisionTBL(); DivisionTBO objDivisionBo = new DivisionTBO(); objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString()); objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objDivisionBo.DivisionName = txtDivisionName.Text; objResults = objDivisionBl.DivisionT_Insert(objDivisionBo); objResults = objDivisionBl.DivisionT_Select_DivisionName_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString())); if (objResults != null) { // ViewState["Division"] = objResults.resultDT; // gvDivision.DataSource = (DataTable)ViewState["Division"]; gvDivision.DataSource = objResults.resultDT; gvDivision.DataBind(); } } } } if (ViewState["DivisionMode"].ToString() == "Edit") { if (dtTask.Rows.Count > 0) { string strFilter = "DivisionName = '" + txtDivisionName.Text.Trim() + "'"; DataRow[] results = dtTask.Select(strFilter); if (results.Length > 1) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Division name already exist.');</script>"); intflagedit = 1; } } if (intflagedit == 0) { if (ViewState["Mode"].ToString() == "Save") { DataTable dtTaskTemp = (DataTable)ViewState["Division"]; foreach (DataRow dr in dtTaskTemp.Rows) // search whole table { if (Convert.ToInt32(dr["DivisionTID"].ToString()) == Convert.ToInt32(ViewState["DivisionDatatableTID"].ToString())) // if id==2 { dr["DivisionName"] = txtDivisionName.Text; //change the name //break; break or not depending on you } ViewState["Division"] = dtTask; gvDivision.DataSource = dtTask; gvDivision.DataBind(); } } else if (ViewState["Mode"].ToString() == "Edit") { ApplicationResult objResults = new ApplicationResult(); DivisionTBL objDivisionBl = new DivisionTBL(); DivisionTBO objDivisionBo = new DivisionTBO(); objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString()); objDivisionBo.DivisionTID = Convert.ToInt32(ViewState["DivisionTID"].ToString()); objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objDivisionBo.DivisionName = txtDivisionName.Text; objResults = objDivisionBl.DivisionT_Update(objDivisionBo); ViewState["Mode"] = "Edit"; objResults = objDivisionBl.DivisionT_Select_DivisionName_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString())); if (objResults != null) { // ViewState["Division"] = objResults.resultDT; // gvDivision.DataSource = (DataTable)ViewState["Division"]; gvDivision.DataSource = objResults.resultDT; gvDivision.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 btnSaveClass_Click(object sender, EventArgs e) { try { ClassBL objClasstBl = new ClassBL(); ClassBO objClassBo = new ClassBO(); DivisionTBO objDivisionBo = new DivisionTBO(); DivisionTBL objDivisionBl = new DivisionTBL(); Controls objControls = new Controls(); ApplicationResult objResults = new ApplicationResult(); if (ValidateName() == true) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " And Divsion " + txtDivisionName.Text + " already Exists.');</script>"); goto Exit; } objClassBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()); objClassBo.SectionTID = Convert.ToInt32(ddlSection.SelectedValue); objClassBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objClassBo.ClassName = txtClassName.Text; objClassBo.NoOfPeriod = Convert.ToInt32(txtNoOfPeriod.Text); objClassBo.ApprovalNo = txtApprovalNo.Text; objClassBo.ApprovalDate = txtApprovalDate.Text; objClassBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objClassBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); #region RollBack Transaction Starts DatabaseTransaction.OpenConnectionTransation(); if (ViewState["Mode"].ToString() == "Save") { //objResults = objClasstBl.Class_ValidateName(txtClassName.Text, Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); //if (objResults != null) //{ // if (objResults.resultDT.Rows.Count > 0) // { // ViewState["ClassMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString()); // SaveClass_T(); // } // else // { objResults = objClasstBl.Class_Insert(objClassBo); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { ViewState["ClassMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString()); SaveClass_T(); ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Record saved successfully.');</script>"); GridDataBind(); PanelGrid_VisibilityMode(1); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " Already Exists.');</script>"); } } // } //} } else { objClassBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString()); objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString()); objResults = objClasstBl.Class_Update(objClassBo); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { //ApplicationResult objResultsDivisionUpdate = new ApplicationResult(); //objResultsDivisionUpdate = // objDivisionBl.DivisionT_Delete_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString())); //DataTable dtTask = (DataTable)ViewState["Division"]; //for (int i = 0; i < dtTask.Rows.Count; i++) //{ // objDivisionBo.DivisionName = dtTask.Rows[i]["DivisionName"].ToString(); // objResultsDivisionUpdate = objDivisionBl.DivisionT_Insert(objDivisionBo); //} ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Record updated successfully.');</script>"); ClearAll(); GridDataBind(); objControls.ClearForm(Master.FindControl("ContentPlaceHolder1")); ViewState["Mode"] = "Save"; } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " Already Exists.');</script>"); } } DatabaseTransaction.CommitTransation(); #endregion Exit :; } 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>"); } }