public void Xoa(NgoaiNguEntity tk)
{
KetNoiCSDL.MoKetNoi();
string sql = @"DELETE tblNgoaiNgu WHERE MaNN=@MaNN";
SqlCommand cdm = new SqlCommand(sql, KetNoiCSDL.connect);
cdm.Parameters.AddWithValue("@MaNN", tk.MaNN);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Xoa(PhongBanEntity pb)
{
KetNoiCSDL.MoKetNoi();
string sql = @"DELETE tblPhongBan WHERE MaPB=@MaPB";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.Parameters.AddWithValue("@MaPB", pb.MaPB);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Xoa(TaiKhoanEntity tk)
{
KetNoiCSDL.MoKetNoi();
string sql = @"DELETE tblTaiKhoan WHERE MaNV=@MaNV";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.Parameters.AddWithValue("@MaNV", tk.MaNV);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Xoa(PhieuLuongEntity pl)
{
KetNoiCSDL.MoKetNoi();
string sql = @"DELETE tblPhieuLuong WHERE MaPhieuLuong=@MaPhieuLuong";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.Parameters.AddWithValue("@MaPhieuLuong", pl.MaPhieuLuong);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Xoa(ChiTietKhenThuongEntity pb)
{
KetNoiCSDL.MoKetNoi();
string sql = @"DELETE tblChiTietKhenThuong WHERE MaKT=@MaHD and MaNV=@MaNV";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.Parameters.AddWithValue("@MaHD", pb.MaKT);
cmd.Parameters.AddWithValue("@MaNV", pb.MaNV);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Sua(TaiKhoanEntity tk)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"UPDATE tblTaiKhoan SET MatKhau =@MatKhau, TaiKhoan =@TaiKhoan Where MaNV=@MaNV";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@TaiKhoan", tk.TaiKhoan);
cdm.Parameters.AddWithValue("@MatKhau", tk.MatKhau);
cdm.Parameters.AddWithValue("@MaNV", tk.MaNV);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Them(NgoaiNguEntity tk)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"INSERT INTO tblNgoaiNgu(MaNN,TenNN) VALUES (@MaNN,@TenNN)";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaNN", tk.MaNN);
cdm.Parameters.AddWithValue("@TenNN", tk.TenNN);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Them(TaiKhoanEntity tk)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"INSERT INTO tblTaiKhoan(TaiKhoan, MatKhau, MaNV) VALUES (@TaiKhoan,@MatKhau,@MaNV)";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@TaiKhoan", tk.TaiKhoan);
cdm.Parameters.AddWithValue("@MatKhau", tk.MatKhau);
cdm.Parameters.AddWithValue("@MaNV", tk.MaNV);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Sua(NgoaiNguEntity tk)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"UPDATE tblNgoaiNgu SET TenNN =@TenNN Where MaNN=@MaNN";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaNN", tk.MaNN);
cdm.Parameters.AddWithValue("@TenNN", tk.TenNN);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Them(ChiTietKhenThuongEntity pb)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"INSERT INTO tblChiTietKhenThuong(MaKT, MaNV,NgayKhenThuong,TienKhenThuong,GhiChu) VALUES(@MaPB,@TenPB,@DiaDiem,@SDT,@GhiChu)";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaPB", pb.MaKT);
cdm.Parameters.AddWithValue("@TenPB", pb.MaNV);
cdm.Parameters.AddWithValue("@DiaDiem", pb.NgayKhenThuong);
cdm.Parameters.AddWithValue("@SDT", pb.TienKhenThuong);
cdm.Parameters.AddWithValue("@GhiChu", pb.GhiChu);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Them(PhongBanEntity pb)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"INSERT INTO tblPhongBan (MaPB, TenPB, DiaDiem, SDT) VALUES(@MaPB,@TenPB,@DiaDiem,@SDT)";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaPB", pb.MaPB);
cdm.Parameters.AddWithValue("@TenPB", pb.TenPB);
cdm.Parameters.AddWithValue("@DiaDiem", pb.DiaDiem);
cdm.Parameters.AddWithValue("@SDT", pb.SDT);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Sua(PhongBanEntity pb)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"UPDATE tblPhongBan SET TenPB =@TenPB, DiaDiem =@DiaDiem, SDT =@SDT Where MaPB=@MaPB";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaPB", pb.MaPB);
cdm.Parameters.AddWithValue("@TenPB", pb.TenPB);
cdm.Parameters.AddWithValue("@DiaDiem", pb.DiaDiem);
cdm.Parameters.AddWithValue("@SDT", pb.SDT);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Them(ChiTietNgoaiNguEntity pb)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"INSERT INTO tblChiTietNgoaiNgu(MaNN, MaNV,ThoiGian,TrinhDo,GhiChu) VALUES(@MaPB,@TenPB,@DiaDiem,@SDT,@GhiChu)";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaPB", pb.MaNN);
cdm.Parameters.AddWithValue("@TenPB", pb.MaNV);
cdm.Parameters.AddWithValue("@DiaDiem", pb.ThoiGian);
cdm.Parameters.AddWithValue("@SDT", pb.TrinhDo);
cdm.Parameters.AddWithValue("@GhiChu", pb.GhiChu);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Sua(ChiTietKhenThuongEntity pb)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"UPDATE tblChiTietKhenThuong SET NgayKhenThuong =@NgayBatDau, TienKhenThuong =@NgayKetThuc, GhiChu =@GhiChu Where MaKT=@MaHD and MaNV=@MaNV";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@NgayBatDau", pb.NgayKhenThuong);
cdm.Parameters.AddWithValue("@NgayKetThuc", pb.TienKhenThuong);
cdm.Parameters.AddWithValue("@GhiChu", pb.GhiChu);
cdm.Parameters.AddWithValue("@MaHD", pb.MaKT);
cdm.Parameters.AddWithValue("@MaNV", pb.MaNV);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void Sua(ChiTietNgoaiNguEntity pb)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"UPDATE tblChiTietNgoaiNgu SET ThoiGian =@ThoiGian, TrinhDo =@TrinhDo, GhiChu =@GhiChu Where MaNN=@MaNN and MaNV=@MaNV";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@ThoiGian", pb.ThoiGian);
cdm.Parameters.AddWithValue("@TrinhDo", pb.TrinhDo);
cdm.Parameters.AddWithValue("@GhiChu", pb.GhiChu);
cdm.Parameters.AddWithValue("@MaNN", pb.MaNN);
cdm.Parameters.AddWithValue("@MaNV", pb.MaNV);
cdm.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(PhieuLuongEntity pl)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"UPDATE tblPhieuLuong SET MaNV =@MaNV, LuongCoBan =@LuongCoBan, HeSoLuong =@HeSoLuong, TienThuong =@TienThuong, PhuCap =@PhuCap, TongLinh =@TongLinh, NgayLinh =@NgayLinh WHERE MaPhieuLuong=@MaPhieuLuong";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaNV", pl.MaNV);
cdm.Parameters.AddWithValue("@LuongCoBan", pl.LuongCoBan);
cdm.Parameters.AddWithValue("@HeSoLuong", pl.HeSoLuong);
cdm.Parameters.AddWithValue("@TienThuong", pl.TienThuong);
cdm.Parameters.AddWithValue("@PhuCap", pl.PhuCap);
cdm.Parameters.AddWithValue("@TongLinh", pl.TongLinh);
cdm.Parameters.AddWithValue("@NgayLinh", pl.NgayLinh);
cdm.Parameters.AddWithValue("@MaPhieuLuong", pl.MaPhieuLuong);
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();
}
public void Them(PhieuLuongEntity pl)
{
KetNoiCSDL.MoKetNoi();
string themhd = @"INSERT INTO tblPhieuLuong(MaPhieuLuong, MaNV, LuongCoBan, HeSoLuong, TienThuong, PhuCap, TongLinh, NgayLinh) VALUES(@MaPhieuLuong,@MaNV,@LuongCoBan,@HeSoLuong,@TienThuong,@PhuCap,@TongLinh,@NgayLinh)";
SqlCommand cdm = new SqlCommand(themhd, KetNoiCSDL.connect);
// cdm.CommandType = CommandType.StoredProcedure;
cdm.Parameters.AddWithValue("@MaPhieuLuong", pl.MaPhieuLuong);
cdm.Parameters.AddWithValue("@MaNV", pl.MaNV);
cdm.Parameters.AddWithValue("@LuongCoBan", pl.LuongCoBan);
cdm.Parameters.AddWithValue("@HeSoLuong", pl.HeSoLuong);
cdm.Parameters.AddWithValue("@TienThuong", pl.TienThuong);
cdm.Parameters.AddWithValue("@PhuCap", pl.PhuCap);
cdm.Parameters.AddWithValue("@TongLinh", pl.TongLinh);
cdm.Parameters.AddWithValue("@NgayLinh", pl.NgayLinh);
cdm.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
