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