public static int GetMax(int bookId)
{
return(Sql.ExecuteScalar <int>("Chapter_GetMax", new Dictionary <string, object>()
{
{ "bookId", bookId }
}));
}
public static int CreateList(Models.List list)
{
return(Sql.ExecuteScalar <int>(
"List_Create",
new { list.boardId, list.name, list.sort, list.cardtype }
));
}
public static bool MemberExists(int userId, int boardId)
{
return(Sql.ExecuteScalar <int>(
"Board_MemberExists",
new { userId, boardId }
) == 1);
}
public static int CreateTeam(Models.Team team)
{
return(Sql.ExecuteScalar <int>(
"Team_Create",
new { team.ownerId, team.security, team.name, team.website, team.description }
));
}
public static int Import(Models.List list, bool merge = false)
{
return(Sql.ExecuteScalar <int>(
"List_Import",
new { list.boardId, list.name, list.sort, merge }
));
}
public static int CreateBoard(Models.Board board, int userId)
{
return(Sql.ExecuteScalar <int>(
"Board_Create",
new { userId, board.teamId, board.favorite, board.name, board.security, board.color }
));
}
public static int Import(Models.Board board, int userId, bool merge = false)
{
return(Sql.ExecuteScalar <int>(
"Board_Import",
new { board.orgId, board.teamId, userId, board.name, board.favorite, board.color, merge }
));
}
public static int CreateUser(Models.User user)
{
return(Sql.ExecuteScalar <int>(
"User_Create",
new { user.name, user.email, user.password, user.photo }
));
}
public static int Create(Models.Team team, int ownerId)
{
return(Sql.ExecuteScalar <int>(
"Team_Create",
new { team.orgId, ownerId, team.name, team.description }
));
}
public static int CreateBoard(Models.Board board, int userId)
{
return(Sql.ExecuteScalar <int>(
"Board_Create",
new { board.orgId, board.teamId, userId, board.name, board.favorite, board.color, board.cardtype }
));
}
public static int TotalEmails(int campaignId)
{
return(Sql.ExecuteScalar <int>("CampaignQueue_TotalEmails",
new Dictionary <string, object>()
{
{ "campaignId", campaignId }
}
));
}
public static string GetPassword(string username)
{
return(Sql.ExecuteScalar <string>("User_GetPassword",
new Dictionary <string, object>()
{
{ "username", username }
}
));
}
public static Models.User GetDetails(int userId)
{
return(Sql.ExecuteScalar <Models.User>("User_GetDetails",
new Dictionary <string, object>()
{
{ "userId", userId }
}
));
}
public static bool HasSubscription(int subscriptionId)
{
return(Sql.ExecuteScalar <int>("InvoiceItems_HasSubscription",
new Dictionary <string, object>()
{
{ "subscriptionId", subscriptionId }
}
) == 1);
}
public static string GetKey(string username)
{
return(Sql.ExecuteScalar <string>("Subscriber_GetKey",
new Dictionary <string, object>()
{
{ "username", username }
}
));
}
public static string GetPassword(string email)
{
return(Sql.ExecuteScalar <string>("User_GetPassword",
new Dictionary <string, object>()
{
{ "email", email }
}
));
}
public static string GetUserName(int subscriberId)
{
return(Sql.ExecuteScalar <string>("Subscriber_GetUserName",
new Dictionary <string, object>()
{
{ "subscriberId", subscriberId }
}
));
}
public static string Get(string key)
{
return(Sql.ExecuteScalar <string>("GoogleToken_GetValue",
new Dictionary <string, object>()
{
{ "key", key }
}
));
}
public static string GetEmail(int userId)
{
return(Sql.ExecuteScalar <string>("User_GetEmail",
new Dictionary <string, object>()
{
{ "userId", userId }
}
));
}
public static string CreateAuthToken(int userId, int expireDays = 30)
{
return(Sql.ExecuteScalar <string>("User_CreateAuthToken",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "expireDays", expireDays }
}
));
}
public static int Create(string eventName, string data)
{
return(Sql.ExecuteScalar <int>("LogStripeWebhooks_Create",
new Dictionary <string, object>()
{
{ "event", eventName },
{ "data", data }
}
));
}
public static Models.CampaignFollowupRule ForCampaign(int campaignId)
{
return(Sql.ExecuteScalar <Models.CampaignFollowupRule>(
"CampaignFollowupRule_ForCampaign",
new Dictionary <string, object>()
{
{ "campaignId", campaignId }
}
));
}
public static Models.CampaignFollowupRule GetInfo(int ruleId)
{
return(Sql.ExecuteScalar <Models.CampaignFollowupRule>(
"CampaignFollowupRule_GetInfo",
new Dictionary <string, object>()
{
{ "ruleId", ruleId }
}
));
}
public static string[] InvitePeople(int invitedBy, int scopeId = 0, Kandu.Models.Scope scope = Kandu.Models.Scope.All, string message = "", List <Models.Xml.Invites.Invite> invites = null)
{
var inviteList = new Models.Xml.Invites()
{
List = invites.ToArray()
};
var errors = Sql.ExecuteScalar <string>("Invite_People_Batch", new { invitedBy, scopeId, scope = (int)scope, message, invites = Common.Serializer.ToXmlDocument(inviteList).OuterXml });
return(string.IsNullOrEmpty(errors) ? new string[] { } : errors.Split(",", StringSplitOptions.RemoveEmptyEntries));
}
public static int CreateSubscriber(Models.Subscriber subscriber)
{
return(Sql.ExecuteScalar <int>(
"Subscriber_Create",
new Dictionary <string, object>()
{
{ "username", subscriber.username },
{ "password", subscriber.password }
}
));
}
public static int Create(int ownerId, string name)
{
return(Sql.ExecuteScalar <int>(
"Team_Create",
new Dictionary <string, object>()
{
{ "ownerId", ownerId },
{ "name", name }
}
));
}
public static string Update(int userId, string key)
{
return(Sql.ExecuteScalar <string>(
"DeveloperKey_Update",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "devkey", key },
}
));
}
public static bool MemberExists(int userId, int boardId)
{
return(Sql.ExecuteScalar <int>(
"Board_MemberExists",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "boardId", boardId }
}
) == 1);
}
public static int Create(int invoiceId, int subscriptionId, decimal price, int quantity)
{
return(Sql.ExecuteScalar <int>("InvoiceItem_Create",
new Dictionary <string, object>()
{
{ "invoiceId", invoiceId },
{ "subscriptionId", subscriptionId },
{ "price", price },
{ "quantity", quantity }
}
));
}
public static int CreateList(Models.List list)
{
return(Sql.ExecuteScalar <int>(
"List_Create",
new Dictionary <string, object>()
{
{ "boardId", list.boardId },
{ "name", list.name },
{ "sort", list.sort }
}
));
}
