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