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;
}
