public static void Update(Models.Team team)
{
Sql.ExecuteNonQuery(
"Team_Update",
new { team.teamId, team.orgId, team.name, team.description }
);
}
public static void UpdateBoard(Models.Board board)
{
Sql.ExecuteNonQuery(
"Board_Update",
new { board.boardId, board.orgId, board.name, board.color, board.cardtype }
);
}
public static void UpdateSettings(int orgId, int teamId, int groupId)
{
Sql.ExecuteNonQuery(
"Team_UpdateSettings",
new { teamId, orgId, groupId }
);
}
public static void UpdateTeam(Models.Team team)
{
Sql.ExecuteNonQuery(
"Team_Update",
new { team.teamId, team.ownerId, team.security, team.name, team.website, team.description }
);
}
public static void Archive(int listId)
{
Sql.ExecuteNonQuery("List_Archive",
new Dictionary <string, object>()
{
{ "listId", listId }
}
);
}
public static void Delete(string key)
{
Sql.ExecuteNonQuery("GoogleToken_Delete",
new Dictionary <string, object>()
{
{ "key", key }
}
);
}
public static void Move(int boardId, int[] cardIds)
{
Sql.ExecuteNonQuery("List_Move",
new Dictionary <string, object>()
{
{ "boardId", boardId },
{ "ids", string.Join(",", cardIds) }
}
);
}
public static void Delete(int boardId, int cardId)
{
Sql.ExecuteNonQuery("Card_Delete",
new Dictionary <string, object>()
{
{ "boardId", boardId },
{ "cardId", cardId }
}
);
}
public static void UpdateName(int teamId, string name)
{
Sql.ExecuteNonQuery("Team_UpdateName",
new Dictionary <string, object>()
{
{ "teamId", teamId },
{ "name", name }
}
);
}
public static void UpdateEmail(int userId, string email)
{
Sql.ExecuteNonQuery("User_UpdateEmail",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "email", email }
}
);
}
public static void AllColor(int userId, bool allColor)
{
Sql.ExecuteNonQuery("User_AllColor",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "allcolor", allColor }
}
);
}
public static void UpdateStatus(int addressId, bool status)
{
Sql.ExecuteNonQuery("AddressBook_UpdateStatus",
new Dictionary <string, object>()
{
{ "addressId", addressId },
{ "status", status }
}
);
}
public static void UpdateStatus(int subscriptionId, bool status)
{
Sql.ExecuteNonQuery("Subscription_UpdateStatus",
new Dictionary <string, object>()
{
{ "subscriptionId", subscriptionId },
{ "status", status }
}
);
}
public static void UpdateStripeCustomerId(int userId, string customerId)
{
Sql.ExecuteNonQuery("User_UpdateStripeCustomerId",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "customerId", customerId }
}
);
}
public static void UpdateStripePaymentMethodId(int userId, string paymentMethodId)
{
Sql.ExecuteNonQuery("User_UpdateStripePaymentMethod",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "paymentMethodId", paymentMethodId }
}
);
}
public static void UpdateCredentialUserId(int userId, string credentialUserId)
{
Sql.ExecuteNonQuery("User_UpdateCredentialUserId",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "credentialUserId", credentialUserId }
}
);
}
public static void UpdateGoogleUserId(int userId, string googleUserId)
{
Sql.ExecuteNonQuery("User_UpdateGoogleUserId",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "googleUserId", googleUserId }
}
);
}
public static void KeepMenuOpen(int userId, bool keepOpen)
{
Sql.ExecuteNonQuery("User_KeepMenuOpen",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "keepmenu", keepOpen }
}
);
}
public static void Delete(int teamId, int addressId)
{
Sql.ExecuteNonQuery("AddressBook_DeleteEntry",
new Dictionary <string, object>()
{
{ "teamId", teamId },
{ "addressId", addressId }
}
);
}
public static void UpdatePassword(int userId, string password)
{
Sql.ExecuteNonQuery("User_UpdatePassword",
new Dictionary <string, object>()
{
{ "userId", userId },
{ "password", password }
}
);
}
public static void Create(string key, string value)
{
Sql.ExecuteNonQuery("GoogleToken_Create",
new Dictionary <string, object>()
{
{ "key", key },
{ "value", value }
}
);
}
public static void UpdateEmail(int addressId, string email)
{
Sql.ExecuteNonQuery("AddressBook_UpdateEmail",
new Dictionary <string, object>()
{
{ "addressId", addressId },
{ "email", email }
}
);
}
public static void UpdateFullName(int addressId, string firstname, string lastname)
{
Sql.ExecuteNonQuery("AddressBook_UpdateFullName",
new Dictionary <string, object>()
{
{ "addressId", addressId },
{ "firstname", firstname },
{ "lastname", lastname }
}
);
}
public static void Delete(int teamId, int ownerId)
{
Sql.ExecuteNonQuery(
"Team_Delete",
new Dictionary <string, object>()
{
{ "teamId", teamId },
{ "ownerId", ownerId }
}
);
}
public static void UpdateSort(int fieldId, short sort)
{
Sql.ExecuteNonQuery(
"AddressField_UpdateSort",
new Dictionary <string, object>()
{
{ "fieldId", fieldId },
{ "sort", sort }
}
);
}
public static void UpdateName(int boardId, int cardId, string name)
{
Sql.ExecuteNonQuery("Card_UpdateName",
new Dictionary <string, object>()
{
{ "boardId", boardId },
{ "cardId", cardId },
{ "name", name }
}
);
}
public static void UpdateDescription(int boardId, int cardId, string description)
{
Sql.ExecuteNonQuery("Card_UpdateDescription",
new Dictionary <string, object>()
{
{ "boardId", boardId },
{ "cardId", cardId },
{ "description", description }
}
);
}
public static void UpdateLabel(int fieldId, string label)
{
Sql.ExecuteNonQuery(
"AddressField_UpdateLabel",
new Dictionary <string, object>()
{
{ "fieldId", fieldId },
{ "label", label }
}
);
}
public static void Add(int campaignId, int addressId)
{
Sql.ExecuteNonQuery(
"CampaignQueue_Add",
new Dictionary <string, object>()
{
{ "campaignId", campaignId },
{ "addressId", addressId }
}
);
}
public static void Delete(int teamId, string email)
{
Sql.ExecuteNonQuery(
"TeamMember_Delete",
new Dictionary <string, object>()
{
{ "teamId", teamId },
{ "email", email }
}
);
}