public HttpResponseMessage EchoValidate(MeetingAddRequest model) { if (ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.OK, model)); } return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); }
public HttpResponseMessage Post(MeetingAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = _meetingsService.Insert(model); return(Request.CreateResponse(response)); }
private static void SetCommonParameters(MeetingAddRequest model, SqlParameterCollection parms) { parms.AddWithValue("@Name", model.Name); parms.AddWithValue("@Description", model.Description); parms.AddWithValue("@Date", model.Date); parms.AddWithValue("@StartTime", model.StartTime); parms.AddWithValue("@EndTime", model.EndTime); parms.AddWithValue("@MeetingTypeId", model.MeetingTypeId); parms.AddWithValue("@MeetingFormatId", model.MeetingFormatId); parms.AddWithValue("@IsTentative", model.Tentative); parms.AddWithValue("@IsPublic", model.Public); parms.AddWithValue("@UserId", UserService.GetCurrentUserId()); }
public int Insert(MeetingAddRequest model) { int id = 0; using (SqlConnection conn = GetConnection()) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "Meetings_Insert"; SetCommonParameters(model, cmd.Parameters); cmd.Parameters.AddOutputParameter("@Id", SqlDbType.Int); cmd.ExecuteNonQuery(); int.TryParse(cmd.Parameters["@Id"].Value.ToString(), out id); } } return(id); }
public int InsertOld(MeetingAddRequest model) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.Meetings_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { SetCommonParameters(model, paramCollection); SqlParameter p = new SqlParameter("@Id", System.Data.SqlDbType.Int); p.Direction = System.Data.ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { int.TryParse(param["@Id"].Value.ToString(), out id); } ); return(id); }
public HttpResponseMessage Echo(MeetingAddRequest model) { return(Request.CreateResponse(HttpStatusCode.OK, model)); }