/// <summary>
/// Prepares the foodtype dataprovider.
/// </summary>
public void PrepareFoodTypeDP()
{
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter daFoodType = new RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter())
{
daFoodType.Fill(ds.FOODTYPE);
}
}
/// <summary>
/// Prepares the full dataprovider.
/// </summary>
public void PrepareFullDataProvider()
{
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.RESTAURANTTableAdapter daRestaurant = new RestoBook.Common.Model.DataSetRestoBookTableAdapters.RESTAURANTTableAdapter())
{
daRestaurant.Fill(ds.RESTAURANT);
}
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter daFoodType = new RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter())
{
daFoodType.Fill(ds.FOODTYPE);
}
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.SERVICETableAdapter daService = new RestoBook.Common.Model.DataSetRestoBookTableAdapters.SERVICETableAdapter())
{
daService.Fill(ds.SERVICE);
}
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.OWNERTableAdapter daOwner = new RestoBook.Common.Model.DataSetRestoBookTableAdapters.OWNERTableAdapter())
{
daOwner.Fill(ds.OWNER);
}
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.EMPLOYEETableAdapter daEmployee = new RestoBook.Common.Model.DataSetRestoBookTableAdapters.EMPLOYEETableAdapter())
{
daEmployee.Fill(ds.EMPLOYEE);
}
}
/// <summary>
/// Creates a new Food Type
/// </summary>
/// <param name="ft">The foodtype to insert in the database.</param>
/// <returns>True in case of successful creation, false in case of failure.</returns>
public bool CreateFoodType(FoodType ft)
{
int nbrRowsCreated = -1;
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter daFoodType = new RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter())
{
nbrRowsCreated = daFoodType.Insert(ft.Name, ft.Description, true);
}
return(nbrRowsCreated > 0);
}
/// <summary>
/// Delete a Food Type
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteFoodType(FoodType ft)
{
int nbrRowsDeleted = -1;
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter daFoodType = new RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter())
{
nbrRowsDeleted = daFoodType.Delete(ft.Id, ft.Name, ft.Description, ft.IsEnabled);
}
return(nbrRowsDeleted > 0);
}
/// <summary>
/// Modify a Food Type
/// </summary>
/// <param name="ft"></param>
/// <returns></returns>
public bool ModifyFoodType(FoodType ft)
{
int nbrRowsUpdated = -1;
DataRow row = dp.ds.FOODTYPE.Select("FOODTYPEID = '" + ft.Id + "'").FirstOrDefault();
row["NAME"] = ft.Name;
row["DESCRIPTION"] = ft.Description;
row["ENABLE"] = ft.IsEnabled;
//FoodType foodtype = GetFoodTypeById(ft.Id);
using (RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter daFoodType = new RestoBook.Common.Model.DataSetRestoBookTableAdapters.FOODTYPETableAdapter())
{
nbrRowsUpdated = daFoodType.Update(row);
}
return(nbrRowsUpdated > 0);
}
