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"));
}
}
}
