public ActionResult RenewJob([FromRoute] decimal jobId)
{
double second = double.Parse(Utility.GetDefineValue(Constant.TIMER_CANCEL_JOB).value);
DateTime date = Utility.GetSysDateTime();
var query = from d in _context.D_JOBS
where d.JOB_ID == jobId &&
((d.UPD_DATETIME.HasValue && DateTime.Compare(d.UPD_DATETIME.Value.AddSeconds(second), date) >= 0) ||
(!d.UPD_DATETIME.HasValue && DateTime.Compare(d.REG_DATETIME.AddSeconds(second), date) >= 0))
select d;
if (query.Any())
{
D_JOB upd = query.Single();
upd.RENEW_NUM = upd.RENEW_NUM + 1;
upd.UPD_DATETIME = Utility.GetSysDateTime();
_context.SaveChanges();
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = true
}));
}
return(Ok(new Result
{
Status = 404,
Message = "Data not exists.",
Data = false
}));
}
public ActionResult CreateJob(JobEntity job)
{
var item = new D_JOB
{
USER_ID = job.userId,
SUGGEST_ID = job.suggestId,
LATITUDE = job.location.latitude,
LONGITUDE = job.location.longitude,
CANCEL_FLG = 0,
RENEW_NUM = 0,
REG_DATETIME = Utility.GetSysDateTime(),
};
_context.D_JOBS.Add(item);
_context.SaveChanges();
return(Ok(new Result
{
Status = 200,
Message = string.Empty,
Data = true
}));
}
private static D_JOB ItemToDTO(D_JOB item)
{
return(item);
}
