public string addMovie(AddMovieRequestJSON req)
{
string res = string.Empty;
using (MovieEntities db = new MovieEntities())
{
foreach (var item in req.Movies)
{
StringBuilder sb = new StringBuilder();
foreach (var actor in item.actors)
{
sb.Append(actor + ",");
}
DateTime dt = DateTime.Now;
DateTime.TryParse(item.releasedate, out dt);
ObjectParameter output_result = new ObjectParameter("Result", typeof(Int32));
string title = !string.IsNullOrWhiteSpace(item.title) ? item.title : null;
string description = !string.IsNullOrWhiteSpace(item.description) ? item.description : null;
string language = !string.IsNullOrWhiteSpace(item.language) ? item.language : null;
string genre = !string.IsNullOrWhiteSpace(item.genre) ? item.genre : null;
string actors = !string.IsNullOrWhiteSpace(sb.ToString().TrimEnd(',')) ? sb.ToString().TrimEnd(',') : null;
decimal finalprice = 0.0m;
if (item.price.HasValue)
{
finalprice = item.price.Value;
}
db.pr_AddMovies(title, description, genre, language, dt, actors, finalprice, output_result);
if (output_result.Value != null)
{
int ouserId = (int)output_result.Value;
if (ouserId == 0)
{
res = "ERR:There seems to be an issue while adding Movies. Please try again.";
return(res);
}
}
}
}
return("Movies Added Successfully");
}