public List <ExpertsDetailtObjects> GetJoin()
{
List <ExpertsDetailtObjects> lst = new List <ExpertsDetailtObjects>();
var db = new eTrainingScheduleEntities();
var list = db.sp_ExpertsDetailt_Join();
foreach (var item in list)
{
ExpertsDetailtObjects ob = new ExpertsDetailtObjects();
ob.ExId = item.ExId; ob.ExpertId = item.ExpertId; ob.CoId = item.CoId; ob.Description = item.DescriptionExpertsDetailt; ob.Createdateed = (DateTime)item.edCreationDate;
ob.CoursesJoin = new CoursesObjects()
{
CoId = (Guid)item.CoId,
CourseId = item.CourseId,
CourseName = item.CourseName,
Deleted = item.DeletedCourses,
Description = item.DescriptionCourses,
EndDate = item.EndDate,
StartDate = item.StartDateCourses,
Status = item.StatusCourses == true,
TotalNumber = item.TotalNumber
};
ob.ExpertsJoin = new ExpertsObjects()
{
Address = item.Address,
Deleted = item.DeletedExperts,
Description = item.DescriptionExperts,
Email = item.Email,
ExpertId = (Guid)item.ExpertId,
FullName = item.FullName,
Mobile = item.Mobile,
Specialize = item.Specialize,
StartDate = item.StartDateExperts,
Status = item.StatusExperts == true,
};
lst.Add(ob);
}
return(lst);
}
