public int Insert(PosterAddRequest model)
{
int result = 0;
using (SqlConnection conn = new SqlConnection(connectionString))
{
string cmdText = "Poster_Insert";
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter param = new SqlParameter();
param.ParameterName = "@Id";
param.SqlDbType = System.Data.SqlDbType.Int;
param.Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@Title", model.Title);
cmd.Parameters.AddWithValue("@Description", model.Description);
cmd.Parameters.AddWithValue("@Type", model.Type);
cmd.Parameters.AddWithValue("@Price", model.Price);
cmd.Parameters.AddWithValue("@ImageUrl", model.ImageUrl);
cmd.Parameters.AddWithValue("@ModifiedBy", model.ModifiedBy);
conn.Open();
cmd.ExecuteNonQuery();
//setting an explicit cast
result = (int)cmd.Parameters["@Id"].Value;
conn.Close();
}
}
return(result);
}
public void Insert_Test()
{
PosterAddRequest model = new PosterAddRequest
{
Title = "Batman",
Description = "Movie cover of the batmobile",
Type = "Movie",
Price = Convert.ToDecimal("12.99"),
ModifiedBy = "Me"
};
PosterService svc = new PosterService();
int result = svc.Insert(model);
Assert.IsTrue(result > 0, "The insert failed!");
}
// POST api/<controller>
public HttpResponseMessage Post([FromBody] PosterAddRequest model)
{
try
{
if (ModelState.IsValid)
{
PosterService svc = new PosterService();
ItemResponse <int> response = new ItemResponse <int>();
response.Item = svc.Insert(model);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, ex.Message));
}
}
