Example #1
0
        private void updateDB(bool isNewQT)
        {
            QuyTrinhXLSC quytrinh = new QuyTrinhXLSC();

            quytrinh.maQTXLSC      = txtMaQT.Text;
            quytrinh.tenQTXLSC     = txtTenQT.Text;
            quytrinh.noidungQTXLSC = rtbNoidung.Text;
            quytrinh.tennguoiviet  = cbNguoiViet.GetItemText(cbNguoiViet.SelectedItem);

            if ((txtMaQT.Text == "") || (txtTenQT.Text == "") || (cbNguoiViet.Text == ""))
            {
                MessageBox.Show(this, "Vui Long Dien Ma, TenQT Va Ten Nguoi Viet", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            DBQuyTrinhXLSC dbquytrinh = new DBQuyTrinhXLSC();

            if (isNewQT)
            {
                dbquytrinh.addnewQuyTrinh(quytrinh, false);
            }
            else
            {
                dbquytrinh.addnewQuyTrinh(quytrinh, true);
            }
            dbquytrinh.updateGridData(dataGridQuyTrinh);
        }
Example #2
0
        public int addnewQuyTrinh(QuyTrinhXLSC quytrinh, bool isUpdate)
        {
            DataBaseManager.initializeInstance();
            DataBaseManager dbmg = DataBaseManager.getInstance();
            SqlConnection   con  = dbmg.openDatabase();

            string insertNewCmd = "INSERT QUYTRINHXULYSUCO (Id, TenQuyTrinh, NguoiVietQuyTrinh, NoiDungQTXLSC) "
                                  + " VALUES (@Id,@TenQuyTrinh,@NguoiVietQuyTrinh,@NoiDungQTXLSC)";
            string updateCmd = "UPDATE QUYTRINHXULYSUCO SET Id = @Id, TenQuyTrinh = @TenQuyTrinh, NguoiVietQuyTrinh = @NguoiVietQuyTrinh,"
                               + " NoiDungQTXLSC = @NoiDungQTXLSC";


            SqlCommand cmd = new SqlCommand();

            cmd.Connection  = con;
            cmd.CommandType = CommandType.Text;
            if (!isUpdate)
            {
                cmd.CommandText = insertNewCmd;
            }
            else
            {
                cmd.CommandText = updateCmd;
            }
            //cmd.CommandText = "INSERT QUYTRINHBAOTRI (Id, TenQuyTrinh) VALUES (@maQTBT,@tenQTBT,@tennguoiviet)";
            cmd.Parameters.AddWithValue("@ID", quytrinh.maQTXLSC);
            cmd.Parameters.AddWithValue("@TenQuyTrinh", quytrinh.tenQTXLSC);
            cmd.Parameters.AddWithValue("@NguoiVietQuyTrinh", quytrinh.tennguoiviet);
            cmd.Parameters.AddWithValue("@NoiDungQTXLSC", quytrinh.noidungQTXLSC);

            int ret = -1;

            try
            {
                ret = cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                Debug.WriteLine("The product name is " + e.Message);
            }

            dbmg.closeDatabase();

            return((ret > 0) ? ret : -1);
        }