public Movy GetRandomMovie()
{
MovieDBEntities ORM = new MovieDBEntities();
Random rand = new Random();
return(ORM.Movies.ToList()[rand.Next(ORM.Movies.Count())]);
}
public List <MovieList> GetCatalog()
{
MovieDBEntities db = new MovieDBEntities();
List <MovieList> movies = db.MovieLists.ToList();
return(movies);
}
public ActionResult MovieAdd(Movy model, HttpPostedFileBase file)
{
if (file == null || file.ContentLength == 0)
{
ModelState.AddModelError("Poster", "Загрузите постер");
return(View(model));
}
var fileBytes = new byte[file.ContentLength];
file.InputStream.Read(fileBytes, 0, file.ContentLength);
if (!ModelState.IsValid)
{
return(View(model));
}
using (var context = new MovieDBEntities())
{
model.Inserted_Date = DateTime.Now;
model.Inserted_UserId = User.Identity.GetUserId();
model.Poster = fileBytes;
context.Movies.Add(model);
var result = context.SaveChanges();
if (result > 0)
{
return(RedirectToAction("MovieDetails", new { id = model.Id }));
}
}
return(View(model));
}
public List <Movy> GetRandomMovies(string Number)
{
MovieDBEntities ORM = new MovieDBEntities();
List <Movy> movies = new List <Movy>();
if (!int.TryParse(Number, out int num) || num < 1 || num > ORM.Movies.Count())
{
return(movies);
}
else
{
Random rand = new Random();
List <int> pickedNum = new List <int>();
for (int i = 0; i < num; i++)
{
int n = rand.Next(ORM.Movies.Count());
while (pickedNum.Contains(n))
{
n = rand.Next(ORM.Movies.Count());
}
pickedNum.Add(n);
movies.Add(ORM.Movies.ToList()[n]);
}
return(movies);
}
}
public List <Movie> ShowMovieCategory(string category)
{
MovieDBEntities ORM = new MovieDBEntities();
return(ORM.Movies.Where(c => c.Category.Contains(category)).ToList());
//http://localhost:55657/api/Movie/ShowMovieCategory?category=Horror
}
public List <Movie> ShowAllMovies()
{
MovieDBEntities ORM = new MovieDBEntities();
return(ORM.Movies.ToList());
//http://localhost:55657/api/Movie/ShowAllMovies
}
public virtual DbResult <int> SaveChanges(MovieDBEntities db)
{
DbResult <int> DMLResult = new DbResult <int>();
try
{
int cnt = db.SaveChanges();
if (cnt > 0)
{
DMLResult.IsSuccess = true;
DMLResult.Message = "Transaction Successful";
DMLResult.Result = cnt;
}
else
{
DMLResult.IsSuccess = false;
DMLResult.Message = "Transaction Failed";
DMLResult.Result = 0;
}
}
catch (Exception ex)
{
//This is the part where I usually log things
throw ex;
}
return(DMLResult);
}
public ActionResult MovieEdit(Movy model, HttpPostedFileBase file)
{
using (var context = new MovieDBEntities())
{
var movie = context.Movies.Find(model.Id);
if (movie.Inserted_UserId != User.Identity.GetUserId())
{
ModelState.AddModelError("", "У вас нет прав на изменения.");
}
if (!ModelState.IsValid)
{
return(View(model));
}
if (file != null && file.ContentLength != 0)
{
var fileBytes = new byte[file.ContentLength];
file.InputStream.Read(fileBytes, 0, file.ContentLength);
movie.Poster = fileBytes;
}
movie.Updated_Date = DateTime.Now;
movie.Title = model.Title;
movie.Producer = model.Producer;
movie.Year = model.Year;
movie.Description = model.Description;
context.Entry(movie).State = EntityState.Modified;
var result = context.SaveChanges();
if (result > 0)
{
return(RedirectToAction("MovieDetails", new { id = model.Id }));
}
}
return(View(model));
}
public List <Movy> GetMoviesByCategory(string Category)
{
MovieDBEntities ORM = new MovieDBEntities();
List <Movy> movies = ORM.Movies.Where(x => x.Category.ToLower() == Category.ToLower()).ToList();
return(movies);
}
public Movy GetRandomMovieByCategory(string Category)
{
MovieDBEntities ORM = new MovieDBEntities();
Random rand = new Random();
return(ORM.Movies.Where(x => x.Category.ToLower() == Category.ToLower()).ToList()[rand.Next(4)]);
}
public List <string> GetMovieCategories()
{
MovieDBEntities ORM = new MovieDBEntities();
List <string> categories = ORM.Movies.Select(x => x.Category).Distinct().ToList();
return(categories);
}
public List <MovieList> GetMovieByGenre(string id)
{
MovieDBEntities db = new MovieDBEntities();
List <MovieList> genre = (from p in db.MovieLists
where p.Genre.Contains(id)
select p).ToList();
return(genre);
}
// public List<MovieList> GetMoviesGenres()
//{
// MovieDBEntities db = new MovieDBEntities();
// IEnumerable<List<MovieList>> movies = (from p in db.MovieLists.AsEnumerable()
// select p.Field<string>("Genre").ToList());
// return movies;
//}
public MovieList GetMovieInfo(string id)
{
MovieDBEntities db = new MovieDBEntities();
MovieList info = (from p in db.MovieLists
where p.Title.Contains(id)
select p).Single();
return(info);
}
public Movy GetRandomMovieFromCategory(string category) // get random movie in a certain category
{
MovieDBEntities ORM = new MovieDBEntities();
Random r = new Random();
List <Movy> movieList = ORM.Movies.Where(c => c.movieCategory.Contains(category)).ToList();
int result = r.Next(movieList.Count());
return(movieList[result]);
}
public string GetRandomMovie() // returns random movie name
{
MovieDBEntities ORM = new MovieDBEntities();
Random r = new Random();
List <string> MoviesList = ORM.Movies.Select(c => c.movieName).ToList();
int result = r.Next(MoviesList.Count());
return(MoviesList[result]);
}
public ActionResult Index()
{
MovieDBEntities ORM = new MovieDBEntities();
List <Movy> MoviesList = ORM.Movies.ToList();
ViewBag.MoviesList = MoviesList;
return(View());
}
public List <MovieList> GetMovieByKeyword(string id)
{
MovieDBEntities db = new MovieDBEntities();
List <MovieList> keyword = (from p in db.MovieLists
where p.Title.Contains(id)
select p).ToList();
return(keyword);
}
public Movie GetRandomMovieByCategory(string category)
{
MovieDBEntities ORM = new MovieDBEntities();
Random r = new Random();
List <Movie> Movies = ORM.Movies.Where(c => c.Category.Contains(category)).ToList();
return(Movies[r.Next(0, Movies.Count)]);
}
public MovieRepository(MovieDBEntities ctx)
{
if (ctx == null)
{
_ctx = new MovieDBEntities();
}
else
{
_ctx = ctx;
}
}
public Movie ShowRandomMovie()
{
// public Movie due to only asking for one random movie to be returned
MovieDBEntities ORM = new MovieDBEntities();
Random r = new Random();
List <Movie> Movies = ORM.Movies.ToList();
return(Movies[r.Next(0, Movies.Count)]);
}
public ActionResult Index(int?page)
{
var pageNumber = page ?? 1;
var pageSize = 10;
using (var context = new MovieDBEntities())
{
var movies = context.Movies.Include(i => i.User).OrderByDescending(p => p.Inserted_Date).ToPagedList(pageNumber, pageSize);
return(View(movies));
}
}
public ActionResult MovieEdit(int?id)
{
using (var context = new MovieDBEntities())
{
var movie = context.Movies.Include(i => i.User).Where(p => p.Id == id).FirstOrDefault();
if (movie != null)
{
return(View(movie));
}
return(RedirectToAction("Index"));
}
}
public MovieList GetRandomMovie(int id)
{
MovieDBEntities db = new MovieDBEntities();
Random rand = new Random();
int random = rand.Next(1, (db.MovieLists.Count() + 1));
MovieList randMovie = (from p in db.MovieLists
where p.ID == random
select p).Single();
return(randMovie);
}
public void Add(MovieModel movie)
{
using (var context = new MovieDBEntities())
{
var entity = context.Movies.Create();
entity.Title = movie.Title;
entity.Director = movie.Director;
entity.DateReleased = movie.DateReleased;
context.Movies.Add(entity);
context.SaveChanges();
}
}
public MovieList GetRandomMovieFromGenre(string id)
{
MovieDBEntities db = new MovieDBEntities();
List <MovieList> movies = (from p in db.MovieLists
where p.Genre == id
select p).ToList();
int data = movies.Count();
Random rand = new Random();
int random = rand.Next(1, data);
return(movies[random]);
}
public void Update(MovieModel movie)
{
using (var context = new MovieDBEntities())
{
var entity = (from m in context.Movies
where m.Id == movie.Id
select m).Single(); // not using SingleOrDefault() because by convention, when we search by Id, if there are no results, we should throw an Exception
entity.Title = movie.Title;
entity.Director = movie.Director;
entity.DateReleased = movie.DateReleased;
context.SaveChanges();
}
}
public List <Movy> GetRandomMovies(int amount) // returns random movie(s)
{
MovieDBEntities ORM = new MovieDBEntities();
Random r = new Random();
List <Movy> MoviesList = ORM.Movies.ToList();
List <Movy> MovieList = new List <Movy>();
for (int i = 0; i < amount; i++)
{
int result = r.Next(MoviesList.Count());
MovieList.Add(MoviesList[result]);
MoviesList.RemoveAt(result);
}
return(MovieList);
}
public Movy ListRandomMoviesFromGenre(string genre)
{
MovieDBEntities ORM = new MovieDBEntities();
Random rand = new Random();
List <Movy> GenreList = ORM.Movies.Where(x => x.Genre.ToLower() == genre.ToLower()).ToList();
int y = rand.Next(GenreList.Count());
if (y == 0)
{
return(new Movy());
}
return(GenreList[y]);
}
public MovieModel Get(int id)
{
using (var context = new MovieDBEntities())
{
var entity = (from m in context.Movies
where m.Id == id
select new MovieModel
{
Id = m.Id,
Title = m.Title,
Director = m.Director,
DateReleased = m.DateReleased
}).SingleOrDefault();
return(entity);
}
}
protected BaseRepository
(
//ILogger logger,
DbTransaction <T> dbTran)
{
_db = DbConnection.GetSQLConnection();//the singleton db conn
//_logger = logger;
if (dbTran != null)
{
_dbTrans = dbTran;
}
else
{
//_dbTrans = new DbTransaction<T>(_logger);
_dbTrans = new DbTransaction <T>();
}
}
