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);
}
