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