public ActionResult GetJobInfo([FromRoute] decimal jobId)
{
V_JobEntity entity = null;
var query = from d in _context.V_JOBS
where d.JOB_ID == jobId
select d;
if (query.Any())
{
V_JOB job = query.Single();
entity = new V_JobEntity();
entity.jobId = job.JOB_ID;
entity.userId = job.USER_ID;
entity.phoneNumber = job.PHONE_NUMBER;
ImageInfoEntity avatar = new ImageInfoEntity();
avatar.path = job.AVATAR;
entity.avatar = avatar;
entity.score = job.SCORE;
entity.likeNum = job.LIKE_NUM;
TemplateEntity template = new TemplateEntity();
template.templateCd = job.TEMPLATE_CD;
template.templateTitle = job.TEMPLATE_TITLE;
entity.template = template;
Location loc = new Location();
loc.latitude = job.LATITUDE;
loc.longitude = job.LONGITUDE;
entity.location = loc;
Catalog catalog = new Catalog();
catalog.catalogCd = job.CATALOG_CD;
catalog.catalogName = job.CATALOG_NAME;
entity.catalog = catalog;
entity.dateTime = job.UPD_DATETIME.HasValue ? job.UPD_DATETIME.Value : job.REG_DATETIME;
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = entity
}));
}
return(Ok(new Result
{
Status = 404,
Message = "Data not exists.",
Data = null
}));
}
public ActionResult GetJobByHirer([FromRoute] decimal userId)
{
double second = double.Parse(Utility.GetDefineValue(Constant.TIMER_CANCEL_JOB).value);
List <V_JobEntity> entityList = new List <V_JobEntity>();
//string language = "vi";
//var hirerInfo = from d in _context.M_USERS
// where d.USER_ID == userId
// select d;
//if (!hirerInfo.Any())
//{
// return Ok(new Result
// {
// Status = 404,
// Message = "Data not exists.",
// Data = null
// });
//}
//M_USER user = hirerInfo.Single();
//language = user.LANGUAGE_TYPE;
var query = from d in _context.V_JOBS
where d.USER_ID == userId &&
d.CANCEL_FLG == 0
select d;
DateTime date = Utility.GetSysDateTime();
if (query.Any())
{
foreach (V_JOB job in query.ToList())
{
if ((job.UPD_DATETIME.HasValue && DateTime.Compare(job.UPD_DATETIME.Value.AddSeconds(second), date) >= 0) ||
(!job.UPD_DATETIME.HasValue && DateTime.Compare(job.REG_DATETIME.AddSeconds(second), date) >= 0))
{
job.CANCEL_FLG = 1;
_context.SaveChanges();
continue;
}
V_JobEntity entity = new V_JobEntity();
entity.jobId = job.JOB_ID;
entity.userId = job.USER_ID;
entity.userName = job.NAME;
entity.phoneNumber = job.PHONE_NUMBER;
ImageInfoEntity avatar = new ImageInfoEntity();
avatar.path = job.AVATAR;
entity.avatar = avatar;
entity.score = job.SCORE;
entity.likeNum = job.LIKE_NUM;
TemplateEntity template = new TemplateEntity();
template.templateCd = job.TEMPLATE_CD;
template.templateTitle = job.TEMPLATE_TITLE;
entity.template = template;
Location loc = new Location();
loc.latitude = job.LATITUDE;
loc.longitude = job.LONGITUDE;
entity.location = loc;
Catalog catalog = new Catalog();
catalog.catalogCd = job.CATALOG_CD;
catalog.catalogName = job.CATALOG_NAME;
entity.catalog = catalog;
entity.dateTime = job.UPD_DATETIME.HasValue ? job.UPD_DATETIME.Value : job.REG_DATETIME;
entityList.Add(entity);
}
}
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = entityList
}));
}
