public CoursesJournalObjects GetByCJId(Guid ob) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_CoursesJournal_GetByCJId(ob); foreach (var item in list) { CoursesJournalObjects obj = new CoursesJournalObjects(); obj.CJId = item.CJId; obj.CoId = item.CoId; obj.DayOf = item.DayOf; obj.Contents = item.Contents; obj.Description = item.Description; return(obj); } return(null); }