/// <summary>
///
/// </summary>
/// <param name="group"></param>
/// <param name="number"></param>
public void GetByLetterNumber(Group group, int number)
{
SELECT select = new SELECT(Table);
select.AddWhere(new Column(GroupIDColumnName), Operator.Equals, group.ID, Vendjuuren.SQL.Boolean.AND);
select.AddWhere(new Column(NumberColumnName), Operator.Equals, number, Vendjuuren.SQL.Boolean.AND);
base.GetByStatement(select);
}
/// <summary>
///
/// </summary>
/// <param name="letter"></param>
public void GetByLetter(Letter letter)
{
SELECT select = new SELECT(Table);
select.AddWhere(new Column(LetterColumnName), Operator.Equals, letter, Vendjuuren.SQL.Boolean.AND);
base.GetByStatement(select);
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
public void GetByName(string name)
{
SELECT select = new SELECT(Table);
select.AddWhere(new Column(NameColumnName), Operator.Equals, name, Vendjuuren.SQL.Boolean.AND);
base.GetByStatement(select);
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
public void GetByBrandAndType(Brand brand, string type)
{
SELECT select = new SELECT(Table);
select.AddWhere(new Column(BrandIDColumnName), Operator.Equals, brand.ID, Vendjuuren.SQL.Boolean.AND);
select.AddWhere(new Column(TypeColumnName), Operator.Equals, type, Vendjuuren.SQL.Boolean.AND);
base.GetByStatement(select);
}
/// <summary>
///
/// </summary>
/// <remarks>
/// TODO: 1 algemene method maken
/// </remarks>
/// <param name="id"></param>
public void GetAllByProgramID(Guid id)
{
SELECT select = new SELECT(Table);
select.AddWhere(new Column(ProgramIDColumnName), Operator.Equals, id, Vendjuuren.SQL.Boolean.AND);
base.GetAllByStatement(select);
}