public void DeletePledge(int id)
{
using (var context = new ShulDataContext(_conStr))
{
context.ExecuteCommand("Delete from pledges where id = {0}", id);
}
}
public void UpdateMonthlyPayment(int id)
{
using (var context = new ShulDataContext(_conStr))
{
context.ExecuteCommand("update monthlypayments set count = count-1 where id = {0}", id);
}
}
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);
}
}
