public IQueryable<page> getPages() { //create an insteance of the data context class called ObjPageDC pagesDataContext objPageDC = new pagesDataContext(); //creating anonymous variable with value being instance of LINQ object var allPages = objPageDC.pages.Select(x => x); //return IQueryable<product> for databound control to bind to return allPages; }
public bool commitDelete(int _id) { pagesDataContext objPageDC = new pagesDataContext(); using (objPageDC) { var objDelPage = objPageDC.pages.Single(x => x.id == _id); //delete command objPageDC.pages.DeleteOnSubmit(objDelPage); //commit delete aginst db objPageDC.SubmitChanges(); return true; } }
public bool commitUpdate(int _id, int _subject_id, string _menu_name, string _title, string _content) { pagesDataContext objPageDC = new pagesDataContext(); using (objPageDC) { var objUpPage = objPageDC.pages.Single(x => x.id == _id); objUpPage.subject_id = _subject_id; objUpPage.menu_name = _menu_name; objUpPage.title = _title; objUpPage.page_content = _content; //commit update against db objPageDC.SubmitChanges(); return true; } }
public bool commitInsert(int _subject_id, string _menu_name, string _title, string _content) { pagesDataContext objPageDC = new pagesDataContext(); //to ensure all data will be disposed when finished using (objPageDC) { //create an instance of the table page objNewPage = new page(); //set table column to new values being passed from *.aspx page objNewPage.subject_id = _subject_id; objNewPage.menu_name = _menu_name; objNewPage.title = _title; objNewPage.page_content = _content; //insert command objPageDC.pages.InsertOnSubmit(objNewPage); //commit insert against db objPageDC.SubmitChanges(); return true; } }
public IQueryable<page> getPageByID(int _id) { pagesDataContext objPageDC = new pagesDataContext(); var allpages = objPageDC.pages.Where(x => x.id == _id).Select(x => x); return allpages; }