public bool UpdateNhanVien(DTO.Nhanvien nv)
{
//UPDATE NHANVIEN SET TenNhanVien = 'SIU', DiaChi = 't', SoDienThoai = 't', Email = 't', CMND = 't', LOAI = 'Nhân viên', UserName = '******', PassWord = '******', PassWord2 = '123456' WHERE id_Nhan_Vien = 'NV0002'
string sql = "UPDATE NHANVIEN SET TenNhanVien = @TENNV, DiaChi =@DC, SoDienThoai =@SDT, Email = @EMAIL, CMND = @CMND, LOAI = @L, UserName = @U, PassWord = @P, PassWord2 = @P2 WHERE id_Nhan_Vien =@ID";
//string sql = "UPDATE NHANVIEN SET TenNhanVien=@TENNV, DiaChi=@DC, SoDienThoai=@SDT, Email=@EMAIL, CMND=@CMND, LOAI=@L, UserName=@U, PassWord=@P, PassWord2=@P2 WHERE id_Nhan_Vien=@ID";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@TENNV", SqlDbType.NVarChar).Value = nv.tennv;
cmd.Parameters.Add("@DC", SqlDbType.NVarChar).Value = nv.diachi;
cmd.Parameters.Add("@SDT", SqlDbType.NChar).Value = nv.sdt;
cmd.Parameters.Add("@EMAIL", SqlDbType.NChar).Value = nv.email;
cmd.Parameters.Add("@CMND", SqlDbType.NChar).Value = nv.cmnd;
cmd.Parameters.Add("@L", SqlDbType.NChar).Value = nv.loai;
cmd.Parameters.Add("@ID", SqlDbType.NVarChar).Value = nv.manv;
cmd.Parameters.Add("@U", SqlDbType.NChar).Value = nv.username;
cmd.Parameters.Add("@P", SqlDbType.NChar).Value = nv.password;
cmd.Parameters.Add("@P2", SqlDbType.NChar).Value = nv.passwordlv2;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool Suanhanvien(DTO.Nhanvien nv)
{
string sql = "UPDATE NHANVIEN SET TENNV=@TENNV, DIACHI=@DIACHI, TENTK=@TENTAIKHOAN, MATKHAU=@MATKHAU, SDT=@SDT, GIOITINH=@GIOITINH, LOAINV=@LOAINV WHERE MANV = @MANV";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MANV", SqlDbType.Int).Value = nv.MANV1;
cmd.Parameters.Add("@TENNV", SqlDbType.NVarChar).Value = nv.TENNV1;
cmd.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = nv.DIACHI1;
cmd.Parameters.Add("@TENTAIKHOAN", SqlDbType.VarChar).Value = nv.TENTK1;
cmd.Parameters.Add("@MATKHAU", SqlDbType.VarChar).Value = nv.MATKHAU1;
cmd.Parameters.Add("@SDT", SqlDbType.VarChar).Value = nv.SDT1;
cmd.Parameters.Add("@GIOITINH", SqlDbType.Bit).Value = nv.GIOITINH1;
cmd.Parameters.Add("@LOAINV", SqlDbType.Int).Value = nv.LOAINV1;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool InsertNhanVien(DTO.Nhanvien nv)
{
string sql = "INSERT INTO NHANVIEN(id_Nhan_Vien, TenNhanVien, DiaChi, SoDienThoai, Email, CMND, UserName, PassWord, LOAI, PassWord2 ) VALUES(@MANV, @TENNV,@DIACHI,@SDT,@EMAIL,@CMND,@USER,@PASS,@LOAI,@PASS2)";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MANV", SqlDbType.NVarChar).Value = TaoMaNhanVien();
cmd.Parameters.Add("@TENNV", SqlDbType.NVarChar).Value = nv.tennv;
cmd.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = nv.diachi;
cmd.Parameters.Add("@SDT", SqlDbType.NChar).Value = nv.sdt;
cmd.Parameters.Add("@EMAIL", SqlDbType.NChar).Value = nv.email;
cmd.Parameters.Add("@CMND", SqlDbType.NChar).Value = nv.cmnd;
cmd.Parameters.Add("@USER", SqlDbType.NChar).Value = nv.username;
cmd.Parameters.Add("@PASS", SqlDbType.NChar).Value = nv.password;
cmd.Parameters.Add("@LOAI", SqlDbType.NVarChar).Value = nv.loai;
cmd.Parameters.Add("@PASS2", SqlDbType.NChar).Value = nv.passwordlv2;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool check_trung_username_insert(DTO.Nhanvien nv)
{
SqlConnection con = dc.GetConnect();
DataTable dt = new DataTable();
string sqlQuery = string.Format("select * from NHANVIEN where UserName='******'", nv.username);
SqlDataAdapter da = new SqlDataAdapter(sqlQuery, con);
da.Fill(dt);
if (dt.Rows.Count >= 1)
{
return(false);
}
else
{
return(true);
}
}
public bool Xoanhanvien(DTO.Nhanvien nv)
{
string sql = "UPDATE NHANVIEN SET XOA = 1 WHERE MANV = @MANV";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MANV", SqlDbType.Int).Value = nv.MANV1;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool DeleteNhanVien(DTO.Nhanvien nv)
{
string sql = "DELETE NHANVIEN WHERE id_Nhan_Vien = @MANV";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MANV", SqlDbType.VarChar).Value = nv.manv;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool Themnhanvien(DTO.Nhanvien nv)
{
string sql = "INSERT INTO NHANVIEN(TENNV,DIACHI,LOAINV,TENTK,MATKHAU,SDT,GIOITINH)VALUES(@TENNV,@DIACHI,@LOAINV,@TENTAIKHOAN,@MATKHAU,@SDT,@GIOITINH)";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@TENNV", SqlDbType.NVarChar).Value = nv.TENNV1;
cmd.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = nv.DIACHI1;
cmd.Parameters.Add("@TENTAIKHOAN", SqlDbType.VarChar).Value = nv.TENTK1;
cmd.Parameters.Add("@MATKHAU", SqlDbType.VarChar).Value = nv.MATKHAU1;
cmd.Parameters.Add("@SDT", SqlDbType.VarChar).Value = nv.SDT1;
cmd.Parameters.Add("@GIOITINH", SqlDbType.Bit).Value = nv.GIOITINH1;
cmd.Parameters.Add("@LOAINV", SqlDbType.Int).Value = nv.LOAINV1;
cmd.ExecuteNonQuery();
con.Close();
}catch (Exception e)
{
return(false);
}
return(true);
}
public bool check_trung_username_insert(DTO.Nhanvien _nv)
{
return(dal.check_trung_username_insert(_nv));
}
public bool DeleteNhanVien(DTO.Nhanvien _nv)
{
return(dal.DeleteNhanVien(_nv));
}
public bool UpdateNhanVien(DTO.Nhanvien _nv)
{
return(dal.UpdateNhanVien(_nv));
}
public bool InsertNhanVien(DTO.Nhanvien _nv)
{
return(dal.InsertNhanVien(_nv));
}
public bool Xoanhanvien(DTO.Nhanvien nv)
{
return(nvd.Xoanhanvien(nv));
}
public bool Suanhanvien(DTO.Nhanvien nv)
{
return(nvd.Suanhanvien(nv));
}
public bool Themnhanvien(DTO.Nhanvien nv)
{
return(nvd.Themnhanvien(nv));
}
public void Setup()
{
dal = new DAL.NhanvienDAL();
fm = new Quan_ly_nhan_vien();
dto = new DTO.Nhanvien(null, null, null, null, null, null, null, null, null, null);
}
//Trường hợp không nhập gì
public void InsertNV1()
{
DAL.NhanvienDAL dal = new DAL.NhanvienDAL();
DTO.Nhanvien dto = new DTO.Nhanvien();
Assert.IsFalse(dal.InsertNhanVien(dto));
}
