public bool Add(ClassEmployee.Employee employee)
{
string query = "INSERT INTO NhanVien VALUES ( @MaNV , @TenNV , @GioiTinh , @NgaySinh , @SDT , @Email , @DiaChi )";
object[] para = new object[] { employee.MaNV, employee.TenNV, employee.GioiTinh, employee.NgaySinh, employee.SDT, employee.Email, employee.DiaChi };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
public bool Edit(ClassEmployee.Employee employee)
{
string MaNV = employee.MaNV;
string query = "UPDATE NhanVien SET TenNV = @TenNV , GioiTinh = @GioiTinh , NgaySinh = @NgaySinh , SDT = @SDT , Email = @Email , DiaChi = @DiaChi WHERE MaNV = @MaNV ";
object[] para = new object[] { employee.TenNV, employee.GioiTinh, employee.NgaySinh, employee.SDT, employee.Email, employee.DiaChi, employee.MaNV };
if (DataProvider.Instance.ExecuteNonQuery(query, para) > 0)
{
return(true);
}
return(false);
}
