public void update()
{
Page p = ConvertIntoPageModel();
DataTable dt = ORM.ConvertToDataTable <Page>(p);
DataBase.InsertIntoDB("editpage", dt, "@page");
}
public void Create()
{
this.UserID = EPages.Controllers.epageController.user.UserID;
this.user = EPages.Controllers.epageController.user;
Page page = ConvertIntoPageModel();
DataTable dt = ORM.ConvertToDataTable <Page>(page);
DataBase.InsertIntoDBAndGetID("CreatePage", dt, "@pages");
page.getPageid();
this.Page_ID = page.Page_ID;
}
public void Save()
{
User u = new User()
{
UserID = this.UserID,
FirstName = this.FirstName,
LastName = this.LastName,
Email = this.Email,
UAddress = this.UAddress,
Pass = this.Pass,
CityID = this.CityID,
GenderID = this.GenderID,
Number = this.Number
};
DataTable dt = ORM.ConvertToDataTable <User>(u);
this.UserID = DataBase.InsertInto(@"newuser", dt, @"nuser");
pages = PageViewModel.FetchPages(this.UserID);
}
public void AddItem()
{
DataTable dt = ORM.ConvertToDataTable <PageItemsViewModel>(this);
DataBase.InsertIntoDB("AddnewItem", dt, "@itemtable");
}