private void btnXoaCV_Click(object sender, EventArgs e) { ViTri temp = new ViTri(txtMaVT.Text, txtTenVT.Text); ConnectDatabase.XoaViTri(temp); dgvVT.DataSource = ConnectDatabase.getAllViTri(); }
public static void XoaViTri(ViTri vt) { string sql = "DELETE FROM VITRICONGVIEC where MaVT=@mavt"; using (SqlCommand command = new SqlCommand(sql, conn)) { command.Parameters.Add(new SqlParameter("@mavt", vt.Mavt)); command.ExecuteNonQuery(); command.Cancel(); } }
public static void SuaViTri(ViTri vt) { string sql = "UPDATE VITRICONGVIEC set TenVT=@tenvt where MaVT=@mavt"; using (SqlCommand command = new SqlCommand(sql, conn)) { command.Parameters.Add(new SqlParameter("@tenvt", vt.Tenvt)); command.Parameters.Add(new SqlParameter("@mavt", vt.Mavt)); command.ExecuteNonQuery(); command.Cancel(); } }
private void btnThemCV_Click(object sender, EventArgs e) { ViTri temp = new ViTri(txtMaVT.Text, txtTenVT.Text); if (ConnectDatabase.checkViTri(temp.Mavt) == 1) { MessageBox.Show("Mã vị trí đã tồn tại. Xin mời nhập mã khác!!!"); return; } ConnectDatabase.ThemViTri(temp); dgvVT.DataSource = ConnectDatabase.getAllViTri(); }
public static void ThemViTri(ViTri vt) { string sql = "insert into VITRICONGVIEC(MaVT, TenVT) values(@mavt, @tenvt)"; SqlCommand cmd = new SqlCommand(sql, conn); using (SqlCommand command = new SqlCommand(sql, conn)) { command.Parameters.Add(new SqlParameter("@mavt", vt.Mavt)); command.Parameters.Add(new SqlParameter("@tenvt", vt.Tenvt)); int kq = command.ExecuteNonQuery(); if (kq > 0) { MessageBox.Show("Thêm vị trí mới thành công!"); } else { MessageBox.Show("Thêm vị trí mới thất bại!"); } command.Cancel(); } }