public void UpdateGraduateCourseApp(GraduateCourseApp graduateCourse, ref List <string> errors)
{
var conn = new SqlConnection(ConnectionString);
try
{
var adapter = new SqlDataAdapter(UpdateGraduateCourseAppProcedure, 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_graduate_course_approve", SqlDbType.Int));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@admin_graduate_course_approve", SqlDbType.Int));
adapter.SelectCommand.Parameters["@student_id"].Value = graduateCourse.StudentId;
adapter.SelectCommand.Parameters["@schedule_id"].Value = graduateCourse.ScheduleId;
adapter.SelectCommand.Parameters["@prof_graduate_course_approve"].Value = graduateCourse.ProfGraduateCourseApprove;
adapter.SelectCommand.Parameters["@admin_graduate_course_approve"].Value = graduateCourse.AdminGraduateCourseApprove;
var dataSet = new DataSet();
adapter.Fill(dataSet);
}
catch (Exception e)
{
errors.Add("Error: " + e);
}
finally
{
conn.Dispose();
}
}
public List <GraduateCourseApp> GetGraduateCourseApp(int scheduleId, ref List <string> errors)
{
var conn = new SqlConnection(ConnectionString);
var graduateCourseAppList = new List <GraduateCourseApp>();
try
{
var adapter = new SqlDataAdapter(GetGraduateCourseAppProcedure, conn)
{
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 graduateCourse = new GraduateCourseApp
{
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(),
ProfGraduateCourseApprove = (int)dataSet.Tables[0].Rows[i]["prof_graduate_course_approve"],
AdminGraduateCourseApprove = (int)dataSet.Tables[0].Rows[i]["admin_graduate_course_approve"]
};
graduateCourseAppList.Add(graduateCourse);
}
}
catch (Exception e)
{
errors.Add("Error: " + e);
}
finally
{
conn.Dispose();
}
return(graduateCourseAppList);
}
public string UpdateGraduateCourseApp(GraduateCourseApp graduateCourseApp)
{
var errors = new List <string>();
var repository = new GraduateCourseAppRepository();
var service = new GraduateCourseAppService(repository);
service.UpdateGraduateCourseApp(graduateCourseApp, ref errors);
if (errors.Count == 0)
{
return("ok");
}
return("error");
}
////[ExpectedException(typeof(ArgumentException))]
public void UpdateGraduateCourseAppErrorTestSuccess()
{
//// Arrange
var errors = new List <string>();
var mockRepository = new Mock <IGraduateCourseAppRepository>();
var graduatecourseappService = new GraduateCourseAppService(mockRepository.Object);
var x = new GraduateCourseApp {
StudentId = "A15614654564"
};
//// Act
graduatecourseappService.UpdateGraduateCourseApp(x, ref errors);
//// Assert
Assert.AreEqual(0, errors.Count);
}
public void UpdateGraduateCourseApp(GraduateCourseApp graduatecourseapp, ref List <string> errors)
{
if (graduatecourseapp == null)
{
errors.Add("GraduateCourseApp cannot be null");
return;
////throw new ArgumentException();
}
if (graduatecourseapp.StudentId.Length < 5)
{
errors.Add("Invalid student id length");
return;
////throw new ArgumentException();
}
this.repository.UpdateGraduateCourseApp(graduatecourseapp, ref errors);
}
