/// <summary>
/// Get a specific type of plate
/// </summary>
/// <param name="type">a type of plate</param>
/// <returns>a plate</returns>
public Plate GetByType(PlateType type)
{
int id = 0;
switch (type)
{
case PlateType.STARTER:
id = 1;
break;
case PlateType.BOWL:
id = 2;
break;
case PlateType.DINNER:
id = 3;
break;
case PlateType.DESSERT:
id = 4;
break;
}
this.Datas.Clear();
this.Request = this.MapTable.GetByType(id);
this.Datas = this.Bdd.getRows(this.Request, "Plates");
Plate result = this.CreatePlate(this.Datas.Tables["Plates"].Rows[0]);
return(result);
}
/// <summary>
/// Build a plate from datarow
/// </summary>
/// <param name="row">Datarow from request</param>
/// <returns>a plate</returns>
private Plate CreatePlate(DataRow row)
{
Plate plate = new Plate();
plate.Id = int.Parse(row["Id"].ToString());
plate.Name = row["Nom"].ToString();
plate.Quantity = int.Parse(row["Quantite"].ToString());
plate.Type = this.DefineTypePlate(int.Parse(row["TypeAssietteid"].ToString()));
return(plate);
}
/// <summary>
/// Get all the plates availables
/// </summary>
/// <returns></returns>
public override List <RoomMaterial> GetAll()
{
this.Datas.Clear();
this.Request = this.MapTable.GetAll();
this.Datas = this.Bdd.getRows(this.Request, "Plates");
List <RoomMaterial> results = new List <RoomMaterial>();
foreach (DataRow item in this.Datas.Tables["Plates"].Rows)
{
Plate plate = this.CreatePlate(item);
results.Add(plate);
}
return(results);
}