public ActionResult LogIn(LogInModel user) { if (user == null) { ViewBag.Error = "HATA! Kullanıcı adı veya şifreniz yanlış!"; } else { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Member.Select(x => new LogInModel { UserID = x.ID, Email = x.Email, Password = x.Password, IsAdmin = x.IsAdmin, UserName = x.UserName }).Where(x => x.Email == user.Email & x.Password == user.Password & x.IsAdmin == false).First(); Session.Add("UserName", data.UserName); Session.Add("Email", data.Email); Session.Add("Password", data.Password); Session.Add("UserID", data.UserID); } } return(RedirectToAction("Home", "Home")); }
public PartialViewResult LastAdded() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Movie.Select(x => new PartialsModel { CategoryName = x.MovieCategory.Select(n => n.Category.Name).FirstOrDefault(), MovieID = x.ID, MovieName = x.Name, MovieYear = x.Year, Description = x.Detail, IsMasked = x.IsMasked, Price = x.Price, AddedTime = x.AddedDate, CustomPictures = x.Picture.Select(p => new CustomPicture { PicID = p.ID, PictureLocation = p.PictureLocation, MovieID = p.MovieID }).Where(p => p.MovieID == x.ID).OrderBy(p => p.PicID).FirstOrDefault(), Categories = x.MovieCategory.Select(y => new CustomPartialCategory { CatID = y.Category.ID, Name = y.Category.Name, MovieID = y.MovieID }).Where(y => y.MovieID == x.ID).ToList(), }).Where(x => x.IsMasked == false).OrderByDescending(x => x.AddedTime).Take(12).ToList(); return(PartialView(data)); } }
public ActionResult HomePageCategories() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data1 = db.Category.Select(x => new CategoryHPModel { ID = x.ID, Name = x.Name, IsHomePage = x.IsHomePage, }).OrderBy(x => x.ID).ToList(); var data2 = db.Category.Select(x => new CategoryHPModel { ID = x.ID, Name = x.Name, IsHomePage = x.IsHomePage, }).OrderBy(x => x.ID).Where(x => x.IsHomePage == true).ToList(); var model = new AdminHPCategoryModel { AvailableCategories = data1, SelectedCategories = data2 }; return(View(model)); } }
public ActionResult AddToCart(int id) { if (Session["UserName"] != null) { MyCart cart = Session["cart"] as MyCart; CartItemDTO cartItem = new CartItemDTO(); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Movie.Where(x => x.ID == id).FirstOrDefault(); cartItem.ID = data.ID; cartItem.Name = data.Name; cartItem.Price = data.Price; cartItem.Amount = 1; cart.Add(cartItem); Session["cart"] = cart; } } else { throw new Exception(); } return(PartialView("_CartButton")); }
public ActionResult EditCategory(AdminCategoryModel _editCategory) { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); _editCategory.ID = Convert.ToInt32(parcalar[1]); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var isThere = db.Category.Where(x => x.Name == _editCategory.Name).FirstOrDefault(); if (isThere != null) { ViewBag.Error = "HATA! Bu kategori ismi kayıtlarda var.Lütfen başka bir giriş yapınız."; ModelState.AddModelError("", "HATA! Bu kategori ismi kayıtlarda var.Lütfen başka bir giriş yapınız."); return(View(_editCategory)); } else { var data = db.Category.Find(_editCategory.ID); data.Name = _editCategory.Name; db.SaveChanges(); } } return(RedirectToAction("Categories", "Admin")); }
public ActionResult ConfirmCart() { if (Session["cart"] != null) { MyCart cart = Session["cart"] as MyCart; if (cart.GetAllCartItem.Count > 0) { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { OrderDetail order = new OrderDetail(); foreach (CartItemDTO item in cart.GetAllCartItem) { order.Date = DateTime.Now; order.UserID = Convert.ToInt32(Session["UserID"]); order.MovieID = item.ID; order.Count = item.Amount; order.Price = item.Price; } db.OrderDetail.Add(order); Session["cart"] = new MyCart(); return(RedirectToAction("Home", "Home")); } } } return(RedirectToAction("Home", "Home")); }
public ActionResult EditMovie(int?_movieID) { string let = Request.Url.PathAndQuery; if (let.Contains('=')) { string[] parcalar = let.Split('='); _movieID = Convert.ToInt32(parcalar[1]); } using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Movie.Select(x => new EditMoviesModel { ID = x.ID, Name = x.Name, Year = x.Year, Price = x.Price, Detail = x.Detail, IsMasked = x.IsMasked, }).Where(x => x.ID == _movieID).First(); ViewBag.Movie = data; return(View()); } }
public ActionResult AddMovie(AddMoviesModel _addMovie) { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { Movie x = new Movie(); x.Name = _addMovie.Name; x.Price = _addMovie.Price; x.Year = _addMovie.Year; x.Detail = _addMovie.Detail; x.AddedDate = DateTime.Now; db.Movie.Add(x); db.SaveChanges(); _addMovie.ID = db.Movie.OrderByDescending(t => t.ID).Select(t => t.ID).First(); MovieCategory y = new MovieCategory(); foreach (var item in _addMovie.CategoryIDs) { y.MovieID = _addMovie.ID; y.CategoryID = item; } db.MovieCategory.Add(y); db.SaveChanges(); } return(RedirectToAction("Movies", "Admin")); }
// GET: Admin/Picture public ActionResult Detail(int?ID) { if (ID == null) { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); ID = Convert.ToInt32(parcalar[1]); } using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Movie.Select(x => new AdminPictureModel { MovieID = x.ID, MovieName = x.Name, PictureOfMovies = x.Picture.Select(y => new PictureOfMovie { MovieID = y.MovieID, PictureID = y.ID, PictureLocation = y.PictureLocation }).Where(y => y.MovieID == x.ID).ToList(), }).Where(x => x.MovieID == ID).FirstOrDefault(); return(View(data)); } }
public PartialViewResult MoviesByCategory(string _categoryName, int _movieCount) { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Movie.Select(x => new PartialsModel { CustomPictures = x.Picture.Select(p => new CustomPicture { MovieID = p.MovieID, PicID = p.ID, PictureLocation = p.PictureLocation }).Where(p => p.MovieID == x.ID).FirstOrDefault(), MovieID = x.ID, MovieName = x.Name, IsMasked = x.IsMasked, MovieYear = x.Year, Description = x.Detail, Price = x.Price, AddedTime = x.AddedDate, CategoryName = x.MovieCategory.Where(n => n.Category.Name == _categoryName).FirstOrDefault().Category.Name, Categories = x.MovieCategory.Select(y => new CustomPartialCategory { CatID = y.Category.ID, Name = y.Category.Name, MovieID = y.MovieID }).Where(y => y.MovieID == x.ID).ToList(), }).Where(x => x.CategoryName == _categoryName && x.IsMasked == false).Take(_movieCount).ToList(); return(PartialView(data)); } }
public ActionResult Register(RegisterModel registerUser) { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var isThere = db.Member.First(x => x.Email == registerUser.Email || x.UserName == registerUser.UserName); if (isThere != null) { ViewBag.Error = "HATA! Daha önce kayıt olmuş kullanıcı adı ya da şifre"; return(RedirectToAction("Register")); } else if (registerUser.Password != registerUser.PasswordAgain) { ViewBag.Error = "Girilen şifreler aynı değil"; return(RedirectToAction("Register")); } else { Member member = new Member(); member.Address = registerUser.Address; member.Email = registerUser.Email; member.IsAdmin = false; member.Name = registerUser.Name; member.Password = registerUser.Password; member.Phone = registerUser.Phone; member.UserName = registerUser.UserName; member.Surname = registerUser.Surname; db.Member.Add(member); db.SaveChanges(); return(RedirectToAction("Login", "User")); } } }
public ActionResult UserProfile() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Member.Where(x => x.UserName == Session["UserName"].ToString()).FirstOrDefault(); return(View(data)); } }
public PartialViewResult Categories() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Category.Select(x => new CategoryModel { CategoryName = x.Name }).OrderBy(x => x.CategoryName).ToList(); return(PartialView(data)); } }
public ActionResult Categories() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Category.Select(x => new AdminCategoryModel { ID = x.ID, Name = x.Name }).OrderBy(x => x.ID).ToList(); return(View(data)); } }
public ActionResult DeletePicture(int?_ID) { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); _ID = Convert.ToInt32(parcalar[1]); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Picture.Where(x => x.ID == _ID).FirstOrDefault(); return(View(data)); } }
public ActionResult DeletePicture() { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); int _ID = Convert.ToInt32(parcalar[1]); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Picture.Where(x => x.ID == _ID).FirstOrDefault(); db.Picture.Remove(data); db.SaveChanges(); return(RedirectToAction("Detail", "Picture", new { ID = data.MovieID })); } }
public ActionResult UnMaskMovie() { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); int _maskedMovieID = Convert.ToInt32(parcalar[1]); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Movie.Find(_maskedMovieID); data.IsMasked = false; db.SaveChanges(); } return(RedirectToAction("Movies", "Admin")); }
// GET: Single public ActionResult Single(int _selectedMovieID) { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); _selectedMovieID = Convert.ToInt32(parcalar[1]); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Movie.Select(x => new SingleModel { MovieID = x.ID, MovieName = x.Name, MovieYear = x.Year, Description = x.Detail, Price = x.Price, AddedTime = x.AddedDate, Categories = x.MovieCategory.Select(y => new CustomSingleCategory { CatID = y.Category.ID, Name = y.Category.Name, MovieID = y.MovieID }).Where(y => y.MovieID == x.ID).ToList(), Comments = x.Comment.Select(z => new CustomSingleComment { CommentID = z.ID, MovieID = z.MovieID, UserID = z.UserID, Comment = z.Comment1, CommentTime = (DateTime)z.AddedDate, NameOfUser = z.Member.Name, SurnameOfUser = z.Member.Surname, NickName = z.Member.UserName }).OrderBy(z => z.CommentTime).Where(z => z.MovieID == x.ID).ToList(), FavoriteModels = x.Favorite.Select(f => new FavoriteModel { FavID = f.ID, MovieID = f.MovieID, UserID = f.UserID }).Where(f => f.MovieID == x.ID && f.UserID == Convert.ToInt32(Session["UserID"])).ToList(), }).Where(x => x.MovieID == _selectedMovieID).FirstOrDefault(); return(View(data)); } }
public ActionResult Orders() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.OrderDetail.Select(x => new OrderModel { OrderDate = x.Date, Price = x.Price, UserID = x.UserID, UserName = x.Member.UserName, MovieID = x.MovieID, MovieName = x.Movie.Name, Count = x.Count }).Where(x => x.UserName == Session["UserName"].ToString()).ToList(); return(View(data)); } }
public ActionResult Comments() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Comment.Select(x => new AdminCommentsModel { ID = x.ID, MovieName = x.Movie.Name, AddedDate = x.AddedDate, Comment = x.Comment1, UserID = x.UserID, UserName = x.Member.Name }).OrderBy(x => x.ID).ToList(); return(View(data)); } }
public ActionResult UserProfile(RegisterModel _user) { _user.UserName = Session["UserName"].ToString(); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { Member member = db.Member.Where(x => x.UserName == _user.UserName).First(); member.Address = _user.Address; member.Phone = _user.Phone; member.Name = _user.Name; member.Surname = _user.Surname; db.SaveChanges(); } return(RedirectToAction("Home", "Home")); }
public ActionResult DeleteComment(int?_deleteCommentID) { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); _deleteCommentID = Convert.ToInt32(parcalar[1]); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Comment.Where(x => x.ID == _deleteCommentID).First(); db.Comment.Remove(data); db.SaveChanges(); } return(RedirectToAction("Comments", "Admin")); }
public ActionResult EditCategory() { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); int _categoryID = Convert.ToInt32(parcalar[1]); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Category.Select(x => new AdminCategoryModel { ID = x.ID, Name = x.Name }).Where(x => x.ID == _categoryID).First(); return(View(data)); } }
public ActionResult Orders() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.OrderDetail.Select(x => new AdminOrdersModel { ID = x.ID, Date = x.Date, MovieID = x.MovieID, MovieName = x.Movie.Name, UserID = x.UserID, NameOfUser = x.Member.Name, SurnameOfUser = x.Member.Surname }).OrderBy(x => x.ID).ToList(); return(View(data)); } }
public ActionResult Pictures() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Movie.Select(x => new AdminPictureModel { MovieID = x.ID, MovieName = x.Name, PictureOfMovies = x.Picture.Select(y => new PictureOfMovie { PictureID = y.ID, PictureLocation = y.PictureLocation, MovieID = y.MovieID }).Where(y => y.MovieID == x.ID).ToList(), }).OrderBy(x => x.MovieID).ToList(); return(View(data)); } }
public ActionResult AddPicture(int?ID) { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); ID = Convert.ToInt32(parcalar[1]); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Movie.Select(x => new MoviePicture { MovieID = x.ID, MovieName = x.Name, PictureLocation = "", }).Where(x => x.MovieID == ID).FirstOrDefault(); return(View(data)); } }
public ActionResult AddPicture(MoviePicture _moviePicture) { string let = Request.Url.PathAndQuery; string[] parcalar = let.Split('='); int _movieID = Convert.ToInt32(parcalar[1]); using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { Picture p = new Picture(); p.MovieID = _movieID; p.PictureLocation = "\\Assets\\Pictures\\" + _moviePicture.PictureLocation; db.Picture.Add(p); db.SaveChanges(); } return(RedirectToAction("Detail", "Picture", new { ID = _movieID })); }
public ActionResult Users() { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data = db.Member.Select(x => new AdminUsersModel { Address = x.Address, Email = x.Email, ID = x.ID, IsAdmin = x.IsAdmin, Name = x.Name, Password = x.Password, Phone = x.Phone, Surname = x.Surname, UserName = x.UserName }).OrderBy(x => x.ID).ToList(); return(View(data)); } }
public ActionResult HomePageCategories(AdminHPCategoryModel model) { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var data1 = db.Category.ToList(); foreach (var item in data1) { item.IsHomePage = false; db.SaveChanges(); } foreach (var item in model.Ids) { var data = db.Category.Find(item); data.IsHomePage = true; db.SaveChanges(); } } return(RedirectToAction("Index", "Admin")); }
public ActionResult AddCategory(AdminCategoryModel _category) { using (SinemaSitesiEntities db = new SinemaSitesiEntities()) { var isThere = db.Category.Where(x => x.Name == _category.Name).FirstOrDefault(); if (isThere != null) { ViewBag.Error = "HATA! Bu kategori ismi kayıtlarda var.Lütfen başka bir giriş yapınız."; ModelState.AddModelError("", "HATA! Bu kategori ismi kayıtlarda var.Lütfen başka bir giriş yapınız."); return(View()); } else { Category c = new Category(); c.Name = _category.Name; db.Category.Add(c); db.SaveChanges(); return(RedirectToAction("Categories", "Admin")); } } }