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