protected void SetRelative(int[] contactID, EntityType entityType, int entityID) { using (var db = GetDb()) using (var tx = db.BeginTransaction()) { var sqlDelete = new SqlDelete("crm_entity_contact"); if (entityID == 0) { throw new ArgumentException(); } sqlDelete.Where(Exp.Eq("entity_type", entityType) & Exp.Eq("entity_id", entityID)); db.ExecuteNonQuery(sqlDelete); if (!(contactID == null || contactID.Length == 0)) { foreach (var id in contactID) { SetRelative(id, entityType, entityID, db); } } tx.Commit(); } }
public void DeleteTagFromEntity(EntityType entityType, int entityID, String tagName) { var tagID = Db.ExecuteScalar <int>(Query("crm_tag").Select("id") .Where(Exp.Eq("trim(lower(title))", tagName.Trim().ToLower()) & Exp.Eq("entity_type", (int)entityType))); if (tagID == 0) { return; } var sqlQuery = new SqlDelete("crm_entity_tag") .Where(Exp.Eq("entity_type", (int)entityType) & Exp.Eq("tag_id", tagID)); if (entityID > 0) { sqlQuery.Where(Exp.Eq("entity_id", entityID)); } Db.ExecuteNonQuery(sqlQuery); if (entityID == 0) { Db.ExecuteNonQuery(Delete("crm_tag") .Where(Exp.Eq("id", tagID) & Exp.Eq("entity_type", (int)entityType))); } }
public void Where(SqlDelete sql, T item) { IEnumerable <KeyValuePair <DbColumnAttribute, PropertyInfo> > keyed = _mappedColumn.Where(x => x.Key.IsKey || x.Key.IsIdentity); InvokeAction(keyed, (name, value) => sql.Where(name, value), item); }
protected void RemoveRelativeInDb(int[] contactID, EntityType entityType, int[] entityID) { if ((contactID == null || contactID.Length == 0) && (entityID == null || entityID.Length == 0)) throw new ArgumentException(); var sqlQuery = new SqlDelete("crm_entity_contact"); if (contactID != null && contactID.Length > 0) sqlQuery.Where(Exp.In("contact_id", contactID)); if (entityID != null && entityID.Length > 0) sqlQuery.Where(Exp.In("entity_id", entityID) & Exp.Eq("entity_type", (int)entityType)); Db.ExecuteNonQuery(sqlQuery); }
public void RemoveProvider(string obj, string provider = null, string hashId = null) { var sql = new SqlDelete("account_links").Where("id", obj); if (!string.IsNullOrEmpty(provider)) { sql.Where("provider", provider); } if (!string.IsNullOrEmpty(hashId)) { sql.Where("uid", hashId); } var db = DbOptions.Get(DbId); db.ExecuteScalar <int>(sql); AccountLinkerStorage.RemoveFromCache(obj); }
public int Remove(int?mailId = null, uint?folderId = null) { var query = new SqlDelete(UserFoldertXMailTable.TABLE_NAME) .Where(UserFoldertXMailTable.Columns.Tenant, Tenant) .Where(UserFoldertXMailTable.Columns.User, CurrentUserId); if (mailId.HasValue) { query.Where(UserFoldertXMailTable.Columns.MailId, mailId.Value); } if (folderId.HasValue) { query.Where(UserFoldertXMailTable.Columns.FolderId, folderId.Value); } var result = Db.ExecuteNonQuery(query); return(result); }
private static SqlDelete ApplyFilter(this SqlDelete query, MailFilter filter, string alias, bool skipFolder) { var conditions = GetMailFilterConditions(filter, skipFolder, alias); if (conditions != null) { query.Where(conditions); } return(query); }
public void RemoveProvider(string obj, string provider = null, string hashId = null) { CacheEntry.Reset(obj); var sql = new SqlDelete(LinkTable).Where("id", obj); if (!string.IsNullOrEmpty(provider)) { sql.Where("provider", provider); } if (!string.IsNullOrEmpty(hashId)) { sql.Where("uid", hashId); } using (var db = new DbManager(_dbid)) { db.ExecuteScalar <int>(sql); } }
public void RemoveProvider(string obj, string provider = null, string hashId = null) { var sql = new SqlDelete("account_links").Where("id", obj); if (!string.IsNullOrEmpty(provider)) { sql.Where("provider", provider); } if (!string.IsNullOrEmpty(hashId)) { sql.Where("uid", hashId); } using (var db = new DbManager(dbid)) { db.ExecuteScalar <int>(sql); } notify.Publish(new LinkerCacheItem { Obj = obj }, CacheNotifyAction.Remove); }
protected void RemoveRelative(int[] contactID, EntityType entityType, int[] entityID) { if (contactID != null && contactID.Length == 0 && entityID != null && entityID.Length == 0) { throw new ArgumentException(); } var sqlQuery = new SqlDelete("crm_entity_contact"); if (contactID != null && contactID.Length > 0) { sqlQuery.Where(Exp.In("contact_id", contactID)); } if (entityID != null && entityID.Length > 0) { sqlQuery.Where(Exp.In("entity_id", entityID) & Exp.Eq("entity_type", (int)entityType)); } DbManager.ExecuteNonQuery(sqlQuery); }
public int Delete(int tagId, string email = null) { var query = new SqlDelete(TagAddressTable.TABLE_NAME) .Where(TagAddressTable.Columns.TagId, tagId) .Where(TagAddressTable.Columns.Tenant, Tenant); if (!string.IsNullOrEmpty(email)) { query.Where(TagAddressTable.Columns.Address, email); } var result = Db.ExecuteNonQuery(query); return(result); }
public void Where(SqlDelete sql, params object[] keys) { InvokeAction(_mappedColumn, (name, value) => sql.Where(name, value), keys); }