public void Update(PRODUCT entity) { try { using (StudioDB db = new StudioDB()) { var obj = from o in db.PRODUCTs where o.id_product == entity.id_product select o; obj.ToList()[0].title = entity.title; obj.ToList()[0].category = entity.category; obj.ToList()[0].size = entity.size; obj.ToList()[0].color = entity.color; obj.ToList()[0].photo = entity.photo; obj.ToList()[0].price = entity.price; obj.ToList()[0].count = entity.count; obj.ToList()[0].id_supply = entity.id_supply; db.SaveChanges(); } } catch (Exception e) { throw e; } }
public void Update(CLIENT entity) { try { using (StudioDB db = new StudioDB()) { var obj = from o in db.CLIENTs where o.id_client == entity.id_client select o; obj.ToList()[0].name = entity.name; obj.ToList()[0].surname = entity.surname; obj.ToList()[0].patronymic = entity.patronymic; obj.ToList()[0].login = entity.login; obj.ToList()[0].password = entity.password; obj.ToList()[0].access_level = entity.access_level; obj.ToList()[0].password = entity.password; obj.ToList()[0].mail = entity.mail; obj.ToList()[0].phone_number = entity.phone_number; obj.ToList()[0].sex = entity.sex; obj.ToList()[0].growth = entity.growth; obj.ToList()[0].chest = entity.chest; obj.ToList()[0].waist = entity.waist; obj.ToList()[0].hip = entity.hip; db.SaveChanges(); } } catch (Exception e) { throw e; } }
public List <ProductInfoContainer> GetProductsInfo() { try { using (StudioDB db = new StudioDB()) { List <ProductInfoContainer> productsInfo = new List <ProductInfoContainer>(); List <PRODUCT> products = AllProducts(); foreach (PRODUCT item in products) { var productMaterials = from ps in db.PRODUCT_STRUCTURE join m in db.MATERIALs on ps.id_material equals m.id_material where ps.id_product == item.id_product select new { m.id_material, m.name, ps.count }; List <ProductMaterial> materialsInfo = productMaterials.ToList() .Select(x => new ProductMaterial(x.id_material, x.name, x.count)) .ToList(); productsInfo.Add(new ProductInfoContainer(item, materialsInfo)); } return(productsInfo); } } catch (Exception e) { throw e; } }
private bool LoadClientProducts() { try { using (StudioDB db = new StudioDB()) { var products = from p in db.PRODUCTs join b in db.BASKETs on p.id_product equals b.id_product where b.id_client == client.id_client select p; clientProducts = products.ToList(); if (clientProducts.Count == 0) { return(false); } } return(true); } catch (Exception e) { throw e; } }
public List <MaterialInfoContainer> GetMaterialsInfo() { try { using (StudioDB db = new StudioDB()) { List <MaterialInfoContainer> materialsInfo = new List <MaterialInfoContainer>(); List <MATERIAL> materials = AllMaterials(); foreach (MATERIAL item in materials) { var products = from ps in db.PRODUCT_STRUCTURE join m in db.MATERIALs on ps.id_material equals m.id_material join p in db.PRODUCTs on ps.id_product equals p.id_product where ps.id_material == item.id_material select p; materialsInfo.Add(new MaterialInfoContainer(item, products.ToList())); } return(materialsInfo); } } catch (Exception e) { throw e; } }
public decimal GetTotalSumMonth(int month, int year) { try { using (StudioDB db = new StudioDB()) { var orders = orderS.All(); decimal res = 0; foreach (var item in orders) { if (Parser.ParseStringToIntArray(item.order_date, '.')[1] == month && Parser.ParseStringToIntArray(item.order_date, '.')[2] == year) { res += item.total_sum; } } return(res); } } catch (Exception e) { throw e; } }
/// <summary> /// Уменьшить количество имеющегося материала /// </summary> /// <param name="entity"></param> public void DecreaseMaterialCount(PRODUCT entity) { try { List <MATERIAL> lMaterials; List <PRODUCT_STRUCTURE> lProductStructures; using (StudioDB db = new StudioDB()) { var productStructures = from ps in db.PRODUCT_STRUCTURE where ps.id_product == entity.id_product select ps; lProductStructures = productStructures.ToList(); var materials = from m in db.MATERIALs join ps in db.PRODUCT_STRUCTURE on m.id_material equals ps.id_material where ps.id_product == entity.id_product select m; lMaterials = materials.ToList(); } for (int i = 0; i < lMaterials.Count; i++) { lMaterials[i].count -= lProductStructures[i].count; materialS.Update(lMaterials[i]); } } catch (Exception e) { throw e; } }
/// <summary> /// Select all record from CLIENT table /// </summary> public IEnumerable <CLIENT> SelectAll() { using (StudioDB db = new StudioDB()) { var clientQuery = from cl in db.CLIENTs select cl; return(clientQuery); } }
public List <PRODUCT> All() { try { using (StudioDB db = new StudioDB()) { return(db.PRODUCTs.ToList()); } } catch (Exception e) { throw e; } }
public List <MATERIAL> All() { try { using (StudioDB db = new StudioDB()) { return(db.MATERIALs.ToList()); } } catch (Exception e) { throw e; } }
public List <SUPPLY> All() { try { using (StudioDB db = new StudioDB()) { return(db.SUPPLies.ToList()); } } catch (Exception e) { throw e; } }
public List <ORDER> All() { try { using (StudioDB db = new StudioDB()) { return(db.ORDERs.ToList()); } } catch (Exception e) { throw e; } }
public void Add(CLIENT entity) { try { using (StudioDB db = new StudioDB()) { db.CLIENTs.Add(entity); db.SaveChanges(); } } catch (Exception e) { throw e; } }
public void Add(SUPPLY entity) { try { using (StudioDB db = new StudioDB()) { db.SUPPLies.Add(entity); db.SaveChanges(); } } catch (Exception e) { throw e; } }
public void Add(PRODUCT_STRUCTURE entity) { try { using (StudioDB db = new StudioDB()) { db.PRODUCT_STRUCTURE.Add(entity); db.SaveChanges(); } } catch (Exception e) { throw e; } }
public void Add(PRODUCT entity) { try { using (StudioDB db = new StudioDB()) { db.PRODUCTs.Add(entity); db.SaveChanges(); } } catch (Exception e) { throw e; //ERROR! } }
public void Add(MATERIAL entity) { try { using (StudioDB db = new StudioDB()) { db.MATERIALs.Add(entity); db.SaveChanges(); } } catch (Exception e) { throw e; } }
public List <string> GetColorsList() { try { using (StudioDB db = new StudioDB()) { var tmpList = db.PRODUCTs.Select(x => x.color).Distinct().ToList(); return(tmpList); } } catch (Exception e) { throw e; } }
public List <CLIENT> SearchClientByLogin(string login) { try { using (StudioDB db = new StudioDB()) { var tmpclient = from cl in db.CLIENTs where cl.login == login select cl; return(tmpclient.ToList()); } } catch (Exception ex) { throw ex; } }
public List <PRODUCT> GetSuppliesProducts(SUPPLY entity) { try { using (StudioDB db = new StudioDB()) { var products = from p in db.PRODUCTs where p.id_supply == entity.id_supply select p; return(products.ToList()); } } catch (Exception e) { throw e; } }
public void Update(SUPPLY entity) { try { using (StudioDB db = new StudioDB()) { var obj = from o in db.SUPPLies where o.id_supply == entity.id_supply select o; obj.ToList()[0].delivery_date = entity.delivery_date; db.SaveChanges(); } } catch (Exception e) { throw e; } }
public decimal GetTotalSumMonthSupply(int month, int year) { try { using (StudioDB db = new StudioDB()) { var supplies = supplyS.All(); int idSupply = -1; foreach (var item in supplies) { if (Parser.ParseStringToIntArray(item.delivery_date, '.')[1] == month && Parser.ParseStringToIntArray(item.delivery_date, '.')[2] == year) { idSupply = item.id_supply; } } decimal res = 0; if (idSupply != -1) { var products = db.PRODUCTs.Where(x => x.id_supply == idSupply); foreach (var item in products) { res += DecrementPercentages(item.price, 10) * item.count; } var salesProducts = from b in db.BASKETs join p in db.PRODUCTs on b.id_product equals p.id_product where p.id_supply == idSupply select new { b.count, p.price }; foreach (var item in salesProducts) { res += DecrementPercentages(item.price, 10) * item.count; } } return(res); } } catch (Exception e) { throw e; } }
public void Update(MATERIAL entity) { try { using (StudioDB db = new StudioDB()) { var obj = from o in db.MATERIALs where o.id_material == entity.id_material select o; obj.ToList()[0].name = entity.name; obj.ToList()[0].count = entity.count; db.SaveChanges(); } } catch (Exception e) { throw e; } }
public void Delete(ORDER entity) { try { using (StudioDB db = new StudioDB()) { ORDER order = db.ORDERs. FirstOrDefault(c => c.id_order == entity.id_order); if (order != null) { db.ORDERs.Remove(order); db.SaveChanges(); } } } catch (Exception e) { throw e; } }
public void Update(PRODUCT_STRUCTURE entity) { try { using (StudioDB db = new StudioDB()) { var obj = from o in db.PRODUCT_STRUCTURE where o.id_product_structure == entity.id_product_structure select o; obj.ToList()[0].count = entity.count; obj.ToList()[0].id_material = entity.id_material; obj.ToList()[0].id_product = entity.id_product; db.SaveChanges(); } } catch (Exception e) { throw e; } }
public void Delete(BASKET entity) { try { using (StudioDB db = new StudioDB()) { BASKET basket = db.BASKETs. FirstOrDefault(c => c.id_basket == entity.id_basket); if (basket != null) { db.BASKETs.Remove(basket); db.SaveChanges(); } } } catch (Exception e) { throw e; } }
public void Delete(MATERIAL entity) { try { using (StudioDB db = new StudioDB()) { MATERIAL material = db.MATERIALs. FirstOrDefault(c => c.id_material == entity.id_material); if (material != null) { db.MATERIALs.Remove(material); db.SaveChanges(); } } } catch (Exception e) { throw e; } }
public void Delete(SUPPLY entity) { try { using (StudioDB db = new StudioDB()) { SUPPLY supply = db.SUPPLies. FirstOrDefault(c => c.id_supply == entity.id_supply); if (supply != null) { db.SUPPLies.Remove(supply); db.SaveChanges(); } } } catch (Exception e) { throw e; } }
public void Delete(PRODUCT entity) { try { using (StudioDB db = new StudioDB()) { PRODUCT product = db.PRODUCTs. FirstOrDefault(c => c.id_product == entity.id_product); if (product != null) { db.PRODUCTs.Remove(product); db.SaveChanges(); } } } catch (Exception e) { throw e; } }
public void Delete(CLIENT entity) { try { using (StudioDB db = new StudioDB()) { CLIENT client = db.CLIENTs. FirstOrDefault(c => c.id_client == entity.id_client); if (client != null) { db.CLIENTs.Remove(client); db.SaveChanges(); } } } catch (Exception e) { throw e; } }