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