Exemplos de eTrainingScheduleEntities.sp_CoursesJournal_Join em C# (CSharp)

Exemplo n.º 1

        public List <CoursesJournalObjects> GetJoin()
        {
            List <CoursesJournalObjects> lst = new List <CoursesJournalObjects>();
            var db   = new eTrainingScheduleEntities();
            var list = db.sp_CoursesJournal_Join();

            foreach (var item in list)
            {
                CoursesJournalObjects ob = new CoursesJournalObjects();
                ob.CJId        = item.CJId; ob.CoId = item.CoId; ob.DayOf = item.DayOf; ob.Contents = item.Contents; ob.Description = item.DescriptionCoursesJournal;
                ob.CoursesJoin = new CoursesObjects()
                {
                    CoId        = (Guid)item.CoId,
                    CourseId    = item.CourseId,
                    CourseName  = item.CourseName,
                    Deleted     = item.Deleted,
                    Description = item.DescriptionCourses,
                    EndDate     = item.EndDate,
                    StartDate   = item.StartDate,
                    Status      = item.Status,
                    TotalNumber = item.TotalNumber
                };
                lst.Add(ob);
            }
            return(lst);
        }