public string[] GetAllPageNames()
{
SQL.Select(PageTableName).SelectColumn("PageName").Complete().Execute(out DataTable table);
List <string> pages = new List <string>();
if (table != null)
{
foreach (DataRow row in table.Rows)
{
pages.Add(SQLConvert.ToString(row["PageName"]));
}
}
return(pages.ToArray());
}
public string Login(string user, string password)
{
SQL.Select(UserTableName).SelectAll().Where().Column("User").EqualsValue(user)
.Complete().Execute(out DataTable table);
if (table == null || table.Rows.Count == 0)
{
throw new CustomException("Please register first!!");
}
if (password != SQLConvert.ToString(table.Rows[0]["Password"]))
{
throw new CustomException("Wrong password!!");
}
return(SQLConvert.ToString(table.Rows[0]["Idx"]));
}
public string[] GetAllowedPages(int userIdx)
{
SQL.Select(AuthorityTableName).SelectColumn("Pages.PageName").LeftJoin("PageIdx", PageTableName, "Idx")
.Where().Column("UserIdx").EqualsValue(userIdx).Complete().Execute(out DataTable table);
List <string> allowedPages = new List <string>();
if (table != null)
{
foreach (DataRow row in table.Rows)
{
allowedPages.Add(SQLConvert.ToString(row["PageName"]));
}
}
return(allowedPages.ToArray());
}
public User GetAuthority(string userIdx)
{
User userResult = new User();
userResult.UserName = userIdx;
SQL.Select(AuthorityTableName).SelectColumn($"{PageTableName}.PageName").InnerJoin("PageIdx", PageTableName, "Idx")
.Where().Column("UserIdx").EqualsValue(userIdx)
.Complete().Execute(out DataTable table);
userResult.PageNames = new List <string>();
if (table != null)
{
foreach (DataRow row in table.Rows)
{
userResult.PageNames.Add(SQLConvert.ToString(row["PageName"]));
}
}
return(userResult);
}
