public List <DTO_SPRT_GigType> GetGigTypeByCategoryID(DTO_SPRT_GigType request)
{
List <DTO_SPRT_GigType> results = new List <DTO_SPRT_GigType>();
GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection();
var list = context.proc_GetGigTypes().Where(gt => gt.CategoryID == request.CategoryID).ToList();
foreach (var entity in list)
{
results.Add(new DTO_SPRT_GigType(entity.typeid, entity.TypeName));
}
return(results);
}
public List <DTO_SPRT_GigType> GetGigs(DTO_SPRT_GigType request)
{
List <DTO_SPRT_GigType> results = new List <DTO_SPRT_GigType>();
using (DB_connection context = new GigALoan_DAL.DB_connection())
{
var list = context.proc_GetGigTypes().ToList();
foreach (var entity in list)
{
results.Add(new DTO_SPRT_GigType(entity.typeid, entity.TypeName));
}
return(results);
}
}
public List <DTO_SPRT_GigType> GetGigTypeByID(DTO_SPRT_GigType request)
{
GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection();
var returnObject = new List <DTO_SPRT_GigType>();
var gigType = context.proc_GetGigTypes().Where(gt => gt.typeid == request.TypeID).Single();
if (gigType != null)
{
DTO_SPRT_GigType result = new DTO_SPRT_GigType(gigType.typeid, gigType.TypeName);
returnObject.Add(result);
}
return(returnObject);
}
public static List <DTO_CORE_Student> GetStudentsBySkillID(DTO_SPRT_GigType request)
{
GigALoan_DAL.DB_connection context = new GigALoan_DAL.DB_connection();
List <DTO_CORE_Student> results = new List <DTO_CORE_Student>();
var students = context.CORE_Students.Where(s => s.SPRT_GigTypes.Any(gt => gt.TypeID == request.TypeID));
foreach (var student in students)
{
results.Add(new DTO_CORE_Student
{
StudentID = student.StudentID
});
}
return(results);
}
