/// <summary> /// ค้นหาข้อมูลของ นักศึกษา หรือ บุคลากร จากฐานข้อมูลทะเบียนของมหาวิทยาลัย /// AD_DETAIL /// </summary> /// <param name="username"></param> /// <returns></returns> public PSUUserInfo GetProfile(string username) { //throw new NotImplementedException(); //algorithm //do get PSU User from Oracle Database (Staff and Student) //throw new NotImplementedException(); var adapter = new Regist2005NewTableAdapters.V_LC_AD_DETAIL_COMPLETETableAdapter(); var user = adapter.GetDataByUsername(username).FirstOrDefault(); if (user == null) { return(null); } //after get PSU User then assign to class PSUUser string campusCode = user.CAMPUS_ID; string facultyCode = user.FAC_ID; string departmentCode = user.DEPT_ID; string majorCode = user.MAJOR_ID; PSUUserInfo profile = PSUUserInfo.Create(username, campusCode, facultyCode, departmentCode, majorCode, false); //assign other value profile.StaffCode = user.STAFF_ID; profile.CitizenID = user.CITIZEN_ID; profile.Email = user.EMAIL; profile.DistinguishedName = string.Empty; profile.Gender = Gender.Unmatch; profile.FirstName = user.NAME_THAI; profile.LastName = user.SNAME_THAI; return(profile); }
public IEnumerable <PSUUserInfo> GetProfileByCamp(string campusCode) { Regist2005NewTableAdapters.V_LC_AD_DETAIL_COMPLETETableAdapter tadapter = new Regist2005NewTableAdapters.V_LC_AD_DETAIL_COMPLETETableAdapter(); return(userinfoConverter(tadapter.GetDataByCampusID(campusCode).ToList())); }
public IEnumerable <PSUUserInfo> GetProfileByDept(string departmentCode) { Regist2005NewTableAdapters.V_LC_AD_DETAIL_COMPLETETableAdapter tadapter = new Regist2005NewTableAdapters.V_LC_AD_DETAIL_COMPLETETableAdapter(); return(userinfoConverter(tadapter.GetDataByDeptID(departmentCode).ToList())); }
public IEnumerable <PSUUserInfo> GetProfiles() { Regist2005NewTableAdapters.V_LC_AD_DETAIL_COMPLETETableAdapter tadapter = new Regist2005NewTableAdapters.V_LC_AD_DETAIL_COMPLETETableAdapter(); return(userinfoConverter(tadapter.GetData().ToList())); }