public static bool AddProductImages(string[] Images)
{
int idProduct = Convert.ToInt32(Images[(Images.Length) - 1]);
using (Baby_BEntities1 db = new Baby_BEntities1())
{
for (int i = 0; i < Images.Length - 1; i++)
{
ProductImage im = new ProductImage();
im.IdProduct = idProduct;
im.PathImage = ConstsValues.IMAGE_PATH + Path.GetFileName(Images[i]);
db.ProductImage.Add(im);
}
try
{
db.SaveChanges();
return(true);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
return(false);
}
public static List <shopping> GetShopping(int id)
{
using (Baby_BEntities1 db = new Baby_BEntities1())
{
List <shopping> f = new List <shopping>();
List <ShoppingCart> userList = db.ShoppingCart.Where(s => s.IdUser == id).ToList();
if (userList != null)
{
foreach (var item in userList)
{
f.Add(new shopping
{
NameProduct = item.NameProduct,
Category = item.Category,
Subcategory = item.Subcategory,
AmountOfPurchases = item.AmountOfPurchases,
ImageOfProduct = item.ImageOfProduct,
Company = item.Company,
DateAdded = item.DateAdded,
Color = item.Color,
Price = item.Price,
size = item.size,
DiscountPercentage = item.DiscountPercentage,
});
//shopping n = new shopping() {NameProduct=item.NameProduct,Color=item.Color };
//f[f.Count] = new shopping();
//f[f.Count] = n;
}
return(f);
}
return(null);
}
}
public static int GetUser(string mail, string password)
{
using (Baby_BEntities1 db = new Baby_BEntities1())
{
Users user = db.Users.Where(u => u.EMail == mail && u.UserPassword == password).First();
if (user == null)
{
return(0);
}
return(user.IdUser);
}
}
public static int Register(Users register)
{
using (Baby_BEntities1 db = new Baby_BEntities1())
{
try
{
db.Users.Add(register);
db.SaveChanges();
int id = db.Users.Where(c => c.EMail == register.EMail && c.UserPassword == register.UserPassword).Select(c => c.IdUser).FirstOrDefault();
return(id);
}
catch (Exception e)
{
//throw new Exception();
return(0);
}
}
}
public static List <Product> GetAllProducts(int IdCategory)
{
List <Product> L = new List <Product>();
List <int> IdSubCategory = new List <int>();
List <Dto.ProductImage> Images = new List <Dto.ProductImage>();
List <ProductImage> ProductImages = new List <ProductImage>();
using (Baby_BEntities1 db = new Baby_BEntities1())
{
IdSubCategory = db.SubCategory.Where(u => u.IdCategory == IdCategory).Select(o => o.IdSubCategory).ToList();
foreach (var item in db.Products)
{
for (int i = 0; i < IdSubCategory.Count(); i++)
{
if (item.IdSubcategory == IdSubCategory[i])
{
Images.Clear();
ProductImages = db.ProductImage.Where(o => o.IdProduct == item.IdProduct).ToList();
Dto.ProductImage im = new Dto.ProductImage();
im.PathImage = ProductImages[0].PathImage;
Images.Add(im);
Product p = new Product();
p.Price = item.Price;
p.NameProduct = item.NameProduct;
p.IdProduct = item.IdProduct;
p.DescriptionProduct = item.DescriptionProduct;
ProductImages = db.ProductImage.Where(o => o.IdProduct == item.IdProduct).ToList();
p.ProductImage = Images;
L.Add(p);
}
}
}
}
return(L);
}