static public void Create(wholesalers wholesaler) { using (var db = new StudiaProjektBazyDanychEntities()) { db.wholesalers.Add(wholesaler); db.SaveChanges(); } }
static public void DeleteByName(string companyName) { using (var db = new StudiaProjektBazyDanychEntities()) { wholesalers wholesaler = db.wholesalers.SingleOrDefault(x => x.company == companyName); var entry = db.Entry(wholesaler); if (entry.State == System.Data.Entity.EntityState.Detached) { db.wholesalers.Attach(wholesaler); } db.wholesalers.Remove(wholesaler); db.SaveChanges(); } }
static public void FinalizeOrder(wholesalers localWholesaler, string additionalInformation) { using (var db = new StudiaProjektBazyDanychEntities()) { var DBWholesaler = db.wholesalers.SingleOrDefault(t => t.id == localWholesaler.id); if (LocalOrder.cases != null) { LocalOrder.id_case = LocalOrder.cases.id; //db.cases.SingleOrDefault(t => t.id == LocalOrder.id_case).warehouse_orders.Add(LocalOrder); } if (LocalOrder.graphics_cards != null) { LocalOrder.id_graphics_card = LocalOrder.graphics_cards.id; //db.graphics_cards.SingleOrDefault(t => t.id == LocalOrder.id_graphics_card).warehouse_orders.Add(LocalOrder); } if (LocalOrder.motherboards != null) { LocalOrder.id_motherboard = LocalOrder.motherboards.id; //db.motherboards.SingleOrDefault(t => t.id == LocalOrder.id_motherboard).warehouse_orders.Add(LocalOrder); } if (LocalOrder.processors != null) { LocalOrder.id_processor = LocalOrder.processors.id; //db.processors.SingleOrDefault(t => t.id == LocalOrder.id_processor).warehouse_orders.Add(LocalOrder); } if (LocalOrder.ram_memories != null) { LocalOrder.id_ram_memory = LocalOrder.ram_memories.id; //db.ram_memories.SingleOrDefault(t => t.id == LocalOrder.id_ram_memory).warehouse_orders.Add(LocalOrder); } LocalOrder.id_wholesaler = DBWholesaler.id; LocalOrder.wholesalers = DBWholesaler; LocalOrder.additional_information = additionalInformation; LocalOrder.status = (int)WarehouseOrderStatus.Ordered; LocalOrder.order_date = DateTime.Now; db.warehouse_orders.Add(LocalOrder); db.SaveChanges(); ResetOrder(); } }