public static String GetDefaultPagePath( Guid userGuid, SiteSettings siteSettings, String defaultFirstPageName, String deafaultFirstPagePath) { String result = String.Empty; int countOfPages = 0; using (IDataReader reader = DBUserPage.SelectByUser(userGuid)) { while ((reader.Read()) && (countOfPages < 1)) { result = reader["PagePath"].ToString(); result += 1; } } if (result == String.Empty) { UserPage userPage = new UserPage(); userPage.SiteId = siteSettings.SiteId; userPage.SiteGuid = siteSettings.SiteGuid; userPage.UserGuid = userGuid; userPage.PageName = defaultFirstPageName; userPage.PagePath = deafaultFirstPagePath; userPage.PageOrder = 1; userPage.Save(); result = deafaultFirstPagePath; } return(result); }
private bool Update() { return(DBUserPage.UpdateUserPage( this.userPageID, this.pageName, this.pageOrder)); }
public static int GetCountByUser(Guid userGuid) { int result = 0; using (IDataReader reader = DBUserPage.SelectByUser(userGuid)) { while (reader.Read()) { result += 1; } } return(result); }
private void GetUserPage(Guid userPageId) { using (IDataReader reader = DBUserPage.GetUserPage(userPageId)) { if (reader.Read()) { this.userPageID = new Guid(reader["UserPageID"].ToString()); this.siteGuid = new Guid(reader["SiteGuid"].ToString()); this.siteID = Convert.ToInt32(reader["SiteID"]); this.userGuid = new Guid(reader["UserGuid"].ToString()); this.pageName = reader["PageName"].ToString(); this.pagePath = reader["PagePath"].ToString(); this.pageOrder = Convert.ToInt32(reader["PageOrder"]); } } }
private bool Create() { Guid newID = Guid.NewGuid(); this.userPageID = newID; int rowsAffected = DBUserPage.AddUserPage( this.userPageID, this.siteGuid, this.siteID, this.userGuid, this.pageName, this.pagePath, this.pageOrder); return(rowsAffected > 0); }
public static bool DeleteUserPage(Guid userPageId) { return(DBUserPage.DeleteUserPage(userPageId)); }
public static bool UpdatePageOrder(Guid userPageId, int pageOrder) { return(DBUserPage.UpdatePageOrder(userPageId, pageOrder)); }
public static int GetNextPageOrder(Guid userGuid) { return(DBUserPage.GetNextPageOrder(userGuid)); }
public static IDataReader SelectByUser(Guid userGuid) { return(DBUserPage.SelectByUser(userGuid)); }
public static bool DeleteByUser(Guid userGuid) { return(DBUserPage.DeleteByUser(userGuid)); }