public void UpdateAdvisingMessage(AcademicAdvisingMessage message)
{
var errors = new List <string>();
IAcademicAdvisingRepository advising = new AcademicAdvisingRepository();
new AcademicAdvisingService(advising).UpdateAdvisingMessage(message, ref errors);
}
public string InsertAdvisingMessage(AcademicAdvisingMessage message)
{
var errors = new List <string>();
IAcademicAdvisingRepository advising = new AcademicAdvisingRepository();
new AcademicAdvisingService(advising).InsertAdvisingMessage(message, ref errors);
if (errors.Count == 0)
{
return("ok");
}
return("error");
}
public void InsertAcademicAdvisingMessageErrorTest4()
{
//// Arrange
var errors = new List <string>();
var mockRepository = new Mock <IAcademicAdvisingRepository>();
var academicAdvisingService = new AcademicAdvisingService(mockRepository.Object);
var message = new AcademicAdvisingMessage {
StudentId = "test", MessageBody = "test", MessageSubject = "test"
};
//// Act
academicAdvisingService.InsertAdvisingMessage(message, ref errors);
//// Assert
Assert.AreEqual(0, errors.Count);
}
public void InsertAcademicAdvisingMessageErrorTest3()
{
//// Arrange
var errors = new List <string>();
var mockRepository = new Mock <IAcademicAdvisingRepository>();
var academicAdvisingService = new AcademicAdvisingService(mockRepository.Object);
var message = new AcademicAdvisingMessage {
MessageBody = string.Empty
};
//// Act
academicAdvisingService.InsertAdvisingMessage(message, ref errors);
//// Assert
Assert.AreEqual(1, errors.Count);
}
public AcademicAdvisingMessage GetAdvisingMessageDetail(int id, ref List <string> errors)
{
var conn = new SqlConnection(ConnectionString);
AcademicAdvisingMessage message = null;
try
{
var adapter = new SqlDataAdapter(GetAcademicAdvisingInfoProcedure, 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 AcademicAdvisingMessage
{
AcademicAdvisingId = id,
StudentId = dataSet.Tables[0].Rows[0]["studentId"].ToString(),
StudentName = dataSet.Tables[0].Rows[0]["studentName"].ToString(),
SendToInstructor = (bool)dataSet.Tables[0].Rows[0]["sendtoInstructor"],
MessageSubject = dataSet.Tables[0].Rows[0]["messageSubject"].ToString(),
MessageBody = dataSet.Tables[0].Rows[0]["message"].ToString()
};
}
catch (Exception e)
{
errors.Add("Error: " + e);
}
finally
{
conn.Dispose();
}
return(message);
}
public void UpdateAdvisingMessage(AcademicAdvisingMessage message, ref List <string> errors)
{
if (message == null)
{
errors.Add("Academic advising message cannot be null");
throw new ArgumentException();
}
if (message.StudentId == null)
{
errors.Add("Academic advising message student id cannot be null");
throw new ArgumentException();
}
if (message.MessageBody == null)
{
errors.Add("Academic advising message body cannot be null");
throw new ArgumentException();
}
if (message.StudentId.Length > 20)
{
errors.Add("Invalid student id");
throw new ArgumentException();
}
if (message.MessageSubject.Length > 50)
{
errors.Add("Invalid message subject");
throw new ArgumentException();
}
if (message.MessageBody.Length > 256)
{
errors.Add("Message body too long!");
throw new ArgumentException();
}
this.repository.UpdateAdvisingMessage(message, ref errors);
}
public void InsertAdvisingMessage(AcademicAdvisingMessage message, ref List <string> errors)
{
var conn = new SqlConnection(ConnectionString);
try
{
var adapter = new SqlDataAdapter(InsertAcademicAdvisingInfoProcedure, conn)
{
SelectCommand =
{
CommandType = CommandType.StoredProcedure
}
};
adapter.SelectCommand.Parameters.Add(new SqlParameter("@studentId", SqlDbType.VarChar, 20));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@studentName", SqlDbType.VarChar, 50));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@sendToInstructor", SqlDbType.Bit));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@messageSubject", SqlDbType.VarChar, 50));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@message", SqlDbType.VarChar, 256));
adapter.SelectCommand.Parameters["@studentId"].Value = message.StudentId;
adapter.SelectCommand.Parameters["@studentName"].Value = message.StudentName;
adapter.SelectCommand.Parameters["@sendToInstructor"].Value = message.SendToInstructor;
adapter.SelectCommand.Parameters["@messageSubject"].Value = message.MessageSubject;
adapter.SelectCommand.Parameters["@message"].Value = message.MessageBody;
var dataSet = new DataSet();
adapter.Fill(dataSet);
}
catch (Exception e)
{
errors.Add("Error: " + e);
}
finally
{
conn.Dispose();
}
}
public List <AcademicAdvisingMessage> GetAdvisingMessages(string studentId, bool isInstructor, ref List <string> errors)
{
var conn = new SqlConnection(ConnectionString);
var messageList = new List <AcademicAdvisingMessage>();
try
{
var adapter = new SqlDataAdapter(GetAcademicAdvisingListProcedure, 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 AcademicAdvisingMessage
{
AcademicAdvisingId = (int)dataSet.Tables[0].Rows[i]["id"],
StudentId = dataSet.Tables[0].Rows[i]["studentId"].ToString(),
StudentName = dataSet.Tables[0].Rows[i]["studentName"].ToString(),
SendToInstructor = (bool)dataSet.Tables[0].Rows[i]["sendtoInstructor"],
MessageSubject = dataSet.Tables[0].Rows[i]["messageSubject"].ToString(),
MessageBody = dataSet.Tables[0].Rows[i]["message"].ToString()
};
messageList.Add(message);
}
}
catch (Exception e)
{
errors.Add("Error: " + e);
}
finally
{
conn.Dispose();
}
return(messageList);
}
