public override PagedResultFilter Adapt(MEPSearchModel source) { var gridExtraFilter = FilterAdapter.Adapt(source.ExtraFilter); CombinedGroup.Conditions[0].Group = gridExtraFilter == null ? null : gridExtraFilter.Group; AddGenericCondition(FieldType.String, "Description", source.Description); AddGenericCondition(FieldType.QuotedList, "Status", source.Status); AddGenericCondition(FieldType.String, "Name", source.Name); AddGenericCondition(FieldType.String, "SerialNumber", source.SerialNumber); AddGenericCondition(FieldType.QuotedList, "TimeZone", source.TimeZone); AddGenericCondition(FieldType.DateTime, "InstallationDateTime", source.InstallationDate); return(new PagedResultFilter { Group = CombinedGroup, PageIndex = source.Page, PageSize = source.Rows, SortFieldName = source.OrderBy, SortType = source.OrderDirection.ToLower() == "asc" ? SortType.Ascending : source.OrderDirection.ToLower() == "desc" ? SortType.Descending : (SortType?)null }); }
public string Delete(string Json) { try { string TableName = JsonAdapter.TableNameFromJson(Json); List <Packet> packets = PackageAdapter.PacketsFromJson(Json); string Condition = FilterAdapter.GetCondition(TableName, packets.ToArray()); string sql = $"DELETE FROM \"{TableName}\" WHERE {Condition}"; return(JsonAdapter.ResultToJson(NpgController.InvokeQuery(sql))); } catch (Exception ex) { return(new JObject().AddStatus(ex).ToString()); } }
public ApiAdapter(IDataBaseManagerFactory dbEngine, string address, string port, string table, string login, string password) { DbManager = new DatabaseManager(dbEngine, address, port, table, login, password); DbConnector = new DbConnector(DbManager); LanguageAdapter = new LanguageAdapter(DbConnector); UserAdapter = new UserAdapter(DbConnector); UserDetailsAdapter = new UserDetailsAdapter(DbConnector); TransactionTypeAdapter = new TransactionTypeAdapter(DbConnector); TransferTypeAdapter = new TransferTypeAdapter(DbConnector); FrequencyAdapter = new FrequencyAdapter(DbConnector); ImportanceAdapter = new ImportanceAdapter(DbConnector); TagAdapter = new TagAdapter(DbConnector); OperationAdapter = new OperationAdapter(DbConnector); OperationDetailsAdapter = new OperationDetailsAdapter(DbConnector); OperationTagRelationAdapter = new OperationTagAdapter(DbConnector); OperationsGroupAdapter = new OperationsGroupAdapter(DbConnector); OperationsGroupRelationAdapter = new OperationsGroupTagAdapter(DbConnector); FilterAdapter = new FilterAdapter(DbConnector); DashboardAdapter = new DashboardAdapter(DbConnector); DashboardFilterRelationAdapter = new DashboardFilterRelationAdapter(DbConnector); BankAdapter = new BankAdapter(DbConnector); SettingsAdapter = new SettingsAdapter(DbConnector); SchematicTypeAdapter = new SchematicTypeAdapter(DbConnector); SchematicAdapter = new SchematicAdapter(DbConnector); LanguageMapper = new LanguageMapper(); UserMapper = new UserMapper(); UserDetailsMapper = new UserDetailsMapper(); TransactionTypeMapper = new TransactionTypeMapper(); TransferTypeMapper = new TransferTypeMapper(); FrequencyMapper = new FrequencyMapper(); ImportanceMapper = new ImportanceMapper(); TagMapper = new TagMapper(); TagRelationMapper = new RelationTagMapper(); OperationMapper = new OperationMapper(); OperationsGroupMapper = new OperationsGroupMapper(); FilterMapper = new FilterMapper(); DashboardMapper = new DashboardMapper(); DashboardFilterMapper = new DashboardFilterMapper(); BankMapper = new BankMapper(); SettingsMapper = new SettingsMapper(); SchematicTypeMapper = new SchematicTypeMapper(); SchematicMapper = new SchematicMapper(); }
public string Update(string Json) { try { string TableName = JsonAdapter.TableNameFromJson(Json); List <Packet> packets = PackageAdapter.PacketsFromJson(Json); string Condition = FilterAdapter.GetCondition(TableName, packets.ToArray()); List <UpdatePacket> updatePackets = SetConverter.FromJson(Json); string Sets = RowCollector.Set(updatePackets); string Sql = $"UPDATE \"{TableName}\" {Sets} WHERE {Condition}"; return(JsonAdapter.ResultToJson(NpgController.InvokeQuery(Sql))); } catch (Exception ex) { return(new JObject().AddStatus(ex).ToString()); } }
public string Adapt(string Json) { string MainTable = JsonAdapter.TableNameFromJson(Json); string TableName = ""; List <Packet> packets = PackageAdapter.PacketsONFromJson(Json); PackageAdapter.Normalize(ref packets); packets = SetTableName(MainTable, packets.ToArray()); try { TableName = $"{GetTableNameFromPackets(packets.ToArray())}"; } catch (Exception ex) { throw ex; } string condition = new FilterAdapter().GetOnCondition(TableName, packets.ToArray()); string Sql = $"INNER JOIN {TableName} ON {condition}"; return(Sql); }
public string Where(string Json) { Validators.CheckPackets check = new Validators.CheckPackets(); try { LimitPacket limitPacket = GetLimit(ref Json); string limit = limitPacket == null ? "" : $" {LimitAdapter.AdaptToSql(limitPacket)}"; OrderByPacket orderByPacket = GetOrderBy(ref Json); string OrderBy = orderByPacket == null ? "" : $" {OrderByAdapter.ToSql(orderByPacket)}"; if (check.CheckJoin(Json)) { string Condition = ""; Joining.JoinAdapter adapter = new Joining.JoinAdapter(); string TableName = JsonAdapter.TableNameFromJson(Json); if (check.CheckPacket(Json)) { List <Packet> packets = PackageAdapter.PacketsFromJson(Json); PackageAdapter.Normalize(ref packets); Condition = $"WHERE {FilterAdapter.GetCondition(TableName, packets.ToArray())}"; } string JoinCondition = adapter.Adapt(Json); string sql = $"SELECT * FROM \"{TableName}\" {JoinCondition} {Condition}{OrderBy}{limit}"; return(JsonAdapter.ResultToJson(NpgController.InvokeQuery(sql))); } else { string TableName = JsonAdapter.TableNameFromJson(Json); List <Packet> packets = PackageAdapter.PacketsFromJson(Json); string Condition = FilterAdapter.GetCondition(TableName, packets.ToArray()); string sql = $"SELECT * FROM \"{TableName}\" WHERE {Condition}{OrderBy}{limit}"; return(JsonAdapter.ResultToJson(NpgController.InvokeQuery(sql))); } } catch (Exception ex) { return(new JObject().AddStatus(ex).ToString()); } }
public List <ApiFilter> GetFilters(ApiUser user) { FilterMapper.Update(user); return(FilterMapper.ConvertToApiEntitiesCollection(FilterAdapter.GetAll($"user_id={user.Id}")).ToList()); }
public bool DeleteFilter(int id) { FilterAdapter.Delete(id); return(true); }