public HttpResponseMessage Add(CalendarAddRequest model) { string timenow = DateTime.Now.ToString(); if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } try { ItemResponse <int> response = new ItemResponse <int>(); response.Item = CalendarService.InsertCalendarItem(model); return(Request.CreateResponse(response)); } catch (Exception ex) { ErrorResponse er = new ErrorResponse(ex.Message); return(Request.CreateResponse(HttpStatusCode.BadRequest, er)); } }
// Inserts Item to the database public static int InsertCalendarItem(CalendarAddRequest model) { var id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.CalendarData_Insert" , inputParamMapper : delegate(SqlParameterCollection AddCalendarItem) { AddCalendarItem.AddWithValue("@Title", model.Title); AddCalendarItem.AddWithValue("@Location", model.Location); AddCalendarItem.AddWithValue("@Description", model.Description); AddCalendarItem.AddWithValue("@StartTime", model.StartTime); AddCalendarItem.AddWithValue("@EndTime", model.EndTime); AddCalendarItem.AddWithValue("@Date", model.EndTime); SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int); p.Direction = System.Data.ParameterDirection.Output; AddCalendarItem.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { int.TryParse(param["@Id"].Value.ToString(), out id); }); return(id); }