public Expenditure[] BySessionUrl(string sessionUrl)
{
using (var context = new TrianglesDataContext())
{
return context.Expenditures.Where(x => x.Session.UniqueUrl == sessionUrl).ToArray();
}
}
public Receipt[] BySessionUrl(string sessionUrl)
{
using (var context = new TrianglesDataContext())
{
return context.Receipts.Where(x => x.Session.UniqueUrl == sessionUrl).ToArray();
}
}
public void Insert(ReceiptRecord receiptRecord)
{
using (var context = new TrianglesDataContext())
{
context.ReceiptRecords.InsertOnSubmit(receiptRecord);
context.SubmitChanges();
}
}
public void Save(Session session)
{
using (var context = new TrianglesDataContext())
{
context.Sessions.InsertOnSubmit(session);
context.SubmitChanges();
}
}
public void Insert(Expenditure expenditure)
{
using (var context = new TrianglesDataContext())
{
context.Expenditures.InsertOnSubmit(expenditure);
context.SubmitChanges();
}
}
public void Delete(int receiptRecordId)
{
using (var context = new TrianglesDataContext())
{
var receiptRecordToDelete = context.ReceiptRecords.First(x => x.Id == receiptRecordId);
context.ReceiptRecords.DeleteOnSubmit(receiptRecordToDelete);
context.SubmitChanges();
}
}
public void Delete(int id)
{
using (var context = new TrianglesDataContext())
{
var expenditureToDelete = context.Expenditures.First(x => x.Id == id);
context.Expenditures.DeleteOnSubmit(expenditureToDelete);
context.SubmitChanges();
}
}
public Receipt ById(int receiptId)
{
using (var context = new TrianglesDataContext())
{
var options = new DataLoadOptions();
options.LoadWith<Receipt>(r => r.ReceiptRecords);
context.LoadOptions = options;
return context.Receipts.First(x => x.Id == receiptId);
}
}
public void Update(Receipt receipt)
{
using (var context = new TrianglesDataContext())
{
var existedReceipt = context.Receipts.First(x => x.Id == receipt.Id);
existedReceipt.Description = receipt.Description;
existedReceipt.Payer = receipt.Payer;
context.SubmitChanges();
}
}
public void Update(ReceiptRecord receiptRecord)
{
using (var context = new TrianglesDataContext())
{
var existedReceiptRecord = context.ReceiptRecords.First(x => x.Id == receiptRecord.Id);
existedReceiptRecord.Participant = receiptRecord.Participant;
existedReceiptRecord.Description = receiptRecord.Description;
existedReceiptRecord.Amount = receiptRecord.Amount;
context.SubmitChanges();
}
}
public void Update(Expenditure expenditure)
{
using (var context = new TrianglesDataContext())
{
var existedExpenditure = context.Expenditures.First(x => x.Id == expenditure.Id);
existedExpenditure.Amount = expenditure.Amount;
existedExpenditure.Description = expenditure.Description;
existedExpenditure.Who = expenditure.Who;
context.SubmitChanges();
}
}
public Session GetByUniqueUrl(string sessionUrl)
{
using (var context = new TrianglesDataContext())
{
var options = new DataLoadOptions();
options.LoadWith<Session>(s => s.Expenditures);
options.LoadWith<Session>(s => s.Receipts);
options.LoadWith<Receipt>(r => r.ReceiptRecords);
context.LoadOptions = options;
var session = context.Sessions.FirstOrDefault(x => x.UniqueUrl == sessionUrl);
return session;
}
}
