public int addCatogory(string catogoryName)
        {
            try
            {
                DTO_Catogory dto_catogory = new DTO_Catogory();

                dto_catogory.CatogoryId   = dal_catogory.increment();
                dto_catogory.CatogoryName = catogoryName;

                return(dal_catogory.addCatogory(dto_catogory) == true ? 200 : 400);
            }
            catch
            {
                return(400);
            }
        }
        public int editCatogory(long catogoryId, string catogoryName)
        {
            try
            {
                DTO_Catogory dto_catogory = new DTO_Catogory();

                dto_catogory.CatogoryId   = catogoryId;
                dto_catogory.CatogoryName = catogoryName;

                return(dal_catogory.editCatogory(dto_catogory) == true ? 200 : 400);
            }
            catch
            {
                return(400);
            }
        }
 public bool editCatogory(DTO_Catogory dto_catogory)
 {
     try
     {
         openConnect();
         SqlCommand cmd = new SqlCommand("stp_editCatogory", conn); //Tên store procedure
         cmd.CommandType = CommandType.StoredProcedure;             //Cho biết đây là store procedure
         cmd.Parameters.AddWithValue("@madm", dto_catogory.CatogoryId);
         cmd.Parameters.AddWithValue("@tendm", dto_catogory.CatogoryName);
         cmd.ExecuteNonQuery();
         closeConnect(); //Đóng kết nối
         return(true);
     }
     catch
     {
         closeConnect();
         return(false);
     }
 }