public List <SchedulersObjects> GetJoin()
{
List <SchedulersObjects> lst = new List <SchedulersObjects>();
var db = new eTrainingScheduleEntities();
var list = db.sp_Schedulers_Join();
foreach (var item in list)
{
SchedulersObjects ob = new SchedulersObjects();
ob.ScId = item.ScId; ob.WeId = item.WeId; ob.ShiftId = item.ShiftId; ob.CoId = item.CoId; ob.Description = item.DescriptionSchedulers;
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 == true,
TotalNumber = item.TotalNumber
};
ob.ShiftDayJoin = new ShiftDayObjects()
{
Description = item.DescriptionShift,
ShiftId = (Guid)item.ShiftId,
ShiftName = item.ShiftName
};
ob.WeekdaysJoin = new WeekdaysObjects()
{
Description = item.DescriptionWeekday,
WeId = (Guid)item.WeId,
WeName = item.WeName
};
lst.Add(ob);
}
return(lst);
}
