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