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