public List<Module> GetAllModulesForLecturer(string StaffNumber) { List<Module> _moduleList = null; SqlParameter[] Params = { new SqlParameter("@StaffNumber", StaffNumber) }; using (DataTable table = DataAccess.ExecuteParamatizedSelectCommand("sp_GetModules4Lecturer", CommandType.StoredProcedure, Params)) { if (table.Rows.Count > 0) { _moduleList = new List<Module>(); foreach (DataRow row in table.Rows) { Module _module = new Module(); _module.NumberOfScheduledClasses = Convert.ToInt32(row["NumberOfClasses"]); _module.ModuleCode = row["ModuleCode"].ToString(); _module.ModuleName = row["ModuleName"].ToString(); _module.StaffNumber = row["StaffNumber"].ToString(); _module.QualificationCode = Convert.ToInt32(row["QualificationCode"]); _moduleList.Add(_module); } } } return _moduleList; }
public ActionResult Create(CreateModuleViewModel _model, FormCollection collector) { BusinessLogicHandler _gateWay = new BusinessLogicHandler(); Module _module = new Module(); _module.ModuleCode = _model.ModuleCode; _module.ModuleName = _model.ModuleName; _module.NumberOfScheduledClasses = _model.NumberOfScheduledClasses; _module.QualificationCode = Convert.ToInt32(collector.GetValue("Qualifications").AttemptedValue); try { if(_gateWay.InsertModule(_module)) { return RedirectToAction("Index");/*CHANGE THIS HERE*/ } else { #region Load Dropdown List<Qualification> _qualifications = new List<Qualification>(); _qualifications = _gateWay.GetQualifications(); List<SelectListItem> _qualList = new List<SelectListItem>(); foreach (var _qualification in _qualifications) { _qualList.Add(new SelectListItem { Text = _qualification.QualificationName, Value = _qualification.QualificationCode.ToString() }); } ViewData["Qualifications"] = _qualList; _model.Qualifications = _qualList; #endregion return View(_model); } } catch (Exception ex) { ModelState.AddModelError("" + ex.Source, ex); #region Load Dropdown List<Qualification> _qualifications = new List<Qualification>(); _qualifications = _gateWay.GetQualifications(); List<SelectListItem> _qualList = new List<SelectListItem>(); foreach (var _qualification in _qualifications) { _qualList.Add(new SelectListItem { Text = _qualification.QualificationName, Value = _qualification.QualificationCode.ToString() }); } ViewData["Qualifications"] = _qualList; _model.Qualifications = _qualList; #endregion return View(_model); } }
public Module GetModule(string ModuleCode) { Module _module = null; SqlParameter[] Params = { new SqlParameter("@ModuleCode", ModuleCode) }; using (DataTable table = DataAccess.ExecuteParamatizedSelectCommand("sp_GetModule", CommandType.StoredProcedure, Params)) { if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; _module = new Module(); _module.NumberOfScheduledClasses = Convert.ToInt32(row["NumberOfClasses"]); _module.ModuleCode = row["ModuleCode"].ToString(); _module.ModuleName = row["ModuleName"].ToString(); _module.StaffNumber = row["StaffNumber"].ToString(); _module.QualificationCode = Convert.ToInt32(row["QualificationCode"]); } } return _module; }
public List<Module> GetAllModules() { List<Module> _moduleList = null; using (DataTable table = DataAccess.ExecuteSelectCommand("sp_GetAllModules", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { _moduleList = new List<Module>(); foreach (DataRow row in table.Rows) { Module _module = new Module(); _module.NumberOfScheduledClasses = Convert.ToInt32(row["NumberOfClasses"]); _module.ModuleCode = row["ModuleCode"].ToString(); _module.ModuleName = row["ModuleName"].ToString(); _module.StaffNumber = row["StaffNumber"].ToString(); _module.QualificationCode = Convert.ToInt32(row["QualificationCode"]); _moduleList.Add(_module); } } } return _moduleList; }
public bool NewModule(Module _module) { SqlParameter[] Params = new SqlParameter[] { new SqlParameter("@ModuleCode", _module.ModuleCode), new SqlParameter("@ModuleName", _module.ModuleName), new SqlParameter("@NumberOfClasses",_module.NumberOfScheduledClasses), new SqlParameter("@StaffNumber", _module.StaffNumber), new SqlParameter("@QualificationCode", _module.QualificationCode) }; return DataAccess.ExecuteNonQuery("sp_InsertModule", CommandType.StoredProcedure, Params); }
public bool InsertModule(Module _module) { ModuleHandler myHandler = new ModuleHandler(); return myHandler.NewModule(_module); }