public List<Module> GetDisabledModuleList(int lecturerID) { //gets list of disabled modules linked to a lecturer List<Module> listModules = null; SqlParameter[] paramaters = new SqlParameter[] { new SqlParameter("@LecturerID", lecturerID), }; using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("sp_GetDisabledModuleList", CommandType.StoredProcedure, paramaters)) { if (table.Rows.Count > 0) { listModules = new List<Module>(); foreach (DataRow row in table.Rows) { Module module = new Module(); module.ModuleID = Convert.ToInt32(row["ModuleID"]); module.ModuleCode = row["ModuleCode"].ToString(); module.LecturerID = Convert.ToInt32(row["LecturerID"]); module.Date = Convert.ToDateTime(row["Date"]); listModules.Add(module); } } } return listModules; }
protected void btnAddModule_Click(object sender, EventArgs e) { if (lstLecturers.SelectedIndex == -1) { lblLecturer.Text = "You must first select a lecturer from the box above."; } else { int lecturerID = Convert.ToInt32(lstLecturers.SelectedValue); int lastID = 0; Module newModule = new Module(); newModule.ModuleCode = txtModuleCode.Value; newModule.LecturerID = lecturerID; newModule.Date = Convert.ToDateTime(dateSelect.Value); ModuleHandler moduleHandler = new ModuleHandler(); lastID = moduleHandler.AddNewModule(newModule); if (lastID > 0) { litAlert.Text = "<div class='alert alert-success'>Module added</div>"; Response.Redirect("AddStudents.aspx?module=" + lastID); } else { litAlert.Text = "<div class='alert alert-danger'>Failed to add module</div>"; } } }
protected void Page_Load(object sender, EventArgs e) { string htmlOutput = ""; int moduleID = Convert.ToInt32(Request.QueryString["module"]); //get module name ModuleHandler moduleHandler = new ModuleHandler(); Module module = new Module(); module = moduleHandler.GetModuleDetails(Convert.ToInt32(moduleID)); litHeader.Text = "<div class='alert alert-info'>" + module.ModuleCode + "</div>"; StudentHandler studentHandler = new StudentHandler(); List<Student> listStudents = studentHandler.GetStudentList(moduleID); //Check to make sure there is students in the system assigned to the module if (listStudents == null) litHeader.Text = "<h3>There are currently no students linked to this module</h3>"; else { htmlOutput = "<tr><th>Student number</th><th>Firstname</th><th>Surname</th></tr>\n"; //add modules to table as it is generated for (int i = 0; i < listStudents.Count; i++) { htmlOutput += "<tr><td>" + listStudents[i].StudentNumber + "</td><td>" + listStudents[i].FirstName + "</td><td>" + listStudents[i].Surname + "</td></tr>\n"; } } litStudentList.Text = htmlOutput; }
public List <MenuClass> GetCTopMenu(int userId) { DataTable dt = new DAL.Module().GetCTopMenu(userId); List <MenuClass> list = new List <MenuClass>(); DataRow[] rows = dt.Select("ParentID=0"); if (rows.Length > 0) { for (int i = 0; i < rows.Length; i++) { MenuClass firstMenu = new MenuClass { MenuId = Convert.ToInt32(rows[i]["PKID"].ToString()), MenuName = rows[i]["Name"].ToString(), ParentID = Convert.ToInt32(rows[i]["ParentID"].ToString()), IsSystem = rows[i]["IsSysModule"].ToString(), ImageAddress = rows[i]["ImagesAddress"].ToString(), }; list.Add(firstMenu); DataRow[] r_list = dt.Select(string.Format("ParentID={0}", rows[i]["PKID"])); if (r_list.Length > 0) { firstMenu.Children = new List <MenuClass>(); for (int j = 0; j < r_list.Length; j++) { MenuClass secondMenu = new MenuClass { MenuId = Convert.ToInt32(r_list[j]["PKID"].ToString()), MenuName = r_list[j]["Name"].ToString(), ParentID = Convert.ToInt32(r_list[j]["ParentID"].ToString()), IsSystem = r_list[j]["IsSysModule"].ToString(), ImageAddress = r_list[j]["ImagesAddress"].ToString(), }; firstMenu.Children.Add(secondMenu); DataRow[] rows2 = dt.Select(string.Format("ParentID={0}", r_list[j]["PKID"])); if (rows2.Length > 0) { secondMenu.Children = new List <MenuClass>(); for (int k = 0; k < rows2.Length; k++) { MenuClass threeMenu = new MenuClass { MenuId = Convert.ToInt32(rows2[k]["PKID"].ToString()), MenuName = rows2[k]["Name"].ToString(), ParentID = Convert.ToInt32(rows2[k]["ParentID"].ToString()), IsSystem = rows2[k]["IsSysModule"].ToString(), ImageAddress = rows2[k]["ImagesAddress"].ToString(), MenuUrl = rows2[k]["PageAddress"].ToString(), }; secondMenu.Children.Add(threeMenu); } } } } } } return(list); }
public int AddNewModule(Module module) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ModuleCode", module.ModuleCode), new SqlParameter("@LecturerID", module.LecturerID), new SqlParameter("@Date", module.Date) }; return DBHelper.ExecuteNonQueryGetLastID("sp_AddNewModule", CommandType.StoredProcedure, parameters); }
protected void Page_Load(object sender, EventArgs e) { moduleID = Convert.ToInt32(Request.QueryString["id"]); //get module name ModuleHandler moduleHandler = new ModuleHandler(); Module module = new Module(); module = moduleHandler.GetModuleDetails(Convert.ToInt32(moduleID)); litHeader.Text = "<div class='alert alert-info'>" + module.ModuleCode + "</div>"; }
protected void btnAddModule_Click(object sender, EventArgs e) { int lastID = 0; Module newModule = new Module(); newModule.ModuleCode = txtModuleCode.Value; newModule.LecturerID = Convert.ToInt32(Session["lecturerID"]); newModule.Date = DateTime.Now; ModuleHandler moduleHandler = new ModuleHandler(); lastID = moduleHandler.AddNewModule(newModule); if (lastID > 0) { litHeader.Text = "Module added"; Response.Redirect("AddStudents.aspx?module=" + lastID); } else { litHeader.Text = "Failed to add module"; } }
public int AddNewModule(Module module) { return moduleDB.AddNewModule(module); }
public Module GetModuleDetails(int moduleID) { //gets list of disabled modules linked to a lecturer Module module = null; SqlParameter[] paramaters = new SqlParameter[] { new SqlParameter("@ModuleID", moduleID), }; using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("sp_GetModuleDetails", CommandType.StoredProcedure, paramaters)) { if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; module = new Module(); module.ModuleID = Convert.ToInt32(row["ModuleID"]); module.ModuleCode = row["ModuleCode"].ToString(); module.LecturerID = Convert.ToInt32(row["LecturerID"]); module.Date = Convert.ToDateTime(row["Date"]); } } return module; }