public DataTable GetKeHoachThucHanh(int IDDM_NamHoc, string NamHoc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_PhongHoc_GetKeHoachThucHanhResult>(client.cDDM_PhongHoc_GetKeHoachThucHanh(GlobalVar.MaXacThuc, IDDM_NamHoc, NamHoc)));
}
}
public DataTable GetByIDBoMon(int IDDM_BoMon)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_Khoa_GetByIDBoMonResult>(client.cDDM_Khoa_GetByIDBoMon(GlobalVar.MaXacThuc, IDDM_BoMon)));
}
}
public DataTable GetDanhSach(int IDDM_KhoiKienThuc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_CT_KhoiKienThuc_GetDanhSachResult>(client.cDKQHT_CT_KhoiKienThuc_GetDanhSach(GlobalVar.MaXacThuc, IDDM_KhoiKienThuc)));
}
}
public DataTable Get(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_HT_ThamSoHeThong_GetResult>(client.cDHT_ThamSoHeThong_Get(GlobalVar.MaXacThuc, pHT_ThamSoHeThongInfo)));
}
}
public DataTable GetByPhanHe(int PhanHe)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_HT_ThamSoHeThong_GetByPhanHeResult>(client.cDHT_ThamSoHeThong_GetByPhanHe(GlobalVar.MaXacThuc, PhanHe)));
}
}
public DataTable GetByIDNS_DonVi_ChucDanh(int IDNS_DonVi, int IDDM_NamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_GG_GiaoVien_GetBy_DonVi_ChucDanhResult>(client.cDNS_GiaoVien_GetByIDNS_DonVi_ChucDanh(GlobalVar.MaXacThuc, IDNS_DonVi, IDDM_NamHoc, HocKy)));
}
}
public DataTable GetHoSo(int NS_GiaoVienID)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_GiaoVien_GetHoSoResult>(client.cDNS_GiaoVien_GetHoSo(GlobalVar.MaXacThuc, NS_GiaoVienID)));
}
}
public DataTable GetByUsername(string Username)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_GiaoVien_GetByUserNameResult>(client.cDNS_GiaoVien_GetByUsername(GlobalVar.MaXacThuc, Username)));
}
}
public DataTable Get_QuaTrinhThamGiaTCCTXH(int IDNS_GiaoVien)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_TongHopCacQuaTrinh_Get_QuaTrinhThamGiaTCCTXHResult>(client.cDNS_GiaoVien_Get_QuaTrinhThamGiaTCCTXH(GlobalVar.MaXacThuc, IDNS_GiaoVien)));
}
}
public DataTable GetAll(int GG_HeSoLopDongTheoKhoaID)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_GG_HeSoLopDongTheoKhoa_GetAllResult>(client.cDGG_HeSoLopDongTheoKhoa_GetAll(GlobalVar.MaXacThuc, GG_HeSoLopDongTheoKhoaID)));
}
}
//public DataTable Get(TC_LoaiThuChiInfo pTC_LoaiThuChiInfo)
//{
// using (var client = new UnimOsServiceClient())
// {
// return ConvertList.ToDataTable<TC_LoaiThuChiInfo>(client.cDTC_LoaiThuChi_Get(GlobalVar.MaXacThuc, pTC_LoaiThuChiInfo));
// }
//}
public DataTable GetBy_IDNamHoc_HocKy(int IDNamHoc, int HocKy, bool HasParent)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_TC_LoaiThuChi_GetBy_IDNamHoc_HocKyResult>(client.cDTC_LoaiThuChi_GetBy_IDNamHoc_HocKy(GlobalVar.MaXacThuc, IDNamHoc, HocKy, HasParent)));
}
}
public DataTable GetByTuTuan(int IDNamHoc, int HocKy, int TuTuan)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_Tuan_GetByTuanThuResult>(client.cDXL_Tuan_GetByTuanThu_2(GlobalVar.MaXacThuc, IDNamHoc, HocKy, TuTuan)));
}
}
public DataTable GetByHocKy_NamHoc(int IDNamHoc, int HocKy)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_Tuan_GetByNamHoc_HocKyResult>(client.cDXL_Tuan_GetBy_NamHoc_HocKy(GlobalVar.MaXacThuc, IDNamHoc, HocKy)));
}
}
public DataTable GetByTuanThu(XL_TuanInfo pTuanInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_XL_Tuan_GetByTuanThuResult>(client.cDXL_Tuan_GetByTuanThu(GlobalVar.MaXacThuc, pTuanInfo)));
}
}
public DataTable NangBacChuyenNgach_GetByIDNS_DonVi(int IDNS_DonVi)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_GiaoVien_NangBacChuyenNgach_GetByIDNS_DonViResult>(client.cDNS_GiaoVien_NangBacChuyenNgach_GetByIDNS_DonVi(GlobalVar.MaXacThuc, IDNS_DonVi)));
}
}
public DataTable TimKiem(NS_GiaoVienInfo pNS_GiaoVienInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <NS_GiaoVienInfo>(client.cDNS_GiaoVien_TimKiem(GlobalVar.MaXacThuc, pNS_GiaoVienInfo)));
}
}
public DataTable GetGiaoVien_DangGiangDay_ByIDNS_DonVi(int IDNS_DonVi)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_GiaoVien_DangGiangDay_GetByIDNS_DonViResult>(client.cDNS_GiaoVien_GetGiaoVien_DangGiangDay_ByIDNS_DonVi(GlobalVar.MaXacThuc, IDNS_DonVi)));
}
}
public DataTable GetBaoCaoChatLuongCanBo(DateTime DenNgay)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_GiaoVien_GetBaoCaoChatLuongCanBoResult>(client.cDNS_GiaoVien_GetBaoCaoChatLuongCanBo(GlobalVar.MaXacThuc, DenNgay)));
}
}
public DataTable ChiTietGioGiang(int IDNS_GiaoVien, int NamHoc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <NS_GiaoVienInfo>(client.cDNS_GiaoVien_ChiTietGioGiang(GlobalVar.MaXacThuc, IDNS_GiaoVien, NamHoc)));
}
}
public DataTable UpdateDanhSach(int IDNS_DonVi, string ChuoiNS_GiaoVienID)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <NS_GiaoVienInfo>(client.cDNS_GiaoVien_UpdateDanhSach(GlobalVar.MaXacThuc, IDNS_DonVi, ChuoiNS_GiaoVienID)));
}
}
//public DataTable Get(HT_ReportInfo pReportInfo)
//{
// using (var client = new UnimOsServiceClient())
// {
// return ConvertList.ToDataTable<HT_ReportInfo>(client.cDHT_Report_Get(GlobalVar.MaXacThuc, pReportInfo));
// }
//}
//public void Add(HT_ReportInfo pReportInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDHT_Report_Add(GlobalVar.MaXacThuc, pReportInfo);
// client.Close();
// mErrorMessage = oDHT_Report.ErrorMessages;
// mErrorNumber = oDHT_Report.ErrorNumber;
//}
//public void Update(HT_ReportInfo pReportInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDHT_Report_Update(GlobalVar.MaXacThuc, pReportInfo);
// client.Close();
// mErrorMessage = oDHT_Report.ErrorMessages;
// mErrorNumber = oDHT_Report.ErrorNumber;
//}
//public void Delete(HT_ReportInfo pReportInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDHT_Report_Delete(GlobalVar.MaXacThuc, pReportInfo);
// client.Close();
// mErrorMessage = oDHT_Report.ErrorMessages;
// mErrorNumber = oDHT_Report.ErrorNumber;
//}
//public List<HT_ReportInfo> GetList(HT_ReportInfo pReportInfo)
//{
// List<HT_ReportInfo> oReportInfoList = new List<HT_ReportInfo>();
// DataTable dtb = Get(pReportInfo);
// if (dtb != null)
// {
// for (int i = 0; i < dtb.Rows.Count; i++)
// {
// oReportInfo = new HT_ReportInfo();
// oReportInfo.HT_ReportID = int.Parse(dtb.Rows[i]["HT_ReportID"].ToString());
// oReportInfo.ReportName = dtb.Rows[i]["ReportName"].ToString();
// oReportInfo.Detail = dtb.Rows[i]["Detail"].ToString();
// oReportInfoList.Add(oReportInfo);
// }
// }
// return oReportInfoList.Count == 0 ? null : oReportInfoList;
//}
public bool LoadReport(C1Report c1r, string ReportName, string FolderPath)
{
// Nếu đã có file .xml trong thư mục báo cáo thì load trực tiếp
// Nếu chưa có thì load trong DB sau đó save lại vào thư mục báo cáo
string FullFileName = FolderPath + "\\Template\\" + ReportName + ".xml";
if (!File.Exists(FullFileName))
{
oReportInfo.ReportName = ReportName;
var client = new UnimOsServiceClient();
DataTable dt = ConvertList.ToDataTable <sp_HT_Report_GetByNameResult>(client.cDHT_Report_GetByName(GlobalVar.MaXacThuc, oReportInfo));
client.Close();
if (dt.Rows.Count > 0)
{
string Detail = dt.Rows[0]["Detail"].ToString();
if (Detail != "")
{
try
{
File.WriteAllText(FullFileName, Detail);
}
catch
{
return(false);
}
}
}
}
// Load report từ file
System.Xml.XmlDocument Doc = new System.Xml.XmlDocument();
c1r.Load(FullFileName, ReportName.Trim());
return(true);
}
public DataTable UpdatePassword(int IDNS_GiaoVien, string Password)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <NS_GiaoVienInfo>(client.cDNS_GiaoVien_UpdatePassword(GlobalVar.MaXacThuc, IDNS_GiaoVien, Password)));
}
}
public DataTable GetByMaThamSo(string MaThamSoHeThong)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_HT_ThamSoHeThong_GetByMaThamSoResult>(client.cDHT_ThamSoHeThong_GetByMaThamSo(GlobalVar.MaXacThuc, MaThamSoHeThong)));
}
}
public DataTable LocGiaoVien(int IDNS_GiaoVien, string HoTen)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <NS_GiaoVienInfo>(client.cDNS_GiaoVien_LocGiaoVien(GlobalVar.MaXacThuc, IDNS_GiaoVien, HoTen)));
}
}
public DataTable Get(DM_KhoaInfo pDM_KhoaInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_Khoa_GetResult>(client.cDDM_Khoa_Get(GlobalVar.MaXacThuc, pDM_KhoaInfo)));
}
}
public DataTable Get_CanhBaoHetNhiemKy(int HanCanhBao, DateTime TinhDenNgay)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_GiaoVien_Get_CanhBaoHetNhiemKyResult>(client.cDNS_GiaoVien_Get_CanhBaoHetNhiemKy(GlobalVar.MaXacThuc, HanCanhBao, TinhDenNgay)));
}
}
public DataTable Get(KQHT_CT_KhoiKienThucInfo pKQHT_CT_KhoiKienThucInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <KQHT_CT_KhoiKienThucInfo>(client.cDKQHT_CT_KhoiKienThuc_Get(GlobalVar.MaXacThuc, pKQHT_CT_KhoiKienThucInfo)));
}
}
public DataTable GetForLapTaiKhoan(int IDNS_DonVi, bool ChuaLapTaiKhoan)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_NS_GiaoVien_GetForLapTaiKhoanResult>(client.cDNS_GiaoVien_GetForLapTaiKhoan(GlobalVar.MaXacThuc, IDNS_DonVi, ChuaLapTaiKhoan)));
}
}
public DataTable GetChon(int IDKQHT_ChuongTrinhDaoTao)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_CT_KhoiKienThuc_GetChonResult>(client.cDKQHT_CT_KhoiKienThuc_GetChon(GlobalVar.MaXacThuc, IDKQHT_ChuongTrinhDaoTao)));
}
}
public DataTable GetChon(int IDToaNha, string mPhongHoc)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_PhongHoc_GetChonResult>(client.cDDM_PhongHoc_GetChon(GlobalVar.MaXacThuc, IDToaNha, mPhongHoc)));
}
}
