public string GetPassword(string email) { return(Sql.ExecuteScalar <string>("User_GetPassword", new Dictionary <string, object>() { { "email", email } } )); }
public string GetEmail(int userId) { return(Sql.ExecuteScalar <string>("User_GetEmail", new Dictionary <string, object>() { { "userId", userId } } )); }
public string CreateAuthToken(int userId, int expireDays = 30) { return(Sql.ExecuteScalar <string>("User_CreateAuthToken", new Dictionary <string, object>() { { "userId", userId }, { "expireDays", expireDays } } )); }
public bool MemberExists(int userId, int boardId) { return(Sql.ExecuteScalar <int>( "Board_MemberExists", new Dictionary <string, object>() { { "userId", userId }, { "boardId", boardId } } ) == 1); }
public int CreateList(Models.List list) { return(Sql.ExecuteScalar <int>( "List_Create", new Dictionary <string, object>() { { "boardId", list.boardId }, { "name", list.name }, { "sort", list.sort } } )); }
public int Import(Models.List list, bool merge = false) { return(Sql.ExecuteScalar <int>( "List_Import", new Dictionary <string, object>() { { "boardId", list.boardId }, { "name", list.name }, { "sort", list.sort }, { "merge", merge } } )); }
public int CreateUser(Models.User user) { return(Sql.ExecuteScalar <int>( "User_Create", new Dictionary <string, object>() { { "name", user.name }, { "email", user.email }, { "password", user.password }, { "photo", user.photo } } )); }
public int CreateTeam(Models.Team team) { return(Sql.ExecuteScalar <int>( "Team_Create", new Dictionary <string, object>() { { "ownerId", team.ownerId }, { "security", team.security }, { "name", team.name }, { "website", team.website }, { "description", team.description } } )); }
public int CreateBoard(Models.Board board, int userId) { return(Sql.ExecuteScalar <int>( "Board_Create", new Dictionary <string, object>() { { "userId", userId }, { "teamId", board.teamId }, { "favorite", board.favorite }, { "name", board.name }, { "security", board.security }, { "color", board.color } } )); }
public int Create(Models.Card card) { return(Sql.ExecuteScalar <int>( "Card_Create", new Dictionary <string, object>() { { "listId", card.listId }, { "boardId", card.boardId }, { "colors", card.colors }, { "name", card.name }, { "datedue", card.datedue == null ? DateTime.Now.AddYears(-100) : card.datedue }, { "description", card.description } } )); }
public int Import(Models.Board board, int userId, bool merge = false) { return(Sql.ExecuteScalar <int>( "Board_Import", new Dictionary <string, object>() { { "userId", userId }, { "teamId", board.teamId }, { "favorite", board.favorite }, { "name", board.name }, { "security", board.security }, { "color", board.color }, { "merge", merge } } )); }
public int Import(Models.Card card, bool merge = false) { return(Sql.ExecuteScalar <int>( "Card_Import", new Dictionary <string, object>() { { "listId", card.listId }, { "boardId", card.boardId }, { "colors", card.colors }, { "name", card.name }, { "datedue", card.datedue == null ? DateTime.Now.AddYears(-100) : card.datedue }, { "description", card.description }, { "merge", merge } } )); }
public bool HasAdmin() { return(Sql.ExecuteScalar <int>("Users_HasAdmin") == 1); }
public bool HasPasswords() { return(Sql.ExecuteScalar <int>("Users_HasPasswords") == 1); }