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