public NhanVienChucVuDTO LayNhanVienChucVuTheoMaNVMaCVTuNgay(int maNV, int maCV, string tungay)
{
NhanVienChucVuDTO nhanVienChucVu = new NhanVienChucVuDTO();
KetNoiCSDL.MoKetNoi();
DateTime dt = DateTime.ParseExact(tungay, "dd/MM/yyyy", null);
string sqlSelect = "Select * from nhanvien_chucvu where manhanvien=@manv and machucvu=@macv and tungay=@ngay";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("manv", maNV);
cmd.Parameters.Add("macv", maCV);
cmd.Parameters.Add("ngay", dt.ToString("MM/dd/yyyy"));
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateTime date = DateTime.Parse(dr["denngay"].ToString());
nhanVienChucVu.MaNhanVien = maNV;
nhanVienChucVu.MaChucVu = maCV;
nhanVienChucVu.TuNgay = tungay;
nhanVienChucVu.DenNgay = date.ToString("dd/MM/yyyy");
}
KetNoiCSDL.DongKetNoi();
return(nhanVienChucVu);
}
public QuaTrinhCongTacDTO LayBangQuaTrinhCongTacTheoMaNVTuNgay(int maNV, string tuNgay)
{
QuaTrinhCongTacDTO ds = null;
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select * from QuaTrinhcongTac where manhanvien=@ma and tungay=@tungay";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("ma", maNV);
cmd.Parameters.Add("tungay", tuNgay);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateTime date1 = DateTime.Parse(dr["tungay"].ToString());
DateTime date2 = DateTime.Parse(dr["denngay"].ToString());
ds = new QuaTrinhCongTacDTO(
Convert.ToInt32(dr["manhanvien"]),
date1.ToString("dd/MM/yyyy"),
date2.ToString("dd/MM/yyyy"),
dr["noicongtac"].ToString(),
dr["chucvu"].ToString());
}
KetNoiCSDL.DongKetNoi();
return(ds);
}
public bool SuaQuaTrinhCongTac(int maNhanVien, string tuNgay, string denNgay, string noiCongTac, string chucvu)
{
try
{
KetNoiCSDL.MoKetNoi();
string sqlUpdate = "update QuaTrinhCongTac set denNgay=@denNgay, noicongtac=@noict, chucVu= @chucvu where maNhanVien=@maNV and tuNgay=@tuNgay";
SqlCommand cmd = new SqlCommand(sqlUpdate, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("maNV", maNhanVien);
cmd.Parameters.Add("tuNgay", tuNgay);
cmd.Parameters.Add("denNgay", denNgay);
cmd.Parameters.Add("noict", noiCongTac);
cmd.Parameters.Add("chucvu", chucvu);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
KetNoiCSDL.DongKetNoi();
}
}
public List <ChucVuDTO> LayTenChucVuTheoMaNhanVien(int manv)
{
List <ChucVuDTO> ds = new List <ChucVuDTO>();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select chucvu.machucvu as 'machucvu',tenchucvu from nhanvien_chucvu " +
"inner join chucvu on nhanvien_chucvu.machucvu=chucvu.machucvu " +
"where nhanvien_chucvu.manhanvien=@ma " +
"group by chucvu.machucvu,TenChucVu";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("ma", manv);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
ChucVuDTO nvcv = new ChucVuDTO(
Convert.ToInt32(dr["machucvu"]),
dr["tenchucvu"].ToString()
);
ds.Add(nvcv);
}
KetNoiCSDL.DongKetNoi();
return(ds);
}
public bool ThemNhanVienChucVu(int maNhanVien, int maChucVu, string tuNgay, string denNgay)
{
try
{
KetNoiCSDL.MoKetNoi();
string sqlInsert = "insert into nhanvien_chucvu values(@maNV,@maCV,@tuNgay,@denNgay)";
SqlCommand cmd = new SqlCommand(sqlInsert, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("maNV", maNhanVien);
cmd.Parameters.Add("maCV", maChucVu);
cmd.Parameters.Add("tuNgay", tuNgay);
cmd.Parameters.Add("denNgay", denNgay);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
KetNoiCSDL.DongKetNoi();
}
}
public List <NhanVienChucVuDTO> LayNhanVienChucVuTheoMaNVMaCV(int manv, int macv)
{
List <NhanVienChucVuDTO> ds = new List <NhanVienChucVuDTO>();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select tungay from nhanvien_chucvu where manhanvien=@manv and machucvu=@macv";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("manv", manv);
cmd.Parameters.Add("macv", macv);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateTime dt = DateTime.Parse(dr["tungay"].ToString());
NhanVienChucVuDTO nv = new NhanVienChucVuDTO(
manv, macv,
dt.ToString("dd/MM/yyyy"),
""
);
ds.Add(nv);
}
KetNoiCSDL.DongKetNoi();
return(ds);
}
public bool themTDCM(int maNV, string nganh, string trinhdo, string loaiHinhDT, string TruongDT)
{
try
{
KetNoiCSDL.MoKetNoi();
string sqlInsert = "insert into TrinhDoChuyenMon values (@ma, @nganh, @trinhdo, @loaihinhDT, @truongdt)";
SqlCommand cmd = new SqlCommand(sqlInsert, KetNoiCSDL.KetNoi);
cmd.Parameters.AddWithValue("ma", maNV);
cmd.Parameters.AddWithValue("nganh", nganh);
cmd.Parameters.AddWithValue("trinhdo", trinhdo);
cmd.Parameters.AddWithValue("loaihinhDT", loaiHinhDT);
cmd.Parameters.AddWithValue("truongdt", TruongDT);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
KetNoiCSDL.DongKetNoi();
}
}
public List <TrinhDoChuyenMonDTO> LayDSTDCMtheoMa(int maNV)
{
List <TrinhDoChuyenMonDTO> ds = new List <TrinhDoChuyenMonDTO>();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select * from trinhdochuyenmon where manhanvien = @ma";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
cmd.Parameters.AddWithValue("ma", maNV);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
TrinhDoChuyenMonDTO td = new TrinhDoChuyenMonDTO(
Convert.ToInt32(dr["manhanvien"]),
dr["nganh"].ToString(),
dr["trinhdo"].ToString(),
dr["loaihinhdaotao"].ToString(),
dr["truongdaotao"].ToString()
);
ds.Add(td);
}
KetNoiCSDL.DongKetNoi();
return(ds);
}
public List <HoSoDTO> LayBangHoSo()
{
List <HoSoDTO> ds = new List <HoSoDTO>();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select * from hoso";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateTime date2 = DateTime.Parse(dr["ngaytuyendung"].ToString());
DateTime date3 = DateTime.Parse(dr["ngaysinh"].ToString());
HoSoDTO hs = new HoSoDTO(
Convert.ToInt32(dr["manhanvien"]),
dr["hodem"].ToString(),
dr["tendem"].ToString(),
date3.ToString("dd/MM/yyyy"),
dr["gioitinh"].ToString(),
dr["sodienthoai"].ToString(),
dr["email"].ToString(),
date2.ToString("dd/MM/yyyy"),
Convert.ToInt32(dr["maphongban"])
);
ds.Add(hs);
}
KetNoiCSDL.DongKetNoi();
return(ds);
}
public HoSoDTO LayNhanVienTheoMa(int maNhanVien)
{
HoSoDTO hs = null;
KetNoiCSDL.MoKetNoi();
string sqlSelect = "Select * from hoso where manhanvien=@ma";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
cmd.Parameters.AddWithValue("ma", maNhanVien);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
hs = new HoSoDTO(
Convert.ToInt32(dr["manhanvien"]),
dr["hodem"].ToString(),
dr["tendem"].ToString(),
dr["ngaysinh"].ToString(),
dr["gioitinh"].ToString(),
dr["sodienthoai"].ToString(),
dr["email"].ToString(),
dr["ngaytuyendung"].ToString(),
Convert.ToInt32(dr["maphongban"])
);
KetNoiCSDL.DongKetNoi();
return(hs);
}
public bool suaHoSo(string manv, string hoDem, string ten, string ngaySinh, string gioiTinh, string sdt, string email, string ngayTuyenDung, int maPhongBan)
{
try
{
KetNoiCSDL.MoKetNoi();
string sqlUpdate = "update HoSo set hodem =@ho, tendem= @ten, ngaysinh=@ns, gioitinh=@gt, sodienthoai=@sdt,email=@email, ngaytuyendung=@ntd, maphongban=@mapb where manhanvien=@ma";
SqlCommand cmd = new SqlCommand(sqlUpdate, KetNoiCSDL.KetNoi);
cmd.Parameters.AddWithValue("ma", manv);
cmd.Parameters.AddWithValue("ho", hoDem);
cmd.Parameters.AddWithValue("ten", ten);
cmd.Parameters.AddWithValue("ns", ngaySinh);
cmd.Parameters.AddWithValue("gt", gioiTinh);
cmd.Parameters.AddWithValue("sdt", sdt);
cmd.Parameters.AddWithValue("email", email);
cmd.Parameters.AddWithValue("ntd", ngayTuyenDung);
cmd.Parameters.AddWithValue("mapb", maPhongBan);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
return(false);
}
finally
{
KetNoiCSDL.DongKetNoi();
}
}
public bool suaTDCM(int maNV, string nganh, string trinhdo, string loaiHinhDT, string TruongDT)
{
try
{
KetNoiCSDL.MoKetNoi();
string sqlUpdate = "update TrinhDoChuyenMon set trinhdo=@trinhdo, loaihinhdaotao=@loaihinhDT, truongdaotao=@truongdt where manhanvien=@ma and nganh=@nganh";
SqlCommand cmd = new SqlCommand(sqlUpdate, KetNoiCSDL.KetNoi);
cmd.Parameters.AddWithValue("ma", maNV);
cmd.Parameters.AddWithValue("nganh", nganh);
cmd.Parameters.AddWithValue("trinhdo", trinhdo);
cmd.Parameters.AddWithValue("loaihinhDT", loaiHinhDT);
cmd.Parameters.AddWithValue("truongdt", TruongDT);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
KetNoiCSDL.DongKetNoi();
}
}
public bool themHoSo(string hoDem, string ten, string ngaySinh, string gioiTinh, string sdt, string email, string ngayTuyenDung, int maPhongBan)
{
try
{
KetNoiCSDL.MoKetNoi();
string sqlInsert = "insert into HoSo values (@ho, @ten, @ns, @gt, @sdt, @email, @ntd, @mapb)";
SqlCommand cmd = new SqlCommand(sqlInsert, KetNoiCSDL.KetNoi);
cmd.Parameters.AddWithValue("ho", hoDem);
cmd.Parameters.AddWithValue("ten", ten);
cmd.Parameters.AddWithValue("ns", ngaySinh);
cmd.Parameters.AddWithValue("gt", gioiTinh);
cmd.Parameters.AddWithValue("sdt", sdt);
cmd.Parameters.AddWithValue("email", email);
cmd.Parameters.AddWithValue("ntd", ngayTuyenDung);
cmd.Parameters.AddWithValue("mapb", maPhongBan);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
KetNoiCSDL.DongKetNoi();
}
}
public List <QuaTrinhCongTacDTO> LayDSQuaTrinhCongTacTheoMaNV(int maNV)
{
List <QuaTrinhCongTacDTO> ds = new List <QuaTrinhCongTacDTO>();
KetNoiCSDL.MoKetNoi();
string sqlselect = "select * from QuaTrinhCongTac" +
" inner join HoSo on QuaTrinhCongTac.MaNhanVien=HoSo.MaNhanVien where QuaTrinhCongTac.MaNhanVien=@ma";
SqlCommand cmd = new SqlCommand(sqlselect, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("ma", maNV);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateTime dt = DateTime.Parse(dr["tungay"].ToString());
DateTime dt2 = DateTime.Parse(dr["denngay"].ToString());
QuaTrinhCongTacDTO qt = new QuaTrinhCongTacDTO(
Convert.ToInt32(dr["manhanvien"].ToString()),
dt.ToString("dd/MM/yyyy"),
dt2.ToString("dd/MM/yyyy"),
dr["noicongtac"].ToString(),
dr["chucvu"].ToString()
);
ds.Add(qt);
}
KetNoiCSDL.DongKetNoi();
return(ds);
}
public bool ThemQuaTrinhCongTac(int maNhanVien, string tuNgay, string denNgay, string noiCongTac, string chucvu)
{
try
{
KetNoiCSDL.MoKetNoi();
string sqlInsert = "insert into QuaTrinhCongTac values(@maNV,@tuNgay,@denNgay, @noict, @chucvu)";
SqlCommand cmd = new SqlCommand(sqlInsert, KetNoiCSDL.KetNoi);
cmd.Parameters.Add("maNV", maNhanVien);
cmd.Parameters.Add("tuNgay", tuNgay);
cmd.Parameters.Add("denNgay", denNgay);
cmd.Parameters.Add("noict", noiCongTac);
cmd.Parameters.Add("chucvu", chucvu);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
KetNoiCSDL.DongKetNoi();
}
}
public DataTable LayThongTinTrinhDoNNGopNN()
{
DataTable dtTrinhDo = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select ngoaingu from trinhdongoaingu group by ngoaingu";
SqlDataAdapter daTrinhDo = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daTrinhDo.Fill(dtTrinhDo);
KetNoiCSDL.DongKetNoi();
return(dtTrinhDo);
}
public DataTable LayThongTinTrinhDoCHuyenMongopLHDT()
{
DataTable dtTrinhDo = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select loaihinhdaotao from trinhdochuyenmon group by loaihinhdaotao";
SqlDataAdapter daTrinhDo = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daTrinhDo.Fill(dtTrinhDo);
KetNoiCSDL.DongKetNoi();
return(dtTrinhDo);
}
public DataTable LayThongTinHoSo()
{
DataTable dtHoSo = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select manhanvien, hodem,TenDem, ngaysinh, gioitinh, sodienthoai, email, ngaytuyendung, phongban.tenphongban from " +
"phongban inner join hoso on phongban.maphongban=hoso.maphongban ";
SqlDataAdapter daHoSo = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daHoSo.Fill(dtHoSo);
KetNoiCSDL.DongKetNoi();
return(dtHoSo);
}
public DataTable LayThongTinTrinhDoNN()
{
DataTable dtTrinhDo = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select trinhdongoaingu.manhanvien, hodem,TenDem, ngoaingu, trinhdo from " +
"trinhdongoaingu inner join hoso on trinhdongoaingu.manhanvien=hoso.manhanvien ";
SqlDataAdapter daTrinhDo = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daTrinhDo.Fill(dtTrinhDo);
KetNoiCSDL.DongKetNoi();
return(dtTrinhDo);
}
public DataTable LayThongTinTrinhDoCHuyenMonGopMa()
{
DataTable dtTrinhDo = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select trinhdochuyenmon.manhanvien from " +
"trinhdochuyenmon inner join hoso on trinhdochuyenmon.manhanvien=hoso.manhanvien group by trinhdochuyenmon.manhanvien";
SqlDataAdapter daTrinhDo = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daTrinhDo.Fill(dtTrinhDo);
KetNoiCSDL.DongKetNoi();
return(dtTrinhDo);
}
public DataTable LayThongTinnganhtheoMa(int maNV)
{
DataTable dtTrinhDoCM = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select nganh from trinhdochuyenmon inner join hoso on trinhdochuyenmon.manhanvien=hoso.manhanvien where hoso.manhanvien=@ma ";
SqlDataAdapter daTrinhDoCM = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daTrinhDoCM.SelectCommand.Parameters.AddWithValue("ma", maNV);
daTrinhDoCM.Fill(dtTrinhDoCM);
KetNoiCSDL.DongKetNoi();
return(dtTrinhDoCM);
}
public DataTable LayThongTinTrinhDoCHuyenMon()
{
DataTable dtTrinhDo = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select trinhdochuyenmon.manhanvien, hodem,TenDem, nganh, trinhdo, loaihinhdaotao, truongdaotao from " +
"trinhdochuyenmon inner join hoso on trinhdochuyenmon.manhanvien=hoso.manhanvien ";
SqlDataAdapter daTrinhDo = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daTrinhDo.Fill(dtTrinhDo);
KetNoiCSDL.DongKetNoi();
return(dtTrinhDo);
}
public DataTable layThongTinHoSoTheoMaNV(int MaNV)
{
DataTable dtHoSo = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select manhanvien, hodem,TenDem, ngaysinh, gioitinh, sodienthoai, email, ngaytuyendung, phongban.tenphongban from " +
"phongban inner join hoso on phongban.maphongban=hoso.maphongban where manhanvien=@ma";
SqlDataAdapter daHoSo = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daHoSo.SelectCommand.Parameters.AddWithValue("ma", MaNV);
daHoSo.Fill(dtHoSo);
KetNoiCSDL.DongKetNoi();
return(dtHoSo);
}
public DataTable LayThongTinTrinhDoNNtheoMa(int maNV)
{
DataTable dtTrinhDoNN = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select trinhdongoaingu.manhanvien, hodem,TenDem, ngoaingu, trinhdo from " +
"trinhdongoaingu inner join hoso on trinhdongoaingu.manhanvien=hoso.manhanvien where trinhdongoaingu.manhanvien=@ma";
SqlDataAdapter daTrinhDoCM = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daTrinhDoCM.SelectCommand.Parameters.AddWithValue("ma", maNV);
daTrinhDoCM.Fill(dtTrinhDoNN);
KetNoiCSDL.DongKetNoi();
return(dtTrinhDoNN);
}
public int TongSoHoSo()
{
KetNoiCSDL.MoKetNoi();
string sqlSelectHoSo = "select count(*) as 'tong' from hoso";
SqlCommand cmd = new SqlCommand(sqlSelectHoSo, KetNoiCSDL.KetNoi);
SqlDataReader dr = cmd.ExecuteReader();
int sum = 0;
while (dr.Read())
{
sum += Convert.ToInt32(dr["tong"]);
}
KetNoiCSDL.DongKetNoi();
return(sum);
}
public int LayMaHoSoMoiThem()
{
int ma = -1;
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select max(manhanvien) as 'ma' from hoso";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
ma = Convert.ToInt32(dr["ma"]);
KetNoiCSDL.DongKetNoi();
return(ma);
}
public DataTable LayThongTinNhanVienChucVu()
{
DataTable dtNhanVienChucVu = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select hoso.manhanvien,trim({ fn CONCAT(HoSo.HoDem + ' ', HoSo.TenDem) }) AS TenNhanVien,tenchucvu,phongban.tenphongban,tungay,denngay from " +
"nhanvien_chucvu inner join hoso on nhanvien_chucvu.manhanvien=hoso.manhanvien " +
"inner join phongban on hoso.maphongban=phongban.maphongban " +
"inner join chucvu on chucvu.machucvu=nhanvien_chucvu.machucvu";
SqlDataAdapter daNhanVienChucVu = new SqlDataAdapter(sqlSelect, KetNoiCSDL.KetNoi);
daNhanVienChucVu.Fill(dtNhanVienChucVu);
KetNoiCSDL.DongKetNoi();
return(dtNhanVienChucVu);
}
public DataTable LayThongTinQuaTrinhCongTac()
{
DataTable dtQuaTrinhCongTac = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlselect = "select QuaTrinhCongTac.MaNhanVien,{ fn concat(hodem + ' ',TenDem) } as 'Hoten', " +
"QuaTrinhCongTac.TuNgay, QuaTrinhCongTac.DenNgay, QuaTrinhCongTac.NoiCongTac," +
" QuaTrinhCongTac.ChucVu from QuaTrinhCongTac" +
" inner join HoSo on QuaTrinhCongTac.MaNhanVien=HoSo.MaNhanVien";
SqlDataAdapter adQuaTrinhCongTac = new SqlDataAdapter(sqlselect, KetNoiCSDL.KetNoi);
adQuaTrinhCongTac.Fill(dtQuaTrinhCongTac);
KetNoiCSDL.DongKetNoi();
return(dtQuaTrinhCongTac);
}
public DataTable LayThongTinQuaTrinhCongTacTheoMaNV(int maNV)
{
DataTable dtQuaTrinhCongTac = new DataTable();
KetNoiCSDL.MoKetNoi();
string sqlselect = "select QuaTrinhCongTac.MaNhanVien,{ fn concat(hodem + ' ',TenDem) } as 'Hoten', " +
"QuaTrinhCongTac.TuNgay, QuaTrinhCongTac.DenNgay, QuaTrinhCongTac.NoiCongTac," +
" QuaTrinhCongTac.ChucVu from QuaTrinhCongTac" +
" inner join HoSo on QuaTrinhCongTac.MaNhanVien=HoSo.MaNhanVien where QuaTrinhCongTac.MaNhanVien=@ma";
SqlDataAdapter adQuaTrinhCongTac = new SqlDataAdapter(sqlselect, KetNoiCSDL.KetNoi);
adQuaTrinhCongTac.SelectCommand.Parameters.AddWithValue("ma", maNV);
adQuaTrinhCongTac.Fill(dtQuaTrinhCongTac);
KetNoiCSDL.DongKetNoi();
return(dtQuaTrinhCongTac);
}
public List <TrinhDoChuyenMonDTO> DemTrinhDoTheoTen()
{
List <TrinhDoChuyenMonDTO> ds = new List <TrinhDoChuyenMonDTO>();
KetNoiCSDL.MoKetNoi();
string sqlSelect = "select trinhdo,count(*) as 'tong' from trinhdochuyenmon group by TrinhDo";
SqlCommand cmd = new SqlCommand(sqlSelect, KetNoiCSDL.KetNoi);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
TrinhDoChuyenMonDTO cm = new TrinhDoChuyenMonDTO(dr["trinhdo"].ToString(), Convert.ToInt32(dr["tong"]));
ds.Add(cm);
}
KetNoiCSDL.DongKetNoi();
return(ds);
}
