Пример #1
0
        public int Update(Differenced diff)
        {
            string query  = "Update_Differenced @id , @diff_name , @val_id , @status , @date_create ";
            int    result = DataProvider.Instance.ExecuteNonQuery(query, new object[] { diff.diff_id, diff.diff_name, diff.val_id, diff.status, diff.date_create });

            return(result);
        }
        public void Update()
        {
            Differenced diff = new Differenced()
            {
                diff_id     = int.Parse(txtDid.Text),
                diff_name   = txtDname.Text,
                date_create = DateTime.Now,
                status      = cbDstatus.Checked == true ? true : false,
                val_id      = (int)cbxValue.SelectedValue
            };
            int result = DifferencedDAO.Instance.Update(diff);

            if (result > 0)
            {
                MessageBox.Show("Update success", "Update");
                Load();
            }
        }
        public void Insert()
        {
            Differenced diff = new Differenced()
            {
                diff_name   = txtDname.Text,
                date_create = DateTime.Now,
                status      = cbDstatus.Checked == true ? true : false,
                val_id      = (int)cbxValue.SelectedValue
            };
            int result = DifferencedDAO.Instance.Insert(diff);

            if (result > 0)
            {
                MessageBox.Show("Insert success", "Add New");
                Load();
                check        = true;
                button2.Text = "Lưu";
            }
        }