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