public List <ProfileModel> GetListProfileAndRecognitionStatusBy(List <string> StarsIdList = null) { List <ProfileModel> lst = new List <ProfileModel>(); using (LBCData context = new LBCData(ConnectionHelper.getConnectionString())) { var list = (from entity in context.LBC_PROFILE where entity.EMP_STATUS_CODE == "A" select entity).ToList(); if (StarsIdList != null) { for (int i = 0; i < StarsIdList.Count(); i++) { var entry = list.Where(q => q.STARS_ID == StarsIdList[i]).FirstOrDefault(); if (entry != null) { lst.Add(MapModelFromLBC_Profile(entry)); } } } else { foreach (LBC_PROFILE item in list) { lst.Add(MapModelFromLBC_Profile(item)); } } } foreach (ProfileModel item in lst) { ProfileRecognitionRepository _recognition = new ProfileRecognitionRepository(); item.recognitionList = _recognition.GetAll(item.STARS_ID); } return(lst); }
public List <ProfileModel> GetListProfileAndRecognitionStatusBy(string dlrRegion) { List <ProfileModel> lst = new List <ProfileModel>(); using (LBCData context = new LBCData(ConnectionHelper.getConnectionString())) { if (string.IsNullOrEmpty(dlrRegion)) { var list = (from entity in context.LBC_PROFILE where entity.EMP_STATUS_CODE == "A" //where entity.DLR_REGION == dlrRegion || string.IsNullOrEmpty(entity.DLR_REGION) select entity).ToList(); foreach (LBC_PROFILE item in list) { lst.Add(MapModelFromLBC_Profile(item)); } } else { var list = (from entity in context.LBC_PROFILE where entity.DLR_REGION == dlrRegion && entity.EMP_STATUS_CODE == "A" select entity).ToList(); foreach (LBC_PROFILE item in list) { lst.Add(MapModelFromLBC_Profile(item)); } } } foreach (ProfileModel item in lst) { ProfileRecognitionRepository _recognition = new ProfileRecognitionRepository(); item.recognitionList = _recognition.GetAll(item.STARS_ID); } return(lst); }