public List <CoursesStudentDetailtObject> GetByCJId(Guid CJId) { List <CoursesStudentDetailtObject> lst = new List <CoursesStudentDetailtObject>(); var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_CoursesStudentDetailt_GetByCJId(CJId); foreach (var item in list) { CoursesStudentDetailtObject ob = new CoursesStudentDetailtObject(); ob.ScsId = item.ScsId; ob.StudetId = item.StudetId; ob.CJId = item.CJId; ob.Description = item.Description_CoursesStudentDetailt; ob.CoursesJournalJoin = new CoursesJournalObjects() { CoId = item.CoId, CJId = item.CJId, Contents = item.Contents, DayOf = item.DayOf, Description = item.Description_CoursesJournal }; ob.StudentJoin = new StudentObjects() { Address = item.Address, Deleted = item.Deleted, Email = item.Email, FullName = item.FullName, Mobile = item.Mobile, Status = item.Status.GetValueOrDefault(), StudetId = (Guid)item.StudetId }; lst.Add(ob); } return(lst); }
public CoursesStudentDetailtObject GetByCJId(Guid ID) { var db = new eTrainingScheduleEntities(); var list = db.sp_tbl_S07_CoursesStudentDetailt_GetByCJId(ID); CoursesStudentDetailtObject obj = new CoursesStudentDetailtObject(); foreach (var item in list) { obj.ScsId = item.ScsId; obj.StudetId = item.StudetId; obj.CJId = item.CJId; obj.Description = item.Description; } return(obj); }