static Assignment GetFromSO(ConfigurationContext config) { using (var cmd = new Assignment_Load_p()) { cmd.Parameters.Assignment_id = 99; using (var sm = new SqlConnectionManager()) using (var dr = sm.ExecuteReader(cmd, config)) { var data = AssignmentInfoAssembler.CreateList(dr)[0]; return new Assignment { Assignment_id = data.Assignment_id, AssignmentType = (AssignmentType)Enum.Parse(typeof(AssignmentType), data.AssignmentTypeCode), Parent_id = data.ParentAssignment_id, Title = data.Title, }; } } }
public BookingContextInfo LoadBookingContextInfo(ScheduledClassInfoList classesInfoList, int student_id, DateTime classUtcDate, DateTime studentBookingBeginUtcDate) { BookingContextInfo result = new BookingContextInfo(); using (SqlConnectionManager cm = new SqlConnectionManager()) { // // Load Student related data // using (var cmd = new Student_Load_p()) { cmd.Parameters.Student_id = student_id; using (SqlDataReader reader = cm.ExecuteReader(cmd, _studentContext)) { result.Student = StudentInfoAssembler.CreateList(reader).First(); } } using (Coupon_LoadCount_p cmd = new Coupon_LoadCount_p()) { cmd.Parameters.Student_id = student_id; using (SqlDataReader reader = cm.ExecuteReader(cmd, _couponContext)) { result.StudentCoupon = CouponCountInfoAssembler.CreateList(reader); } } using (var cmd = new Booking_LoadByStudentDateRange_p()) { cmd.Parameters.Student_id = student_id; cmd.Parameters.BeginDate = studentBookingBeginUtcDate; cmd.Parameters.EndDate = DateTime.MaxValue; using (SqlDataReader reader = cm.ExecuteReader(cmd, _bookingContext)) { result.StudentBookingInfo = new StudentBookingInfoList(BookingInfoAssembler.CreateList(reader)); } } // // Load scheduled class related data // result.ClassesInfoList = classesInfoList; result.BookingInfoListForClasses = new System.Collections.Generic.List<ScheduledClassBookingInfoList>(); foreach (var c in result.ClassesInfoList.ScheduledClass) { using (Booking_LoadByScheduledClass_id_p cmd = new Booking_LoadByScheduledClass_id_p()) { cmd.Parameters.ScheduledClass_id = c.ScheduledClass_id; using (SqlDataReader reader = cm.ExecuteReader(cmd, _scheduledClassContext)) { var bookingList = BookingInfoAssembler.CreateList(reader); result.BookingInfoListForClasses.Add(new ScheduledClassBookingInfoList(c.ScheduledClass_id, bookingList)); } } } } return result; }
public List<Classroom_lkpInfo> LoadClassroomAllWithoutCache() { List<Classroom_lkpInfo> result = null; using(var cm = new SqlConnectionManager()) { using (var cmd = new Classroom_lkp_LoadAll_p()) { using(var reader = cm.ExecuteReader(cmd,_context)) { result = Classroom_lkpInfoAssembler.CreateList(reader); } } } return result; }