public bool Delete(ProductTypeProvider provider) { bool isDelete = false; try { SqlCommand command = new SqlCommand(); this.ConnectionOpen(); command.Connection = Connection; this.BeginTransaction(true); command.Transaction = this.Transaction; command.CommandType = CommandType.StoredProcedure; command.CommandText = StoredProcedureNames.ProductTypeSet; command.Parameters.Add("@ID", SqlDbType.Int).Value = provider.ID; command.Parameters.Add("@Option", SqlDbType.Int).Value = DBConstants.DataModificationOption.Delete; command.ExecuteNonQuery(); this.CommitTransaction(); this.ConnectionClosed(); isDelete = true; } catch (Exception exp) { this.RollbackTransaction(); throw new Exception(exp.Message); } finally { this.ConnectionClosed(); } return(isDelete); }
public MainForm(UserModel loggedUser) { InitializeComponent(); this.loggedUser = loggedUser; productProvider = new ProductProvider(); imageHelper = new ImageHelper(new CloudHelper()); productTypeProvider = new ProductTypeProvider(); ingredientProvider = new IngredientProvider(); dishProvider = new DishProvider(); //Common Font for all Labels in the forms commonFont = new Font("Berlin Sans FB", 14F); //Common Table Padding without horisontal ScrollBar commonTablePadding = new Padding(0, 0, SystemInformation.VerticalScrollBarWidth, 0); }
public ProductTypesController(ProductTypeProvider productTypeProvider) { this.productTypeProvider = productTypeProvider; }