//creating an instance of findDoctor table (Model) as a parameter
public bool commitInsert(findDoctor doctor)
{
//to ensure all data will be disposed of when finished
using (objDoctor)
{
//using our model to set table columns to new values being passed and providing it to the insert command
objDoctor.findDoctors.InsertOnSubmit(doctor);
//commit insert with db
objDoctor.SubmitChanges();
return true;
}
}
public ActionResult doctorDelete(int Id, findDoctor doctor)
{
//Selected value will be deleted from the database
try
{
objDoctor.commitDelete(Id);
return RedirectToAction("doctorIndex");
}
catch
{
return View();
}
}
partial void DeletefindDoctor(findDoctor instance);
partial void UpdatefindDoctor(findDoctor instance);
partial void InsertfindDoctor(findDoctor instance);
public ActionResult doctorInsert(findDoctor doctor)
{
if (ModelState.IsValid)
{
try
{
objDoctor.commitInsert(doctor);
return RedirectToAction("doctorIndex"); //On sucessful insert, redirect to the index view
}
catch
{
//Error handling, return to view if something goes wrong
return View();
}
}
return View();
}
public ActionResult doctorUpdate(int Id, findDoctor doctor)
{
//If all the input were valid , then database will be updated
if (ModelState.IsValid)
{
try
{
objDoctor.commitUpdate(Id, doctor.fname, doctor.lname, doctor.speciality, doctor.branch_id, doctor.gender);
return RedirectToAction("doctorIndex");
}
catch
{
return View();
}
}
return View();
}
