// Updates item in database by Id public static void UpdateCalendarItem(CalendarUpdateRequest model) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.CalendarData_Update" , inputParamMapper : delegate(SqlParameterCollection UpdateCalendarItem) { UpdateCalendarItem.AddWithValue("@Id", model.Id); UpdateCalendarItem.AddWithValue("@Title", model.Title); UpdateCalendarItem.AddWithValue("@Location", model.Location); UpdateCalendarItem.AddWithValue("@Description", model.Description); UpdateCalendarItem.AddWithValue("@StartTime", model.StartTime); UpdateCalendarItem.AddWithValue("@EndTime", model.EndTime); UpdateCalendarItem.AddWithValue("@Date", model.Date); }); }
public HttpResponseMessage Update(CalendarUpdateRequest model, int id) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } try { SuccessResponse response = new SuccessResponse(); CalendarService.UpdateCalendarItem(model); return(Request.CreateResponse(response)); } catch (Exception ex) { ErrorResponse er = new ErrorResponse(ex.Message); return(Request.CreateResponse(HttpStatusCode.BadRequest, er)); } }