private void btnAdd_Click(object sender, EventArgs e) { Model.Producer u = new Model.Producer(txtID.Text, txtName.Text, txtAdd.Text, txtPhone.Text); if (Controller.Connector.updateProducer(u)) { MessageBox.Show("Sửa thành công nhà cung cấp " + txtID.Text, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Sửa lỗi " + txtID.Text, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.Close(); }
public static bool updateProducer(Model.Producer _p) { try { openConnection(); // Them don vi string strCmd = string.Format("UPDATE NSX set TENNSX = N'{0}', DIACHI = N'{1}', SDT = '{2}' where MANSX = '{3}'", _p.Name, _p.Add, _p.Phone, _p.IdString); SqlCommand myCmd = new SqlCommand(strCmd, conn); SqlDataReader myReader = myCmd.ExecuteReader(); conn.Close(); conn.Dispose(); return(true); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); conn.Close(); conn.Dispose(); return(false); } }
public static bool insertProducer(Model.Producer _p) { try { openConnection(); // Them don vi string strCmd = string.Format("INSERT INTO NSX VALUES('{0}', N'{1}', N'{2}', '{3}')", _p.IdString, _p.Name, _p.Add, _p.Phone); SqlCommand myCmd = new SqlCommand(strCmd, conn); SqlDataReader myReader = myCmd.ExecuteReader(); conn.Close(); conn.Dispose(); return(true); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message); conn.Close(); conn.Dispose(); return(false); } }