protected void ddlSubject_OnSelectedIndexChanged(object sender, EventArgs e) { try { DropDownList ddl1 = (sender as DropDownList); string strname = ddl1.ID; string i = strname.Substring(strname.Length - 1, 1); if (i == "0") { i = "10"; } DropDownList ddl2 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlTeacher" + i.ToString()) as DropDownList; ddl2.Items.Clear(); ApplicationResult objResult = new ApplicationResult(); SubjectTBL objSubjectTbl = new SubjectTBL(); Controls objControls = new Controls(); objResult = objSubjectTbl.SubjectT_Select_Teacher(Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue), Convert.ToInt32(ddl1.SelectedValue)); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { objControls.BindDropDown_ListBox(objResult.resultDT, ddl2, "EmployeeFNameENG", "EmployeeMID"); } } ddl2.Items.Insert(0, new ListItem("None", "-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>"); } }
public void BindSubject(int intMode) { ApplicationResult objResult = new ApplicationResult(); SubjectTBL objSubjectTbl = new SubjectTBL(); Controls objControl = new Controls(); objResult = objSubjectTbl.Subject_Select_By_Class_Division(Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue), intMode, Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString())); if (objResult != null) { objControl.BindDropDown_ListBox(objResult.resultDT, ddlSubject, "NameEng", "SubjectMID"); } ddlSubject.Items.Insert(0, new ListItem("--Select--", "")); }
protected void gvTeacher_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "DeleteTeacher") { if (ViewState["Mode"].ToString() == "Save") { GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer); DataTable dtTeacher = (DataTable)ViewState["Teacher"]; dtTeacher.Rows.RemoveAt(row.RowIndex); dtTeacher.AcceptChanges(); ViewState["Teacher"] = dtTeacher; gvTeacher.DataSource = (DataTable)ViewState["Teacher"]; gvTeacher.DataBind(); } else if (ViewState["Mode"].ToString() == "Edit") { ApplicationResult objResult = new ApplicationResult(); SubjectTBL objSubjectTbl = new SubjectTBL(); SubjectTBO objSubjectTbo = new SubjectTBO(); objSubjectTbo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue); objSubjectTbo.DivisionTID = Convert.ToInt32(ddlDivision.SelectedValue); objSubjectTbo.SubjectMID = Convert.ToInt32(ddlSubject.SelectedValue); objSubjectTbo.EmployeeMID = Convert.ToInt32(e.CommandArgument.ToString()); objResult = objSubjectTbl.SubjectT_Delete_Association(objSubjectTbo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { objResult = objSubjectTbl.SubjectT_Select(objSubjectTbo); ViewState["Teacher"] = objResult.resutlDS.Tables[1]; gvTeacher.DataSource = (DataTable)ViewState["Teacher"]; gvTeacher.DataBind(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>"); } 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 gvSubjectAssociation_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); SubjectTBL objSubjectTbl = new SubjectTBL(); SubjectTBO objSubjectTbo = new SubjectTBO(); objSubjectTbo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue); objSubjectTbo.DivisionTID = Convert.ToInt32(ddlDivision.SelectedValue); objSubjectTbo.SubjectMID = Convert.ToInt32(e.CommandArgument.ToString()); if (e.CommandName == "Edit1") { BindSubject(1); ViewState["Mode"] = "Edit"; objResult = objSubjectTbl.SubjectT_Select(objSubjectTbo); ddlSubject.SelectedValue = objResult.resutlDS.Tables[0].Rows[0][SubjectTBO.SUBJECTT_SUBJECTMID].ToString(); ViewState["Teacher"] = objResult.resutlDS.Tables[1]; gvTeacher.DataSource = (DataTable)ViewState["Teacher"]; gvTeacher.DataBind(); PanelVisibility(2); } else if (e.CommandName == "Delete1") { objResult = objSubjectTbl.SubjectT_Delete(objSubjectTbo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record deleted successfully.');</script>"); BindSubjectAssociation(); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('You cannot delete this record because it is in used.');</script>"); } ClearAll(); } } 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 BindSubjectAssociation() { ApplicationResult objResult = new ApplicationResult(); SubjectTBL objSubjectTbl = new SubjectTBL(); objResult = objSubjectTbl.SubjectT_SelectAll_By_Class_Division(Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue)); if (objResult.resultDT.Rows.Count > 0) { gvSubjectAssociation.DataSource = objResult.resultDT; gvSubjectAssociation.DataBind(); PanelVisibility(1); } else { BindSubject(2); PanelVisibility(2); } }
public void BindSubject() { ApplicationResult objResult = new ApplicationResult(); SubjectTBL objSubjectTbl = new SubjectTBL(); Controls objControl = new Controls(); int intCount = Convert.ToInt32(hfNoOfPeriod.Value); objResult = objSubjectTbl.SubjectT_SelectAll_By_Class_Division(Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue)); if (objResult != null) { for (int i = 1; i <= intCount; i++) { DropDownList ddl = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlSubject" + i.ToString()) as DropDownList; objControl.BindDropDown_ListBox(objResult.resultDT, ddl, "Subject", "SubjectMID"); } } for (int j = 1; j <= intCount; j++) { DropDownList ddl1 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlSubject" + j.ToString()) as DropDownList; DropDownList ddl2 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlTeacher" + j.ToString()) as DropDownList; ddl1.Items.Insert(0, new ListItem("None", "-1")); ddl2.Items.Insert(0, new ListItem("None", "-1")); } }
protected void btnSaveClass_OnClick(object sender, EventArgs e) { try { if (ViewState["Count"] != null) { if (Convert.ToInt32(ViewState["Count"].ToString()) > 0) { ApplicationResult objResult = new ApplicationResult(); SubjectTBO objSubjectTbo = new SubjectTBO(); SubjectTBL objSubjectTbl = new SubjectTBL(); string strEmployeeMIDs = null; objSubjectTbo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()); objSubjectTbo.ClassMID = Convert.ToInt32(ddlClass.SelectedValue); objSubjectTbo.DivisionTID = Convert.ToInt32(ddlDivision.SelectedValue); objSubjectTbo.SubjectMID = Convert.ToInt32(ddlSubject.SelectedValue); DataTable dtTeacher = (DataTable)ViewState["Teacher"]; for (int i = 0; i < dtTeacher.Rows.Count; i++) { if (strEmployeeMIDs != null) { strEmployeeMIDs += "~"; } strEmployeeMIDs += dtTeacher.Rows[i]["EmployeeMID"].ToString(); } if (ViewState["Mode"].ToString() == "Save") { objResult = objSubjectTbl.SubjectT_Insert(objSubjectTbo, strEmployeeMIDs); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { objResult = objSubjectTbl.SubjectT_Update(objSubjectTbo, strEmployeeMIDs); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>"); } } ClearAll(); BindSubjectAssociation(); PanelVisibility(1); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Add teachers First.');</script>"); } } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please Add teachers First.');</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>"); } }