public static void Add(int unNbPlaceTablee)
{
Tablee unTablee = new Tablee();;
unTablee.nbPlaceTablee = unNbPlaceTablee;
Tablee.AddTablee(unTablee);
}
/// <summary>
/// maj Table
/// </summary>
/// <returns>indique si l action a reussi</returns>
public static bool UpdateTablee(Tablee TableeToUpdate)
{
bool ok;
using (BDDRestaurantEntities bdd = new BDDRestaurantEntities())
{
try
{
//maj de l'atrticle ds l entitee
Tablee unTablee = bdd.Tablee.Where(x => x.numTablee == TableeToUpdate.numTablee).FirstOrDefault();
unTablee.numTablee = TableeToUpdate.numTablee;
unTablee.nbPlaceTablee = TableeToUpdate.nbPlaceTablee;
//save les modifs dans la base
bdd.SaveChanges();
ok = true;
}
catch (Exception)
{
ok = false;
}
}
return(ok);
}
public static void Delete(int unNumTablee)
{
Tablee unTablee = new Tablee();
unTablee.numTablee = unNumTablee;
Tablee.DeleteTablee(unTablee);
}
public static void Update(int unNumTablee, int unNbPlaceTablee)
{
Tablee unServeur = Tablee.GetInstance(unNumTablee);
unServeur.numTablee = unNumTablee;
unServeur.nbPlaceTablee = unNbPlaceTablee;
Tablee.UpdateTablee(unServeur);
}
public B_Tablee(int unNumTablee, int unNbPlaceTablee)
{
Tablee unTablee = new Tablee();
unTablee.numTablee = unNumTablee;
unTablee.numTablee = unNbPlaceTablee;
Tablee.AddTablee(unTablee);
}
/// <summary>
/// recup un Table a partir de son numéro
/// </summary>
/// <param name="unIDTablee">id de la Table recherché</param>
/// <returns></returns>
public static Tablee GetInstance(int unIdTablee)
{
Tablee unTablee;
using (BDDRestaurantEntities bdd = new BDDRestaurantEntities())
{
try
{
unTablee = bdd.Tablee.Where(x => x.numTablee == unIdTablee).FirstOrDefault();
}
catch (Exception)
{
unTablee = new Tablee();
}
}
return(unTablee);
}
/// <summary>
/// ajoute une Table
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static bool AddTablee(Tablee Tablee)
{
bool ok;
using (BDDRestaurantEntities bdd = new BDDRestaurantEntities())
{
try
{
//ajoute le user a l entitee
bdd.Tablee.Add(Tablee);
//save les modifs dans la base
bdd.SaveChanges();
ok = true;
}
catch (Exception)
{
ok = false;
}
}
return(ok);
}
