public List <Service> GetServicesByOffer(int id) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { return(db.Services.ToList()); } }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { var q = from pd in db.Offers join od in db.OfferServices on pd.Id equals od.OfferId join sd in db.Services on od.ServiceId equals sd.Id orderby pd.Name ascending group new { ServiceId = sd.Id, ServiceName = sd.Name, ServiceMeasure = sd.Measure, ServicePrice = sd.Price, ServiceQuantity = od.Quantity, ServiceAmount = od.Amount } by pd into servicesByOffers select new { OfferId = servicesByOffers.Key.Id, OfferCreated = servicesByOffers.Key.CreatedDate, OfferName = servicesByOffers.Key.Name, OfferDescription = servicesByOffers.Key.Description, OfferTotal = servicesByOffers.Key.Total, Services = servicesByOffers }; offerList.ItemsSource = q.ToList(); } }
public Offer GetOffer(int id) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { return(db.Offers.SingleOrDefault(o => o.Id == id)); } }
public Service GetById(int id) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { return(db.Services.SingleOrDefault(s => s.Id == id)); } }
public List <Service> GetAll() { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { return(db.Services.ToList()); } }
public Offer SaveOffer(Offer record) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { db.Offers.Add(record); db.SaveChanges(); return(record); } }
public void Delete(Service record) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { var service = db.Services.SingleOrDefault(s => s.Id == record.Id); db.Services.Remove(service); db.SaveChanges(); } }
public Service Insert(Service record) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { db.Services.Add(record); db.SaveChanges(); return(record); } }
public void DeleteTask(Task record) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { var task = db.Tasks.FirstOrDefault(t => t.Id == record.Id); db.Tasks.Attach(task); db.Tasks.Remove(task); db.SaveChanges(); } }
public void Update(Service record) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { var service = db.Services.SingleOrDefault(s => s.Id == record.Id); service.Measure = record.Measure; service.Name = record.Name; service.Price = record.Price; db.SaveChanges(); } }
private void BindTasks() { var tasks = new List <Task>(); using (var db = new BM_DatabaseEntities()) { tasks = db.Tasks.ToList(); } _scheduleDataContext.Tasks.Clear(); tasks.ForEach(task => _scheduleDataContext.Tasks.Add(task)); taskList.ItemsSource = tasks; }
public Task SaveTask(Task record) { using (BM_DatabaseEntities db = new BM_DatabaseEntities()) { try { db.Tasks.Add(record); db.SaveChanges(); } catch (DbEntityValidationException ee) { foreach (var error in ee.EntityValidationErrors) { foreach (var thisError in error.ValidationErrors) { var errorMessage = thisError.ErrorMessage; } } } return(record); } }