public RedirectToRouteResult AddToCart(CartViewModel cart, int productId, string returnUrl)
{
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var product = (from item in dbc.Products where item.ID == productId select item).ToList().FirstOrDefault();
if (product != null)
{
cart.AddItem(product, 1);
}
}
return RedirectToAction("Cart", new { returnUrl });
}
public ViewResult Checkout(CartViewModel cart, User user, Order order)
{
if (cart.OrdersDetails.Count() == 0)
{
ViewBag.IsSuccess = false;
ViewBag.Message = "Sorry, your cart is empty!";
}
else
{
ViewBag.IsSuccess = true;
ViewBag.Message = "Thanks for placing your order. We'll ship your goods as soon as possible.";
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
if (!User.Identity.IsAuthenticated)
{
dbc.Users.InsertOnSubmit(user);
dbc.SubmitChanges();
order.UserID = user.ID;
}
else
{
User currentUser = (from u in dbc.Users where u.Email == User.Identity.Name select u).ToList().FirstOrDefault();
order.UserID = currentUser.ID;
}
order.ShippingDate = DateTime.Now.ToOADate();
if (order.ShippingStatus == null)
order.ShippingStatus = "Check";
dbc.Orders.InsertOnSubmit(order);
dbc.SubmitChanges();
Sale sale = new Sale() { OrderID = order.ID, SalesAmount = cart.ComputeTotalValue() };
dbc.Sales.InsertOnSubmit(sale);
dbc.SubmitChanges();
foreach (var orderDetails in cart.OrdersDetails)
{
var orderDetails2 = new OrderDetails() { OrderID = order.ID, ProductID = orderDetails.ProductID, Quantity = orderDetails.Quantity };
dbc.OrderDetails.InsertOnSubmit(orderDetails2);
dbc.SubmitChanges();
}
cart.Clear();
}
}
ViewBag.IsAuthenticated = User.Identity.IsAuthenticated;
return View();
}
public ActionResult Index(ProfileViewModel profileInfo)
{
//if (ModelState.IsValid)
//{
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var newUserInfo = new Classes.User();
var oldUserInfo = (from u in dbc.Users where u.Email == profileInfo.Email select u).ToList().FirstOrDefault();
if (oldUserInfo != null)
{
dbc.Users.DeleteOnSubmit(oldUserInfo);
dbc.SubmitChanges();
//Currently constant fields:
newUserInfo.ID = oldUserInfo.ID;
newUserInfo.UserName = oldUserInfo.UserName;
newUserInfo.Password = oldUserInfo.Password;
//Changable fields:
newUserInfo.FirstName = profileInfo.FirstName;
newUserInfo.LastName = profileInfo.LastName;
newUserInfo.Phone = profileInfo.Phone;
newUserInfo.Address = profileInfo.Address;
newUserInfo.Email = profileInfo.Email;
dbc.Users.InsertOnSubmit(newUserInfo);
dbc.SubmitChanges();
ProfileViewModel newProfile = new ProfileViewModel();
newProfile.UserName = newUserInfo.UserName ?? "";
newProfile.FirstName = newUserInfo.FirstName ?? "";
newProfile.LastName = newUserInfo.LastName ?? "";
newProfile.Email = newUserInfo.Email ?? "";
newProfile.Phone = newUserInfo.Phone ?? "";
newProfile.Address = newUserInfo.Address ?? "";
return View(newProfile);
}
}
//}
return View(profileInfo);
}
public ActionResult Index(string returnUrl)
{
ProfileViewModel profile = new ProfileViewModel();
if (User.Identity.IsAuthenticated)
{
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var currentUser = (from u in dbc.Users where u.Email == User.Identity.Name select u).ToList().FirstOrDefault();
if (currentUser != null)
{
profile.UserName = currentUser.UserName ?? "";
profile.FirstName = currentUser.FirstName ?? "";
profile.LastName = currentUser.LastName ?? "";
profile.Email = currentUser.Email ?? "";
profile.Phone = currentUser.Phone ?? "";
profile.Address = currentUser.Address ?? "";
}
}
}
ViewBag.ReturnUrl = returnUrl;
return View(profile);
}
public ActionResult Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var userInfo = (from u in dbc.Users where u.Email == model.Email select u).ToList().FirstOrDefault();
if (userInfo == null)
{
var user = new Classes.User()
{
UserName = model.UserName,
FirstName = model.FirstName,
LastName = model.LastName,
Phone = model.Phone,
Email = model.Email,
Password = model.Password
};
dbc.Users.InsertOnSubmit(user);
dbc.SubmitChanges();
FormsAuthentication.SetAuthCookie(model.Email, false);
return RedirectToAction("Index", "Home");
}
else
{
ModelState.AddModelError("", "Email address already in use.");
}
}
}
// If we got this far, something failed, redisplay form
return View(model);
}
public ActionResult Login(LoginViewModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return View(model);
}
bool result = false;
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var userInfo = (from u in dbc.Users where u.Email == model.Email select u).ToList().FirstOrDefault();
if (userInfo != null && userInfo.Password == model.Password)
{
result = true;
}
}
if (result)
{
FormsAuthentication.SetAuthCookie(model.Email, false);
return Redirect(returnUrl ?? Url.Action("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Invalid login attempt.");
return View(model);
}
}
private ProductsListModel CreateProductList(string category, int priceFrom, int priceTo, int page)
{
//initialize data
ProductsListModel model = new ProductsListModel();
model.Categories = new List<string>();
model.Products = new List<ProductDetailListModel>();
List<Category> categories = null;
List<Product> products = null;
//Loading data from DB
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
categories = (from item in dbc.Categories select item).ToList();
if (category == null || category == "All")
products = (from item in dbc.Products where item.Price >= priceFrom && item.Price <= priceTo select item).ToList();
else
{
int categ = (from item in categories where item.CategoryName == category select item).ToList().FirstOrDefault().ID;
products = (from item in dbc.Products where item.Price >= priceFrom && item.Price <= priceTo && item.CategoryID == categ select item).ToList();
}
}
//Fill Catagory
if (categories != null)
foreach (Category item in categories)
model.Categories.Add(item.CategoryName);
//Fill Products
List<ProductDetailListModel> tempProsuctDetailListModel = new List<ProductDetailListModel>();
if (categories != null && products != null)
foreach (Product prod in products)
{
string categ = (from item in categories where item.ID == prod.CategoryID select item).ToList().FirstOrDefault().CategoryName;
ProductDetailListModel productDetailModel = new ProductDetailListModel(
prod.ID,
prod.ProductName,
prod.Description,
prod.Image,
categ,
prod.Quantity,
prod.Price);
tempProsuctDetailListModel.Add(productDetailModel);
}
//Determine list of Products in one Page
int ProductsOnPage = 6;
int CurrentPage = page;
int TotalPages = 0;
List<ProductDetailListModel> ProsuctDetailListModelToView = new List<ProductDetailListModel>();
if (tempProsuctDetailListModel.Count > 0)
{
tempProsuctDetailListModel.Sort(delegate(ProductDetailListModel m1, ProductDetailListModel m2) { return m1.ProductName.CompareTo(m2.ProductName); });
double TotalPagesDouble = (double)(tempProsuctDetailListModel.Count) / (double)ProductsOnPage;
if ((TotalPagesDouble - Math.Truncate(TotalPagesDouble)) == 0 || TotalPagesDouble < 1)
TotalPages = Convert.ToInt32(TotalPagesDouble);
else
TotalPages = (int)(Math.Truncate(TotalPagesDouble)) + 1;
int startElement = (CurrentPage - 1) * ProductsOnPage;
int endElement = CurrentPage * ProductsOnPage - 1;
if (startElement > (tempProsuctDetailListModel.Count - 1))
{
startElement = 0;
endElement = ProductsOnPage;
}
if (endElement > (tempProsuctDetailListModel.Count - 1))
endElement = tempProsuctDetailListModel.Count - 1;
for (int i = startElement; i <= endElement; i++)
ProsuctDetailListModelToView.Add(tempProsuctDetailListModel[i]);
}
//Create model for View
model.Page = CurrentPage;
model.CountOfPages = TotalPages;
model.PriceFrom = priceFrom;
model.PriceTo = priceTo;
model.SelectedCategory = category;
model.Products = ProsuctDetailListModelToView;
return model;
}
public ActionResult ProductDetailList(int id)
{
Product product;
ProductDetailListModel model = null;
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
product = (from item in dbc.Products where item.ID == id select item).ToList().FirstOrDefault();
if (product != null)
{
string category = (from item in dbc.Categories where item.ID == product.CategoryID select item).ToList().FirstOrDefault().CategoryName;
model = new ProductDetailListModel(
product.ID,
product.ProductName,
product.Description,
product.Image,
category,
product.Quantity,
product.Price);
}
}
if (model == null)
return RedirectToAction("Index");
return View(model);
}
public ActionResult OrderHistory()
{
List<OrderHistory_OrderModel> model = new List<OrderHistory_OrderModel>();
if (User.Identity.IsAuthenticated)
{
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var currentUser = (from u in dbc.Users where u.Email == User.Identity.Name select u).ToList().FirstOrDefault();
if (currentUser != null)
{
List<Order> orders = (from item in dbc.Orders where item.UserID==currentUser.ID select item).ToList();
foreach (Order o in orders)
{
List<OrderDetails> tempOrderDetails = (from od in dbc.OrderDetails where od.OrderID==o.ID select od).ToList();
double summ = (from s in dbc.Sales where s.OrderID == o.ID select s.SalesAmount).ToList().FirstOrDefault();
OrderHistory_OrderModel oh_om = new OrderHistory_OrderModel(o.ID,o.ShippingAddress, DateTime.FromOADate(o.ShippingDate),o.ShippingStatus,summ);
foreach (OrderDetails od in tempOrderDetails)
oh_om.Products.Add(new OrderHistory_ProductModel(od.Product.ID, od.Product.ProductName, od.Product.Image, od.Product.Price,od.Quantity));
model.Add(oh_om);
}
}
}
}
return View(model);
}
public ActionResult Index()
{
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var products = (from c in dbc.Products select c).ToList();
List<Product> newList = new List<Product>();
foreach (var product in products)
if (product.Featured)
newList.Add(product);
ViewBag.Products = newList;
}
return View();
}
public ActionResult Contact()
{
UserMessageViewModel user = new UserMessageViewModel();
if (User.Identity.IsAuthenticated)
{
using (InternetStoreDBContext dbc = new InternetStoreDBContext())
{
var currentUser = (from u in dbc.Users where u.Email == User.Identity.Name select u).ToList().FirstOrDefault();
if (currentUser != null)
{
user.FirstName = currentUser.FirstName ?? "";
user.LastName = currentUser.LastName ?? "";
user.Email = currentUser.Email ?? "";
user.Phone = currentUser.Phone ?? "";
}
}
}
return View("Contact", user);
}