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();
}
}
