//creating an instance of volunteer table (Model) as a parameter public bool commitInsert(volunteer vol) { //to ensure all data will be disposed of when finished using (objVol) { //using our model to set table columns to new values being passed and providing it to the insert command objVol.volunteers.InsertOnSubmit(vol); //commit insert with db objVol.SubmitChanges(); return true; } }
public ActionResult VolunteerUpdate(int Id, volunteer vol) { //If all the input were valid , then database will be updated if (ModelState.IsValid) { try { objVol.commitUpdate(Id, vol.position, vol.location, vol.requirement); return RedirectToAction("VolunteerIndex"); } catch { return View(); } } return View(); }
public ActionResult VolunteerInsert(volunteer vol) { if (ModelState.IsValid) { try { objVol.commitInsert(vol); return RedirectToAction("VolunteerIndex"); //On sucessful insert, redirect to the index view } catch { //Error handling, return to view if something goes wrong return View(); } } return View(); }
public ActionResult VolunteerDelete(int Id, volunteer vol) { //Selected value will be deleted from the database try { objVol.commitDelete(Id); return RedirectToAction("VolunteerIndex"); } catch { return View(); } }
partial void Deletevolunteer(volunteer instance);
partial void Updatevolunteer(volunteer instance);
partial void Insertvolunteer(volunteer instance);