public void UpdateGradeChangeMessage([FromBody] GradeChangeMessage message) { var errors = new List <string>(); IGradeChangeRepository gradeChange = new GradeChangeRepository(); new GradeChangeService(gradeChange).UpdateGradeChangeMessage(message, ref errors); }
public string InsertGradeChangeMessage(GradeChangeMessage message) { var errors = new List <string>(); IGradeChangeRepository gradeChange = new GradeChangeRepository(); new GradeChangeService(gradeChange).InsertGradeChangeMessage(message, ref errors); if (errors.Count == 0) { return("ok"); } return("error"); }
public void InsertGradeChangeMessageErrorTest5() { //// Arrange var errors = new List <string>(); var mockRepository = new Mock <IGradeChangeRepository>(); var gradeChangeService = new GradeChangeService(mockRepository.Object); var message = new GradeChangeMessage { StudentId = "test", MessageBody = "test" }; //// Act gradeChangeService.InsertGradeChangeMessage(message, ref errors); //// Assert Assert.AreEqual(0, errors.Count); }
public GradeChangeMessage GetGradeChangeMessageDetail(int id, List <string> errors) { var conn = new SqlConnection(ConnectionString); GradeChangeMessage message = null; try { var adapter = new SqlDataAdapter(GetGradeChangeInfoProcedure, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; adapter.SelectCommand.Parameters.Add(new SqlParameter("@id", SqlDbType.Int)); adapter.SelectCommand.Parameters["@id"].Value = id; var dataSet = new DataSet(); adapter.Fill(dataSet); if (dataSet.Tables[0].Rows.Count == 0) { return(null); } message = new GradeChangeMessage { GradeChangeId = id, StudentName = dataSet.Tables[0].Rows[0]["studentName"].ToString(), StudentId = dataSet.Tables[0].Rows[0]["studentId"].ToString(), CourseName = dataSet.Tables[0].Rows[0]["courseName"].ToString(), InstructorName = dataSet.Tables[0].Rows[0]["instructorName"].ToString(), MessageBody = dataSet.Tables[0].Rows[0]["message"].ToString(), Status = dataSet.Tables[0].Rows[0]["status"].ToString() }; } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } return(message); }
public void UpdateGradeChangeMessage(GradeChangeMessage message, ref List <string> errors) { var conn = new SqlConnection(ConnectionString); try { var adapter = new SqlDataAdapter(UpdateGradeChangeInfoProcedure, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; adapter.SelectCommand.Parameters.Add(new SqlParameter("@id", SqlDbType.Int)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@studentName", SqlDbType.VarChar, 128)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@studentId", SqlDbType.VarChar, 20)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@courseName", SqlDbType.VarChar, 50)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@instructorName", SqlDbType.VarChar, 50)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@message", SqlDbType.VarChar, 1000)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@status", SqlDbType.VarChar, 10)); adapter.SelectCommand.Parameters["@id"].Value = message.GradeChangeId; adapter.SelectCommand.Parameters["@studentName"].Value = message.StudentName; adapter.SelectCommand.Parameters["@studentId"].Value = message.StudentId; adapter.SelectCommand.Parameters["@courseName"].Value = message.CourseName; adapter.SelectCommand.Parameters["@instructorName"].Value = message.InstructorName; adapter.SelectCommand.Parameters["@message"].Value = message.MessageBody; adapter.SelectCommand.Parameters["@status"].Value = message.Status; var dataSet = new DataSet(); adapter.Fill(dataSet); } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } }
public void UpdateGradeChangeMessage(GradeChangeMessage message, ref List <string> errors) { if (message == null) { errors.Add("Grade change message cannot be null"); throw new ArgumentException(); } if (message.StudentId == null) { errors.Add("Invalid student id"); throw new ArgumentException(); } if (message.MessageBody == null) { errors.Add("Invalid message body"); throw new ArgumentException(); } this.repository.UpdateGradeChangeMessage(message, ref errors); }
public List <GradeChangeMessage> GetGradeChangeMessages(string studentId, bool isInstructor, ref List <string> errors) { var conn = new SqlConnection(ConnectionString); var messageList = new List <GradeChangeMessage>(); try { var adapter = new SqlDataAdapter(GetGradeChangeListProcedure, conn) { SelectCommand = { CommandType = CommandType.StoredProcedure } }; adapter.SelectCommand.Parameters.Add(new SqlParameter("@studentId", SqlDbType.VarChar, 20)); adapter.SelectCommand.Parameters.Add(new SqlParameter("@isInstructor", SqlDbType.Bit)); adapter.SelectCommand.Parameters["@studentId"].Value = studentId; if (isInstructor) { adapter.SelectCommand.Parameters["@isInstructor"].Value = 1; } else { adapter.SelectCommand.Parameters["@isInstructor"].Value = 0; } 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 message = new GradeChangeMessage { GradeChangeId = (int)dataSet.Tables[0].Rows[i]["id"], StudentName = dataSet.Tables[0].Rows[i]["studentName"].ToString(), StudentId = dataSet.Tables[0].Rows[i]["studentId"].ToString(), CourseName = dataSet.Tables[0].Rows[i]["courseName"].ToString(), InstructorName = dataSet.Tables[0].Rows[i]["instructorName"].ToString(), MessageBody = dataSet.Tables[0].Rows[i]["message"].ToString(), Status = dataSet.Tables[0].Rows[i]["status"].ToString() }; messageList.Add(message); } } catch (Exception e) { errors.Add("Error: " + e); } finally { conn.Dispose(); } return(messageList); }