public void XoaNhanVien(NhanVienEntity nv)
{
KetNoiCSDL.MoKetNoi();
string sql = @"DELETE NHANVIEN WHERE MaNV=@MaNV";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.Parameters.AddWithValue("@MaNV", nv.MaNV);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public int UpdateData(NhanVienEntity NV)
{
SqlParameter[] para =
{
new SqlParameter("MaNV", NV.MaNV),
new SqlParameter("TenNV", NV.TenNV),
new SqlParameter("GioiTinh", NV.GioiTinh),
new SqlParameter("NgaySinh", NV.NgaySinh),
new SqlParameter("DienThoai", NV.DienThoai)
};
return(conn.ExcuteSQL("SuaNV ", para));
}
public int InsertData(NhanVienEntity NV)
{
SqlParameter[] para =
{
new SqlParameter("MaNV", NV.MaNV),
new SqlParameter("TenNV", NV.TenNV),
new SqlParameter("NgaySinh", NV.NgaySinh),
new SqlParameter("GioiTinh", NV.GioiTinh),
new SqlParameter("SoDT", NV.SoDT),
new SqlParameter("DiaChi", NV.DiaChi)
};
return(conn.ExcuteSQL("ThemNV", para));
}
public void Sua(NhanVienEntity nv)
{
KetNoiCSDL.MoKetNoi();
string sql = "UPDATE NHANVIEN SET MatKhau =@MatKhau,TenDangNhap =@TenDn Where MaNV=@MaNV";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.Parameters.AddWithValue("@MatKhau", nv.MatKhau);
cmd.Parameters.AddWithValue("@TenDn", nv.TenDangNhap);
cmd.Parameters.AddWithValue("@MaNV", nv.MaNV);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public int UpdateData(NhanVienEntity NV)
{
SqlParameter[] para =
{
new SqlParameter("MaNV", NV.MaNV),
new SqlParameter("TenNV", NV.TenNV),
new SqlParameter("NgaySinh", NV.NgaySinh),
new SqlParameter("QueQuan", NV.QueQuan),
new SqlParameter("SDT", NV.SDT),
new SqlParameter("Luong", NV.Luong),
new SqlParameter("MaGH", NV.MaGH),
new SqlParameter("GioiTinh", NV.GioiTinh)
};
return(conn.ExcuteSQL("SuaNV ", para));
}
public int UpdateData(NhanVienEntity NV)
{
SqlParameter[] para =
{
new SqlParameter("MaNV", NV.MaNV),
new SqlParameter("HoTen", NV.HoTen),
new SqlParameter("DanToc", NV.DanToc),
new SqlParameter("GioiTinh", NV.GioiTinh),
new SqlParameter("SDT", NV.SDT),
new SqlParameter("QueQuan", NV.QueQuan),
new SqlParameter("NgaySinh", NV.NgaySinh),
new SqlParameter("MaTDHV", NV.MaTDHV),
new SqlParameter("MaPB", NV.MaPB),
new SqlParameter("BacLuong", NV.BacLuong)
};
return(conn.ExcuteSQL("SuaNV ", para));
}
public void ThemNhanVien(NhanVienEntity nv)
{
KetNoiCSDL.MoKetNoi();
string sql = "INSERT INTO NHANVIEN(MaNV, MatKhau, TenNV, GT, DiaChi, SDT, TenDangNhap) VALUES(@MaNV,@MatKhau,@TenNV,@GT,@DiaChi,@SDT,@SDT,@TenDn)";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNV", nv.MaNV);
cmd.Parameters.AddWithValue("@MatKhau", nv.MatKhau);
cmd.Parameters.AddWithValue("@TenNV", nv.TenNV);
cmd.Parameters.AddWithValue("@GT", nv.GT);
cmd.Parameters.AddWithValue("@DiaChi", nv.DiaChi);
cmd.Parameters.AddWithValue("@SDT", nv.SDT);
cmd.Parameters.AddWithValue("@TenDn", nv.TenDangNhap);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void SuaNhanVien(NhanVienEntity nv)
{
KetNoiCSDL.MoKetNoi();
string sql = "UPDATE NHANVIEN SET MatKhau =@MatKhau, TenNV =@TenNV, DiaChi =@DiaChi, GT =@GT, SDT =@SDT, TenDangNhap =@TenDn Where MaNV=@MaNV";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MatKhau", nv.MK);
cmd.Parameters.AddWithValue("@TenNV", nv.TenNV);
cmd.Parameters.AddWithValue("@GT", nv.GT);
cmd.Parameters.AddWithValue("@DiaChi", nv.DiaChi);
cmd.Parameters.AddWithValue("@SDT", nv.SDT);
cmd.Parameters.AddWithValue("@TenDn", nv.TenDangNhap);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Them(NhanVienEntity pb)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"INSERT INTO tblNhanVien(MaNV, HoTen, GioiTinh, NgaySinh, DiaChi, MaPB, MaChucVu, MaChuyenMon, GhiChu) VALUES(@MaNV,@HoTen,@GioiTinh,@NgaySinh,@DiaChi,@MaPB,@MaChucVu,@MaChuyenMon,@GhiChu)";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaNV", pb.MaNV);
cdm.Parameters.AddWithValue("@HoTen", pb.HoTen);
cdm.Parameters.AddWithValue("@GioiTinh", pb.GioiTinh);
cdm.Parameters.AddWithValue("@NgaySinh", pb.NgaySinh);
cdm.Parameters.AddWithValue("@MaPB", pb.MaPB);
cdm.Parameters.AddWithValue("@DiaChi", pb.DiaChi);
cdm.Parameters.AddWithValue("@MaChucVu", pb.MaChucVu);
cdm.Parameters.AddWithValue("@MaChuyenMon", pb.MaChuyenMon);
cdm.Parameters.AddWithValue("@GhiChu", pb.GhiChu);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Sua(NhanVienEntity pb)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"UPDATE tblNhanVien SET HoTen =@HoTen, GioiTinh =@GioiTinh, NgaySinh =@NgaySinh, DiaChi =@DiaChi, MaPB =@MaPB, MaChucVu =@MaChucVu, MaChuyenMon =@MaChuyenMon, GhiChu =@GhiChu Where MaNV=@MaNV";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaNV", pb.MaNV);
cdm.Parameters.AddWithValue("@HoTen", pb.HoTen);
cdm.Parameters.AddWithValue("@GioiTinh", pb.GioiTinh);
cdm.Parameters.AddWithValue("@NgaySinh", pb.NgaySinh);
cdm.Parameters.AddWithValue("@MaPB", pb.MaPB);
cdm.Parameters.AddWithValue("@DiaChi", pb.DiaChi);
cdm.Parameters.AddWithValue("@MaChucVu", pb.MaChucVu);
cdm.Parameters.AddWithValue("@MaChuyenMon", pb.MaChuyenMon);
cdm.Parameters.AddWithValue("@GhiChu", pb.GhiChu);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
private void Them()
{
NhanVienEntity nv = new NhanVienEntity();
nv.HoTen = txtTen.Text;
nv.DiaChi = txtDiaChi.Text;
nv.GhiChu = txtGhiChu.Text;
nv.MaChucVu = cboChucVu.SelectedValue.ToString();
nv.MaPB = cboPhongBan.SelectedValue.ToString();
nv.MaChuyenMon = cboChuyenMon.SelectedValue.ToString();
nv.NgaySinh = dtNgaySinh.Value.ToString();
if (ckNam.Checked == true)
{
nv.GioiTinh = "Nam";
}
else
{
nv.GioiTinh = "Nữ";
}
NhanVienBus nhanv = new NhanVienBus();
nhanv.Them(nv);
}
public int UpdateData(NhanVienEntity NV)
{
return(da.UpdateData(NV));
}
public int InsertData(NhanVienEntity NV)
{
return(da.InsertData(NV));
}
