private void updateDB(bool isNewQT) { QuyTrinhBT quytrinh = new QuyTrinhBT(); quytrinh.maQTBT = txtMaQT.Text; quytrinh.tenQTBT = txtTenQT.Text; quytrinh.noidungQT = 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; } DBQuyTrinhBT dbquytrinh = new DBQuyTrinhBT(); if (isNewQT) { dbquytrinh.addnewQuyTrinh(quytrinh, false); } else { dbquytrinh.addnewQuyTrinh(quytrinh, true); } dbquytrinh.updateGridData(dataGridQuyTrinh); }
public int addnewQuyTrinh(QuyTrinhBT quytrinh, bool isUpdate) { DataBaseManager.initializeInstance(); DataBaseManager dbmg = DataBaseManager.getInstance(); SqlConnection con = dbmg.openDatabase(); string insertNewCmd = "INSERT QUYTRINHBAOTRI (Id, TenQuyTrinh, NguoiVietQuyTrinh, NoiDungQT) " + " VALUES (@Id,@TenQuyTrinh,@NguoiVietQuyTrinh,@NoiDungQT)"; string updateCmd = "UPDATE QUYTRINHBAOTRI SET Id = @Id, TenQuyTrinh = @TenQuyTrinh, NguoiVietQuyTrinh = @NguoiVietQuyTrinh," + " NoiDungQT = @NoiDungQT"; 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.maQTBT); cmd.Parameters.AddWithValue("@TenQuyTrinh", quytrinh.tenQTBT); cmd.Parameters.AddWithValue("@NguoiVietQuyTrinh", quytrinh.tennguoiviet); cmd.Parameters.AddWithValue("@NoiDungQT", quytrinh.noidungQT); 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); }