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