public List <UISubCategory> GetUISubCategories(int id = 0) { string query = "SELECT s.Id, s.Name, s.CategoryId, " + "s.Description, c.Name as CategoryName " + "FROM SubCategory s LEFT JOIN Category c ON s.CategoryId = c.ID"; using (CommanderBase commander = DBContext.CreateCommander()) { if (id > 0) { return(commander.Reader <UISubCategory>(query + " WHERE s.Id=" + id)); } return(commander.Reader <UISubCategory>(query)); } }
public List <UIUserRoles> GetUserRoles(int id) { string q = $"select * from UserRole u join Role r on u.RoleId=r.Id Where u.AppUserId={id}"; using (CommanderBase commander = DBContext.CreateCommander()) { var ur = commander.Reader <UIUserRoles>(q); return(ur); } }
public List <UIGames> GetUserGames(int id) { string q = $"select g.*, " + $"u.UserName as AcceptUserName, " + $"u1.UserName as RequestUserName " + $"from Games g " + $"LEFT JOIN AppUser u on u.Id = g.AcceptUser " + $"LEFT JOIN AppUser u1 on u1.Id = g.RequestUser " + $"where g.RequestUser = {id} or g.AcceptUser = {id}"; using (CommanderBase commander = DBContext.CreateCommander()) return(commander.Reader <UIGames>(q)); }
public bool IsUserRole(int userId, int roleId) { string q = $"select * from UserRole u Where u.AppUserId={userId} and u.RoleId={roleId}"; using (CommanderBase commander = DBContext.CreateCommander()) { var ur = commander.Reader <UserRole>(q); if (ur.Count > 0) { return(true); } else { return(false); } } }