public List <TwoColumn> SearchByTypeName(string type, string Query, int PageIndex, int PageSize) { string procName = GetProcSearchName(type); List <TwoColumn> list = null; _data.ExecuteCmd(procName , inputParamMapper : delegate(SqlParameterCollection inputCollection) { inputCollection.AddWithValue("@PageIndex", PageIndex); inputCollection.AddWithValue("@PageSize", PageSize); inputCollection.AddWithValue("@Query", Query); } , singleRecordMapper : delegate(IDataReader reader, short set) { TwoColumn twoColumn = MapTwoColumns(reader); if (list == null) { list = new List <TwoColumn>(); } list.Add(twoColumn); }); return(list); }
private static TwoColumn MapTwoColumns(IDataReader reader) { TwoColumn twoColumn = new TwoColumn(); int startingIndex = 0; twoColumn.Id = reader.GetSafeInt32(startingIndex++); twoColumn.Name = reader.GetSafeString(startingIndex++); return(twoColumn); }
public Paged <Job> GetByCurrent(int createdBy, int pageIndex, int pageSize) { string procName = "[dbo].[Openings_Select_ByCreatedBy_V2]"; Paged <Job> pagedResult = null; List <Job> result = null; Job job = null; OrganizationSelect organization = null; TwoColumn jobType = null; LocationInfo location = null; UserProfile userProfile = null; int totalCount = 0; _data.ExecuteCmd(procName, inputParamMapper : delegate(SqlParameterCollection parameterCollection) { parameterCollection.AddWithValue("@CreatedBy", createdBy); parameterCollection.AddWithValue("@PageIndex", pageIndex); parameterCollection.AddWithValue("@PageSize", pageSize); }, singleRecordMapper : delegate(IDataReader reader, short set) { job = new Job(); organization = new OrganizationSelect(); jobType = new TwoColumn(); location = new LocationInfo(); userProfile = new UserProfile(); MapJob(reader, job, organization, jobType, location, userProfile); if (totalCount == 0) { totalCount = reader.GetSafeInt32(26); } if (result == null) { result = new List <Job>(); } if (job.CreatedBy.Id == createdBy) { result.Add(job); } }); if (result != null) { pagedResult = new Paged <Job>(result, pageIndex, pageSize, totalCount); } return(pagedResult); }
public List <TwoColumn> GetByTypeName(string type) { string procName = GetProcName(type); List <TwoColumn> list = null; _data.ExecuteCmd(procName, inputParamMapper : null , singleRecordMapper : delegate(IDataReader reader, short set) { TwoColumn twoColumn = MapTwoColumns(reader); if (list == null) { list = new List <TwoColumn>(); } list.Add(twoColumn); }); return(list); }
public Job Get(int Id) { string procName = "[dbo].[Openings_Details_ById]"; Job job = null; OrganizationSelect organization = null; TwoColumn jobType = null; LocationInfo location = null; UserProfile userProfile = null; _data.ExecuteCmd(procName, delegate(SqlParameterCollection jobCol) { jobCol.AddWithValue("@Id", Id); }, delegate(IDataReader reader, short set) { job = new Job(); organization = new OrganizationSelect(); jobType = new TwoColumn(); location = new LocationInfo(); userProfile = new UserProfile(); MapJob(reader, job, organization, jobType, location, userProfile); }); return(job); }
private static void SwitchTypes(short set, IDataReader reader, ProviderTypes provider) { switch (set) { case 0: TwoColumn languages = MapTwoColumns(reader); if (provider.Languages == null) { provider.Languages = new List <TwoColumn>(); } provider.Languages.Add(languages); break; case 1: TwoColumn daysOfWeek = MapTwoColumns(reader); if (provider.DaysOfWeek == null) { provider.DaysOfWeek = new List <TwoColumn>(); } provider.DaysOfWeek.Add(daysOfWeek); break; case 2: TwoColumn concernTypes = MapTwoColumns(reader); if (provider.ConcernTypes == null) { provider.ConcernTypes = new List <TwoColumn>(); } provider.ConcernTypes.Add(concernTypes); break; case 3: TwoColumn expertiseTypes = MapTwoColumns(reader); if (provider.ExpertiseTypes == null) { provider.ExpertiseTypes = new List <TwoColumn>(); } provider.ExpertiseTypes.Add(expertiseTypes); break; case 4: TwoColumn licenseTypes = MapTwoColumns(reader); if (provider.LicenseTypes == null) { provider.LicenseTypes = new List <TwoColumn>(); } provider.LicenseTypes.Add(licenseTypes); break; case 5: TwoColumn careNeedsTypes = MapTwoColumns(reader); if (provider.CareNeedsTypes == null) { provider.CareNeedsTypes = new List <TwoColumn>(); } provider.CareNeedsTypes.Add(careNeedsTypes); break; case 6: TwoColumn certificateTypes = MapTwoColumns(reader); if (provider.CertificateTypes == null) { provider.CertificateTypes = new List <TwoColumn>(); } provider.CertificateTypes.Add(certificateTypes); break; case 7: TwoColumn helpNeedTypes = MapTwoColumns(reader); if (provider.HelpNeedTypes == null) { provider.HelpNeedTypes = new List <TwoColumn>(); } provider.HelpNeedTypes.Add(helpNeedTypes); break; case 8: TwoColumn states = MapTwoColumns(reader); if (provider.States == null) { provider.States = new List <TwoColumn>(); } provider.States.Add(states); break; case 9: TwoColumn providerTypes = MapTwoColumns(reader); if (provider.LocationTypes == null) { provider.LocationTypes = new List <TwoColumn>(); } provider.LocationTypes.Add(providerTypes); break; } }
private static Job MapJob(IDataReader reader, Job job, OrganizationSelect organization, TwoColumn jobType, LocationInfo location, UserProfile userProfile) { int indexer = 0; job.Id = reader.GetSafeInt32(indexer++); organization.Id = reader.GetSafeInt32(indexer++); organization.OrgName = reader.GetSafeString(indexer++); organization.SiteUrl = reader.GetSafeString(indexer++); organization.Logo = reader.GetSafeString(indexer++); job.Organization = organization; jobType.Id = reader.GetSafeInt32(indexer++); jobType.Name = reader.GetSafeString(indexer++); job.JobType = jobType; location.Id = reader.GetSafeInt32(indexer++); location.LineOne = reader.GetSafeString(indexer++); location.City = reader.GetSafeString(indexer++); location.Zip = reader.GetSafeString(indexer++); location.StateName = reader.GetSafeString(indexer++); location.StateProvinceCode = reader.GetSafeString(indexer++); job.Location = location; userProfile.Id = reader.GetSafeInt32(indexer++); userProfile.FirstName = reader.GetSafeString(indexer++); userProfile.LastName = reader.GetSafeString(indexer++); userProfile.AvatarUrl = reader.GetSafeString(indexer++); job.CreatedBy = userProfile; job.Title = reader.GetSafeString(indexer++); job.Description = reader.GetSafeString(indexer++); job.Requirements = reader.GetSafeString(indexer++); job.IsActive = reader.GetSafeBool(indexer++); job.ContactName = reader.GetSafeString(indexer++); job.ContactPhone = reader.GetSafeString(indexer++); job.ContactEmail = reader.GetSafeString(indexer++); job.DateCreated = reader.GetSafeDateTime(indexer++); job.DateModified = reader.GetSafeDateTime(indexer++); return(job); }