public List <BranchExam> GetExams()
{
IList <DbParameter> parameters = new List <DbParameter>()
{
};
string sql = $"SELECT * FROM {Tables.BranchExams.TableName}";
DataTable table = _dbContext.GetDataTable(sql, parameters);
if (table != null)
{
return(BranchExamConverter.TableToBranchExam(table));
}
return(new List <BranchExam>());
}
public List <BranchExam> GetBranchExamsByBranchId(int id)
{
IList <DbParameter> parameters = new List <DbParameter>()
{
new MySqlParameter("@id", id)
};
string sql = $"SELECT * FROM {Tables.BranchExams.TableName} WHERE {Tables.BranchExams.BranchId.Name}=@id";
DataTable table = _dbContext.GetDataTable(sql, parameters);
if (table != null)
{
return(BranchExamConverter.TableToBranchExam(table));
}
return(new List <BranchExam>());
}
