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