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);
}
