public ActionResult SaveOrUpdate(SectionEntities sectionentities) { SectionBL sectionBl = new SectionBL(); int rowAffected = sectionBl.SaveOrUpdate(sectionentities); return(Json(rowAffected, JsonRequestBehavior.AllowGet)); }
private void GridDataBind() { try { ApplicationResult objResult = new ApplicationResult(); SectionBL objSectionBL = new SectionBL(); objResult = objSectionBL.Section_SelectAll(Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResult != null) { gvSection.DataSource = objResult.resultDT; gvSection.DataBind(); if (objResult.resultDT.Rows.Count > 0) { PanelGrid_VisibilityMode(1); } else { PanelGrid_VisibilityMode(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 ActionResult DeleteSeciton(int ID) { SectionBL sectionBl = new SectionBL(); int recordaffected = sectionBl.Delete(ID); return(Json(recordaffected, JsonRequestBehavior.AllowGet)); }
public ActionResult saveuser(int id, string ques) { //Update data to database SectionBL.UpdateQues(id, ques); return(RedirectToAction("questionManag")); }
public ActionResult addQues(Question q) { SectionBL.InsertToQues(q); Session["quesId"] = q.quesId; return(RedirectToAction("addQues")); }
public ActionResult AddSec(Models.Section s) { SectionBL.InsertToSec(s); Session["SecId"] = s.secId; return(RedirectToAction("AddSec")); }
private DataTable FetchSection(int intSchoolID) { // DataTable dtStudent = new DataTable(); SectionBL objSectionBL = new SectionBL(); SectionBO objSectionBO = new SectionBO(); ApplicationResult objResults = new ApplicationResult(); objResults = objSectionBL.Section_SelectAll_ForDropDown(intSchoolID); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0) { } return(objResults.resultDT); }
public void GetAllGradeForDrp() { List <GradeEntities> gradeList = new List <GradeEntities>(); SectionBL sectionBl = new SectionBL(); gradeList = sectionBl.GetAllGradeForDrp(); ViewBag.getAllGradeForDrp = gradeList.Select(x => new SelectListItem { Text = x.Grade, Value = x.ID.ToString() } ); }
public void getSectionName() { ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); SectionBL objStatusBl = new SectionBL(); objResult = objStatusBl.Section_SelectAll(Convert.ToInt32(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]))); if (objResult != null) { objControls.BindDropDown_ListBox(objResult.resultDT, ddlSection, "SectionName", "SectionMID"); if (objResult.resultDT.Rows.Count > 0) { } ddlSection.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "")); } }
public bool ValidateName() { ApplicationResult objResults = new ApplicationResult(); SectionBL objSectionBL = new SectionBL(); if (ViewState["Mode"].ToString() == "Save") { objResults = objSectionBL.Section_ValidateName(txtSectionName.Text, txtAbbreviation.Text, -1, Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); } else { objResults = objSectionBL.Section_ValidateName(txtSectionName.Text, txtAbbreviation.Text, Convert.ToInt32(ViewState["SectionMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); } if (objResults.resultDT.Rows.Count > 0) { return(true); } return(false); }
/// <summary> /// Initialization /// </summary> public override void _Ready() { //Intializing nodes sectionBL = new SectionBL(); studentScoreBL = new StudentScoreBL(); forwardBtn = GetNode <TextureButton>("ArrowNavigation/ForwardButton"); backWardBtn = GetNode <TextureButton>("ArrowNavigation/BackwardButton"); sectionLbl = GetNode <Label>("Title/SectionName"); level1 = GetNode <TextureButton>("Levels/Level1"); level2 = GetNode <TextureButton>("Levels/Level2"); level3 = GetNode <TextureButton>("Levels/Level3"); level4 = GetNode <TextureButton>("Levels/Level4"); level5 = GetNode <TextureButton>("Levels/Level5"); level6 = GetNode <TextureButton>("Levels/Level6"); bg = GetNode <Sprite>("Bg"); bgList = new List <string>(); bgList.Add("res://Assets/LevelUI/LvlMap03.png"); bgList.Add("res://Assets/LevelUI/LvlMap01.png"); bgList.Add("res://Assets/LevelUI/LvlMap02.png"); //On load set section id to 1 to display section 1 Global.SectionId = 1; sectionList = sectionBL.GetWorldSections(Global.WorldId); sectionLbl.Text = sectionList[count - 1].SectionName; //Star path string[] starArray = new string[3]; starArray[0] = "Level/1 stars.png"; starArray[1] = "Level/2 stars.png"; starArray[2] = "Level/3 stars.png"; //Disable forward n back btns if only have 1 level DisableBothButtons(); backWardBtn.Disabled = true; HideLevels(); DisplayLevelScore(); }
public JsonResult LoadAllSectionPageWise() { int draw, start, length; int pageIndex = 0; if (null != Request.Form.GetValues("draw")) { draw = int.Parse(Request.Form.GetValues("draw").FirstOrDefault().ToString()); start = int.Parse(Request.Form.GetValues("start").FirstOrDefault().ToString()); length = int.Parse(Request.Form.GetValues("length").FirstOrDefault().ToString()); } else { draw = 1; start = 0; length = 50; } if (start == 0) { pageIndex = 1; } else { pageIndex = (start / length) + 1; } SectionBL sectionBl = new SectionBL(); int totalrecords = 0; List <SectionEntities> sectionList = new List <SectionEntities>(); sectionList = sectionBl.GetAllSectionPageWise(pageIndex, ref totalrecords, length); var data = sectionList; return(Json(new { draw = draw, recordsFiltered = totalrecords, recordsTotal = totalrecords, data = data }, JsonRequestBehavior.AllowGet)); }
public ActionResult user(int id = -1) { if (Session["UserId"] == null) { return(RedirectToAction("LogIn")); } else { ViewBag.getCrs = CourseBL.DisplayAll(); ViewBag.Model = CourseBL.getCourseById(id); ViewBag.Doc = CourseBL.getInsByCid(id, "دكتور"); ViewBag.Assistant = CourseBL.getInsByCid(id, "معيد"); ViewBag.getSpe = CourseBL.GetSpecializationsByCid(id); ViewBag.getSec = SectionBL.DisplayAllSections(); ViewBag.getQues = SectionBL.DisplayAllQuestions(); ViewBag.SelectedItemDDL = id; // UserInfo u = new UserInfo(); //Session["UserId"] = u.userId; ViewBag.UserId = Session["userId"]; return(View()); } }
public void BindSection() { try { SectionBL ObjSectionBl = new SectionBL(); ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); objResult = ObjSectionBl.Section_SelectAll_SectionMID(Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { objControls.BindDropDown_ListBox(objResult.resultDT, ddlSection, "SectionName", "SectionMID"); ddlSection.Items.Insert(0, new ListItem("-Select-", "")); } } } 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 ActionResult addQues() { ViewBag.getSec = SectionBL.DisplayAllSectionsToManag(); return(View()); }
public ActionResult questionManag() { return(View(SectionBL.DisplayAllQuestionsOfSpecificSection(1))); }
protected void btnSave_Click(object sender, EventArgs e) { try { ApplicationResult objResults = new ApplicationResult(); SectionBO objSectionBO = new SectionBO(); SectionBL objSectionBL = new SectionBL(); SectionTBO objSectionTBO = new SectionTBO(); objSectionBO.SectionName = txtSectionName.Text; objSectionBO.SectionAvbbreviation = txtAbbreviation.Text; objSectionBO.Description = txtSectionDesc.Text; objSectionBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objSectionBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); if (ValidateName() == true) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Section Name or/and Section Abbrev " + txtSectionName.Text + "/" + txtAbbreviation.Text + " Already Exists.');</script>"); goto Exit; } #region RollBack Transaction Starts DatabaseTransaction.OpenConnectionTransation(); if (ViewState["Mode"].ToString() == "Save") { objResults = objSectionBL.Section_Insert(objSectionBO); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { ViewState["SectionMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString()); objSectionTBO.SectionMID = Convert.ToInt32(ViewState["SectionMID"].ToString()); objSectionTBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objSectionTBO.MediumMID = 1; objSectionTBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objSectionTBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResults = objSectionBL.SectionT_Insert(objSectionTBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { } } } ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Section Created Successfully.');</script>"); //GridDataBind(); PanelGrid_VisibilityMode(1); } else { ApplicationResult objResultsUpdate = new ApplicationResult(); objSectionBO.SectionMID = Convert.ToInt32(ViewState["SectionMID"].ToString()); objResultsUpdate = objSectionBL.Section_Update(objSectionBO); if (objResultsUpdate.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Section updated successfully.');</script>"); ClearAll(); } } DatabaseTransaction.CommitTransation(); GridDataBind(); #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>"); } }
public ActionResult questionManagement(int id = -1) { ViewBag.getSec = SectionBL.DisplayAllSectionsThatHaveQuestion(); ViewBag.getQues = SectionBL.DisplayAllQuestions(id); return(View()); }
public ActionResult EditQues(int quesId, string ques) { SectionBL.UpdateQues(quesId, ques); return(RedirectToAction("questionManagment")); }
protected void ddlSchoolName_SelectedIndexChanged(object sender, EventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); SectionBL objSectionBl = new SectionBL(); objResult = objSectionBl.Section_SelectAll_ForDropDown(Convert.ToInt32(ddlSchoolName.SelectedValue)); if (objResult != null) { objControls.BindDropDown_ListBox(objResult.resultDT, ddlSection, "SectionName", "SectionMID"); if (objResult.resultDT.Rows.Count > 0) { } ddlSection.Items.Insert(0, new ListItem("--Select--", "")); } #region Fetch Academic Month from School SchoolBL objSchoolBl = new SchoolBL(); ApplicationResult objResults = new ApplicationResult(); int intMonth = 0; objResults = objSchoolBl.School_Select(Convert.ToInt32(ddlSchoolName.SelectedValue)); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { intMonth = Convert.ToInt32(objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ACADEMICMONTH].ToString()); } } #endregion int month = System.DateTime.Now.Month; int Year = System.DateTime.Now.Year; int lastTwoDigit = Year % 100; string yr = string.Empty; if (month >= intMonth) { yr = (lastTwoDigit.ToString() + (lastTwoDigit + 1).ToString()).ToString(); } else { yr = ((lastTwoDigit - 1).ToString() + lastTwoDigit.ToString()).ToString(); } int f = (Convert.ToInt32(yr.Substring(0, 2))); int l = (Convert.ToInt32(yr.Substring(2, 2))); DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("AcademicYear", typeof(string))); for (int i = 0; i < 5; i++) { dr = dt.NewRow(); if (i == 0) { dr["AcademicYear"] = Convert.ToString(f.ToString() + "-" + l.ToString()); dt.Rows.Add(dr); } else { if ((f - 1).ToString().Length < 2) { if (f.ToString().Length == 2) { dr["AcademicYear"] = Convert.ToString("0" + (f - 1).ToString() + "-" + (f).ToString()); } else { dr["AcademicYear"] = Convert.ToString("0" + (f - 1).ToString() + "-" + "0" + (f).ToString()); } dt.Rows.Add(dr); } else { dr["AcademicYear"] = Convert.ToString((f - 1).ToString() + "-" + (f).ToString()); dt.Rows.Add(dr); } f = f - 1; l = f; } } objControls.BindDropDown_ListBox(dt, ddlYear, "AcademicYear", "AcademicYear"); ddlYear.Items.Insert(0, new ListItem("-Select-", "-1")); } catch (Exception) { throw; } }
protected void gvStudent_RowCommand(object sender, GridViewCommandEventArgs e) { try { btnSave.Enabled = true; btnSave.Attributes.Add("bgcolor", "#848484"); Controls objControls = new Controls(); StudentBL objStudentBL = new StudentBL(); ApplicationResult objResults = new ApplicationResult(); if (e.CommandName.ToString() == "Edit1") { ViewState["StudentMID"] = Convert.ToInt32(e.CommandArgument.ToString()); objResults = objStudentBL.Student_Select(Convert.ToInt32(ViewState["StudentMID"].ToString()), 0); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { ViewState["DivisionName"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString(); #region Find DivisionName DivisionTBL objDivision = new DivisionTBL(); ApplicationResult objResultsDivision = new ApplicationResult(); objResultsDivision = objDivision.DivisionT_Select_By_DivisionTID(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString())); if (objResultsDivision != null) { if (objResultsDivision.resultDT.Rows.Count > 0) { ViewState["Division"] = objResultsDivision.resultDT.Rows[0][DivisionTBO.DIVISIONT_DIVISIONNAME].ToString(); } } #endregion #region Find SectionName SectionBL objSection = new SectionBL(); ApplicationResult objResultsSection = new ApplicationResult(); objResultsSection = objSection.Section_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTSECTIONID].ToString())); if (objResultsSection != null) { if (objResultsSection.resultDT.Rows.Count > 0) { ViewState["SectionName"] = objResultsSection.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString(); } } #endregion #region Find Class ClassBL objClass = new ClassBL(); ApplicationResult objResultsClass = new ApplicationResult(); objResultsClass = objClass.Class_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTCLASSID].ToString())); if (objResultsClass != null) { if (objResultsClass.resultDT.Rows.Count > 0) { ViewState["ClassMID"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSMID].ToString(); ViewState["ClassName"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSNAME].ToString(); } } #endregion ViewState["AcademicYear"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString(); } } } } 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 ActionResult EditSec(int secId, string sec) { SectionBL.UpdateSec(secId, sec); return(RedirectToAction("secManagment")); }
public ActionResult secManagement() { return(View(SectionBL.DisplayAllSections())); }
public ActionResult GetSectionByID(int ID) { SectionBL sectionBl = new SectionBL(); return(Json(sectionBl.GetSectionByID(ID), JsonRequestBehavior.AllowGet)); }
public ActionResult deActiveQues(int quesId, int active) { SectionBL.deActiveQues(quesId, active); return(RedirectToAction("questionManagement")); }
public ActionResult deActiveSec(int secId, int active) { SectionBL.deActiveSec(secId, active); return(RedirectToAction("sectionManagement")); }
protected void gvStudent_RowCommand(object sender, GridViewCommandEventArgs e) { try { Controls objControls = new Controls(); StudentBL objStudentBL = new StudentBL(); ApplicationResult objResults = new ApplicationResult(); if (e.CommandName.ToString() == "Edit1") { ViewState["StudentMID"] = Convert.ToInt32(e.CommandArgument.ToString()); divStudentPanel.Visible = true; objResults = objStudentBL.Student_Select(Convert.ToInt32(ViewState["StudentMID"].ToString()), 0); divStudentPanel.Visible = true; if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { ViewState["DivisionName"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString(); #region Find DivisionName DivisionTBL objDivision = new DivisionTBL(); ApplicationResult objResultsDivision = new ApplicationResult(); objResultsDivision = objDivision.DivisionT_Select_By_DivisionTID(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString())); if (objResultsDivision != null) { if (objResultsDivision.resultDT.Rows.Count > 0) { ViewState["Division"] = objResultsDivision.resultDT.Rows[0][DivisionTBO.DIVISIONT_DIVISIONNAME].ToString(); } } #endregion #region Find SectionName SectionBL objSection = new SectionBL(); ApplicationResult objResultsSection = new ApplicationResult(); objResultsSection = objSection.Section_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTSECTIONID].ToString())); if (objResultsSection != null) { if (objResultsSection.resultDT.Rows.Count > 0) { ViewState["SectionName"] = objResultsSection.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString(); } } #endregion #region Find Class ClassBL objClass = new ClassBL(); ApplicationResult objResultsClass = new ApplicationResult(); objResultsClass = objClass.Class_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTCLASSID].ToString())); if (objResultsClass != null) { if (objResultsClass.resultDT.Rows.Count > 0) { ViewState["ClassMID"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSNAME].ToString(); } } #endregion lblAdmissionNo.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_ADMISSIONNO].ToString(); lblCurrentGrNo.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTGRNO].ToString(); lblStudentNameEng.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_STUDENTLASTNAMEENG].ToString() + " " + objResults.resultDT.Rows[0][StudentBO.STUDENT_STUDENTFIRSTNAMEENG].ToString() + " " + objResults.resultDT.Rows[0][StudentBO.STUDENT_STUDENTMIDDLENAMEENG].ToString(); lblClassDivision.Text = ViewState["ClassMID"].ToString() + "-" + ViewState["Division"].ToString(); lblCurrentSection.Text = ViewState["SectionName"].ToString(); lblAcademicYear.Text = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString(); ViewState["AcademicYear"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString(); } } GridDataBind(); } } 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 gvSection_RowCommand(object sender, GridViewCommandEventArgs e) { try { Controls objControls = new Controls(); ApplicationResult objResults = new ApplicationResult(); TrustBL objTrustBl = new TrustBL(); SectionBL objSectionBL = new SectionBL(); ViewState["SectionMID"] = Convert.ToInt32(e.CommandArgument.ToString()); objResults = objTrustBl.Abbreviation_Validation(0, 0, Convert.ToInt32(ViewState["SectionMID"].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { txtAbbreviation.Enabled = false; } else { txtAbbreviation.Enabled = true; } } if (e.CommandName.ToString() == "Edit1") { objResults = objSectionBL.Section_Select(Convert.ToInt32(ViewState["SectionMID"].ToString())); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { txtSectionName.Text = objResults.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString(); txtAbbreviation.Text = objResults.resultDT.Rows[0][SectionBO.SECTION_SECTIONAVBBREVIATION].ToString(); txtSectionDesc.Text = objResults.resultDT.Rows[0][SectionBO.SECTION_DESCRIPTION].ToString(); ViewState["Mode"] = "Edit1"; PanelGrid_VisibilityMode(2); } } } else if ((e.CommandName.ToString() == "Delete1")) { objControls.EnableControls(Master.FindControl("ContentPlaceHolder1")); objResults = objSectionBL.Validate_Section_Delete(Convert.ToInt32(ViewState["SectionMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { if (Convert.ToInt32(objResults.resultDT.Rows[0]["SectionMID"]) == Convert.ToInt32(ViewState["SectionMID"].ToString())) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('There are Classes(s) associated with this Section. To delete this Section you need to delete Classes(s) first.');</script>"); goto Exit; } } } ApplicationResult objResultsDelete = new ApplicationResult(); objResultsDelete = objSectionBL.Section_Delete(Convert.ToInt32(e.CommandArgument.ToString())); if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS) { ApplicationResult objResultsDeleteT = new ApplicationResult(); objResultsDeleteT = objSectionBL.SectionT_Delete(Convert.ToInt32(e.CommandArgument.ToString())); if (objResultsDeleteT.status == ApplicationResult.CommonStatusType.SUCCESS) { } ClearAll(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Section deleted successfully.');</script>"); GridDataBind(); PanelGrid_VisibilityMode(1); } } 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>"); } }