public Branches Contains(Branch.Includes includes, string str) { IList <DbParameter> parameters = new List <DbParameter>() { }; string sql = $"select column_name from INFORMATION_SCHEMA.COLUMNS where table_name = 'branches' and column_name not like '%date%'"; DataTable table = _dbContext.GetDataTable(sql, parameters); List <string> st = new List <string>(); for (int i = 0; i < table.Rows.Count; i++) { st.Add(table.Rows[i].ItemArray[0].ToString()); } string strings = " "; for (int i = 1; i < table.Rows.Count - 1; i++) { strings += " or branches." + st[i] + " LIKE '%" + str + "%' "; } sql = GetQueryForMultipleTables(includes) + $" WHERE {Tables.Branches.TableName}.{Tables.Branches.Name.Name} LIKE '%" + str + "%';"; table = _dbContext.GetDataTable(sql, parameters); if (table != null) { return(BranchConverter.TableToBranch(table, includes)); } return(null); }
public Branches GetBranchesByType(int id, Branch.Includes includes) { IList <DbParameter> parameters = new List <DbParameter>() { new MySqlParameter("@id", id) }; string sql = GetQueryForMultipleTables(includes) + $" WHERE {Tables.Branches.TypeId.Name}=@id"; DataTable table = _dbContext.GetDataTable(sql, parameters); if (table != null) { return(BranchConverter.TableToBranch(table, includes)); } return(new Branches()); }
public Branch GetBranchById(int id, Branch.Includes includes) { IList <DbParameter> parameters = new List <DbParameter>() { new MySqlParameter("@id", id) }; string sql = GetQueryForMultipleTables(includes) + $" WHERE {Tables.Branches.TableName}.{Tables.Branches.Id.Name}= @id"; DataTable table = _dbContext.GetDataTable(sql, parameters); if (table != null) { return(BranchConverter.RowToBranch(table.AsEnumerable(), includes)); } return(null); }