public List <RegisteredUserInfo> GetRegistrationByCourseID(int course_portal_id) { var query = new List <RegisteredUserInfo>(); try { dev_testEntities dbContext = new dev_testEntities(); //query = (from s in dbContext.u_registration where s.course_portal_id == course_portal_id orderby s.registration_id select s).ToList(); // select u.user_id, u.first_nm, u.last_nm,r.registration_dttm from u_registration as r innerjoin u_user as u on r.userid == u.userid where r.course_portal_id = course_portal_id ; var requery = from r in dbContext.u_registration join u in dbContext.u_user on r.user_id equals u.user_id where r.course_portal_id == course_portal_id select new { u.user_id, u.first_nm, u.last_nm, r.registration_dttm }; //query = (from r in dbContext.u_registration join u in dbContext.u_user on r.user_id equals u.user_id where r.course_portal_id == course_portal_id select new RegisteredUserInfo ( u.user_id, u.first_nm, u.last_nm,r.registration_dttm)).ToList(); foreach (var item in requery) { query.Add(new RegisteredUserInfo(item.user_id, item.first_nm, item.last_nm, item.registration_dttm)); // Console.WriteLine("test" + item.user_id); } } catch (Exception e) { throw new Exception("test"); } return(query); }
public List <u_course_portal> GetCoursesByPortalID(int portal_id) { var query = new List <u_course_portal>(); try { dev_testEntities db = new dev_testEntities(); query = (List <u_course_portal>)(from s in db.u_course_portal where s.portal_id == portal_id orderby s.course_portal_nm select s).ToList(); } catch (Exception e) { //Console.WriteLine("Exception occurred" + e.Message); throw new System.InvalidOperationException("database exception"); } //select cp.course_portal_id, cp.course_portal_nm //from u_course_portal cp //where cp.portal_id = 1-- will show only courses for specific client //orderby cp.course_portal_nm return(query); }