public IEnumerable <MonthlyPayment> GetMonthlyPayments()
{
using (var context = new ShulDataContext(_conStr))
{
return(context.MonthlyPayments.Where(p => p.Count > 0).ToList());
}
}
public void UpdatePledge(int amount, int id)
{
using (var context = new ShulDataContext(_conStr))
{
context.ExecuteCommand("update Pledges set amount = amount-{0} where id = {1}", amount, id);
}
}
public IEnumerable <Message> GetAllMessages()
{
using (var context = new ShulDataContext(_conStr))
{
return(context.Messages.ToList());
}
}
public Expense GetExpenseByExpenseId(int expenseId)
{
using (var context = new ShulDataContext(_conStr))
{
return(context.Expenses.FirstOrDefault(e => e.Id == expenseId));
}
}
public void DeletePledge(int id)
{
using (var context = new ShulDataContext(_conStr))
{
context.ExecuteCommand("Delete from pledges where id = {0}", id);
}
}
public Member GetMember(int id)
{
using (var context = new ShulDataContext(_conStr))
{
return(context.Members.FirstOrDefault(m => m.Id == id));
}
}
public List <Member> GetMembers()
{
using (var context = new ShulDataContext(_conStr))
{
return(context.Members.ToList());
}
}
public void UpdateMonthlyPayment(int id)
{
using (var context = new ShulDataContext(_conStr))
{
context.ExecuteCommand("update monthlypayments set count = count-1 where id = {0}", id);
}
}
public Pledge GetPledge(int id)
{
using (var context = new ShulDataContext(_conStr))
{
return(context.Pledges.FirstOrDefault(p => p.Id == id));
}
}
public Member GetByEmail(string email)
{
using (var context = new ShulDataContext(_conStr))
{
return(context.Members.FirstOrDefault(m => m.Email == email));
}
}
public void AddPledge(Pledge pledge)
{
using (var context = new ShulDataContext(_conStr))
{
context.Pledges.InsertOnSubmit(pledge);
context.SubmitChanges();
}
}
public void AddPayment(Payment payment)
{
using (var context = new ShulDataContext(_conStr))
{
context.Payments.InsertOnSubmit(payment);
context.SubmitChanges();
}
}
public void AddExpense(Expense expense)
{
using (var context = new ShulDataContext(_conStr))
{
context.Expenses.InsertOnSubmit(expense);
context.SubmitChanges();
}
}
public void AddMonthlyPayment(MonthlyPayment mp)
{
using (var context = new ShulDataContext(_conStr))
{
context.MonthlyPayments.InsertOnSubmit(mp);
context.SubmitChanges();
}
}
public void AddMessage(Message message)
{
using (var context = new ShulDataContext(_conStr))
{
context.Messages.InsertOnSubmit(message);
context.SubmitChanges();
}
}
public IEnumerable <Payment> GetPaymentsByMemberId(int memberId)
{
using (var context = new ShulDataContext(_conStr))
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <Payment>(p => p.Expense);
context.LoadOptions = loadOptions;
return(context.Payments.Where(p => p.MemberId == memberId).ToList());
}
}
public IEnumerable <MonthlyPayment> GetMonthlyPaymentsByExpenseId(int id)
{
using (var context = new ShulDataContext(_conStr))
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <MonthlyPayment>(mp => mp.Member);
context.LoadOptions = loadOptions;
return(context.MonthlyPayments.Where(mp => mp.ExpenseId == id).ToList());
}
}
public IEnumerable <Pledge> GetPledgesByExpenseId(int id)
{
using (var context = new ShulDataContext(_conStr))
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <Pledge>(p => p.Member);
context.LoadOptions = loadOptions;
return(context.Pledges.Where(p => p.ExpenseId == id).ToList());
}
}
public List <Expense> GetExpensesWithPaps()
{
using (var context = new ShulDataContext(_conStr))
{
var loadOptions = new DataLoadOptions();
loadOptions.LoadWith <Expense>(e => e.Payments);
loadOptions.LoadWith <Expense>(e => e.Pledges);
context.LoadOptions = loadOptions;
return(context.Expenses.ToList());
}
}
public void SignUp(Member member, string password)
{
string salt = PasswordHelper.GenerateSalt();
string passwordHash = PasswordHelper.HashPassword(password, salt);
member.PasswordSalt = salt;
member.PasswordHash = passwordHash;
using (var context = new ShulDataContext(_conStr))
{
context.Members.InsertOnSubmit(member);
context.SubmitChanges();
}
}
