public void DeleteEnrollmentRule(EnrollmentRule enrollmentRule, ref List <string> errors)
{
var conn = new SqlConnection(ConnectionString);
try
{
var adapter = new SqlDataAdapter(DeleteEnrollmentRuleProcedure, conn)
{
SelectCommand =
{
CommandType = CommandType.StoredProcedure
}
};
var dataSet = new DataSet();
adapter.Fill(dataSet);
}
catch (Exception e)
{
errors.Add("Error: " + e);
}
finally
{
conn.Dispose();
}
}
public void UpdateEnrollmentRule(EnrollmentRule enrollmentRule, ref List <string> errors)
{
var conn = new SqlConnection(ConnectionString);
try
{
var adapter = new SqlDataAdapter(UpdateEnrollmentRuleProcedure, conn)
{
SelectCommand =
{
CommandType = CommandType.StoredProcedure
}
};
adapter.SelectCommand.Parameters.Add(new SqlParameter("@minimum_unit", SqlDbType.Int));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@maximum_unit", SqlDbType.Int));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@drop_wo_w_deadline", SqlDbType.Date));
adapter.SelectCommand.Parameters.Add(new SqlParameter("@drop_wo_f_deadline", SqlDbType.Date));
adapter.SelectCommand.Parameters["@minimum_unit"].Value = enrollmentRule.MinimumUnit;
adapter.SelectCommand.Parameters["@maximum_unit"].Value = enrollmentRule.MaximumUnit;
adapter.SelectCommand.Parameters["@drop_wo_w_deadline"].Value = enrollmentRule.DropWoWDeadline;
adapter.SelectCommand.Parameters["@drop_wo_f_deadline"].Value = enrollmentRule.DropWoFDeadline;
var dataSet = new DataSet();
adapter.Fill(dataSet);
}
catch (Exception e)
{
errors.Add("Error: " + e);
}
finally
{
conn.Dispose();
}
}
public void DeleteEnrollmentRule(EnrollmentRule enrollmentRule, ref List <string> errors)
{
if (enrollmentRule == null)
{
errors.Add("Enrollment rule cannot be null");
////throw new ArgumentException();
return;
}
this.repository.DeleteEnrollmentRule(enrollmentRule, ref errors);
}
public string DeleteEnrollmentRule(EnrollmentRule enrollmentRule)
{
var errors = new List <string>();
var repository = new EnrollmentRuleRepository();
var service = new EnrollmentRuleService(repository);
service.DeleteEnrollmentRule(enrollmentRule, ref errors);
if (errors.Count == 0)
{
return("ok");
}
return("error");
}
////[ExpectedException(typeof(ArgumentException))]
public void UpdateEnrollmentRuleErrorTest3()
{
//// Arrange
var errors = new List <string>();
var mockRepository = new Mock <IEnrollmentRuleRepository>();
var enrollmentRuleService = new EnrollmentRuleService(mockRepository.Object);
var enrollment = new EnrollmentRule {
MinimumUnit = 13, MaximumUnit = 20, DropWoWDeadline = "2015-08-25", DropWoFDeadline = "2015-09-28"
};
enrollmentRuleService.UpdateEnrollmentRule(enrollment, ref errors);
//// Assert
Assert.AreEqual(0, errors.Count);
}
public void UpdateEnrollmentRuleSuccessTest()
{
//// Arrange
var errors = new List <string>();
var mockRepository = new Mock <IEnrollmentRuleRepository>();
var enrollmentRuleService = new EnrollmentRuleService(mockRepository.Object);
var x = new EnrollmentRule {
MaximumUnit = 19
};
//// Act
enrollmentRuleService.UpdateEnrollmentRule(x, ref errors);
//// Assert
Assert.AreEqual(0, errors.Count);
}
public List <EnrollmentRule> GetEnrollmentRuleList(ref List <string> errors)
{
var conn = new SqlConnection(ConnectionString);
var enrollmentRuleList = new List <EnrollmentRule>();
try
{
var adapter = new SqlDataAdapter(GetEnrollmentRuleProcedure, conn)
{
SelectCommand =
{
CommandType = CommandType.StoredProcedure
}
};
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 enrollmentRule = new EnrollmentRule
{
MinimumUnit = (int)dataSet.Tables[0].Rows[i]["minimum_unit"],
MaximumUnit = (int)dataSet.Tables[0].Rows[i]["maximum_unit"],
DropWoWDeadline = dataSet.Tables[0].Rows[i]["drop_wo_w_deadline"].ToString(),
DropWoFDeadline = dataSet.Tables[0].Rows[i]["drop_wo_f_deadline"].ToString()
};
enrollmentRuleList.Add(enrollmentRule);
}
}
catch (Exception e)
{
errors.Add("Error: " + e);
}
finally
{
conn.Dispose();
}
return(enrollmentRuleList);
}
