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();
}
}
