public List <OrganizationSelect> GetOrganizations(string search, int pageIndex, int pageSize)
{
OrganizationSelect model = null;
List <OrganizationSelect> list = null;
string procName = "[dbo].[OpeningsOrganization_SelectAll_Search]";
_data.ExecuteCmd(procName, inputParamMapper : delegate(SqlParameterCollection parameterCollection)
{
parameterCollection.AddWithValue("@Search", search);
parameterCollection.AddWithValue("@pageIndex", pageIndex);
parameterCollection.AddWithValue("@pageSize", pageSize);
}, singleRecordMapper : delegate(IDataReader reader, short set)
{
model = new OrganizationSelect();
int indexer = 0;
model.Id = reader.GetSafeInt32(indexer++);
model.OrgName = reader.GetSafeString(indexer++);
model.SiteUrl = reader.GetSafeString(indexer++);
model.Logo = reader.GetSafeString(indexer++);
if (list == null)
{
list = new List <OrganizationSelect>();
}
list.Add(model);
});
return(list);
}
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 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 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);
}
