public async Task <IHttpActionResult> Post([FromBody] HolidayRequest holidayRequest)
{
var parts = holidayRequest.DateRange.Split(new[] { " - " }, StringSplitOptions.RemoveEmptyEntries);
var absence = new Models.Absence()
{
StartDate = DateTime.Parse(parts[0]),
EndDate = DateTime.Parse(parts[1])
};
var absenceRepository = new Repositories.AbsenceRepository();
await absenceRepository.Create(absence);
return(Ok());
}
public async Task Create(Models.Absence absence)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["main"].ConnectionString))
{
await conn.OpenAsync();
using (var cmd = new SqlCommand("Absence.AbsenceRequest_Create", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@StartDate", absence.StartDate));
cmd.Parameters.Add(new SqlParameter("@EndDate", absence.EndDate));
await cmd.ExecuteNonQueryAsync();
}
}
}
