public ActionResult SearchPartial(string searching)
{
ShoppingCartAppEntities db = new ShoppingCartAppEntities();
return(PartialView("SearchPartial"));
}
public ActionResult AddUser(User model)
{
using (ShoppingCartAppEntities entities = new ShoppingCartAppEntities())
{
entities.Users.Add(model);
entities.SaveChanges();
int UserId = model.UserId;
//return RedirectToAction("Display");
ViewBag.result = " Registration Successful!";
}
SendActivationEmail(model);
return(View(model));
}
public ActionResult EditYourProfile(UserDataViewModel obj)
{
using (ShoppingCartAppEntities db = new ShoppingCartAppEntities())
{
ContentRepository service = new ContentRepository();
int i = service.AddUpdateUserData(obj); if (i == 1)
{
return(RedirectToAction("UserProfile"));
}
db.SaveChanges();
return(RedirectToAction("UserProfile"));
}
}
public ActionResult MyorderPartial()
{
try
{
ShoppingCartAppEntities db = new ShoppingCartAppEntities();
var sum = 0;
var Price = 0;
int UserId = System.Convert.ToInt32(Session["UserId"].ToString());
//var Quantity =from a in db.UserCarts
// where a.UserId== UserId
// select a;
var item = (from a in db.UserCarts
join b in db.Contents
on a.ProductId equals b.ID
where a.UserId == UserId
select new ContentViewModel
{
ID = b.ID,
Name = b.Name,
Image = b.Image,
Quantity = a.Quantity == null ? 0 : a.Quantity.Value,
price = b.price,
}).ToList();
foreach (var totalsum in item)
{
//sum = sum + System.Convert.ToInt32(totalsum.price);
// sum = sum - ((totalsum.price * totalsum.Offer) / 100);
Price = System.Convert.ToInt32(totalsum.price) * System.Convert.ToInt32(totalsum.Quantity);
sum = sum + /*System.Convert.ToInt32(totalsum.price)*/ Price;
}
ViewBag.Total = sum;
//String.Format("{0:n}", ViewBag.Total);
ViewBag.Price = Price;
var count = (from a in db.UserCarts
where a.UserId == (UserId)
select a.Quantity).Sum();
ViewBag.cartCount = count;
return(View("Myorder", item));
// return View((List<Content>)Session["cart"]);
}
catch (Exception ex)
{
return(RedirectToAction("Login"));
}
}
//[HttpPost]
//[ValidateAntiForgeryToken]
//public ActionResult ProductDetails(Content obj)
//{
// using (ProjectEntities1 db = new ProjectEntities1())
// {
// Content contentDetails = (from c in db.Contents where c.ID == obj.ID select c).FirstOrDefault();
// contentDetails.Name = obj.Name;
// contentDetails.price = obj.price;
// contentDetails.Description = obj.Description;
// contentDetails.Image = obj.Image == null ? contentDetails.Image : obj.Image;
// contentDetails.price = obj.price;
// contentDetails.Review = obj.Review;
// return View("ProductDetails");
// }
//}
private void SendActivationEmail(User user)
{
ShoppingCartAppEntities projectEntities = new ShoppingCartAppEntities();
SmtpSection secObj = (SmtpSection)ConfigurationManager.GetSection("system.net/mailSettings/smtp");
using (MailMessage mm = new MailMessage("*****@*****.**", user.Email))
{
if (Session["Role"] != null)
{
mm.Subject = "Account Activation";
string body = "Hello " + user.FirstName + ",";
body = "Your Account has been created in Our shoppingCart. Your credentials are: ";
body += "<br /><br /> UserId :" + user.Email + ", ";
body += "<br /> Password :"******",";
body += "<br /><br />Thanks";
mm.Body = body;
}
else
{
mm.Subject = "Order status";
string body = "Hello " + user.FirstName + ",";
body = "Your Order has been Placed Successfully: ";
body += "<br /><br />Thanks";
mm.Body = body;
}
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
// smtp.Host = "smtp.gmail.com";
// NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", "padmin1432");
smtp.Host = secObj.Network.Host;
smtp.EnableSsl = true;
NetworkCredential NetworkCred = new NetworkCredential("*****@*****.**", secObj.Network.Password);
smtp.ServicePoint.MaxIdleTime = 1;
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
smtp.Send(mm);
}
}
public ActionResult Create()
{
try
{
int UserId = Convert.ToInt32(Session["UserId"].ToString());
if (UserId != null)
{
ShoppingCartAppEntities db = new ShoppingCartAppEntities();
ViewBag.BrandId = new SelectList(db.Brands.OrderBy(x => x.BrandName), "BrandId", "BrandName");
ViewBag.CateGoryId = new SelectList(db.Categories.OrderBy(x => x.CategoryName), "CategoryId", "CategoryName");
return(View());
}
return(RedirectToAction("Login"));
}
catch (Exception ex)
{
return(RedirectToAction("Login"));
}
}
public ActionResult CheckOrders()
{
ShoppingCartAppEntities db = new ShoppingCartAppEntities();
int UserId = Convert.ToInt32(Session["UserId"].ToString());
var item = db.UserOrders.GroupBy(r =>
new
{
r.OrderId,
r.Date,
r.UserId,
r.OrderStatus,
}).Select(r => new OrderViewModel()
{
DateTime = r.Key.Date,
OrderId = r.Key.OrderId,
UserId = r.Key.UserId,
OrderStatus = r.Key.OrderStatus,
Quantity = r.Sum(a => a.Quantity),
Price = r.Sum(a => a.Price)
}).ToList()
.Where(g => g.UserId == UserId);
//foreach (var itemdata in item )
//{
// var data = from a in db.UserOrders
// where a.UserId == UserId && a.OrderId == itemdata.OrderId
// select a.OrderStatus;
//}
//ViewBag.data = data;
var count = (from a in db.UserCarts
where a.UserId == (UserId)
select a.Quantity).Sum();
ViewBag.cartCount = count;
return(View("CheckOrders", item));
}
public ActionResult OrderClick(string OrderId)
{
ShoppingCartAppEntities db = new ShoppingCartAppEntities();
var sum = 0;
int Price = 0;
int UserId = System.Convert.ToInt32(Session["UserId"].ToString());
var item = (from a in db.UserOrders
join b in db.Contents
on a.ProductId equals b.ID
where a.UserId == UserId && a.OrderId == OrderId
select new OrderViewModel
{
ProductId = b.ID,
Name = b.Name,
BrandDesc = b.Brand.BrandName,
Image = b.Image,
Price = b.price,
TotalPrice = a.Price,
OrderId = a.OrderId,
Quantity = a.Quantity == null ? 0 : a.Quantity.Value,
DateTime = a.Date,
OrderStatus = a.OrderStatus,
}).ToList();
foreach (var totalsum in item)
{
Price = System.Convert.ToInt32(totalsum.Price) * System.Convert.ToInt32(totalsum.Quantity);
sum = sum + /*System.Convert.ToInt32(totalsum.price)*/ Price;
}
ViewBag.Total = sum;
var count = (from a in db.UserCarts
where a.UserId == (UserId)
select a.Quantity).Sum();
ViewBag.cartCount = count;
return(View("OrderClick", item));
}
public ActionResult Edit(ContentViewModel obj)
{
try
{
using (ShoppingCartAppEntities db = new ShoppingCartAppEntities())
{
HttpPostedFileBase file = Request.Files["ImageData"];
ContentRepository service = new ContentRepository();
int i = service.AddUpdateConttentData(file, obj); if (i == 1)
{
return(RedirectToAction("Display"));
}
db.SaveChanges();
return(RedirectToAction("Display"));
}
}
catch (Exception ex)
{
return(RedirectToAction("Login"));
}
}
public ActionResult AddQuantity(int ProductId, int UserId)
{
ShoppingCartAppEntities db = new ShoppingCartAppEntities();
int Quantity;
CartViewModel cm = new CartViewModel();
var data = (from a in db.UserCarts
where a.UserId == UserId && a.ProductId == ProductId
select a.ProductId).Count();
var data_user = db.UserCarts.Count(a => a.UserId == UserId);
if (data_user == 0)
{
Quantity = 1;
UserCart c = new UserCart()
{
UserId = UserId,
ProductId = ProductId,
DateTime = System.DateTime.Now,
Quantity = Quantity,
};
db.UserCarts.Add(c);
db.SaveChanges();
}
else
{
if (data == 0)
{
Quantity = 1;
UserCart c = new UserCart()
{
UserId = UserId,
ProductId = ProductId,
DateTime = System.DateTime.Now,
Quantity = Quantity,
};
db.UserCarts.Add(c);
db.SaveChanges();
}
else
{
var abc = (from a in db.UserCarts
where a.ProductId == (ProductId) && a.UserId == (UserId)
select a.Quantity).Single();
int QuantityData = System.Convert.ToInt32(abc);
QuantityData++;
var result = db.UserCarts.SingleOrDefault(b => b.ProductId == ProductId && b.UserId == UserId);
result.ProductId = ProductId;
result.Quantity = QuantityData;
result.UserId = UserId;
result.DateTime = System.DateTime.Now;
db.SaveChanges();
}
}
var count = (from a in db.UserCarts
where a.UserId == (UserId)
select a.Quantity).Sum();
ViewBag.cartCount = count;
return(Redirect("MyorderPartial"));
}
public ActionResult Add(int ProductId, int UserId)
{
ShoppingCartAppEntities db = new ShoppingCartAppEntities();
int Quantity;
CartViewModel cm = new CartViewModel();
// var roductId = db.UserCarts.AsNoTracking().Where(p => p.ProductId == ProductId).FirstOrDefault();
// var roductId = db.UserCarts.Find(ProductId);
// var roductId = from u in db.UserCarts.Where(p => p.ProductId == ProductId).Select(v => v.ProductId) select ProductId;
// var data = db.UserCarts.Count(a => a.ProductId == ProductId);
var data = (from a in db.UserCarts
where a.UserId == UserId && a.ProductId == ProductId
select a.ProductId).Count();
var data_user = db.UserCarts.Count(a => a.UserId == UserId);
if (data_user == 0)
{
Quantity = 1;
UserCart c = new UserCart()
{
UserId = UserId,
ProductId = ProductId,
DateTime = System.DateTime.Now,
Quantity = Quantity,
};
db.UserCarts.Add(c);
db.SaveChanges();
}
else
{
if (data == 0)
{
Quantity = 1;
UserCart c = new UserCart()
{
UserId = UserId,
ProductId = ProductId,
DateTime = System.DateTime.Now,
Quantity = Quantity,
};
db.UserCarts.Add(c);
db.SaveChanges();
}
else
{
var abc = (from a in db.UserCarts
where a.ProductId == (ProductId) && a.UserId == (UserId)
select a.Quantity).Single();
int pqr = System.Convert.ToInt32(abc);
pqr++;
var result = db.UserCarts.SingleOrDefault(b => b.ProductId == ProductId && b.UserId == UserId);
result.ProductId = ProductId;
result.Quantity = pqr;
result.UserId = UserId;
result.DateTime = System.DateTime.Now;
db.SaveChanges();
}
}
var count = (from a in db.UserCarts
where a.UserId == (UserId)
select a.Quantity).Sum();
ViewBag.cartCount = count;
// TempData["ProductAddedToCart"] = "Product added to cart successfully";
// return RedirectToAction("Display", ViewBag.cartCount);
return(RedirectToAction("DisplayPartial", ViewBag.cartCount));
}
public ActionResult Login(UserDataViewModel objUser)
{
//UserDataViewModel model = new UserDataViewModel();
try
{
if (ModelState.IsValid)
{
using (ShoppingCartAppEntities db = new ShoppingCartAppEntities())
{
if (objUser.Email != null && objUser.Password != null)
{
string rank = db.Users.Where(a => a.Email == objUser.Email).FirstOrDefault().Role;
var obj = db.Users.Where(a => a.Email.Equals(objUser.Email) && a.Password.Equals(objUser.Password)).FirstOrDefault();
if (obj != null && rank == "Admin")
{
FormsAuthentication.SetAuthCookie(objUser.Email, objUser.Remember);
FormsAuthentication.SetAuthCookie(objUser.Password, objUser.Remember);
Session["UserId"] = obj.UserId.ToString();
Session["Email"] = obj.Email.ToString();
Session["Role"] = obj.Role.ToString();
Session["FirstName"] = obj.FirstName.ToString();
Session["LastName"] = obj.LastName.ToString();
if (objUser.Remember)
{
HttpCookie cookie = new HttpCookie("Login");
cookie.Values.Add("Email", obj.Email);
cookie.Values.Add("Password", obj.Password);
cookie.Expires = DateTime.Now.AddDays(15);
Response.Cookies.Add(cookie);
}
else
{
Response.Cookies["Email"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1);
}
//Response.Cookies["UserName"].Value = obj.Email.Trim();
//Response.Cookies["Password"].Value = obj.Password.Trim();
return(RedirectToAction("Display"));
}
else if (obj != null && rank == "User")
{
FormsAuthentication.SetAuthCookie(objUser.Email, objUser.Remember);
FormsAuthentication.SetAuthCookie(objUser.Password, objUser.Remember);
Session["UserId"] = obj.UserId.ToString();
Session["Email"] = obj.Email.ToString();
//return RedirectToAction("UserDataDisplay");
if (objUser.Remember)
{
HttpCookie cookie = new HttpCookie("Login");
cookie.Values.Add("Email", obj.Email);
cookie.Values.Add("Password", obj.Password);
cookie.Expires = DateTime.Now.AddDays(15);
Response.Cookies.Add(cookie);
}
else
{
Response.Cookies["Email"].Expires = DateTime.Now.AddDays(-1);
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-1);
}
Response.Cookies["Email"].Value = obj.Email.Trim();
Response.Cookies["Password"].Value = obj.Password.Trim();
return(RedirectToAction("Display"));
}
else
{
ViewBag.Message = "Your Password is Wrong";
return(View("Login"));
}
}
else
{
ViewBag.Message = "Please Fill the UserName and Password.";
return(View("Login"));
}
}
}
return(View(objUser));
}
catch (Exception ex)
{
ViewBag.Message = "Please Fill the UserName and Password Correct.";
return(View("Login"));
}
}
