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