// // tab: category // // -- event Using DAO -------------------------- // create button click private void btnDAOCreateC_Click(object sender, EventArgs e) { try { // get input item getInputItem(); // input check CheckCategory(); IsNotRequireCategory(); // make instance category = makeCategoryInstance(); // insert manage.insertDAOCategory(category); MessageBox.Show("New category has been added"); } catch (CanoeException) { } catch (Exception ex) { MessageBox.Show(ex.Message); } }
// Data Source -- update category public bool DSupdateCategory(Category category) { try { // set adapter cta = new canoeDataSetTableAdapters.Canoe_CategoryTableAdapter(); // update cta.UpdateCategoryQuery( category.Type, category.Description, category.CID ); return true; } catch (Exception ex) { throw new CanoeException("DSupdateCategory", ex.Message); } }
// DAO -- update category public bool DAOupdateCategory(Category category) { try { // connect GetConnection(); // update category SqlCommand cmd; cmd = new SqlCommand(updateCategoryQuery, con); cmd.Parameters.AddWithValue("@Type", category.Type); cmd.Parameters.AddWithValue("@Description", category.Description); cmd.Parameters.AddWithValue("@CID", category.CID); cmd.ExecuteScalar(); // close con.Close(); con.Dispose(); cmd.Dispose(); return true; } catch (Exception ex) { throw new CanoeException("DAOupdateCategory", ex.Message); } }
// update Category public bool updateDSCategoryDB(Category category) { db = new DatabaseAccess(); db.DSupdateCategory(category); return true; }
// insert Category public bool insertDSCategoryDB(Category category) { db = new DatabaseAccess(); db.DSinsertCategory(category); return true; }
// update Category public bool updateDAOCategory(Category category) { db = new DatabaseAccess(); db.DAOupdateCategory(category); return true; }
public Category makeCategory(int CID, String type, String description) { Category category = new Category( CID, type, description ); return category; }
// category make instance private Category makeCategoryInstance() { if (cID.Length > 0) { category = manage.makeCategory( int.Parse(cID), type, description); } else { category = manage.makeCategory( type, description); } return category; }
// update button click private void btnDSUpdateC_Click(object sender, EventArgs e) { try { // get input item getInputItem(); // input check CheckCategory(); IsRequireCategory(); // make instance category = makeCategoryInstance(); // update manage.updateDSCategoryDB(category); MessageBox.Show("Category has been updated"); } catch (CanoeException) { } catch (Exception ex) { MessageBox.Show(ex.Message); } }