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