public List <StudentDetailtObjects> GetJoin()
{
List <StudentDetailtObjects> lst = new List <StudentDetailtObjects>();
var db = new eTrainingScheduleEntities();
var list = db.sp_StudentDetailt_Join();
foreach (var item in list)
{
if (item.DeletedStudent == true || item.DeletedCourses == true)
{
continue;
}
StudentDetailtObjects ob = new StudentDetailtObjects();
ob.StdId = item.StdId;
ob.StudetId = item.StudetId;
ob.CoId = item.CoId;
ob.Description = item.DescriptionStudent;
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.StartDate,
Status = item.StatusCourses,
TotalNumber = item.TotalNumber
};
ob.StudentJoin = new StudentObjects()
{
Address = item.Address,
Deleted = item.DeletedStudent,
Email = item.Email,
FullName = item.FullName,
Mobile = item.Mobile,
Status = item.StatusStudent,
StudetId = (Guid)item.StudetId
};
lst.Add(ob);
}
return(lst);
}
public List <StudentDetailtObjects> GetJoin()
{
List <StudentDetailtObjects> lst = new List <StudentDetailtObjects>();
var db = new eTrainingScheduleEntities();
var list = db.sp_StudentDetailt_Join();
foreach (var item in list)
{
StudentDetailtObjects ob = new StudentDetailtObjects();
ob.StdId = item.StdId;
ob.StudetId = item.StudetId;
ob.CoId = item.CoId;
ob.Description = item.DescriptionStudent;
ob.StatusSC = (bool)item.StatusSC;
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.StartDate,
Status = item.StatusCourses == true,
TotalNumber = item.TotalNumber
};
ob.StudentJoin = new StudentObjects()
{
Address = item.Address,
Deleted = item.DeletedStudent,
Email = new SecurityConexts().DecryptInfo(item.Email),
Mobile = new SecurityConexts().DecryptInfo(item.Mobile),
FullName = item.FullName,
Status = item.StatusStudent.Value,
StudetId = (Guid)item.StudetId
};
lst.Add(ob);
}
return(lst);
}
