public IQueryable<donation> getDonation() { donationDataContext objDonateDC = new donationDataContext(); var allDonations = objDonateDC.donations.Select(x => x); return allDonations; }
public IQueryable<donation> getDonationByID(int _id) { donationDataContext objDonateDC = new donationDataContext(); var allDonations = objDonateDC.donations.Where(x => x.Id == _id).Select(x => x); return allDonations; }
public bool commitDelete(int _id) { donationDataContext objDonateDC = new donationDataContext(); using (objDonateDC) { var objDelDonate = objDonateDC.donations.Single(x => x.Id == _id); objDonateDC.donations.DeleteOnSubmit(objDelDonate); objDonateDC.SubmitChanges(); return true; } }
public bool commitInsert(string _firstname, string _lastname, string _email, string _message) { donationDataContext objDonateDC = new donationDataContext(); using (objDonateDC) { donation objDonate = new donation(); objDonate.firstname = _firstname; objDonate.lastname = _lastname; objDonate.email = _email; objDonate.message = _message; objDonateDC.donations.InsertOnSubmit(objDonate); objDonateDC.SubmitChanges(); return true; } }
public bool commitUpdate(int _id, string _firstname, string _lastname, string _email, string _message) { donationDataContext objDonateDC = new donationDataContext(); using (objDonateDC) { var objUpDonate = objDonateDC.donations.Single(x => x.Id == _id); objUpDonate.firstname = _firstname; objUpDonate.lastname = _lastname; objUpDonate.email = _email; objUpDonate.message = _message; objDonateDC.SubmitChanges(); return true; } }