public void BindSubject() { ApplicationResult objResult = new ApplicationResult(); SubjectMBL objSubjectMbl = new SubjectMBL(); objResult = objSubjectMbl.SubjectM_Select_By_School(Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResult.resultDT.Rows.Count > 0) { gvSubject.DataSource = objResult.resultDT; gvSubject.DataBind(); PanelVisibility(1); } else { PanelVisibility(2); } }
protected void gvSubject_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); SubjectMBL objSubjectMBL = new SubjectMBL(); if (e.CommandName.ToString() == "Edit1") { ViewState["Mode"] = "Edit"; ViewState["SubjectMID"] = e.CommandArgument.ToString(); objResult = objSubjectMBL.SubjectM_Select(Convert.ToInt32(ViewState["SubjectMID"].ToString())); if (objResult != null) { DataTable dtResult = objResult.resultDT; if (dtResult.Rows.Count > 0) { txtSubjectNameENG.Text = dtResult.Rows[0][SubjectMBO.SUBJECTM_NAMEENG].ToString(); txtSubjectNameGUJ.Text = dtResult.Rows[0][SubjectMBO.SUBJECTM_NAMEGUJ].ToString(); txtDescription.Text = dtResult.Rows[0][SubjectMBO.SUBJECTM_DESCRIPTION].ToString(); PanelVisibility(2); } } } else if (e.CommandName.ToString() == "Delete1") { objResult = objSubjectMBL.SubjectM_Delete(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session[ApplicationSession.USERID]), DateTime.UtcNow.AddHours(5.5).ToString()); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>"); PanelVisibility(1); BindSubject(); } 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>"); } }
protected void ddlClass_SelectedIndexChanged(object sender, EventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); DivisionTBL objDivisionTbl = new DivisionTBL(); objResult = objDivisionTbl.DivisionT_SelectAll_For_Exam(Convert.ToInt32(ddlClass.SelectedValue)); if (objResult != null) { objControls.BindDropDown_ListBox(objResult.resultDT, lbDivision, "DivisionName", "DivisionTID"); if (objResult.resultDT.Rows.Count > 0) { DivisionTID = Convert.ToInt32(objResult.resultDT.Rows[0]["DivisionTID"].ToString()); ViewState["DivisionTID"] = DivisionTID; } } ApplicationResult objResult1 = new ApplicationResult(); SubjectMBL objSubjectMbl = new SubjectMBL(); Controls objControl = new Controls(); objResult1 = objSubjectMbl.SubjectM_Select_By_ClassDivision(Convert.ToInt32(ddlClass.SelectedValue), DivisionTID); if (objResult1 != null) { objControl.BindDropDown_ListBox(objResult1.resultDT, lbSrcSubject, "NameEng", "SubjectMID"); //PanelVisibility(1); } else { //PanelVisibility(2); } } 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 BindSubject1() { try { ApplicationResult objResult = new ApplicationResult(); SubjectMBL objSubjectMbl = new SubjectMBL(); Controls objControl = new Controls(); objResult = objSubjectMbl.SubjectM_Select_By_School(Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResult != null) { objControl.BindDropDown_ListBox(objResult.resultDT, lbSrcSubject, "NameEng", "SubjectMID"); PanelVisibility(1); } else { PanelVisibility(2); } } 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_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>"); } }