static public List <clients> GetAll() { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.clients.ToList <clients>()); } }
private void WarehouseOrderDeleteButton_Click(object sender, RoutedEventArgs e) { using (var db = new StudiaProjektBazyDanychEntities()) { WarehouseOrderAccessor.DeleteByID(warehouseOrderSetsList[WarehouseOrderSetsListView.SelectedIndex].OrderId); } }
private void ClientOrderDeleteButton_Click(object sender, RoutedEventArgs e) { using (var db = new StudiaProjektBazyDanychEntities()) { ClientOrdersAccessor.DeleteById(clientOrderSetsList[ClientOrderSetsListView.SelectedIndex].OrderId); } }
static public client_order_sets GetById(int id) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.client_order_sets.SingleOrDefault(t => t.id == id)); } }
static public clients GetByName(string name, string surname) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.clients.SingleOrDefault(t => t.name == name && t.surname == surname)); } }
static public List <client_order_set_view> GetAll() { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.client_order_set_view.ToList <client_order_set_view>()); } }
static public wholesalers GetByName(string companyName) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.wholesalers.SingleOrDefault(t => t.company == companyName)); } }
static public client_order_set_view GetByDateTime(DateTime dateTime) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.client_order_set_view.SingleOrDefault(t => t.order_date == dateTime)); } }
static public List <OrderDataForUI> GetAll() { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.client_order_sets.Select(t => new OrderDataForUI() { OrderId = t.id, OrderDate = (DateTime)t.order_date, ClientId = t.clients.id, ClientName = t.clients.name, ClientSurname = t.clients.surname, ProcessorId = t.processors.id, ProcessorModel = t.processors.model, MotherboardId = t.motherboards.id, MotherboardModel = t.motherboards.model, GraphicCardId = t.graphics_cards.id, RamMemoryId = t.ram_memories.id, RamMemoryModel = t.ram_memories.model, CaseId = t.cases.id, CaseModel = t.cases.model, OrderStatus = t.status }) .ToList()); } }
static public List <client_order_sets> GetClientOrdersWithService() { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.client_order_sets.Where(t => t.services != null && (t.status == (short)ClientOrderStatus.Ordered || t.status == (short)ClientOrderStatus.Reclamated)).ToList()); } }
static public warehouse_orders GetByStatus(short status) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.warehouse_orders.SingleOrDefault(t => t.status == status)); } }
static public List <warehouse_orders> GetAll() { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.warehouse_orders.ToList <warehouse_orders>()); } }
static public warehouse_orders GetByID(int id) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.warehouse_orders.SingleOrDefault(t => t.id == id)); } }
static public Registration GetByActivationCode(string activationCode) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.Registration.SingleOrDefault(t => t.activation_code == activationCode)); } }
static public users GetByUsername(string username) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.users.SingleOrDefault(t => t.username == username)); } }
static public List <users> GetAll() { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.users.ToList()); } }
static public void CreateNew(Registration newRegistration) { using (var db = new StudiaProjektBazyDanychEntities()) { db.Registration.Add(newRegistration); db.SaveChanges(); } }
static public void Create(ram_memories ram) { using (var db = new StudiaProjektBazyDanychEntities()) { db.ram_memories.Add(ram); db.SaveChanges(); } }
static public void CreateNew(graphics_cards newGraphicCard) { using (var db = new StudiaProjektBazyDanychEntities()) { db.graphics_cards.Add(newGraphicCard); db.SaveChanges(); } }
static public void Create(wholesalers wholesaler) { using (var db = new StudiaProjektBazyDanychEntities()) { db.wholesalers.Add(wholesaler); db.SaveChanges(); } }
static public void CreateNew(processors newProcessor) { using (var db = new StudiaProjektBazyDanychEntities()) { db.processors.Add(newProcessor); db.SaveChanges(); } }
static public void CreateNew(clients newClient) { using (var db = new StudiaProjektBazyDanychEntities()) { db.clients.Add(newClient); db.SaveChanges(); } }
static public void CreateNew(services newService) { using (var db = new StudiaProjektBazyDanychEntities()) { db.services.Add(newService); db.SaveChanges(); } }
static public void CreateNew(warehouse_orders order) { using (var db = new StudiaProjektBazyDanychEntities()) { db.warehouse_orders.Add(order); db.SaveChanges(); } }
static public services GetByID(int id) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.services .Where(t => t.client_order_sets.Count == 0) .SingleOrDefault(t => t.id == id)); } }
static public List <services> GetAll() { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.services .Where(t => t.client_order_sets.Count == 0) .ToList <services>()); } }
static public void MarkServiceAsCompletedById(int id) { using (var db = new StudiaProjektBazyDanychEntities()) { var order = db.client_order_sets.SingleOrDefault(t => t.id == id); order.status = (short)ClientOrderStatus.ServiceCompleted; db.SaveChanges(); } }
static public processors GetByModel(string modelName) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.processors .Where(t => t.client_order_sets.Count == 0) .SingleOrDefault(t => t.model == modelName)); } }
static public cases GetByModel(string caseModel) { using (var db = new StudiaProjektBazyDanychEntities()) { return(db.cases .Where(t => t.client_order_sets.Count == 0) .SingleOrDefault(t => t.model.ToString() == caseModel)); } }
static public void DeleteByModel(string modelName) { using (var db = new StudiaProjektBazyDanychEntities()) { var processorToDelete = db.processors.SingleOrDefault(t => t.model == modelName); db.processors.Remove(processorToDelete); db.SaveChanges(); } }