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