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