public static int Insert(ActAddRequest model)
{
int id = 0;
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "dbo.Act_Insert";
MapCommonActParameters(model, cmd);
cmd.Parameters.AddWithValue("@UserIdCreated", HttpContext.Current.User.Identity.GetUserId());
SqlParameter outputId = new SqlParameter("@Id", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
cmd.Parameters.Add(outputId);
cmd.ExecuteNonQuery();
id = (int)outputId.Value;
}
conn.Close();
}
return(id);
}
private static void MapCommonActParameters(ActAddRequest model, SqlCommand cmd)
{
cmd.Parameters.AddWithValue("@Title", model.Title ?? String.Empty);
cmd.Parameters.AddWithValue("@Summary", model.Summary ?? String.Empty);
cmd.Parameters.AddWithValue("@Notes", model.Notes ?? String.Empty);
cmd.Parameters.AddWithValue("@CentralQuestion", model.CentralQuestion ?? String.Empty);
cmd.Parameters.AddWithValue("@ProjectId", model.ProjectId);
}
public HttpResponseMessage Insert(ActAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
response.Item = ActService.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
