public static void Add(int productId, string name, string value)
{
using (var dbContext = new DataContext())
{
int nameId = 0;
int valueId = 0;
var paramName = dbContext.ParamNames.FirstOrDefault(s => s.Name.Equals(name));
var paramValue = dbContext.ParamValues.FirstOrDefault(s => s.Name.Equals(value));
if (paramName == null)
{
paramName = dbContext.ParamNames.Add(new ParamName() { Name = name });
dbContext.SaveChanges();
}
nameId = paramName.ParamNameId;
if (paramValue == null)
{
paramValue = dbContext.ParamValues.Add(new ParamValue() { Name = value });
dbContext.SaveChanges();
}
valueId = paramValue.ParamValueId;
dbContext.Parameters.Add(new Parameter()
{
ParamValueId = valueId,
ParamNameId = nameId,
ProductId = productId
});
dbContext.SaveChanges();
}
}
public static List<Tag> GetTagsFromString(String StringOfTags)
{
using (var dbContext = new DataContext())
{
String[] StrTags = StringOfTags.ToLower().Split(new Char[] { ',' });
List<Tag> list = new List<Tag>();
foreach (var tag in StrTags)
{
var tags = dbContext.Tags.Where(s => s.Name == tag);
if (tags.Count() == 0)
{
dbContext.Tags.Add(new Tag { Name = tag, Value = 1 });
dbContext.SaveChanges();
}
else
{
tags.ToList()[0].Value++;
dbContext.SaveChanges();
}
list.Add(dbContext.Tags.FirstOrDefault(s => s.Name == tag));
}
return list;
}
}
public void Edit(Category category)
{
using (var dbContext = new DataContext())
{
dbContext.Entry(category).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public void Add(Category category)
{
using (var dbContext = new DataContext())
{
dbContext.Categories.Add(category);
dbContext.SaveChanges();
}
}
public void Edit(Product product)
{
using (var dbContext = new DataContext())
{
dbContext.Entry(product).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public static void Add(Basket basket)
{
using (var dbContext = new DataContext())
{
dbContext.Baskets.Add(basket);
dbContext.SaveChanges();
}
}
public static void Add(Adress adress)
{
using (var dbContext = new DataContext())
{
dbContext.Adresses.Add(adress);
dbContext.SaveChanges();
}
}
public static void Edit(Adress adress)
{
using (var dbContext = new DataContext())
{
dbContext.Entry(adress).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public void Delete(int id)
{
using (var dbContext = new DataContext())
{
User user = dbContext.Users.Find(id);
dbContext.Users.Remove(user);
dbContext.SaveChanges();
}
}
public static void Delete(int id)
{
using (var dbContext = new DataContext())
{
var adress = dbContext.Adresses.Find(id);
dbContext.Adresses.Remove(adress);
dbContext.SaveChanges();
}
}
public void Delete(int id)
{
using (var dbContext = new DataContext())
{
Category category = dbContext.Categories.Find(id);
dbContext.Categories.Remove(category);
dbContext.SaveChanges();
}
}
public void Delete(int id)
{
using (var dbContext = new DataContext())
{
Product product = dbContext.Products.Find(id);
dbContext.Products.Remove(product);
dbContext.SaveChanges();
}
}
public void Edit(int id, int idParent)
{
using (var dbContext = new DataContext())
{
Category category = Find(id);
category.Parent = Find(idParent);
dbContext.Entry(category).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public static void Delete(int productId, int userId)
{
using (var dbContext = new DataContext())
{
var basket = dbContext.Baskets.Where(s => s.UserId == userId)
.First(s => s.ProductId == productId);
dbContext.Baskets.Remove(basket);
dbContext.SaveChanges();
}
}
public int AddOrderProduct(OrderProduct orderProduct)
{
using (var dbContext = new DataContext())
{
int id = dbContext.OrderProducts.Add(orderProduct).Id;
var product = dbContext.Store.Find(orderProduct.ProductId);
product.Quantity--;
dbContext.Entry(product).State = EntityState.Modified;
dbContext.SaveChanges();
return id;
}
}
public static void Delete(int id)
{
using (var dbContext = new DataContext())
{
Picture pic = dbContext.Pictures.Find(id);
var product = dbContext.Products.Find(pic.ProductId);
product.Picture.Remove(pic);
dbContext.Pictures.Remove(pic);
dbContext.Entry(product).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public static void Add(Picture picture)
{
using (var dbContext = new DataContext())
{
dbContext.Pictures.Add(picture);
var product = dbContext.Products.Find(picture.ProductId);
List<Picture> listPicture = product.Picture.ToList();
listPicture.Add(picture);
product.Picture = listPicture;
dbContext.Entry(product).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public void Add(Product product, String StringTags)
{
using (var dbContext = new DataContext())
{
foreach (var tag in TagRepository.GetTagsFromString(StringTags))
{
product.Tags.Add(dbContext.Tags.Find(tag.TagId));
}
dbContext.Products.Add(product);
dbContext.SaveChanges();
}
}
public int Add(Order order)
{
using (var dbContext = new DataContext())
{
dbContext.Orders.Add(order);
dbContext.SaveChanges();
int id = dbContext.Orders
.Where(s => s.UserId == order.UserId)
.Where(s => s.TotalPrice == order.TotalPrice)
.FirstOrDefault(s => s.AdressId == order.AdressId).OrderId;
return id;
}
}
public static void Delete(int idProduct, int idValue, int idName)
{
using (var dbContext = new DataContext())
{
var param = dbContext.Parameters
.Where(s => s.ParamNameId == idName)
.Where(s => s.ParamValueId == idValue)
.First(s => s.ProductId == idProduct);
if (param != null)
{
dbContext.Parameters.Remove(param);
}
dbContext.SaveChanges();
}
}
public static void Add(String text, int productId, int userId)
{
using (var dbContext = new DataContext())
{
var listProduct = new List<Product>();
var comment = new Description() {
TextDescription = text,
Data = DateTime.Now,
UserId = userId
};
var product = dbContext.Products.Find(productId);
product.Descriptions.Add(comment);
var user = dbContext.Users.Find(userId);
user.Descriptions.Add(comment);
dbContext.Entry(user).State = EntityState.Modified;
dbContext.Descriptions.Add(comment);
dbContext.Entry(product).State = EntityState.Modified;
dbContext.SaveChanges();
}
}