public async Task <bool> PostTrackingUpdateDB()
{
try
{
using (var dbCtxScope = _dbContextScopeFactory.Create())
{
SettingsDto versionTask = _settingsService
.GetByKey("CurrentTaskVersion");
string currentVersion = versionTask.Value;
int version = Int32.Parse(currentVersion);
List <string> queries = GetQueryUpdate(version);
foreach (string item in queries)
{
try
{
string query = item.Replace("GO", "");
await _projectCategoryRepository.SqlQueryAsync(typeof(bool), item);
}
catch (Exception ex)
{
_loggerServices.WriteError("PostTrackingUpdateDB at: " + item + " message: " + ex.ToString());
continue;
}
}
return(true);
}
}
catch (Exception ex)
{
_loggerServices.WriteError(ex.ToString());
return(false);
}
}
private async Task SendMulticastAsync(SendMessageData messageData, IReadOnlyList <string> tokens)
{
try
{
if (tokens == null || !tokens.Any())
{
return;
}
var message = CreateMessage(messageData, tokens);
FirebaseMessaging.DefaultInstance.SendMulticastAsync(message, CancellationToken.None);
}
catch (Exception ex)
{
_loggerServices.WriteError(ex.ToString());
}
}
public async Task <TaskItemAssignDto> GetByAssignTo(Guid taskId, Guid userId)
{
TaskItemAssignDto dto = null;
try
{
using (var scope = _dbContextScopeFactory.CreateReadOnly())
{
TaskItemAssign entity = _objectRepository.GetAll().Include(t => t.TaskItemProcessHistories).Include(t => t.TaskItem).Include(t => t.TaskItemStatus).Include(t => t.TaskItem.TaskItemStatus).Where(p => p.IsDeleted == false && p.TaskItemId == taskId && p.AssignTo == userId).FirstOrDefault();
if (entity != null)
{
var users = _userServices.GetUsers();
var userDepartments = await _userDepartmentServices.GetCachedUserDepartmentDtos();
dto = _mapper.Map <TaskItemAssignDto>(entity);
var assignTo = userDepartments.Where(e => e.UserID == entity.AssignTo).FirstOrDefault();
dto.AssignToFullName = assignTo.FullName;
var assignBy = userDepartments.Where(e => e.UserID == entity.TaskItem.AssignBy).FirstOrDefault();
dto.TaskItem.AssignByFullName = assignBy.FullName;
if (dto.TaskItem.FromDate.HasValue)
{
dto.TaskItem.FromDateText = dto.TaskItem.FromDate.Value.ToString("dd/MM/yyyy");
}
if (dto.TaskItem.ToDate.HasValue)
{
dto.TaskItem.ToDateText = dto.TaskItem.ToDate.Value.ToString("dd/MM/yyyy");
}
if (dto.TaskType != TaskType.Primary)
{
dto.TaskItem.IsReport = false;
}
if (dto.ExtendDate.HasValue)
{
dto.ExtendDateText = dto.ExtendDate.Value.ToString("dd/MM/yyyy");
}
var isFinished = dto.TaskItem.TaskItemStatusId == TaskItemStatusId.Finished || dto.TaskItem.TaskItemStatusId == TaskItemStatusId.Cancel;
if ((!isFinished && dto.TaskItem.ToDate.Value.Date < DateTime.Now.Date) || (isFinished && dto.TaskItem.FinishedDate.HasValue && dto.TaskItem.ToDate.Value.Date < dto.TaskItem.FinishedDate.Value.Date))
{
dto.TaskItem.IsLate = true;
dto.TaskItem.Process = "out-of-date";
}
else if (!isFinished && dto.TaskItem.ToDate.Value.Date <= DateTime.Now.AddDays(2).Date)
{
dto.TaskItem.IsLate = false;
dto.TaskItem.Process = "near-of-date";
}
else
{
dto.TaskItem.IsLate = false;
dto.TaskItem.Process = "in-due-date";
}
dto.IsExtend = false;
}
}
}
catch (Exception ex)
{
_loggerServices.WriteError(ex.ToString());
}
return(dto);
}
