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