public ActionResult EditMovie(string sCode)
{
Movie_Info oMovie = lstMovies.Find(x => x.Movie_Code == sCode);
ViewBag.Media = MediaController.lstMedia_Types;
ViewBag.Genre = GenreController.lstGenres;
return(View(oMovie));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Movie_Info movie_Info = await db.Movie_Info.FindAsync(id);
db.Movie_Info.Remove(movie_Info);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "Movie_Id,M_ID,Movie_Name,Movie_Description,Movie_Rating")] Movie_Info movie_Info)
{
if (ModelState.IsValid)
{
db.Entry(movie_Info).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(movie_Info));
}
public ActionResult AddMovie(Movie_Info myMovie)
{
if (ModelState.IsValid)
{
lstMovies.Add(myMovie);
return(RedirectToAction("Index", "Home"));
}
else
{
return(View(myMovie));
}
}
public async Task <ActionResult> Create([Bind(Include = "Movie_Id,M_ID,Movie_Name,Movie_Description,Movie_Rating")] Movie_Info movie_Info)
{
if (ModelState.IsValid)
{
db.Movie_Info.Add(movie_Info);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(movie_Info));
}
public ActionResult Create(Movie_Info movie)
{
if (ModelState.IsValid)
{
list_movie.Add(movie);
return(RedirectToAction("Index", "Home"));
}
else
{
return(View(movie));
}
}
public ActionResult EditMovie(Movie_Info myMovie)
{
var obj = lstMovies.FirstOrDefault(x => x.Movie_Code == myMovie.Movie_Code);
if (obj != null)
{
obj.Movie_Code = myMovie.Movie_Code;
obj.Movie_Title = myMovie.Movie_Title;
obj.Genre_Code = myMovie.Genre_Code;
obj.Media_Code = myMovie.Media_Code;
}
return(RedirectToAction("Index", "Home"));
}
// GET: Movie_Info/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Movie_Info movie_Info = await db.Movie_Info.FindAsync(id);
if (movie_Info == null)
{
return(HttpNotFound());
}
return(View(movie_Info));
}
public ActionResult Edit(Movie_Info movie)
{
if (ModelState.IsValid)
{
/*var obj = list_movie.FirstOrDefault(x => x.Movie_code == movie.Movie_code);
* if (obj != null)
* {
* obj = movie;
* }*/
list_movie.RemoveAt(pos);
list_movie.Insert(pos, movie);
return(RedirectToAction("Index", "Home"));
}
else
{
return(View(movie));
}
}
/// <summary>
/// Insert new movies to database
/// </summary>
/// <returns></returns>
public static async Task MoviesToDatabase()
{
await History.Create(History.Type.API, new History_API()
{
api_action = "Starting task -> Add movies to local Database",
api_datetime = DateTime.Now,
api_type = "Task -> add movies to Db",
});
var list = new List <int>();
//item1 = MovieData, item2 = Match
foreach (var item in NewMovieEntry)
{
try
{
//check if movie is already in database with this title and update values only for data not info!!
var Db_Movie = await Db.Movie_Data.Where(x => x.name == item.Item1.name).FirstOrDefaultAsync();
if (Db_Movie == null)
{
//get movieinfo from api
if (MoviesAPI.countAPICalls > 30)
{
await Task.Delay(5000); MoviesAPI.countAPICalls = 0;
}
//editMovieInfo, movie[0] is array from method GetMovieName
Movie_Info mInfo = await MoviesAPI.Get.Info(item.Item2, DatabaseMovieCount);
if (mInfo.id != null)
{
//tagline error in database has max length of 128 char in SQL
if (mInfo.tagline.Length > 128)
{
mInfo.tagline = mInfo.tagline.Substring(0, 127);
}
item.Item1.Movie_Info = mInfo;
//set tick for movie length
item.Item1.Movie_Info.length = Media.Length(item.Item1);
try
{
Db.Movie_Data.Add(item.Item1);
await Db.SaveChangesAsync();
//databaseMovieCount++;
//temp.Add(mData);
Movie_Data movie = Db.Movie_Data.Where(x => x.name == item.Item1.name).First();
await History.Create(History.Type.API, new History_API()
{
api_action = "Movie " + movie.Movie_Info.title + " was added to the database as id " + movie.Id + "!",
api_datetime = DateTime.Now,
api_type = "Movie added to database",
});
list.Add(movie.Id);
}
catch (Exception ex)
{
await History.Create(History.Type.API, new History_API()
{
api_action = "Exception : Inserting movie to Database --> " + ex.Message,
api_datetime = DateTime.Now,
api_type = "Exception thrown InsertMoviesToDb",
});
}
}
else
{
await History.Create(History.Type.API, new History_API()
{
api_action = "Movie " + item.Item2.Groups["title"].ToString() + " was not added as there was a problem!",
api_datetime = DateTime.Now,
api_type = "Error on movie addition",
});
}
}
else
{
//update movie info but only directory at which the movie is located
await History.Create(History.Type.API, new History_API()
{
api_action = "Movie update -> Updating movie: " + Db_Movie.name + " directory!",
api_datetime = DateTime.Now,
api_type = "Task -> update movie data / info in SQL...",
});
if (await Database.Movie.Update.Directory(Db_Movie, item.Item1))
{
await History.Create(History.Type.API, new History_API()
{
api_action = "Movie update -> Succesfully updated movie: " + Db_Movie.name + " directory!",
api_datetime = DateTime.Now,
api_type = "Task -> Success",
});
}
else
{
await History.Create(History.Type.API, new History_API()
{
api_action = "Movie update -> Failed to update movie: " + Db_Movie.name + " directory!",
api_datetime = DateTime.Now,
api_type = "Task -> Failed",
});
}
}
}
catch (Exception ex)
{
await History.Create(History.Type.API, new History_API()
{
api_action = "Error -> An error occured : " + ex.Message,
api_datetime = DateTime.Now,
api_type = "Error occured on InsertMoviesToDb",
});
}
}
await History.Create(History.Type.API, new History_API()
{
api_action = "End of import of movies.",
api_datetime = DateTime.Now,
api_type = "Status -> InsertMoviesToDb",
});
History_API hapi;
if (list.Count == NewMovieEntry.Count)
{
hapi = new History_API()
{
api_type = "Movie to Db status",
api_datetime = DateTime.Now,
api_action = "Info -> All movies added (" + list.Count + " - ADDED)",
};
}
else if (list.Count < NewMovieEntry.Count)
{
hapi = new History_API()
{
api_type = "Movie to Db status",
api_datetime = DateTime.Now,
api_action = "Error -> Less movies added than found on local storage! Movies added " + list.Count,
};
}
else
{
hapi = new History_API()
{
api_type = "Movie to Db status",
api_datetime = DateTime.Now,
api_action = "Error -> Something went wrong with importing data to Db! Movies added " + list.Count,
};
}
if (hapi != null)
{
await History.Create(History.Type.API, hapi);
}
}
