public ActionResult Product()
{
dbMyOnlineShoppingEntities ctx = new dbMyOnlineShoppingEntities();
List <Product> productsList = ctx.Products.ToList();
ProductViewModel productVM = new ProductViewModel();
List <ProductViewModel> productVMList = productsList.Select(x => new ProductViewModel
{
ProductId = x.ProductId,
CategoryName = x.Category.CategoryName,
ArtistName = x.Album.Artist.Name,
AlbumName = x.Album.AlbumName,
Genre = x.Album.Genre,
ProductImage = x.ProductImage,
Description = x.Description,
IsFeatured = x.IsFeatured,
Quantity = x.Quantity,
Price = x.Price,
ModifiedDate = x.ModifiedDate,
CreatedDate = x.CreatedDate
}).ToList();
return(View(productVMList));
}
public ActionResult Login(Tbl_Admin tbl, string returnUrl)
{
dbMyOnlineShoppingEntities db = new dbMyOnlineShoppingEntities();
tbl.Password = Tbl_Admin.MD5Hash(tbl.Password);
var dataItem = db.Tbl_Admin.Where(x => x.UserName == tbl.UserName && x.Password == tbl.Password).SingleOrDefault();
if (dataItem != null)
{
FormsAuthentication.SetAuthCookie(dataItem.UserName, false);
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") &&
!returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\"))
{
return(Redirect(returnUrl));
}
else
{
//Valid login and password
return(Redirect("/Admin/Product"));
}
}
else
{
ModelState.AddModelError("", "Invalid user/pass");
return(View());
}
}
public void AddCategories(CategoryDetail category)
{
using (dbMyOnlineShoppingEntities db = new dbMyOnlineShoppingEntities())
{
Tbl_Category CA = new Tbl_Category();
CA.CategoryName = category.CategoryName;
db.Tbl_Category.Add(CA);
db.SaveChanges();
}
}
public ActionResult AddAdmin(Tbl_Admin tbl)
{
if (tbl.Password != null && tbl.UserName != null)
{
dbMyOnlineShoppingEntities db = new dbMyOnlineShoppingEntities();
tbl.Password = Tbl_Admin.MD5Hash(tbl.Password);
var dataItem = db.Tbl_Admin.Where(x => x.UserName == tbl.UserName).SingleOrDefault();
if (dataItem == null)
{
_unitOfWork.GetRepositoryInstance <Tbl_Admin>().Add(tbl);
return(RedirectToAction("Login"));
}
}
return(RedirectToAction("AddAdmin"));
}
public void AddUserAccount(RegisterViewModel user)
{
using (dbMyOnlineShoppingEntities db = new dbMyOnlineShoppingEntities())
{
Tbl_Members SU = new Tbl_Members();
SU.EmailId = user.EmailId;
SU.Password = user.Password;
SU.FristName = user.FristName;
SU.LastName = user.LastName;
SU.CreatedOn = DateTime.Now;
SU.ModifiedOn = DateTime.Now;
db.Tbl_Members.Add(SU);
db.SaveChanges();
}
}
public GenericRepository(dbMyOnlineShoppingEntities DBEntity)
{
_DBEntity = DBEntity;
_dbSet = DBEntity.Set <Tbl_Entity>();
}
public ActionResult CreateOrder(CreateOrderViewModel orderViewModel)
{
if (orderViewModel != null && ModelState.IsValid)
{
dbMyOnlineShoppingEntities db = new dbMyOnlineShoppingEntities();
var mem = _unitOfWork.GetRepositoryInstance <Tbl_Members>().GetAllRecords();
var maxMemberId = 0;
foreach (var item in mem)
{
if (item.MemberId > maxMemberId)
{
maxMemberId = item.MemberId + 1;
}
}
Tbl_Members person = new Tbl_Members();
person.FristName = orderViewModel.Member.FristName;
person.LastName = orderViewModel.Member.LastName;
person.MemberId = maxMemberId;
person.CreatedOn = DateTime.Now;
person.EmailId = orderViewModel.Member.EmailId;
person.IsActive = true;
person.IsDelete = false;
person.Password = "******";
person.ModifiedOn = DateTime.Now;
_unitOfWork.GetRepositoryInstance <Tbl_Members>().Add(person);
var shippingDet = _unitOfWork.GetRepositoryInstance <Tbl_ShippingDetails>().GetAllRecords();
var maxShipId = 0;
foreach (var item in shippingDet)
{
if (item.ShippingDetailId > maxShipId)
{
maxShipId = item.ShippingDetailId + 1;
}
}
var orders = _unitOfWork.GetRepositoryInstance <Tbl_Orders>().GetAllRecords();
var maxOrderId = 0;
foreach (var item in orders)
{
if (item.OrderId > maxOrderId)
{
maxOrderId = item.OrderId + 1;
}
}
Tbl_ShippingDetails shippingDetails = new Tbl_ShippingDetails();
shippingDetails.ShippingDetailId = maxShipId;
shippingDetails.Adress = orderViewModel.ShippingDetails.Adress;
shippingDetails.City = orderViewModel.ShippingDetails.City;
shippingDetails.ZipCode = orderViewModel.ShippingDetails.ZipCode;
shippingDetails.Country = orderViewModel.ShippingDetails.Country;
shippingDetails.State = orderViewModel.ShippingDetails.State;
shippingDetails.MemberId = maxMemberId;
string AmountPaid = Session["SesTotal"].ToString();
shippingDetails.AmountPaid = Decimal.Parse(AmountPaid);
orderViewModel.ShippingDetails.AmountPaid = shippingDetails.AmountPaid;
shippingDetails.PaymentType = "Cash";
_unitOfWork.GetRepositoryInstance <Tbl_ShippingDetails>().Add(shippingDetails);
Tbl_Orders order = new Tbl_Orders();
order.MemberId = person.MemberId;
order.OrderStatus = "First Step";
order.ShippingDetailsId = shippingDetails.ShippingDetailId;
order.OrderId = maxOrderId;
_unitOfWork.GetRepositoryInstance <Tbl_Orders>().Add(order);
List <Item> cart = (List <Item>)Session["cart"];
foreach (var item in cart)
{
if (item.Quantity > 0)
{
Tbl_OrderProducts orderProducts = new Tbl_OrderProducts();
orderProducts.ProductId = item.Product.ProductId;
orderProducts.Quantity = item.Quantity;
orderProducts.OrderId = order.OrderId;
_unitOfWork.GetRepositoryInstance <Tbl_OrderProducts>().Add(orderProducts);
}
}
//The string with the products that will be sent to the customer
string products = "------------------------------------------------------------------------------------------\n" +
"|Qty.x Price| Name \n" +
"------------------------------------------------------------------------------------------\n"
;
foreach (Item item in (List <Item>)Session["cart"])
{
int lineTotal = Convert.ToInt32(item.Quantity * item.Product.Price);
string product = "| " + item.Quantity + " x " + item.Product.Price + " | " + item.Product.ProductName + ":\n " +
"------------------------------------------------------------------------------------------\n";
products = string.Concat(products, product);
}
Gmail.SendEmail(orderViewModel, products);
return(RedirectToAction("PayOrder", "Home"));
}
//if the Model was not valid render again the page
return(RedirectToAction("CreateOrder", "Home"));
}
public GenericRepository(dbMyOnlineShoppingEntities db2)
{
db = db2;
dbSet = db.Set <Tbl_Entity>();
}