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);
}
