//POst
//[HttpPost, ActionName("Delete")]
//[ValidateAntiForgeryToken]
public ActionResult Delete(int id)
{
Content content = db.Contents.Find(id);
db.Contents.Remove(content);
db.SaveChanges();
return(RedirectToAction("Display"));
}
//public int UploadImageInDataBase(HttpPostedFileBase file, ContentViewModel contentViewModel)
//{
// contentViewModel.Image = ConvertToBytes(file);
// var Content = new Content
// {
// Name = contentViewModel.Name,
// BrandId=contentViewModel.BrandId,
// CategoryId=contentViewModel.CategoryId,
// price = contentViewModel.price,
// Review = contentViewModel.Review,
// Description = contentViewModel.Description,
// Image = contentViewModel.Image
// };
// db.Contents.Add(Content);
// int i = db.SaveChanges();
// if (i == 1)
// {
// return 1;
// }
// else
// {
// return 0;
// }
public int AddUpdateUserData(UserDataViewModel userdataviewmodel)
{
if (userdataviewmodel.UserId == 0)
{
var UserData = new User
{
FirstName = userdataviewmodel.FirstName,
LastName = userdataviewmodel.LastName,
Gender = userdataviewmodel.Gender,
Email = userdataviewmodel.Email,
Password = userdataviewmodel.Password,
PhoneNo = userdataviewmodel.PhoneNo,
Address = userdataviewmodel.Address,
BirthDate = userdataviewmodel.BirthDate
};
db.Users.Add(UserData);
}
else
{
User updateData = (from a in db.Users
where a.UserId == userdataviewmodel.UserId
select a).FirstOrDefault();
updateData.FirstName = userdataviewmodel.FirstName;
updateData.LastName = userdataviewmodel.LastName;
updateData.Gender = userdataviewmodel.Gender;
updateData.Email = userdataviewmodel.Email;
updateData.Password = userdataviewmodel.Password;
updateData.PhoneNo = userdataviewmodel.PhoneNo;
updateData.Address = userdataviewmodel.Address;
updateData.BirthDate = userdataviewmodel.BirthDate;
}
int i = db.SaveChanges();
if (i == 1)
{
return(1);
}
else
{
return(0);
}
}
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 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));
}