public List <Opportunity> GetAllOpportunities() { try { List <Opportunity> listOpportunities = new List <Opportunity>(); Opportunity opportunity = null; var read = _repositoryConnection.SearchCommand("GetAllOpportunities", parameters); DataTable dataTable = JsonConvert.DeserializeObject <DataTable>(read); foreach (DataRow row in dataTable.Rows) { opportunity = new Opportunity(); opportunity.OpportunityId = Convert.ToInt32(row["OpportunityId"]); opportunity.OpportunityName = row["OpportunityName"].ToString(); opportunity.OpportunityRequirements = row["OpportunityRequirements"].ToString(); opportunity.DesirableRequirements = row["DesirableRequirements"].ToString(); opportunity.DateRegister = Convert.ToDateTime(row["DateRegister"]); opportunity.ClosingDate = Convert.ToDateTime(row["ClosingDate"]); opportunity.CancellationDate = Convert.ToDateTime(row["CancellationDate"]); opportunity.OpportunityStatus = Convert.ToBoolean(row["OpportunityStatus"]); opportunity.Career = new Career(); opportunity.Career.CareerId = Convert.ToInt32(row["CareerId"]); opportunity.Career = _careerRepository.GetCareerById(opportunity.Career.CareerId); opportunity.Service = new Service(); opportunity.Service.ServiceId = Convert.ToInt32(row["ServiceId"]); opportunity.Service = _serviceRepository.GetServiceById(opportunity.Service.ServiceId); opportunity.ProfessionalLevel = new ProfessionalLevel(); opportunity.ProfessionalLevel.ProfessionalLevelId = Convert.ToInt32(row["ProfessionalLevelId"]); opportunity.ProfessionalLevel = _professionalLevelRepository.GetProfessionalLevelById(opportunity.ProfessionalLevel.ProfessionalLevelId); opportunity.OpportunityType = new OpportunityType(); opportunity.OpportunityType.OpportunityTypeId = Convert.ToInt32(row["OpportunityTypeId"]); opportunity.OpportunityType = _opportunityTypeRepository.GetOpportunityTypeById(opportunity.OpportunityType.OpportunityTypeId); listOpportunities.Add(opportunity); } return(listOpportunities); } catch (Exception ex) { throw ex; } }
public List <VacationOpportunity> GetAllVacationOpportunities() { try { List <VacationOpportunity> listVacationOpportunities = new List <VacationOpportunity>(); VacationOpportunity vacationOpportunity = null; var read = _repositoryConnection.SearchCommand("GetAllVacationOpportunities", parameters); DataTable dataTable = JsonConvert.DeserializeObject <DataTable>(read); foreach (DataRow row in dataTable.Rows) { vacationOpportunity = new VacationOpportunity(); vacationOpportunity.VacationOpportunityId = Convert.ToInt32(row["VacationOpportunityId"]); vacationOpportunity.VacationOpeningNumber = row["VacationOpeningNumber"].ToString(); vacationOpportunity.VacationOpeningDate = Convert.ToDateTime(row["VacationOpeningDate"]); vacationOpportunity.VacationOfferLetterDate = Convert.ToDateTime(row["VacationOfferLetterDate"]); vacationOpportunity.VacationLeader = row["VacationLeader"].ToString(); vacationOpportunity.VacationCancellationDate = Convert.ToDateTime(row["VacationCancellationDate"]); vacationOpportunity.VacationOpportunityStatus = Convert.ToBoolean(row["VacationOpportunityStatus"]); vacationOpportunity.Career = new Career(); vacationOpportunity.Career.CareerId = Convert.ToInt32(row["CareerId"]); vacationOpportunity.Career = _careerRepository.GetCareerById(vacationOpportunity.Career.CareerId); vacationOpportunity.ProfessionalLevel = new ProfessionalLevel(); vacationOpportunity.ProfessionalLevel.ProfessionalLevelId = Convert.ToInt32(row["ProfessionalLevelId"]); vacationOpportunity.ProfessionalLevel = _professionalLevelRepository.GetProfessionalLevelById(vacationOpportunity.ProfessionalLevel.ProfessionalLevelId); vacationOpportunity.OpportunityType = new OpportunityType(); vacationOpportunity.OpportunityType.OpportunityTypeId = Convert.ToInt32(row["OpportunityTypeId"]); vacationOpportunity.OpportunityType = _opportunityTypeRepository.GetOpportunityTypeById(vacationOpportunity.OpportunityType.OpportunityTypeId); listVacationOpportunities.Add(vacationOpportunity); } return(listVacationOpportunities); } catch (Exception ex) { throw ex; } }