public bool JobChangeStatus(out string message)
{
message = "error";
try
{
TMSDbContext DbContext = new TMSDbContext();
DbContext.Database.CommandTimeout = Common.Constants.CommonConstants.TimeExcuteSql;
DbContext.Database.ExecuteSqlCommand(Common.Constants.AbnormalQuery.ExcuteCheckTimeOut);
var explanationRequest = _explanationRequestRepository.GetMulti(x => x.StatusRequestId == 1 || x.StatusRequestId == 5).ToList();
foreach (var item in explanationRequest)
{
if (_commonService.GetDateExRequestInPast(item.CreatedDate.Value) < DateTime.Now.Date)
{
item.StatusRequestId = 2;
_explanationRequestRepository.Update(item);
_explanationRequestService.Save();
}
}
log.Info("Job Change Status Run Success :" + DateTime.Now.ToString("dd'/'MM'/'yyyy HH:mm:ss"));
message = "Success";
return(true);
}
catch (Exception ex)
{
message = "Error:" + ex.Message;
return(false);
}
}
//Change status explanation request by delegate config, when set delegate config in menu group
public void ChangeStatusExplanationRequestConfigDelegate(string assignTo, List <ExplanationRequest> lstExplanationRequest)
{
var status = _statusRequestRepository.GetMulti(x => x.Name.Contains(CommonConstants.StatusDelegation)).FirstOrDefault();
if (lstExplanationRequest.Count() > 0)
{
foreach (var itemExplanation in lstExplanationRequest)
{
if (itemExplanation.StatusRequest.Name.Equals(CommonConstants.StatusDelegation))
{
itemExplanation.DelegateId = assignTo;
_explanationRequestRepository.Update(itemExplanation);
}
else
{
itemExplanation.StatusRequestId = status.ID;
itemExplanation.DelegateId = assignTo;
_explanationRequestRepository.Update(itemExplanation);
}
}
SaveChange();
}
}
/// <summary>
/// chech request status
/// </summary>
/// <param name="delegationRequestID">ID of Request</param>
/// <param name="action"></param>
/// <returns>obejct request</returns>
private ExplanationRequest CheckStatus(int DelegationRequestID, string action, string changeStatusBy)
{
var model = GetIdRequest(DelegationRequestID);
var statusRequest = _statusRequestRepository.GetMulti(x => x.Name.Equals(action)).FirstOrDefault();
if (model.StatusRequest.Name == CommonConstants.StatusDelegation)
{
model.UpdatedBy = changeStatusBy;
model.DelegateId = null;
model.UpdatedDate = DateTime.Now;
model.StatusRequestId = statusRequest.ID;
_explanationRequestRepository.Update(model);
Save();
return(model);
}
else
{
return(model);
}
}