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