public ActionResult ResetPassword(ResetPasswordModel model)
{
var message = "";
if (ModelState.IsValid)
{
using (DatabaseEntities1 dc = new DatabaseEntities1())
{
var user = dc.Users.Where(a => a.ResetPasswordCode == model.ResetCode).FirstOrDefault();
if (user != null)
{
user.Password = Crypto.Hash(model.NewPassword);
user.ResetPasswordCode = "";
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = "Your password has been successfully updated";
}
}
}
else
{
message = "Something invalid";
}
ViewBag.Message = message;
return(View(model));
}
public ViewResult Display()
{
var context = new DatabaseEntities1();
var model = context.Employee.ToList();
return(View(model));
}
public ActionResult ForgotPassword(string Email)
{
//verify Email
//GEnerate Reser Password link
//Send Email
string message = "";
bool status = false;
using (DatabaseEntities1 dc = new DatabaseEntities1())
{
var account = dc.Users.Where(a => a.Email == Email).FirstOrDefault();
if (account != null)
{
//Send reset password email
string resetCode = Guid.NewGuid().ToString();
SendVerificationLinkEmail(account.Email, resetCode, "ResetPassword");
account.ResetPasswordCode = resetCode;
//
//this code wil prevent the website from having issues with password do not match
dc.Configuration.ValidateOnSaveEnabled = false;
dc.SaveChanges();
message = "A link to reset your password has been sent to your Email.";
}
else
{
message = "Account not found";
}
}
ViewBag.Message = message;
return(View());
}
public ActionResult Save(Korisnikk kor)
{
bool status = false;
if (ModelState.IsValid)
{
using (DatabaseEntities1 dq = new DatabaseEntities1())
{
if (kor.Korisnik_Id > 0)
{
var varr = dq.Korisnikks.Where(a => a.Korisnik_Id == kor.Korisnik_Id).FirstOrDefault();
if (varr != null)
{
varr.FirstName = kor.FirstName;
varr.LastName = kor.LastName;
varr.AdressName = kor.AdressName;
varr.E_mail = kor.E_mail;
varr.Tel_broj = kor.Tel_broj;
varr.Vrsta_tel_broja = kor.Vrsta_tel_broja;
}
}
else
{
dq.Korisnikks.Add(kor);
}
dq.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult MonthSales(string month1, string month2, string year)
{
var db = new DatabaseEntities1();
int Sales1 = 0;
int Sales2 = 0;
int[] Sales = new int[6];
foreach (Order order in db.Orders)
{
if (month1 == "" || month2 == "")
{
Sales1 = 10;
Sales2 = 10;
}
if (month1 == order.OrderDate.Month.ToString(format: "D2") && year == order.OrderDate.Year.ToString(format: "d4"))
{
Sales1 = Sales1 + order.Payment.Amount;
Sales[0] = Sales1;
Sales[2] = order.OrderDate.Month;
Sales[3] = order.OrderDate.Year;
}
if (month2 == order.OrderDate.Month.ToString(format:"D2") && year == order.OrderDate.Year.ToString(format: "d4"))
{
Sales2 = Sales2 + order.Payment.Amount;
Sales[1] = Sales2;
Sales[4] = order.OrderDate.Month;
Sales[5] = order.OrderDate.Year;
}
}
ViewBag.data = Sales;
return(View());
}
public ActionResult Confirmationdetails(int orderNumber)
{
Dictionary <Book, int> BookQuantity = new Dictionary <Book, int>();
Tuple <Order, OrderDetail, Payment> info;
using (var db = new DatabaseEntities1())
{
Order orderObj = db.Orders.Where(x => x.Order_Number == orderNumber).FirstOrDefault();
OrderDetail orderDetailObj = db.OrderDetails.Where(x => x.Order_Number == orderNumber).FirstOrDefault();
Payment paymentObj = db.Payments.Where(x => x.Order_Number == orderNumber).FirstOrDefault();
// GET PRODUCTS
string[] products = orderDetailObj.Products.Split('|');
foreach (var item in products)
{
string[] books = item.Split('-');
double isbn = Convert.ToDouble(books[0]);
Book book = db.Books.Where(x => x.ISBN == isbn).FirstOrDefault();
int quantity = Convert.ToInt32(books[1]);
BookQuantity.Add(book, quantity);
}
info = new Tuple <Order, OrderDetail, Payment>(orderObj, orderDetailObj, paymentObj);
Session["Checkout"] = BookQuantity;
}
return(View(info));
}
public ActionResult Users(int id = 0)
{
using (DatabaseEntities1 dbModel = new DatabaseEntities1())
{
return(View(dbModel.Users.ToList()));
}
}
public ActionResult UserOrderSta()
{
var db = new DatabaseEntities1();
int[] Users = new int[2];
int unregisterd = 0;
int registerd = 0;
foreach (Order order in db.Orders)
{
if (order.User_id == null)
{
unregisterd = unregisterd + order.Payment.Amount;
Users[0] = unregisterd;
}
if (order.User_id != 0)
{
registerd = registerd + order.Payment.Amount;
Users[1] = registerd;
}
}
ViewBag.data = Users;
return(View());
}
public ActionResult AddEmployee(Employee emp)
{
var context = new DatabaseEntities1();
context.Employee.Add(emp);
context.SaveChanges();
return(RedirectToAction("Display"));
}
public ActionResult Find(string id)
{
int EmpId = int.Parse(id);
var context = new DatabaseEntities1();
var model = context.Employee.FirstOrDefault((e) => e.EmpId == EmpId);
return(View(model));
}
public bool IsEmailExist(string email)
{
using (DatabaseEntities1 dc = new DatabaseEntities1())
{
var v = dc.Users.Where(a => a.Email == email).FirstOrDefault();
return(v != null);
}
}
protected void Login1_LoggedIn(object sender, EventArgs e)
{
DatabaseEntities1 Db = new DatabaseEntities1();
var name = Login1.UserName;
var user = (from u in Db.User where u.Username == name select u).FirstOrDefault();
Session["id_user"] = user.IdUser;
}
public ActionResult Save(int id)
{
using (DatabaseEntities1 dq = new DatabaseEntities1())
{
var var1 = dq.Korisnikks.Where(a => a.Korisnik_Id == id).FirstOrDefault();
return(View(var1));
}
}
public ActionResult GetContact()
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var korisnici = db.Korisnikks.OrderBy(a => a.FirstName).ToList();
return(Json(new { data = korisnici }, JsonRequestBehavior.AllowGet));
}
}
public void ShoppingCart(string isbn)
{
if (Session["User_id"] != null)
{
var list = db.Carts.Select(s => s);
double isbnD = Convert.ToDouble(isbn);
int User_id = Convert.ToInt32(Session["User_id"]);
bool has = list.Any(cus => cus.ISBN == isbnD && cus.User_id == User_id);
if (has)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
db.Carts.Remove(db.Carts.Single(cus => cus.ISBN == isbnD && cus.User_id == User_id));
db.SaveChanges();
}
}
else
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var cart = new Cart()
{
User_id = User_id, ISBN = Convert.ToDouble(isbn), Quantity = 1
};
db.Carts.Add(cart);
db.SaveChanges();
}
}
}
else
{
// UNREGISTERED USER
if (Session["shoppingCart"] == null || Session["shoppingCart"] == "")
{
Session["shoppingCart"] = isbn.ToString();
}
else
{
List <string> isbns = Session["shoppingCart"].ToString().Split(',').ToList();
//Check of die al in je cart zit.
//Deletes product from cart
if (isbns.Contains(isbn))
{
isbns.RemoveAll(s => isbn == s);
var newcart = String.Join(",", isbns);
Session["shoppingCart"] = newcart;
}
else
{
Session["shoppingCart"] = Session["shoppingCart"] + "," + isbn.ToString();
}
}
}
}
public ActionResult DeleteEmployee(string id)
{
int EmpId = int.Parse(id);
var context = new DatabaseEntities1();
var model = context.Employee.FirstOrDefault((e) => e.EmpId == EmpId);
context.Employee.Remove(model);
context.SaveChanges();
return(RedirectToAction("Display"));
}
public ActionResult Confirmation(int orderNumber)
{
Dictionary <Book, int> BookQuantity = new Dictionary <Book, int>();
Tuple <Order, OrderDetail, Payment> info;
using (var db = new DatabaseEntities1())
{
Order orderObj = db.Orders.Where(x => x.Order_Number == orderNumber).FirstOrDefault();
OrderDetail orderDetailObj = db.OrderDetails.Where(x => x.Order_Number == orderNumber).FirstOrDefault();
Payment paymentObj = db.Payments.Where(x => x.Order_Number == orderNumber).FirstOrDefault();
int currentuser_id = Convert.ToInt32(Session["User_id"]);
User currentuser = db.Users.Where(x => x.User_id == currentuser_id).FirstOrDefault();
if (Session["User_id"] != null)
{
string Email = Convert.ToString(currentuser.Email);
SendConEmail(Email, orderNumber);
}
else
{
string Email = Convert.ToString(orderDetailObj.Email);
SendConEmail(Email, orderNumber);
}
// GET PRODUCTS
string[] products = orderDetailObj.Products.Split('|');
foreach (var item in products)
{
string[] books = item.Split('-');
double isbn = Convert.ToDouble(books[0]);
Book book = db.Books.Where(x => x.ISBN == isbn).FirstOrDefault();
int quantity = Convert.ToInt32(books[1]);
BookQuantity.Add(book, quantity);
}
info = new Tuple <Order, OrderDetail, Payment>(orderObj, orderDetailObj, paymentObj);
Session["Checkout"] = BookQuantity;
// CLEAR CARTS
if (Session["User_id"] != null)
{
int User_id = Convert.ToInt32(Session["User_id"]);
db.Carts.RemoveRange(db.Carts.Where(x => x.User_id == User_id));
db.SaveChanges();
}
else
{
Session["ShoppingCart"] = null;
}
}
return(View(info));
}
public ActionResult Find(Employee emp)
{
var context = new DatabaseEntities1();
var model = context.Employee.FirstOrDefault((e) => e.EmpId == emp.EmpId);
model.EmpName = emp.EmpName;
model.EmpAddress = emp.EmpAddress;
model.EmpSalary = emp.EmpSalary;
context.SaveChanges();
return(RedirectToAction("Display"));
}
public ActionResult Delete(int id)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var va = db.Korisnikks.Where(a => a.Korisnik_Id == id).FirstOrDefault();
if (va != null)
{
return(View(va));
}
else
{
return(HttpNotFound());
}
}
}
public DbAccess()
{
Context = new DatabaseEntities1();
Count = Context.WeatherSnapshots.Count();
if (Count == 0)
{
FirstDate = DateTime.Now;
LastDate = DateTime.Now;
}
else
{
FirstDate = Context.WeatherSnapshots.Min(tr => tr.Timestamp);
LastDate = Context.WeatherSnapshots.Max(tr => tr.Timestamp);
}
}
public ActionResult AddOrEdit(User userModel)
{
using (DatabaseEntities1 dbModel = new DatabaseEntities1())
{
if (dbModel.Users.Any(x => x.UserName == userModel.UserName))
{
ViewBag.DuplicateMessage = "Username already exist.";
return(View("AddOrEdit", userModel));
}
dbModel.Users.Add(userModel);
dbModel.SaveChanges();
}
ModelState.Clear();
ViewBag.SuccessMessage = "Registration Successful.";
return(View("AddOrEdit", new User()));
}
public ActionResult DeleteKorisnik(int id)
{
bool status = false;
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var v = db.Korisnikks.Where(a => a.Korisnik_Id == id).FirstOrDefault();
if (v != null)
{
db.Korisnikks.Remove(v);
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Authorize(User userModel)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var userPassword = Crypto.Hash(userModel.Password);
var userData = db.Users.Where(x => x.Email == userModel.Email &&
x.Password == userPassword).FirstOrDefault();
if (userData == null)
{
userModel.LoginErrorMessage = "Wrong Email or Password";
return(View("Index", userModel));
}
else if (userData.IsEmailVerified == false)
{
userModel.LoginErrorMessage = "Your email must be verified before you can log in. A new verification link has been sent to your email ";
SendVerificationLinkEmail(userData.Email, userData.ActivationCode.ToString());
return(View("Index", userModel));
}
else
{
//SUCCESFULLY LOGIN
Session["User_id"] = userData.User_id;
Session["Name"] = userData.Name;
var cart = (Dictionary <Book, int>)Session["Cart"];
db.Carts.RemoveRange(db.Carts.Where(x => x.User_id == userData.User_id));
db.SaveChanges();
foreach (KeyValuePair <Book, int> kv in cart)
{
var cartObj = new Cart()
{
User_id = userData.User_id, ISBN = kv.Key.ISBN, Quantity = kv.Value
};
db.Carts.Add(cartObj);
db.SaveChanges();
}
return(RedirectToAction("Address", "Checkout"));
}
}
}
public ActionResult Authorize(User userModel)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var userPassword = Crypto.Hash(userModel.Password);
var userData = db.Users.Where(x => x.Email == userModel.Email &&
x.Password == userPassword).FirstOrDefault();
var Data = db.Users.Where(x => x.Email == userModel.Email &&
x.Password == userPassword).FirstOrDefault();
if (userData == null)
{
userModel.LoginErrorMessage = "Wrong Email or Password";
return(View("Index", userModel));
}
else if (Data.IsEmailVerified == false)
{
userModel.LoginErrorMessage = "Your email must be verified before you can log in. A new verification link has been sent to your email ";
SendVerificationLinkEmail(userData.Email, userData.ActivationCode.ToString());
return(View("Index", userModel));
}
else
{
if (userData.Type)
{
Session["Admin"] = true;
}
else
{
Session["Admin"] = false;
}
Session["User_id"] = userData.User_id;
Session["Name"] = userData.Name;
return(RedirectToAction("Index", "Home"));
}
}
}
public ActionResult ResetPassword(string id)
{
//Verify the reset password link
//Find account associated with this link
//redirect to reset password page
using (DatabaseEntities1 dc = new DatabaseEntities1())
{
var user = dc.Users.Where(a => a.ResetPasswordCode == id).FirstOrDefault();
if (user != null)
{
ResetPasswordModel model = new ResetPasswordModel
{
ResetCode = id
};
return(View(model));
}
else
{
return(HttpNotFound());
}
}
}
public void FavoriteList(string isbn)
{
if (Session["User_id"] == null)
{
TempData["favo"] = "<script>alert('You need to login first.');</script>";
}
else
{
var list = db.Favorites.Select(s => s);
double isbnD = Convert.ToDouble(isbn);
int User_id = Convert.ToInt32(Session["User_id"]);
bool has = list.Any(cus => cus.ISBN == isbnD && cus.User_id == User_id);
//CHECKEN OF ISBN AL IN FAVORIETEN ZIT VAN DE GEBRUIKER.
if (has)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
db.Favorites.Remove(db.Favorites.Single(cus => cus.ISBN == isbnD && cus.User_id == User_id));
db.SaveChanges();
}
}
else
{
// ISBN TOEVOEGEN AAN FAVORIETEN
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var favo = new Favorite()
{
User_id = User_id, ISBN = Convert.ToDouble(isbn)
};
db.Favorites.Add(favo);
db.SaveChanges();
}
}
}
}
public ActionResult VerifyAccount(string id)
{
bool status = false;
using (DatabaseEntities1 dc = new DatabaseEntities1())
{
dc.Configuration.ValidateOnSaveEnabled = false; //This line will avoid any problems by confirm password
//does not match issue in the save changes section
var v = dc.Users.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault();
if (v != null)
{
v.IsEmailVerified = true;
dc.SaveChanges();
status = true;
}
else
{
ViewBag.Message = "Invaild Request";
}
}
ViewBag.Status = status;
return(View());
}
public ActionResult Authorize(User user)
{
using (DatabaseEntities1 dbModel = new DatabaseEntities1())
{
var UserDetails = dbModel.Users.Where(x => x.UserName == user.UserName && x.Password == user.Password).FirstOrDefault();
if (UserDetails == null)
{
user.LoginErrorMessege = "Wrong username or password";
return(View("Login", user));
}
else if (UserDetails.UserName == "Admin" && UserDetails.Password == "Admin")
{
return(RedirectToAction("Admin", "Admin"));
}
else
{
Session["UserId"] = UserDetails.Id;
Session["UserName"] = UserDetails.UserName;
return(RedirectToAction("Index", "Home"));
}
}
}
//CHECKOUT AS GUEST
public ActionResult Address(string Name, string Surname, string Email, string PhoneNumber, string Street,
int?HouseNumber, string City, string ZipCode, string Country, string Save)
{
Dictionary <User, Address> userInfo = new Dictionary <User, Address>();
if (Name == "" || Surname == "" || Email == "" || PhoneNumber == "" || Street == "" ||
HouseNumber == null || City == "" || ZipCode == "" || Country == "")
{
ViewBag.Message = "Please fill in everything.";
return(View());
}
else
{
if (Session["User_id"] != null)
{
int User_id = Convert.ToInt32(Session["User_id"]);
userInfo.Add(new User {
Name = Name, Surname = Surname, Email = Email, Phone_number = PhoneNumber
},
new Address
{
Street_name = Street,
House_number = Convert.ToInt32(HouseNumber),
Zip_code = ZipCode,
Country = Country,
User_id = User_id
});
Session["UserInfo"] = userInfo;
if (Save == "Save")
{
using (var db = new DatabaseEntities1())
{
var has = db.Addresses.Where(x => x.User_id == User_id).SingleOrDefault();
if (has != null)
{
db.Addresses.Remove(db.Addresses.Where(x => x.User_id == User_id).SingleOrDefault());
}
db.Addresses.Add(new Address
{
Street_name = Street,
City = City,
House_number = Convert.ToInt32(HouseNumber),
Zip_code = ZipCode,
Country = Country,
User_id = User_id
});
db.SaveChanges();
}
}
return(RedirectToAction("Review"));
}
else
{
userInfo.Add(new User {
Name = Name, Surname = Surname, Email = Email, Phone_number = PhoneNumber
},
new Address
{
Street_name = Street,
House_number = Convert.ToInt32(HouseNumber),
Zip_code = ZipCode,
Country = Country
});
Session["UserInfo"] = userInfo;
return(RedirectToAction("Review"));
}
}
}
public ActionResult Payment(bool?payment)
{
if (payment != null)
{
if ((bool)payment)
{
string products = "";
Dictionary <User, Address> userInfo = (Dictionary <User, Address>)Session["UserInfo"];
int Ordernumber = new Random().Next(1000000, int.MaxValue);
using (var db = new DatabaseEntities1())
{
//Check if ordernumber already exists.
while (db.Orders.Where(x => x.Order_Number == Ordernumber).FirstOrDefault() != null)
{
Ordernumber = new Random().Next(1000000, int.MaxValue);
}
// CREATE ORDER IN DATABASE
Order orderObj = new Order();
if (Session["User_id"] != null)
{
//CREATER ORDER OBJECT
orderObj = new Order()
{
Order_status = "Pending",
OrderDate = DateTime.Now,
User_id = Convert.ToInt32(Session["User_id"]),
Order_Number = Ordernumber
};
//ADD ORDER TO DATABASE
db.Orders.Add(orderObj);
db.SaveChanges();
//READ ALL PRODUCTS AND QUANITIES TO STRING
Dictionary <Book, int> bookDict = new Dictionary <Book, int>();
var User_id = Convert.ToInt32(Session["User_id"]);
var a = db.Carts.Where(x => x.User_id == User_id).ToList();
foreach (var item in a)
{
Book bookObj = db.Books.Where(x => x.ISBN == item.ISBN).FirstOrDefault();
bookDict.Add(bookObj, item.Quantity);
//Changes the stock of the book in the database.
bookObj.Stock = bookObj.Stock - item.Quantity;
db.SaveChanges();
}
int maxCount = bookDict.Count;
int counter = 0;
foreach (KeyValuePair <Book, int> kv in bookDict)
{
counter += 1;
if (counter == maxCount)
{
products += kv.Key.ISBN.ToString() + "-" + kv.Value;
}
else
{
products += kv.Key.ISBN.ToString() + "-" + kv.Value + "|";
}
}
//ADD ORDERDETAILS TO DB
foreach (KeyValuePair <User, Address> kv2 in userInfo)
{
OrderDetail orderDetailObj = new OrderDetail()
{
OrderDate = DateTime.Now,
Products = products,
Name = kv2.Key.Name,
Surname = kv2.Key.Surname,
Email = kv2.Key.Email,
Phone_Number = kv2.Key.Phone_number,
Street_Name = kv2.Value.Street_name,
House_number = kv2.Value.House_number,
Zip_code = kv2.Value.Zip_code,
Country = kv2.Value.Country,
Order_Number = Ordernumber
};
//CREATE PAYMENT OBJ AND ADD IT TO PAYMENT TABLE
Payment PaymentObj = new Payment
{
Payment_date = DateTime.Now,
Amount = Convert.ToInt32(Session["TotalPrice"]),
Order_Number = Ordernumber
};
db.OrderDetails.Add(orderDetailObj);
db.Payments.Add(PaymentObj);
db.SaveChanges();
}
//ADD ORDERDETAIL ID & PAMYENT ID TO ORDER
var orderDetailObj2 = db.OrderDetails.Where(x => x.Order_Number == Ordernumber).FirstOrDefault();
var paymentObj2 = db.Payments.Where(x => x.Order_Number == Ordernumber).FirstOrDefault();
var orderObj2 = db.Orders.Where(x => x.Order_Number == Ordernumber).FirstOrDefault();
orderObj2.OrderDetails_id = orderDetailObj2.OrderDetails_Id;
orderObj2.Payment_id = paymentObj2.Payment_id;
db.SaveChanges();
return(RedirectToAction("Confirmation", new { orderNumber = Ordernumber }));
}
else
{
// CREATE ORDER OBJECT
orderObj = new Order()
{
Order_status = "Pending",
OrderDate = DateTime.Now,
Order_Number = Ordernumber
};
//ADD ORDER TO DATABASE
db.Orders.Add(orderObj);
db.SaveChanges();
//READ ALL PRODUCTS AND QUANITIES TO STRING
Dictionary <Book, int> cartQuantity = (Dictionary <Book, int>)Session["Cart"];
int maxCount = cartQuantity.Count;
int counter = 0;
foreach (KeyValuePair <Book, int> kv in cartQuantity)
{
counter += 1;
if (counter == maxCount)
{
products += kv.Key.ISBN.ToString() + "-" + kv.Value;
}
else
{
products += kv.Key.ISBN.ToString() + "-" + kv.Value + "|";
}
}
//Change Stock for the Books in the Shopping Cart (Stock = Stock - Quantity that's been ordered)
var cart = (Dictionary <Book, int>)Session["Cart"];
foreach (var item in cart)
{
Book Bookobj = db.Books.Where(x => x.ISBN == item.Key.ISBN).FirstOrDefault();
Bookobj.Stock = Bookobj.Stock - item.Value;
db.SaveChanges();
}
// ADD ORDERDETAILS TO DB
foreach (KeyValuePair <User, Address> kv2 in userInfo)
{
//CREATE ORDERDETAIL OBJ AND ADD IT TO ORDERDETAIL TABLE
OrderDetail orderDetailObj = new OrderDetail()
{
OrderDate = DateTime.Now,
Products = products,
Name = kv2.Key.Name,
Surname = kv2.Key.Surname,
Email = kv2.Key.Email,
Phone_Number = kv2.Key.Phone_number,
Street_Name = kv2.Value.Street_name,
House_number = kv2.Value.House_number,
Zip_code = kv2.Value.Zip_code,
Country = kv2.Value.Country,
Order_Number = Ordernumber
};
//CREATE PAYMENT OBJ AND ADD IT TO PAYMENT TABLE
Payment PaymentObj = new Payment
{
Payment_date = DateTime.Now,
Amount = Convert.ToInt32(Session["TotalPrice"]),
Order_Number = Ordernumber
};
db.OrderDetails.Add(orderDetailObj);
db.Payments.Add(PaymentObj);
db.SaveChanges();
}
//ADD ORDERDETAIL ID TO ORDER
var orderDetailObj2 = db.OrderDetails.Where(x => x.Order_Number == Ordernumber).FirstOrDefault();
var paymentObj2 = db.Payments.Where(x => x.Order_Number == Ordernumber).FirstOrDefault();
var orderObj2 = db.Orders.Where(x => x.Order_Number == Ordernumber).FirstOrDefault();
orderObj2.OrderDetails_id = orderDetailObj2.OrderDetails_Id;
orderObj2.Payment_id = paymentObj2.Payment_id;
db.SaveChanges();
return(RedirectToAction("Confirmation", new { orderNumber = Ordernumber }));
}
}
}
}
return(View());
}
public ActionResult Index(string Title, double?isbn, double?favo, double?cart)
{
string favoISBN = favo.ToString();
string cartISBN = cart.ToString();
var _isbn = isbn.ToString();
if (favoISBN != "" && favoISBN != null)
{
if (Session["User_id"] == null)
{
TempData["favo"] = "<script>alert('You need to login first.');</script>";
}
else
{
var list = db.Favorites.Select(s => s);
double isbnD = Convert.ToDouble(isbn);
int User_id = Convert.ToInt32(Session["User_id"]);
bool has = list.Any(cus => cus.ISBN == isbnD && cus.User_id == User_id);
//CHECKEN OF ISBN AL IN FAVORIETEN ZIT VAN DE GEBRUIKER.
if (has)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
db.Favorites.Remove(db.Favorites.Single(cus => cus.ISBN == isbnD && cus.User_id == User_id));
db.SaveChanges();
}
}
else
{
// ISBN TOEVOEGEN AAN FAVORIETEN
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var favo1 = new Favorite()
{
User_id = User_id, ISBN = Convert.ToDouble(isbn)
};
db.Favorites.Add(favo1);
db.SaveChanges();
}
}
}
}
//Cart button toevoegen
if (cartISBN != "" && cartISBN != null)
{
if (Session["User_id"] != null)
{
var list = db.Carts.Select(s => s);
double isbnD = Convert.ToDouble(isbn);
int User_id = Convert.ToInt32(Session["User_id"]);
bool has = list.Any(cus => cus.ISBN == isbnD && cus.User_id == User_id);
if (has)
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
db.Carts.Remove(db.Carts.Single(cus => cus.ISBN == isbnD && cus.User_id == User_id));
db.SaveChanges();
}
}
else
{
using (DatabaseEntities1 db = new DatabaseEntities1())
{
var cart1 = new Cart()
{
User_id = User_id, ISBN = Convert.ToDouble(isbn), Quantity = 1
};
db.Carts.Add(cart1);
db.SaveChanges();
}
}
}
else
{
// UNREGISTERED USER
if (Session["shoppingCart"] == null || Session["shoppingCart"] == "")
{
Session["shoppingCart"] = isbn.ToString();
}
else
{
List <string> isbns = Session["shoppingCart"].ToString().Split(',').ToList();
//Check of die al in je cart zit.
//Deletes product from cart
if (isbns.Contains(_isbn))
{
isbns.RemoveAll(s => _isbn == s);
var newcart = String.Join(",", isbns);
Session["shoppingCart"] = newcart;
}
else
{
Session["shoppingCart"] = Session["shoppingCart"] + "," + isbn.ToString();
}
}
}
}
return(View());
}
