public static bool DeleteClient(int number) { using (var db = new TravelAgencyContext()) { int count = db.Clients.Count(); Client client = null; client = db.Clients.Where(x => x.ClientNumber == number).First(); db.Clients.Remove(client); try { db.SaveChanges(); } catch (DbUpdateException ex) { throw ex; } if (db.Clients.Count() + 1 == count) { return(true); } else { return(false); } } }
public static void UpdateWorker(Worker worker) { using (var db = new TravelAgencyContext()) { db.Entry(worker).State = EntityState.Modified; db.SaveChanges(); } }
public static Worker SelectServiceWorker(Order order) { Worker worker = null; using (var db = new TravelAgencyContext()) { if (db.Orders.Count() > 0) { worker = db.Orders.Where(x => x.OrderNumber == order.OrderNumber).First().ServiceWorker; } } return(worker); }
public static List <Client> SelectClients() { List <Client> list = new List <Client>(); using (var db = new TravelAgencyContext()) { if (db.Clients.Count() > 0) { list = db.Clients.ToList(); } } return(list); }
public static List <Offer> SelectOffers() { List <Offer> list = new List <Offer>(); using (var db = new TravelAgencyContext()) { if (db.Offers.Count() > 0) { list = db.Offers.ToList(); } } return(list); }
public static List <Order> SelectOrders() { List <Order> list = new List <Order>(); using (var db = new TravelAgencyContext()) { if (db.Orders.Count() > 0) { list = db.Orders.Include(x => x.ServiceWorker).ToList(); } } return(list); }
public static Order SelectOrderFromQuery(string query) { Order order = null; using (var db = new TravelAgencyContext()) { if (db.Orders.Count() > 0) { order = db.Orders.SqlQuery(query).ToList().First(); } } return(order); }
public static Client SelectClientFromQuery(string query) { Client client = null; using (var db = new TravelAgencyContext()) { if (db.Clients.Count() > 0) { client = db.Clients.SqlQuery(query).ToList().First(); } } return(client); }
public static bool InsertWorkerOrder(Order order, Worker worker) { using (var db = new TravelAgencyContext()) { int count = db.Workers.Where(x => x.WorkerNumber == worker.WorkerNumber).First().WorkerOrders.Count; db.Workers.Where(x => x.WorkerNumber == worker.WorkerNumber).First().WorkerOrders.Add(order); db.SaveChanges(); if (count + 1 == db.Workers.Where(x => x.WorkerNumber == worker.WorkerNumber).First().WorkerOrders.Count) { return(true); } else { return(false); } } }
public static bool InsertClient(Client client) { using (var db = new TravelAgencyContext()) { int count = db.Clients.Count(); db.Clients.Add(client); db.SaveChanges(); if (count + 1 == db.Clients.Count()) { return(true); } else { return(false); } } }
public static bool InsertOffer(Offer offer) { using (var db = new TravelAgencyContext()) { int count = db.Offers.Count(); db.Offers.Add(offer); db.SaveChanges(); if (count + 1 == db.Offers.Count()) { return(true); } else { return(false); } } }
public static bool InsertOrder(Order order) { using (var db = new TravelAgencyContext()) { int count = db.Orders.Count(); db.Entry(order.ServiceWorker).State = EntityState.Unchanged; db.Orders.Add(order); db.SaveChanges(); if (count + 1 == db.Orders.Count()) { return(true); } else { return(false); } } }
public static List <Order> SelectWorkerOrders(Worker worker) { List <Order> list = new List <Order>(); using (var db = new TravelAgencyContext()) { try { if (db.Workers.Where(x => x.WorkerNumber == worker.WorkerNumber).First().WorkerOrders.Count() > 0) { list = db.Workers.Where(x => x.WorkerNumber == worker.WorkerNumber).First().WorkerOrders.ToList(); } } catch (InvalidOperationException) { return(list); } } return(list); }