public AjaxResponse PostMovie([FromBody] PostMovie newMovie)
{
try
{
int prod;
var httpRequest = HttpContext.Current.Request;
if (newMovie.Title != null)
{
prod = _helper.PostMovie(newMovie);
}
return(new AjaxResponse
{
Success = true,
Response = "Transaction successful",
});
}
catch (Exception x)
{
//req.CreateResponse(HttpStatusCode.InternalServerError);
return(new AjaxResponse
{
Success = false,
Response = "Request Failed",
ExceptionMessage = x.ToString()
});
}
}
public int PostMovie(PostMovie movie)
{
using (var con = new NpgsqlConnection(_Ycon))
{
int result;
var cmd = new NpgsqlCommand("\"submitmovie\"", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new NpgsqlParameter("reqTitle", NpgsqlTypes.NpgsqlDbType.Varchar));
cmd.Parameters[0].Value = movie.Title;
cmd.Parameters.Add(new NpgsqlParameter("reqGenreId", NpgsqlTypes.NpgsqlDbType.Integer));
cmd.Parameters[1].Value = movie.GenreId;
cmd.Parameters.Add(new NpgsqlParameter("reqSynopsis", NpgsqlTypes.NpgsqlDbType.Varchar));
cmd.Parameters[2].Value = movie.Synopsis;
cmd.Parameters.Add(new NpgsqlParameter("reqPosterUrl", NpgsqlTypes.NpgsqlDbType.Varchar));
cmd.Parameters[3].Value = movie.PosterUrl;
cmd.Parameters.Add(new NpgsqlParameter("reqTrailerUrl", NpgsqlTypes.NpgsqlDbType.Varchar));
cmd.Parameters[4].Value = movie.TrailerUrl;
cmd.Parameters.Add(new NpgsqlParameter("reqAmount", NpgsqlTypes.NpgsqlDbType.Varchar));
cmd.Parameters[5].Value = movie.Amount;
cmd.Parameters.Add(new NpgsqlParameter("reqHouseId", NpgsqlTypes.NpgsqlDbType.Integer));
cmd.Parameters[6].Value = movie.HouseId;
cmd.Parameters.Add(new NpgsqlParameter("reqReleaseDate", NpgsqlTypes.NpgsqlDbType.Date));
cmd.Parameters[7].Value = movie.ReleaseDate;
cmd.Parameters.Add(new NpgsqlParameter("reqCreatedBy", NpgsqlTypes.NpgsqlDbType.Varchar));
cmd.Parameters[8].Value = movie.CreatedBy;
cmd.Parameters.Add(new NpgsqlParameter("reqCreationDate", NpgsqlTypes.NpgsqlDbType.Date));
cmd.Parameters[9].Value = movie.CreationDate;
cmd.Parameters.Add(new NpgsqlParameter("reqUserId", NpgsqlTypes.NpgsqlDbType.Integer));
cmd.Parameters[10].Value = movie.UserId;
con.Open();
result = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
con.Dispose();
return(result);
}
}
public IHttpActionResult Post(PostMovie movie)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var service = CreateMovieService();
if (!service.CreateMovie(movie))
{
return(InternalServerError());
}
return(Ok());
}
public bool CreateMovie(PostMovie model)
{
var entity =
new Movie()
{
//OwnerId = _userId,
Title = model.Title,
Description = model.Description,
Genre = (Data.GenreType)model.Genre,
// AverageRating = model.AverageRating
};
using (var ctx = new ApplicationDbContext())
{
ctx.Movies.Add(entity);
return(ctx.SaveChanges() == 1);
}
}
