public int EnglishInsert(EnglishModel model) { int id = 0; using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("dbo.UsersEnglish_Insert", conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", model.UserId); cmd.Parameters.AddWithValue("@Passage1", model.Passage1); cmd.Parameters.AddWithValue("@Passage2", model.Passage2); cmd.Parameters.AddWithValue("@Passage3", model.Passage3); cmd.Parameters.AddWithValue("@Passage4", model.Passage4); cmd.Parameters.AddWithValue("@Passage5", model.Passage5); SqlParameter parm = new SqlParameter("@Id", SqlDbType.Int); parm.Direction = ParameterDirection.Output; cmd.Parameters.Add(parm); cmd.ExecuteNonQuery(); id = (int)cmd.Parameters["@Id"].Value; }; conn.Close(); } return(id); }
public HttpResponseMessage Insert(EnglishModel model) { try { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ; EnglishService svc = new EnglishService(); ItemResponse <int> resp = new ItemResponse <int>(); resp.Item = svc.EnglishInsert(model); return(Request.CreateResponse(HttpStatusCode.OK, resp)); } catch (Exception e) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e.Message)); } }