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