public IEnumerable<NGANH_LstResult> NGANH_Lst() { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.NGANH_Lst().ToList(); } } catch (Exception e) { return null; } }
public KHOI_UpdResult KHOI_Upd(System.Xml.Linq.XElement xmlData) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.KHOI_Upd(xmlData).FirstOrDefault(); } } catch (Exception e) { return new KHOI_UpdResult() { errorDesc = e.Message, result = "-1" }; } }
public IEnumerable<TL_USER_SearchResult> TL_USER_Search(TL_USER_SearchResult data, int? top) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_USER_Search(data.userID, data.userName, data.password, data.userFullName, data.roleID, data.email, data.address, data.phone, data.birthday == null ? null : data.birthday.Value.ToString(CommonClass.Constants.FormatDate), top).ToList(); } } catch (Exception e) { return new List<TL_USER_SearchResult>(); } }
public TL_USER_UpdResult TL_USER_Upd(TL_USER_SearchResult data) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_USER_Upd(data.userID, data.userName, MD5Code.GetMd5Hash( data.password), data.userFullName, data.roleID, data.email, data.address, data.phone, data.birthday == null ? null : data.birthday.Value.ToString(CommonClass.Constants.FormatDate)).FirstOrDefault(); } } catch (Exception e) { return new TL_USER_UpdResult() { USERID = "", RESULT = "-1", ERRORDESC = e.Message }; } }
public TL_USER_DelResult TL_USER_Del(string userID) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_USER_Del(userID).FirstOrDefault(); } } catch (Exception e) { return new TL_USER_DelResult() { RESULT = "-1", ERRORDESC = e.Message }; } }
public IEnumerable<KHOI_SearchResult> KHOI_Search(KHOI_SearchResult data, int? top) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.KHOI_Search(data.maKhoi, data.maXKhoi, data.tenKhoi, data.maNguoiLap, data.thoiGianLap == null ? "" : data.thoiGianLap.Value.ToString(Constants.FormatDate), data.maNguoiDuyet, data.thoiGianDuyet == null ? "" : data.thoiGianDuyet.Value.ToString(Constants.FormatDate), data.maTrangThaiDuyet, data.trangThaiDuLieu, top).ToList(); } } catch (Exception e) { return null; } }
public IEnumerable<TL_MENU_LstResult> TL_MENU_Lst() { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_MENU_Lst().ToList(); } } catch (Exception e) { return new List<TL_MENU_LstResult>(); } }
public IEnumerable<TL_MENU_ByIdResult> TL_MENU_ById(int? menuID) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_MENU_ById(menuID).ToList(); } } catch (Exception e) { return null; } }
public TL_MENU_UpdResult TL_MENU_Upd(TL_MENU_SearchResult data) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_MENU_Upd(data.menuID, data.menuName, data.menuNameEL, data.menuParentID, data.menuLink, data.menuNumber, data.menuIcon, data.menuLevel).FirstOrDefault(); } } catch (Exception e) { return new TL_MENU_UpdResult() { MENUID = null, RESULT = "-1", ERRORDESC = e.Message }; } }
public SigninData TL_USER_GetSiginData(string userName, string password, bool isCheckPass) { try { using (var db = new OOAD_EDUManagementDataContext()) { password = MD5Code.GetMd5Hash(password); TL_USER_SearchResult currentUser = null; if(isCheckPass) currentUser = db.TL_USER_Search(null, userName, null, null, null, null, null, null, null, 1).FirstOrDefault(); else currentUser = db.TL_USER_Search(null, userName, password, null, null, null, null, null, null, 1).FirstOrDefault(); if (currentUser == null) return new SigninData() { IsPasswordCorrect = false, Roles = null, User = null }; SigninData signinData = new SigninData(); signinData.IsPasswordCorrect = true; signinData.User = currentUser; signinData.Roles = db.TL_SYS_ROLE_DETAIL_LstOnRoleID(currentUser.roleID).ToList(); return signinData; } } catch (Exception e) { return null; } }
public TL_MENU_DelResult TL_MENU_Del(int? menuID) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_MENU_Del(menuID).FirstOrDefault(); } } catch (Exception e) { return null; } }
public BIEN_BAN_CHAM_THI_DelResult BIEN_BAN_CHAM_THI_Del(string maMon, string maThiSinh) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.BIEN_BAN_CHAM_THI_Del(maMon, maThiSinh).FirstOrDefault(); } } catch (Exception e) { return new BIEN_BAN_CHAM_THI_DelResult() { ERRORDESC = e.Message, RESULT = "-1" }; } }
public THI_SINH_InsResult THI_SINH_Ins(THI_SINH_SearchResult data) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.THI_SINH_Ins(data.SBD, data.suDungDeThiChung, data.duThiLienThong, data.maChuyenNganh, data.maCumThi, data.maDoiTuongUuTien, data.maDonViDKDT, data.maDotTuyenSinh, data.maKhoi, data.maKhuVuc, data.maNganh, data.maPhong, data.maQuan_HuyenThuongTru, data.maTinhLop10, data.maTinhLop11, data.maTinhLop12, data.maTinh_TPThuongTru, data.maTruongLop10, data.maTruongLop11, data.maTruongLop12, data.maTruongThi, data.maMonDoatGiai, data.kiThiGiai, data.loaiGiai_HuyChuong, data.CMND_HoChieu, data.diaChiNhan_KQ, data.email, data.maGioiTinh, data.hoChuLot, data.hoKhau, data.maDanToc, data.maQuocTich, data.nam_TN_THPT, data.diem_TN_THPT, data.loai_TN_THPT, data.nam_TN_TCN_CD, data.truong_TN_TCN_CD, data.ngaySinh == null ? "" : data.ngaySinh.Value.ToString(Constants.FormatDate), data.noiSinh, data.soDienThoai, data.ten, data.anhHoSo, data.maNguoiLap, data.thoiGianLap == null ? "" : data.thoiGianLap.Value.ToString(Constants.FormatDate), data.maNguoiDuyet, data.thoiGianDuyet == null ? "" : data.thoiGianDuyet.Value.ToString(Constants.FormatDate), data.maTrangThaiDuyet, data.trangThaiDuLieu).FirstOrDefault(); } } catch (Exception e) { return new THI_SINH_InsResult() { RESULT = "-1", ERRORDESC = e.Message }; } }
public IEnumerable<KET_QUA_THI_SearchResult> KET_QUA_THI_Search(KET_QUA_THI_SearchResult data, int? top) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.KET_QUA_THI_Search(data.maKetQuaThi, data.maXKetQuaThi, data.maThiSinh, data.maMon, data.maTui, data.maPhach, data.tinhTrang, data.diemThi, data.diemPhucKhao, data.maNguoiLap, data.thoiGianLap == null ? "" : data.thoiGianLap.Value.ToString(Constants.FormatDate), data.maNguoiDuyet, data.thoiGianDuyet == null ? "" : data.thoiGianDuyet.Value.ToString(Constants.FormatDate), data.maTrangThaiDuyet, data.trangThaiDuLieu, top).ToList(); } } catch (Exception e) { return null; } }
public IEnumerable<TL_SYS_ROLE_SearchResult> TL_SYS_ROLE_Search(TL_SYS_ROLE_SearchResult data, int? top) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_SYS_ROLE_Search(data.roleID, data.roleDesc, top).ToList(); } } catch (Exception e) { return new List<TL_SYS_ROLE_SearchResult>(); } }
public KET_QUA_THI_UpdOnMaThiSinhResult KET_QUA_THI_UpdOnMaThiSinh(string maThiSinh, XElement xmlData) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.KET_QUA_THI_UpdOnMaThiSinh(maThiSinh, xmlData).FirstOrDefault(); } } catch (Exception e) { return new KET_QUA_THI_UpdOnMaThiSinhResult() { ERRORDESC = e.Message, RESULT = "-1" }; } }
public KET_QUA_THI_InsResult KET_QUA_THI_Ins(KET_QUA_THI_SearchResult data) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.KET_QUA_THI_Ins(data.maXKetQuaThi, data.maThiSinh, data.maMon, data.maTui, data.maPhach, data.tinhTrang, data.diemThi, data.diemPhucKhao, data.maNguoiLap, data.thoiGianLap == null ? "" : data.thoiGianLap.Value.ToString(Constants.FormatDate), data.maNguoiDuyet, data.thoiGianDuyet == null ? "" : data.thoiGianDuyet.Value.ToString(Constants.FormatDate), data.maTrangThaiDuyet, data.trangThaiDuLieu).FirstOrDefault(); } } catch (Exception e) { return new KET_QUA_THI_InsResult() { ERRORDESC = e.Message, MAKETQUATHI = "", RESULT = "-1" }; } }
public IEnumerable<DonTuiDanhPhach_GetListResult> DonTuiDanhPhach_GetList(string maDotTuyenSinh) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.DonTuiDanhPhach_GetList(maDotTuyenSinh).ToList(); } } catch (Exception e) { return null; } }
public DonTuiDanhPhachResult DonTuiDanhPhach(string maDotTuyenSinh, int soMon, int soPhong, int soBaiThi) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.DonTuiDanhPhach(maDotTuyenSinh, soMon, soPhong, soBaiThi).FirstOrDefault(); } } catch (Exception e) { return new DonTuiDanhPhachResult() { ErrorDesc = e.Message, Result = "-1" }; } }
public BIEN_BAN_CHAM_THI_UpdResult BIEN_BAN_CHAM_THI_Upd(XElement xmlData) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.BIEN_BAN_CHAM_THI_Upd(xmlData).FirstOrDefault(); } } catch (Exception e) { return new BIEN_BAN_CHAM_THI_UpdResult() { errorDesc = e.Message, result = "-1" }; } }
public IEnumerable<TL_MENU_SearchResult> TL_MENU_Search(TL_MENU_SearchResult data, int? top) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_MENU_Search( data.menuName, data.menuNameEL, data.menuParentID, data.menuLink, data.menuNumber, data.menuIcon, data.menuLevel, top).ToList(); } } catch (Exception e) { return new List<TL_MENU_SearchResult>(); } }
public IEnumerable<HINH_THUC_TUYEN_SINH_SearchResult> HINH_THUC_TUYEN_SINH_Search(HINH_THUC_TUYEN_SINH_SearchResult data, int? top) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.HINH_THUC_TUYEN_SINH_Search(data.maHinhThucTuyenSinh, data.maXHinhThucTuyenSinh, data.tenHinhThucTuyenSinh, data.maNguoiLap, data.thoiGianLap == null ? "" : data.thoiGianLap.Value.ToString(Constants.FormatDate), data.maNguoiDuyet, data.thoiGianDuyet == null ? "" : data.thoiGianDuyet.Value.ToString(Constants.FormatDate), data.maTrangThaiDuyet, data.trangThaiDuLieu, top).ToList(); } } catch (Exception e) { return null; } }
public TL_SYS_ROLE_UpdResult TL_SYS_ROLE_Upd(TL_SYS_ROLE_SearchResult data, System.Xml.Linq.XElement xmlData) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_SYS_ROLE_Upd(data.roleID, data.roleDesc, xmlData).FirstOrDefault(); } } catch (Exception e) { return new TL_SYS_ROLE_UpdResult() { ROLEID="" ,RESULT = "-1", ERRORDESC = e.Message }; } }
public IEnumerable<BIEN_BAN_CHAM_THI_SearchResult> BIEN_BAN_CHAM_THI_Search(BIEN_BAN_CHAM_THI_SearchResult data, int? top) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.BIEN_BAN_CHAM_THI_Search(data.maGiamKhao, data.SBD, data.maMon, data.namTuyenSinh, top).ToList(); } } catch (Exception e) { return null; } }
public IEnumerable<TL_SYS_ROLE_DETAIL_LstOnRoleIDResult> TL_SYS_ROLE_DETAIL_LstOnRoleID(string roleID) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_SYS_ROLE_DETAIL_LstOnRoleID(roleID).ToList(); } } catch (Exception e) { return new List<TL_SYS_ROLE_DETAIL_LstOnRoleIDResult>(); } }
public HINH_THUC_TUYEN_SINH_UpdResult HINH_THUC_TUYEN_SINH_Upd(XElement xmlData) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.HINH_THUC_TUYEN_SINH_Upd(xmlData).FirstOrDefault(); } } catch (Exception e) { return new HINH_THUC_TUYEN_SINH_UpdResult() { errorDesc = e.Message, result = "-1" }; } }
public IEnumerable<NHAN_SU_SearchResult> NHAN_SU_Search(NHAN_SU_SearchResult data, int? top) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.NHAN_SU_Search(data.maNhanSu, data.maXNhanSu, data.hoVaTen, data.CMND, data.diaChi, data.email, data.ngaySinh == null ? "" : data.ngaySinh.Value.ToString(Constants.FormatDate), data.noiCongTac, data.noiSinh, data.soDienThoai, data.maNguoiLap, data.thoiGianLap == null ? "" : data.thoiGianLap.Value.ToString(Constants.FormatDate), data.maNguoiDuyet, data.thoiGianDuyet == null ? "" : data.thoiGianDuyet.Value.ToString(Constants.FormatDate), data.maTrangThaiDuyet, data.trangThaiDuLieu, top).ToList(); } } catch (Exception e) { return null; } }
public IEnumerable<NGUYEN_VONG_SearchResult> NGUYEN_VONG_Search(NGUYEN_VONG_SearchResult data, int? top) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.NGUYEN_VONG_Search(data.maNguyenVong, data.maXNguyenVong, data.tenNguyenVong, data.doUuTien, data.maNguoiLap, data.thoiGianLap == null ? "" : data.thoiGianLap.Value.ToString(Constants.FormatDate), data.maNguoiDuyet, data.thoiGianDuyet == null ? "" : data.thoiGianDuyet.Value.ToString(Constants.FormatDate), data.maTrangThaiDuyet, data.trangThaiDuLieu, top).ToList(); } } catch (Exception e) { return null; } }
public TL_USER_ByIdResult TL_USER_ById(string userID) { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.TL_USER_ById(userID).FirstOrDefault(); } } catch (Exception e) { return null; } }
public IEnumerable<THI_SINH_LstExamResult> THI_SINH_LstExam() { try { using (var db = new OOAD_EDUManagementDataContext()) { return db.THI_SINH_LstExam().ToList(); } } catch (Exception e) { return null; } }