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