Example #1
0
        // 
        // 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);
            }
        }
Example #2
0
        // 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);
            }
        }
Example #3
0
        // 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);
            }
        }
Example #4
0
 // update Category
 public bool updateDSCategoryDB(Category category)
 {
     db = new DatabaseAccess();
     db.DSupdateCategory(category);
     return true;
 }
Example #5
0
 // insert Category
 public bool insertDSCategoryDB(Category category)
 {
     db = new DatabaseAccess();
     db.DSinsertCategory(category);
     return true;
 }
Example #6
0
 // update Category
 public bool updateDAOCategory(Category category)
 {
     db = new DatabaseAccess();
     db.DAOupdateCategory(category);
     return true;
 }
Example #7
0
 public Category makeCategory(int CID, String type, String description)
 {
     Category category = new Category(
         CID,
         type,
         description
     );
     return category;
 }
Example #8
0
 // 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;
 }
Example #9
0
        // 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);
            }
        }