public string deleteSearch(int person_id)
{
searchClassDataContext objSearchDC = new searchClassDataContext();
using (objSearchDC)
{
var objSearchDel = objSearchDC.search_APIs.Single(x => x.Id == person_id);
objSearchDC.search_APIs.DeleteOnSubmit(objSearchDel);
objSearchDC.SubmitChanges();
return "Your delete was successful";
}
}
public string updateSearch(string fname, string lname, string department, string phone, string email, int person_id)
{
searchClassDataContext objSearchDC = new searchClassDataContext();
using (objSearchDC)
{
var objSearchInstance = objSearchDC.search_APIs.Single(x => x.Id == person_id);
objSearchInstance.fname = fname;
objSearchInstance.lname = lname;
objSearchInstance.department = department;
objSearchInstance.phone = phone;
objSearchInstance.email = email;
objSearchDC.SubmitChanges();
return "Your update was successful";
}
}
public string insertSearch(string fname, string lname, string department, string phone, string email)
{
searchClassDataContext objSearchDC = new searchClassDataContext();
using (objSearchDC)
{
search_API objSearchInsert = new search_API();
objSearchInsert.fname = fname;
objSearchInsert.lname = lname;
objSearchInsert.department = department;
objSearchInsert.phone = phone;
objSearchInsert.email = email;
objSearchDC.search_APIs.InsertOnSubmit(objSearchInsert);
objSearchDC.SubmitChanges();
return "Your insert was successful";
}
}