public void UpdatePrereqOverride(PrereqOverride prereq, ref List <string> errors) { var conn = new SqlConnection(ConnectionString); try { var adapter = new SqlDataAdapter(UpdatePrereqOverrideProcedure, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; adapter.SelectCommand.Parameters.Add(new SqlParameter("@student_id", SqlDbType.VarChar, 20)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@schedule_id", SqlDbType.Int)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@prof_pre_req_override_status", SqlDbType.Int)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@admin_pre_req_override_status", SqlDbType.Int)); adapter.SelectCommand.Parameters["@student_id"].Value = prereq.StudentId; adapter.SelectCommand.Parameters["@schedule_id"].Value = prereq.ScheduleId; adapter.SelectCommand.Parameters["@prof_pre_req_override_status"].Value = prereq.ProfPrereqOverrideStatus; adapter.SelectCommand.Parameters["@admin_pre_req_override_status"].Value = prereq.AdminPrereqOverrideStatus; var dataSet = new DataSet(); adapter.Fill(dataSet); } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } }
public void UpdatePrereqOverride(PrereqOverride prereqOverride, ref List <string> errors) { if (prereqOverride == null) { errors.Add("Prereq Override Application cannot be null"); //// throw new ArgumentException(); return; } if (this.CheckStudentId(prereqOverride.StudentId) == false) { errors.Add("Invalid Student Id"); //// throw new ArgumentException(); return; } if (prereqOverride.ScheduleId <= 0) { errors.Add("Prereq Override Schedule cannot be null"); //// throw new ArgumentException(); return; } if (string.IsNullOrEmpty(prereqOverride.StudentId)) { errors.Add("Student Id cannot be null"); //// throw new ArgumentException(); return; } this.repository.UpdatePrereqOverride(prereqOverride, ref errors); }
public List <PrereqOverride> GetPrereqOverride(int scheduleId, ref List <string> errors) { var conn = new SqlConnection(ConnectionString); var prereqList = new List <PrereqOverride>(); try { var adapter = new SqlDataAdapter(GetPrereqOverrideProcedure, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; adapter.SelectCommand.CommandType = CommandType.StoredProcedure; adapter.SelectCommand.Parameters.Add(new SqlParameter("@schedule_id", SqlDbType.Int)); adapter.SelectCommand.Parameters["@schedule_id"].Value = scheduleId; var dataSet = new DataSet(); adapter.Fill(dataSet); if (dataSet.Tables[0].Rows.Count == 0) { return(null); } for (var i = 0; i < dataSet.Tables[0].Rows.Count; i++) { var prereq = new PrereqOverride { StudentId = dataSet.Tables[0].Rows[i]["student_id"].ToString(), ScheduleId = (int)dataSet.Tables[0].Rows[i]["schedule_id"], CourseTitle = dataSet.Tables[0].Rows[i]["course_title"].ToString(), ProfPrereqOverrideStatus = (int)dataSet.Tables[0].Rows[i]["prof_pre_req_override_status_flag"], AdminPrereqOverrideStatus = (int)dataSet.Tables[0].Rows[i]["admin_pre_req_override_status_flag"] }; prereqList.Add(prereq); } } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } return(prereqList); }
public string UpdatePrereqOverride(PrereqOverride prereq) { var errors = new List <string>(); var repository = new PrereqOverrideRepository(); var service = new PrereqOverrideService(repository); service.UpdatePrereqOverride(prereq, ref errors); if (errors.Count == 0) { return("ok"); } return("error"); }
//// [ExpectedException(typeof(ArgumentException))] public void InsertPrereqOverrideNegativeScheduleIdTest() { //// Arrange var errors = new List <string>(); var mockRepository = new Mock <IPrereqOverrideRepository>(); var prereqOverrideService = new PrereqOverrideService(mockRepository.Object); var prereq = new PrereqOverride { StudentId = "A01234567", ScheduleId = -1, ProfPrereqOverrideStatus = 1, AdminPrereqOverrideStatus = 0 }; //// Act prereqOverrideService.InsertPrereqOverride(prereq, ref errors); //// Assert Assert.AreEqual(1, errors.Count); }
//// [ExpectedException(typeof(ArgumentException))] public void UpdatePrereqOverrideSuccessTest() { //// Arrange var errors = new List <string>(); var mockRepository = new Mock <IPrereqOverrideRepository>(); var prereqOverrideService = new PrereqOverrideService(mockRepository.Object); var prereq = new PrereqOverride { StudentId = "A0123456", ScheduleId = 2, ProfPrereqOverrideStatus = 1, AdminPrereqOverrideStatus = 0 }; //// Act prereqOverrideService.UpdatePrereqOverride(prereq, ref errors); //// Assert Assert.AreEqual(0, errors.Count); }
////[ExpectedException(typeof(ArgumentException))] public void UpdatePrereqOverrideEmptyStudentIdTest() { //// Arrange var errors = new List <string>(); var mockRepository = new Mock <IPrereqOverrideRepository>(); var prereqOverrideService = new PrereqOverrideService(mockRepository.Object); var prereq = new PrereqOverride { StudentId = string.Empty }; //// Act prereqOverrideService.UpdatePrereqOverride(prereq, ref errors); //// Assert Assert.AreEqual(1, errors.Count); }