public void EmptyCart(Guid UserID)
{
dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
dbContext.Cart.RemoveRange(dbContext.Cart.Where(c => c.UserID == UserID));
dbContext.SaveChanges();
return;
}
public void update(ViewCartDTO vcdto)
{
foreach (var iter in vcdto.CartProduct)
{
dbContext.Variant.SingleOrDefault(cad => cad.ID == iter.Variant_ID).QuantitySold += 1;
Variant vd = dbContext.Variant.Where(abc1 => abc1.ID == iter.Variant_ID).First();
Product pd = dbContext.Product.Where(ds => ds.ID == vd.ProductID).FirstOrDefault();
Category cat1 = dbContext.Category.Where(re => re.ID == pd.CategoryID).FirstOrDefault();
dbContext.Category.SingleOrDefault(c => c.ID == cat1.ID).ProductsSold += 1;
dbContext.SaveChanges();
}
}
public Guid AddAddress(AddressDTO addDTO, Guid userid)
{
Address address = new Address();
dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
address.AddressLine1 = addDTO.Address1;
address.AddressLine2 = addDTO.Address2;
address.Pin = addDTO.Pin;
address.ID = Guid.NewGuid();
address.UserID = userid;
dbContext.Address.Add(address);
dbContext.SaveChanges();
return(address.ID);
}
//registering the user
public UserBasicDTO AddUser(UserRegisterDTO userRegisterDTO)
{
User user = UserRegisterDTOusermapper.Map <UserRegisterDTO, User>(userRegisterDTO);
dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
user.ID = Guid.NewGuid();
user.RoleID = dbContext.Role.Where(r => r.Name == "user").First().ID;
dbContext.User.Add(user);
dbContext.SaveChanges();
UserBasicDTO userBasicDTO = userUserBasicDTOMapper.Map <User, UserBasicDTO>(user);
return(userBasicDTO);
}
//adding product to the cart using the loggedin user's userID
public bool AddProduct(Guid id, Guid user_id)
{
Product product = dbContext.Product.Where(a => a.ID == id).FirstOrDefault();
if (product == null)
{
dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
Variant variant = dbContext.Variant.Where(s => s.ID == id).FirstOrDefault();
Guid p_id = variant.ProductID;
Product pr = dbContext.Product.Where(cdd => cdd.ID == p_id).FirstOrDefault();
VariantImage vimage = dbContext.VariantImage.Where(cdd => cdd.VariantID == variant.ID).FirstOrDefault();
ProductDetailDTO cartdto = new ProductDetailDTO();
IEnumerable <Cart> ca = dbContext.Cart.Where(pd => pd.UserID == user_id);
foreach (var cd in ca)
{
if (cd.VariantID == variant.ID)
{
return(false);
}
}
Cart cart = new Cart();
cart.ID = Guid.NewGuid();
cart.VariantID = variant.ID;
cart.SellingPrice = variant.Discount;
cart.Qty = 1;
cart.UserID = user_id;
cartdto.Name = pr.Name;
cartdto.ImageURL = vimage.ImageURL;
dbContext.Cart.Add(cart);
dbContext.SaveChanges();
return(true);
}
else
{
dbContext.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
Variant variant = dbContext.Variant.Where(s => s.ProductID == id).FirstOrDefault();
//Guid p_id = variant.ProductID;
VariantImage vimage = dbContext.VariantImage.Where(cdd => cdd.VariantID == variant.ID).FirstOrDefault();
ProductDetailDTO cartdto = new ProductDetailDTO();
IEnumerable <Cart> ca = dbContext.Cart.Where(pd => pd.UserID == user_id);
foreach (var cd in ca)
{
if (cd.VariantID == variant.ID)
{
return(false);
}
}
Cart cart = new Cart();
cart.ID = Guid.NewGuid();
cart.VariantID = variant.ID;
cart.SellingPrice = variant.Discount;
cart.Qty = 2;
cart.UserID = user_id;
cartdto.Name = product.Name;
cartdto.ImageURL = vimage.ImageURL;
dbContext.Cart.Add(cart);
dbContext.SaveChanges();
return(true);
}
}
