public void updateOperationTask(int id, Update operationTask)
{
try
{
if (operationTask.TaskContent != null)
{
JObject tmp = JObject.Parse(operationTask.TaskContent);
}
}
catch
{
throw new Exception("TaskContent must be in Json fromat");
}
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
OperationTask existingOperationTask = dbhelp.GetByid(id);
DateTime invaildDatetime = new DateTime(1, 1, 1);
existingOperationTask.Name = operationTask.Name;
existingOperationTask.TaskStatus = operationTask.TaskStatus;
existingOperationTask.CompletedAt = (operationTask.CompletedAt.Equals(invaildDatetime)) ? null : operationTask.CompletedAt;
existingOperationTask.RetryCounter = operationTask.RetryCounter;
existingOperationTask.Entity = operationTask.Entity;
existingOperationTask.EntityId = operationTask.EntityId;
existingOperationTask.TaskContent = operationTask.TaskContent;
existingOperationTask.TaskLog = operationTask.TaskLog;
dbhelp.Update(existingOperationTask);
}
public static void UpdateTaskByFail(int taskId, string failLog, int status = TaskStatus.FAILED)
{
try
{
DBHelper._OperationTask opsTaskHelper = new DBHelper._OperationTask();
OperationTask opsTask = opsTaskHelper.GetByid(taskId);
opsTask.RetryCounter = opsTask.RetryCounter + 1;
opsTask.TaskLog = DateTime.UtcNow + ": " + failLog;
switch (status)
{
case TaskStatus.FAILED:
opsTask.TaskStatus = "Fail";
break;
case TaskStatus.WARNING:
opsTask.TaskStatus = "Warning";
break;
case TaskStatus.COMPLETED:
opsTask.TaskStatus = "Completed";
opsTask.TaskLog = DateTime.UtcNow + ": Done. " + failLog;
opsTask.CompletedAt = DateTime.UtcNow;
break;
}
opsTaskHelper.Update(opsTask);
}
catch (Exception)
{
}
}
public void deleteOperationTask(int id)
{
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
OperationTask existingOperationTask = dbhelp.GetByid(id);
dbhelp.Delete(existingOperationTask);
}
public int addOperationTask(Add operationTask)
{
try
{
if (operationTask.TaskContent != null)
{
JObject tmp = JObject.Parse(operationTask.TaskContent);
}
}
catch
{
throw new Exception("TaskContent must be in Json fromat");
}
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
DateTime invaildDatetime = new DateTime(1, 1, 1);
var newOperationTask = new OperationTask()
{
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = operationTask.CompanyId,
CompletedAt = (operationTask.CompletedAt.Equals(invaildDatetime)) ? null : operationTask.CompletedAt,
RetryCounter = operationTask.RetryCounter,
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = operationTask.TaskContent,
TaskLog = operationTask.TaskLog
};
int operationTaskId = dbhelp.Add(newOperationTask);
return(operationTaskId);
}
public List <Detail> GetAllOperationTaskByCompanyId(int companyId)
{
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
DBHelper._Company dbhelp_company = new DBHelper._Company();
List <OperationTask> operationTaskList = new List <OperationTask>();
List <Detail> returnOperationtTaskDetail = new List <Detail>();
DateTime invaildDatetime = new DateTime(1, 1, 1);
operationTaskList = dbhelp.GetAllByCompanyId(companyId);
foreach (OperationTask operationTask in operationTaskList)
{
Company company = dbhelp_company.GetByid((int)operationTask.CompanyId);
returnOperationtTaskDetail.Add(new Detail()
{
Id = operationTask.Id,
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = (int)operationTask.CompanyId,
CompanyName = company == null ? "" : company.Name,
CompletedAt = operationTask.CompletedAt,
RetryCounter = (operationTask.RetryCounter == null) ? "" : operationTask.RetryCounter.ToString(),
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = (operationTask.TaskContent == null) ? null : JObject.Parse(operationTask.TaskContent),
TaskLog = operationTask.TaskLog
});
}
return(returnOperationtTaskDetail);
}
public static void UpdateTaskBySuccess(int taskId)
{
DBHelper._OperationTask opsTaskHelper = new DBHelper._OperationTask();
OperationTask opsTask = opsTaskHelper.GetByid(taskId);
opsTask.CompletedAt = DateTime.UtcNow;
opsTask.TaskLog = DateTime.UtcNow + ": Done.";
opsTask.TaskStatus = "Completed";
opsTaskHelper.Update(opsTask);
}
static void UpdateTaskByFail(int taskId, string failLog)
{
try
{
DBHelper._OperationTask opsTaskHelper = new DBHelper._OperationTask();
OperationTask opsTask = opsTaskHelper.GetByid(taskId);
opsTask.RetryCounter = opsTask.RetryCounter + 1;
opsTask.TaskStatus = "Fail";
opsTask.TaskLog = DateTime.UtcNow + ": " + failLog;
opsTaskHelper.Update(opsTask);
}
catch (Exception ex)
{
ConsoleLog.WriteBlobLogError("Exception on UpdateTaskByFail: {0}", ex.Message);
}
}
private static int addOperationTask(OperationTask operationTask)
{
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
DateTime invaildDatetime = new DateTime(1, 1, 1);
var newOperationTask = new OperationTask()
{
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = operationTask.CompanyId,
CompletedAt = (operationTask.CompletedAt.Equals(invaildDatetime)) ? null : operationTask.CompletedAt,
RetryCounter = operationTask.RetryCounter,
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = operationTask.TaskContent,
TaskLog = operationTask.TaskLog
};
int operationTaskId = dbhelp.Add(newOperationTask);
return(operationTaskId);
}
public Detail getOperationTaskById(int id)
{
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
DBHelper._Company dbhelp_company = new DBHelper._Company();
OperationTask operationTask = dbhelp.GetByid(id);
Company company = dbhelp_company.GetByid((int)operationTask.CompanyId);
return(new Detail()
{
Id = operationTask.Id,
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = (int)operationTask.CompanyId,
CompanyName = company == null ? "" : company.Name,
CompletedAt = operationTask.CompletedAt,
RetryCounter = (operationTask.RetryCounter == null) ? "" : operationTask.RetryCounter.ToString(),
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = (operationTask.TaskContent == null) ? null : JObject.Parse(operationTask.TaskContent),
TaskLog = operationTask.TaskLog
});
}
public List <Detail> searchInPastSevenDaysOperations(SearchCondition condition, int companyId = 0)
{
int hours;
string taskStatus;
if (condition == null)
{
hours = -168;
taskStatus = null;
}
else
{
hours = (condition.hours == 0 || condition.hours > 168) ? -168 : -(condition.hours);
taskStatus = condition.taskStatus;
}
DBHelper._OperationTask dbhelp = new DBHelper._OperationTask();
DBHelper._Company dbhelp_company = new DBHelper._Company();
List <OperationTask> operationTaskList = new List <OperationTask>();
List <Detail> returnOperationtTaskDetail = new List <Detail>();
if (companyId > 0)
{
operationTaskList = dbhelp.Search(taskStatus, hours, companyId);
Company company = dbhelp_company.GetByid(companyId);
foreach (OperationTask operationTask in operationTaskList)
{
try
{
returnOperationtTaskDetail.Add(new Detail()
{
Id = operationTask.Id,
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = (int)operationTask.CompanyId,
CompanyName = company == null ? "" : company.Name,
CompletedAt = operationTask.CompletedAt,
RetryCounter = (operationTask.RetryCounter == null) ? "" : operationTask.RetryCounter.ToString(),
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = (operationTask.TaskContent == null) ? null : JObject.Parse(operationTask.TaskContent),
TaskLog = operationTask.TaskLog
});
}
catch { }
}
}
else
{
operationTaskList = dbhelp.Search(taskStatus, hours);
List <int> companyIdList = operationTaskList.Select(s => (int)s.CompanyId).Distinct().ToList <int>();
CDStudioEntities dbEntity = new CDStudioEntities();
var L2Enty = from c in dbEntity.Company
where companyIdList.Contains(c.Id)
select new { Id = c.Id, Name = c.Name };
Dictionary <int, string> companyTable = new Dictionary <int, string>();
foreach (var company in L2Enty)
{
companyTable.Add(company.Id, company.Name);
}
foreach (OperationTask operationTask in operationTaskList)
{
try
{
returnOperationtTaskDetail.Add(new Detail()
{
Id = operationTask.Id,
Name = operationTask.Name,
TaskStatus = operationTask.TaskStatus,
CompanyId = (int)operationTask.CompanyId,
CompanyName = companyTable.ContainsKey((int)operationTask.CompanyId) ? companyTable[(int)operationTask.CompanyId] : "",
CompletedAt = operationTask.CompletedAt,
RetryCounter = (operationTask.RetryCounter == null) ? "" : operationTask.RetryCounter.ToString(),
Entity = operationTask.Entity,
EntityId = operationTask.EntityId,
TaskContent = (operationTask.TaskContent == null) ? null : JObject.Parse(operationTask.TaskContent),
TaskLog = operationTask.TaskLog
});
}
catch { }
}
}
return(returnOperationtTaskDetail);
}
