public void AppTaskLanguageService_PostUpdateAppTaskLanguageDB_GetAppTaskLanguageWithAppTaskIDAndLanguageDB_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
AppTaskModel appTaskModel = appTaskServiceTest.AddAppTaskModel();
LanguageEnum LangToAdd = LanguageEnum.es;
appTaskLanguageModelNew.AppTaskID = appTaskModel.AppTaskID;
FillAppTaskLanguageModel(LangToAdd, appTaskLanguageModelNew);
AppTaskLanguageModel appTaskLanguageModelRet = appTaskLanguageService.PostAddAppTaskLanguageDB(appTaskLanguageModelNew);
using (ShimsContext.Create())
{
SetupShim();
FillAppTaskLanguageModel(LangToAdd, appTaskLanguageModelRet);
//string ErrorText = "ErrorText";
shimAppTaskLanguageService.GetAppTaskLanguageWithAppTaskIDAndLanguageDBInt32LanguageEnum = (a, b) =>
{
return(null);
};
AppTaskLanguageModel appTaskLanguageModelRet2 = UpdateAppTaskLanguageModel(LangToAdd, appTaskLanguageModelRet);
Assert.AreEqual(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.AppTaskLanguage), appTaskLanguageModelRet2.Error);
}
}
}
}
public AppTaskModel PostUpdateAppTask(AppTaskModel appTaskModel)
{
string retStr = AppTaskModelOK(appTaskModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
AppTask appTaskToUpdate = GetAppTaskWithAppTaskIDDB(appTaskModel.AppTaskID);
if (appTaskToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.AppTask)));
}
retStr = FillAppTask(appTaskToUpdate, appTaskModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
AppTaskLanguageModel appTaskLanguageModel = new AppTaskLanguageModel()
{
AppTaskID = appTaskModel.AppTaskID,
DBCommand = DBCommandEnum.Original,
ErrorText = appTaskModel.ErrorText,
StatusText = appTaskModel.StatusText,
Language = Lang,
TranslationStatus = (Lang == LanguageRequest ? TranslationStatusEnum.Translated : TranslationStatusEnum.NotTranslated),
};
AppTaskLanguageModel appTaskLanguageModelRet = _AppTaskLanguageService.PostUpdateAppTaskLanguageDB(appTaskLanguageModel);
if (!string.IsNullOrEmpty(appTaskLanguageModelRet.Error))
{
return(ReturnError(appTaskLanguageModelRet.Error));
}
}
ts.Complete();
}
return(GetAppTaskModelWithAppTaskIDDB(appTaskToUpdate.AppTaskID));
}
public void AppTaskLanguageService_PostAddAppTaskLanguageDB_Add_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
AppTaskModel appTaskModel = appTaskServiceTest.AddAppTaskModel();
Assert.AreEqual("", appTaskModel.Error);
LanguageEnum LangToAdd = LanguageEnum.es;
using (ShimsContext.Create())
{
SetupShim();
//string ErrorText = "ErrorText";
shimAppTaskLanguageService.FillAppTaskLanguageAppTaskLanguageAppTaskLanguageModelContactOK = (a, b, c) =>
{
return("");
};
appTaskLanguageModelNew.AppTaskID = appTaskModel.AppTaskID;
FillAppTaskLanguageModel(LangToAdd, appTaskLanguageModelNew);
AppTaskLanguageModel appTaskLanguageModelRet = appTaskLanguageService.PostAddAppTaskLanguageDB(appTaskLanguageModelNew);
Assert.IsTrue(appTaskLanguageModelRet.Error.StartsWith(string.Format(ServiceRes.CouldNotAddError_, "").Substring(0, 10)));
}
}
}
}
public void GroupingMWQMSitesAndPolSourceSitesGenerateService_GenerateLinksBetweenMWQMSitesAndPolSourceSitesForCSSPWebToolsVisualization_Test()
{
// AppTaskID TVItemID TVItemID2 AppTaskCommand AppTaskStatus PercentCompleted Parameters Language StartDateTime_UTC EndDateTime_UTC EstimatedLength_second RemainingTime_second LastUpdateDate_UTC LastUpdateContactTVItemID
// 12643 344316 344316 2 1 1 ||| MikeScenarioTVItemID,344316 ||| 1 2018 - 03 - 20 14:49:58.440 NULL NULL NULL 2018 - 03 - 20 14:49:58.443 2
foreach (LanguageEnum LanguageRequest in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
SetupTest(LanguageRequest);
int ProvinceTVItemID = 7;
StringBuilder sbKML = new StringBuilder();
string Parameters = $"|||ProvinceTVItemID,{ ProvinceTVItemID }|||";
AppTaskModel appTaskModel = new AppTaskModel()
{
AppTaskID = 100000,
TVItemID = ProvinceTVItemID,
TVItemID2 = ProvinceTVItemID,
AppTaskCommand = AppTaskCommandEnum.GenerateLinksBetweenMWQMSitesAndPolSourceSitesForCSSPWebToolsVisualization,
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = Parameters,
Language = LanguageRequest,
StartDateTime_UTC = DateTime.Now,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
LastUpdateDate_UTC = DateTime.Now,
LastUpdateContactTVItemID = 2, // Charles LeBlanc
};
appTaskModel.AppTaskStatus = AppTaskStatusEnum.Running;
BWObj bwObj = new BWObj()
{
Index = 1,
appTaskModel = appTaskModel,
appTaskCommand = appTaskModel.AppTaskCommand,
TextLanguageList = new List <TextLanguage>(),
bw = new BackgroundWorker(),
};
TaskRunnerBaseService taskRunnerBaseService = new TaskRunnerBaseService(new List <BWObj>()
{
bwObj
});
taskRunnerBaseService._BWObj = bwObj;
GroupingMWQMSitesAndPolSourceSitesGenerateService groupingMWQMSitesAndPolSourceSitesGenerateService = new GroupingMWQMSitesAndPolSourceSitesGenerateService(taskRunnerBaseService);
groupingMWQMSitesAndPolSourceSitesGenerateService.GenerateLinksBetweenMWQMSitesAndPolSourceSitesForCSSPWebToolsVisualization();
Assert.AreEqual(0, taskRunnerBaseService._BWObj.TextLanguageList.Count);
break;
}
}
// Fill
public string FillAppTask(AppTask appTask, AppTaskModel appTaskModel, ContactOK contactOK)
{
appTask.DBCommand = (int)appTaskModel.DBCommand;
appTask.TVItemID = appTaskModel.TVItemID;
appTask.TVItemID2 = appTaskModel.TVItemID2;
appTask.AppTaskCommand = (int)appTaskModel.AppTaskCommand;
appTask.AppTaskStatus = (int)appTaskModel.AppTaskStatus;
appTask.PercentCompleted = appTaskModel.PercentCompleted;
appTask.Parameters = appTaskModel.Parameters;
appTask.Language = (int)appTaskModel.Language;
appTask.EndDateTime_UTC = appTaskModel.EndDateTime_UTC;
appTask.StartDateTime_UTC = appTaskModel.StartDateTime_UTC;
appTask.EstimatedLength_second = appTaskModel.EstimatedLength_second;
appTask.RemainingTime_second = appTaskModel.RemainingTime_second;
appTask.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
appTask.LastUpdateContactTVItemID = 2;
}
else
{
appTask.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
public void AppTaskLanguageService_FillAppTaskLanguage_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
AppTaskModel appTaskModel = appTaskServiceTest.AddAppTaskModel();
Assert.AreEqual("", appTaskModel.Error);
LanguageEnum LangToAdd = LanguageEnum.es;
appTaskLanguageModelNew.AppTaskID = appTaskModel.AppTaskID;
FillAppTaskLanguageModel(LangToAdd, appTaskLanguageModelNew);
ContactOK contactOK = appTaskLanguageService.IsContactOK();
string retStr = appTaskLanguageService.FillAppTaskLanguage(appTaskLanguage, appTaskLanguageModelNew, contactOK);
Assert.AreEqual("", retStr);
Assert.AreEqual(contactOK.ContactTVItemID, appTaskLanguage.LastUpdateContactTVItemID);
contactOK = null;
retStr = appTaskLanguageService.FillAppTaskLanguage(appTaskLanguage, appTaskLanguageModelNew, contactOK);
Assert.AreEqual("", retStr);
Assert.AreEqual(2, appTaskLanguage.LastUpdateContactTVItemID);
}
}
}
private AppTaskLanguageModel AddAppTaskLanguageModel(LanguageEnum LangToAdd)
{
AppTaskModel appTaskModel = appTaskServiceTest.AddAppTaskModel();
if (!string.IsNullOrWhiteSpace(appTaskModel.Error))
{
return(new AppTaskLanguageModel()
{
Error = appTaskModel.Error
});
}
appTaskLanguageModelNew.AppTaskID = appTaskModel.AppTaskID;
FillAppTaskLanguageModel(LangToAdd, appTaskLanguageModelNew);
AppTaskLanguageModel appTaskLanguagModelRet = appTaskLanguageService.PostAddAppTaskLanguageDB(appTaskLanguageModelNew);
if (!string.IsNullOrWhiteSpace(appTaskLanguagModelRet.Error))
{
return(appTaskLanguagModelRet);
}
CompareAppTaskLanguageModels(appTaskLanguageModelNew, appTaskLanguagModelRet);
return(appTaskLanguagModelRet);
}
public void AppTaskLanguageService_PostUpdateAppTaskLanguageDB_DoUpdateChanges_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
AppTaskModel appTaskModel = appTaskServiceTest.AddAppTaskModel();
LanguageEnum LangToAdd = LanguageEnum.es;
appTaskLanguageModelNew.AppTaskID = appTaskModel.AppTaskID;
FillAppTaskLanguageModel(LangToAdd, appTaskLanguageModelNew);
AppTaskLanguageModel appTaskLanguageModelRet = appTaskLanguageService.PostAddAppTaskLanguageDB(appTaskLanguageModelNew);
using (ShimsContext.Create())
{
SetupShim();
FillAppTaskLanguageModel(LangToAdd, appTaskLanguageModelRet);
string ErrorText = "ErrorText";
shimAppTaskLanguageService.DoUpdateChanges = () =>
{
return(ErrorText);
};
AppTaskLanguageModel appTaskLanguageModelRet2 = UpdateAppTaskLanguageModel(LangToAdd, appTaskLanguageModelRet);
Assert.AreEqual(ErrorText, appTaskLanguageModelRet2.Error);
}
}
}
}
public void MikeScenarioFileService_MikeScenarioImport_Test()
{
// AppTaskID TVItemID TVItemID2 AppTaskCommand AppTaskStatus PercentCompleted Parameters Language StartDateTime_UTC EndDateTime_UTC EstimatedLength_second RemainingTime_second LastUpdateDate_UTC LastUpdateContactTVItemID
//17907 381362 381362 3 1 1 ||| TVItemID,12110 ||| UploadClientPath,E:\CSSP\Modelling\Mike21\New Brunswick\Cap - Pele\Model\Model Inputs\||| 1 2019 - 09 - 30 20:00:08.687 NULL NULL NULL 2019 - 09 - 30 20:00:08.697 2
foreach (LanguageEnum LanguageRequest in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
SetupTest(LanguageRequest);
int MikeScenarioTVItemID = 381362;
string Parameters = $@"|||TVItemID,12110|||UploadClientPath,E:\CSSP\Modelling\Mike21\New Brunswick\Cap-Pele\Model\Model Inputs\|||";
AppTaskModel appTaskModel = new AppTaskModel()
{
AppTaskID = 100000,
TVItemID = MikeScenarioTVItemID,
TVItemID2 = MikeScenarioTVItemID,
AppTaskCommand = AppTaskCommandEnum.MikeScenarioImport,
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = Parameters,
Language = LanguageRequest,
StartDateTime_UTC = DateTime.Now,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
LastUpdateDate_UTC = DateTime.Now,
LastUpdateContactTVItemID = 2, // Charles LeBlanc
};
appTaskModel.AppTaskStatus = AppTaskStatusEnum.Running;
BWObj bwObj = new BWObj()
{
Index = 1,
appTaskModel = appTaskModel,
appTaskCommand = appTaskModel.AppTaskCommand,
TextLanguageList = new List <TextLanguage>(),
bw = new BackgroundWorker(),
};
TaskRunnerBaseService taskRunnerBaseService = new TaskRunnerBaseService(new List <BWObj>()
{
bwObj
});
taskRunnerBaseService._BWObj = bwObj;
MikeScenarioFileService _MikeScenarioFileService = new MikeScenarioFileService(taskRunnerBaseService);
_MikeScenarioFileService.MikeScenarioImportDB();
Assert.AreEqual(0, taskRunnerBaseService._BWObj.TextLanguageList.Count);
break;
}
}
public void MikeScenarioFileService_MikeScenarioAskToRun_Test()
{
// AppTaskID TVItemID TVItemID2 AppTaskCommand AppTaskStatus PercentCompleted Parameters Language StartDateTime_UTC EndDateTime_UTC EstimatedLength_second RemainingTime_second LastUpdateDate_UTC LastUpdateContactTVItemID
// 14895 337049 337049 2 1 1 ||| MikeScenarioTVItemID,337049 ||| 1 2018 - 10 - 17 12:04:21.687 NULL NULL NULL 2018 - 10 - 17 12:04:21.687 2
foreach (LanguageEnum LanguageRequest in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
SetupTest(LanguageRequest);
int MikeScenarioTVItemID = 337049;
string Parameters = $"|||MikeScenarioTVItemID,{ MikeScenarioTVItemID }|||";
AppTaskModel appTaskModel = new AppTaskModel()
{
AppTaskID = 100000,
TVItemID = MikeScenarioTVItemID,
TVItemID2 = MikeScenarioTVItemID,
AppTaskCommand = AppTaskCommandEnum.MikeScenarioAskToRun,
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = Parameters,
Language = LanguageRequest,
StartDateTime_UTC = DateTime.Now,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
LastUpdateDate_UTC = DateTime.Now,
LastUpdateContactTVItemID = 2, // Charles LeBlanc
};
appTaskModel.AppTaskStatus = AppTaskStatusEnum.Running;
BWObj bwObj = new BWObj()
{
Index = 1,
appTaskModel = appTaskModel,
appTaskCommand = appTaskModel.AppTaskCommand,
TextLanguageList = new List <TextLanguage>(),
bw = new BackgroundWorker(),
};
TaskRunnerBaseService taskRunnerBaseService = new TaskRunnerBaseService(new List <BWObj>()
{
bwObj
});
taskRunnerBaseService._BWObj = bwObj;
MikeScenarioFileService _MikeScenarioFileService = new MikeScenarioFileService(taskRunnerBaseService);
_MikeScenarioFileService.MikeScenarioAskToRun();
Assert.AreEqual(0, taskRunnerBaseService._BWObj.TextLanguageList.Count);
break;
}
}
public void ClassificationGenerateService_GenerateClassificationForCSSPWebToolsVisualization_Test()
{
foreach (LanguageEnum LanguageRequest in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
SetupTest(LanguageRequest);
int ProvinceTVItemID = 7;
StringBuilder sbKML = new StringBuilder();
string Parameters = $"|||ProvinceTVItemID,{ ProvinceTVItemID }|||";
AppTaskModel appTaskModel = new AppTaskModel()
{
AppTaskID = 100000,
TVItemID = ProvinceTVItemID,
TVItemID2 = ProvinceTVItemID,
AppTaskCommand = AppTaskCommandEnum.GenerateClassificationForCSSPWebToolsVisualization,
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = Parameters,
Language = LanguageRequest,
StartDateTime_UTC = DateTime.Now,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
LastUpdateDate_UTC = DateTime.Now,
LastUpdateContactTVItemID = 2, // Charles LeBlanc
};
appTaskModel.AppTaskStatus = AppTaskStatusEnum.Running;
BWObj bwObj = new BWObj()
{
Index = 1,
appTaskModel = appTaskModel,
appTaskCommand = appTaskModel.AppTaskCommand,
TextLanguageList = new List <TextLanguage>(),
bw = new BackgroundWorker(),
};
TaskRunnerBaseService taskRunnerBaseService = new TaskRunnerBaseService(new List <BWObj>()
{
bwObj
});
taskRunnerBaseService._BWObj = bwObj;
ClassificationGenerateService classificationGenerateService = new ClassificationGenerateService(taskRunnerBaseService);
classificationGenerateService.GenerateClassificationForCSSPWebToolsVisualization();
Assert.AreEqual(0, taskRunnerBaseService._BWObj.TextLanguageList.Count);
break;
}
}
public void HydrometricService_LoadHydrometricDataValueDB_Test()
{
// AppTaskID TVItemID TVItemID2 AppTaskCommand AppTaskStatus PercentCompleted Parameters Language StartDateTime_UTC EndDateTime_UTC EstimatedLength_second RemainingTime_second LastUpdateDate_UTC LastUpdateContactTVItemID
// 14775 361210 361210 44 2 1 |||MikeSourceTVItemID,361210|||MikeScenarioTVItemID,357139||| 1 2018-10-02 14:15:24.317 NULL NULL NULL 2018-10-02 14:15:25.307 2
foreach (LanguageEnum LanguageRequest in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
int MikeSourceTVItemID = 361210;
int MikeScenarioTVItemID = 357139;
string Parameters = $"|||MikeSourceTVItemID,{ MikeSourceTVItemID }|||MikeScenarioTVItemID,{ MikeScenarioTVItemID }|||";
AppTaskModel appTaskModel = new AppTaskModel()
{
AppTaskID = 100000,
TVItemID = MikeSourceTVItemID,
TVItemID2 = MikeSourceTVItemID,
AppTaskCommand = AppTaskCommandEnum.LoadHydrometricDataValue,
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = Parameters,
Language = LanguageRequest,
StartDateTime_UTC = DateTime.Now,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
LastUpdateDate_UTC = DateTime.Now,
LastUpdateContactTVItemID = 2, // Charles LeBlanc
};
appTaskModel.AppTaskStatus = AppTaskStatusEnum.Running;
BWObj bwObj = new BWObj()
{
Index = 1,
appTaskModel = appTaskModel,
appTaskCommand = appTaskModel.AppTaskCommand,
TextLanguageList = new List <TextLanguage>(),
bw = new BackgroundWorker(),
};
TaskRunnerBaseService taskRunnerBaseService = new TaskRunnerBaseService(new List <BWObj>()
{
bwObj
});
taskRunnerBaseService._BWObj = bwObj;
HydrometricService _HydrometricService = new HydrometricService(taskRunnerBaseService);
_HydrometricService.LoadHydrometricDataValueDB();
Assert.AreEqual(0, taskRunnerBaseService._BWObj.TextLanguageList.Count);
break;
}
}
public void TidesAndCurrentsService_Constructor_Test()
{
foreach (LanguageEnum LanguageRequest in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
// Arrange
SetupTest(LanguageRequest);
Assert.IsNotNull(csspWebToolsTaskRunner);
AppTaskModel appTaskModel = new AppTaskModel()
{
AppTaskID = 100000,
TVItemID = 123456,
TVItemID2 = 123456,
AppTaskCommand = AppTaskCommandEnum.SetupWebTide,
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = "|||MikeScenarioTVItemID,336888|||WebTideDataSet,11|||",
Language = LanguageRequest,
StartDateTime_UTC = DateTime.Now,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
LastUpdateDate_UTC = DateTime.Now,
LastUpdateContactTVItemID = 2, // Charles LeBlanc
};
appTaskModel.AppTaskStatus = AppTaskStatusEnum.Running;
BWObj bwObj = new BWObj()
{
Index = 1,
appTaskModel = appTaskModel,
appTaskCommand = appTaskModel.AppTaskCommand,
TextLanguageList = new List <TextLanguage>(),
bw = new BackgroundWorker(),
};
TaskRunnerBaseService taskRunnerBaseService = new TaskRunnerBaseService(new List <BWObj>()
{
bwObj
});
taskRunnerBaseService._BWObj = bwObj;
using (TransactionScope ts = new TransactionScope())
{
tidesAndCurrentsService = new TidesAndCurrentsService(taskRunnerBaseService);
Assert.IsNotNull(tidesAndCurrentsService);
Assert.IsNotNull(tidesAndCurrentsService._TaskRunnerBaseService);
Assert.AreEqual(bwObj.appTaskModel.AppTaskID, tidesAndCurrentsService._TaskRunnerBaseService._BWObj.appTaskModel.AppTaskID);
}
}
}
public void TidesAndCurrentsService_SetWebTide_Test()
{
foreach (LanguageEnum LanguageRequest in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
SetupTest(LanguageRequest);
int MikeScenarioTVItemID = 336888;
string Parameters = "|||MikeScenarioTVItemID,336888|||WebTideDataSet,11|||";
//AppTaskID TVItemID TVItemID2 AppTaskCommand AppTaskStatus PercentCompleted Parameters Language StartDateTime_UTC EndDateTime_UTC EstimatedLength_second RemainingTime_second LastUpdateDate_UTC LastUpdateContactTVItemID
//10346 336888 336888 8 2 10 |||MikeScenarioTVItemID,336888|||WebTideDataSet,11||| 1 2018-02-12 13:16:35.400 NULL NULL NULL 2018-02-12 13:16:36.477 2
AppTaskModel appTaskModel = new AppTaskModel()
{
AppTaskID = 100000,
TVItemID = MikeScenarioTVItemID,
TVItemID2 = MikeScenarioTVItemID,
AppTaskCommand = AppTaskCommandEnum.SetupWebTide,
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = Parameters,
Language = LanguageRequest,
StartDateTime_UTC = DateTime.Now,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
LastUpdateDate_UTC = DateTime.Now,
LastUpdateContactTVItemID = 2, // Charles LeBlanc
};
appTaskModel.AppTaskStatus = AppTaskStatusEnum.Running;
BWObj bwObj = new BWObj()
{
Index = 1,
appTaskModel = appTaskModel,
appTaskCommand = appTaskModel.AppTaskCommand,
TextLanguageList = new List <TextLanguage>(),
bw = new BackgroundWorker(),
};
TaskRunnerBaseService taskRunnerBaseService = new TaskRunnerBaseService(new List <BWObj>()
{
bwObj
});
taskRunnerBaseService._BWObj = bwObj;
TidesAndCurrentsService tidesAndCurrentsService = new TidesAndCurrentsService(taskRunnerBaseService);
tidesAndCurrentsService.SetupWebTide();
break;
}
}
public void MikeScenarioFileService_MikeScenarioPrepareResults_Test()
{
foreach (LanguageEnum LanguageRequest in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
SetupTest(LanguageRequest);
int MikeScenarioTVItemID = 357139;
string Parameters = $"|||MikeScenarioTVItemID,{ MikeScenarioTVItemID }|||";
AppTaskModel appTaskModel = new AppTaskModel()
{
AppTaskID = 100000,
TVItemID = MikeScenarioTVItemID,
TVItemID2 = MikeScenarioTVItemID,
AppTaskCommand = AppTaskCommandEnum.MikeScenarioPrepareResults,
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = Parameters,
Language = LanguageRequest,
StartDateTime_UTC = DateTime.Now,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
LastUpdateDate_UTC = DateTime.Now,
LastUpdateContactTVItemID = 2, // Charles LeBlanc
};
BWObj bwObj = new BWObj()
{
Index = 1,
appTaskModel = appTaskModel,
appTaskCommand = appTaskModel.AppTaskCommand,
TextLanguageList = new List <TextLanguage>(),
bw = new BackgroundWorker(),
};
TaskRunnerBaseService taskRunnerBaseService = new TaskRunnerBaseService(new List <BWObj>()
{
bwObj
});
taskRunnerBaseService._BWObj = bwObj;
MikeScenarioFileService _MikeScenarioFileService = new MikeScenarioFileService(taskRunnerBaseService);
_MikeScenarioFileService.MikeScenarioPrepareResults();
Assert.AreEqual(0, taskRunnerBaseService._BWObj.TextLanguageList.Count);
break;
}
}
public async Task <IActionResult> UpsertTask([FromBody] AppTaskModel task)
{
var result = await _executor
.Validate(ModelState)
.Map <AppTaskToAppTaskModelMapping>(() => task)
.Add <UpsertTaskOperation, AppTask, (Guid, AppTask)>(last => (User.GetAccountId().Value, last))
.Map <AppTaskToAppTaskModelMapping>()
.Execute();
return(result.CreateHttpResult());
}
public void HydrometricService_UpdateHydrometricSitesInformationForProvinceTVItemID_Test()
{
foreach (LanguageEnum LanguageRequest in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
int ProvinceTVItemID = 7;
AppTaskModel appTaskModel = new AppTaskModel()
{
AppTaskID = 0,
TVItemID = ProvinceTVItemID,
TVItemID2 = ProvinceTVItemID,
AppTaskCommand = AppTaskCommandEnum.UpdateHydrometricSiteInformation,
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = "",
Language = LanguageRequest,
StartDateTime_UTC = DateTime.Now,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
LastUpdateDate_UTC = DateTime.Now,
LastUpdateContactTVItemID = 2, // Charles LeBlanc
};
appTaskModel.AppTaskStatus = AppTaskStatusEnum.Running;
BWObj bwObj = new BWObj()
{
Index = 1,
appTaskModel = appTaskModel,
appTaskCommand = appTaskModel.AppTaskCommand,
TextLanguageList = new List <TextLanguage>(),
bw = new BackgroundWorker(),
};
TaskRunnerBaseService taskRunnerBaseService = new TaskRunnerBaseService(new List <BWObj>()
{
bwObj
});
taskRunnerBaseService._BWObj = bwObj;
HydrometricService _HydrometricService = new HydrometricService(taskRunnerBaseService);
_HydrometricService.UpdateHydrometricSitesInformationForProvinceTVItemID();
Assert.AreEqual(0, taskRunnerBaseService._BWObj.TextLanguageList.Count);
break;
}
}
private void RemoveAllTask()
{
List <AppTaskModel> appTaskModelList = csspWebToolsTaskRunner._TaskRunnerBaseService._AppTaskService.GetAppTaskModelListDB();
foreach (AppTaskModel appTaskModel in appTaskModelList)
{
// Act
AppTaskModel appTaskModelRet = csspWebToolsTaskRunner._TaskRunnerBaseService._AppTaskService.PostDeleteAppTaskDB(appTaskModel.AppTaskID);
// Assert
Assert.AreEqual("", appTaskModelRet.Error);
}
}
// Get
public AppTaskModel CheckAppTask()
{
AppTaskModel appTaskModel = new AppTaskModel();
try
{
appTaskModel = (from c in db.AppTasks
from cl in db.AppTaskLanguages
where c.AppTaskID == cl.AppTaskID &&
c.AppTaskStatus == (int)AppTaskStatusEnum.Created
select new AppTaskModel
{
Error = "",
AppTaskID = c.AppTaskID,
DBCommand = (DBCommandEnum)c.DBCommand,
AppTaskCommand = (AppTaskCommandEnum)c.AppTaskCommand,
EndDateTime_UTC = c.EndDateTime_UTC,
StartDateTime_UTC = c.StartDateTime_UTC,
EstimatedLength_second = c.EstimatedLength_second,
Language = (LanguageEnum)c.Language,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
Parameters = c.Parameters,
PercentCompleted = c.PercentCompleted,
RemainingTime_second = c.RemainingTime_second,
AppTaskStatus = (AppTaskStatusEnum)c.AppTaskStatus,
TVItemID = c.TVItemID,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
ErrorText = cl.ErrorText,
TVItemID2 = c.TVItemID2,
StatusText = cl.StatusText,
}).FirstOrDefault <AppTaskModel>();
}
catch (Exception)
{
return(ReturnError(ServiceRes.NoNewTaskToRun));
}
if (appTaskModel == null)
{
return(ReturnError(ServiceRes.NoNewTaskToRun));
}
return(appTaskModel);
}
public AppTaskModel GetAppTaskModelWithTVItemIDTVItemID2AndCommandDB(int TVItemID, int TVItemID2, AppTaskCommandEnum Command)
{
AppTaskModel appTaskModel = (from c in db.AppTasks
let tvItemIDTVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID select cl.TVText).FirstOrDefault <string>()
let tvItemIDTVText2 = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.TVItemID2 select cl.TVText).FirstOrDefault <string>()
let errorText = (from cl in db.AppTaskLanguages where cl.Language == (int)LanguageRequest && cl.AppTaskID == c.AppTaskID select cl.ErrorText).FirstOrDefault <string>()
let statusText = (from cl in db.AppTaskLanguages where cl.Language == (int)LanguageRequest && cl.AppTaskID == c.AppTaskID select cl.StatusText).FirstOrDefault <string>()
where c.TVItemID == TVItemID &&
c.TVItemID2 == TVItemID2 &&
c.AppTaskCommand == (int)Command
select new AppTaskModel
{
Error = "",
AppTaskID = c.AppTaskID,
DBCommand = (DBCommandEnum)c.DBCommand,
TVItemID = c.TVItemID,
TVItemIDTVText = tvItemIDTVText,
TVItemID2 = c.TVItemID2,
TVItemID2TVText = tvItemIDTVText2,
AppTaskCommand = (AppTaskCommandEnum)c.AppTaskCommand,
ErrorText = errorText,
StatusText = statusText,
AppTaskStatus = (AppTaskStatusEnum)c.AppTaskStatus,
PercentCompleted = c.PercentCompleted,
Parameters = c.Parameters,
Language = (LanguageEnum)c.Language,
EndDateTime_UTC = c.EndDateTime_UTC,
StartDateTime_UTC = c.StartDateTime_UTC,
EstimatedLength_second = c.EstimatedLength_second,
RemainingTime_second = c.RemainingTime_second,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <AppTaskModel>();
if (appTaskModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.AppTask, ServiceRes.TVItemID + "," + ServiceRes.TVItemID2 + "," + ServiceRes.AppTaskCommand, TVItemID + "," + TVItemID2 + "," + Command.ToString())));
}
return(appTaskModel);
}
public TVItemModel GenerateCSVDocumentNationalOfMWQMSitesDB(int CountryTVItemID)
{
using (TransactionScope ts = new TransactionScope())
{
AppTaskModel appTaskModelExist = _AppTaskService.GetAppTaskModelWithTVItemIDTVItemID2AndCommandDB(CountryTVItemID, CountryTVItemID, AppTaskCommandEnum.OpenDataCSVNationalOfMWQMSites);
if (string.IsNullOrWhiteSpace(appTaskModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.AppTask)));
}
List <AppTaskParameter> appTaskParameterList = new List <AppTaskParameter>();
AppTaskModel appTaskModelNew = new AppTaskModel()
{
DBCommand = DBCommandEnum.Original,
TVItemID = CountryTVItemID,
TVItemID2 = CountryTVItemID,
AppTaskCommand = AppTaskCommandEnum.OpenDataCSVNationalOfMWQMSites,
ErrorText = "",
StatusText = ServiceRes.GeneratingDocument + " " + _BaseEnumService.GetEnumText_AppTaskCommandEnum(AppTaskCommandEnum.OpenDataCSVNationalOfMWQMSites),
AppTaskStatus = AppTaskStatusEnum.Created,
PercentCompleted = 1,
Parameters = "No Parameters",
Language = LanguageRequest,
StartDateTime_UTC = DateTime.UtcNow,
EndDateTime_UTC = null,
EstimatedLength_second = null,
RemainingTime_second = null,
};
AppTaskModel appTaskModelRet = _AppTaskService.PostAddAppTask(appTaskModelNew);
if (!string.IsNullOrWhiteSpace(appTaskModelRet.Error))
{
return(ReturnError(appTaskModelRet.Error));
}
ts.Complete();
}
return(ReturnError(""));
}
public JsonResult FindMissingPrecipForProvinceJSON(int ProvinceTVItemID)
{
AppTaskModel appTaskModel = _ProvinceToolsService.FindMissingPrecipForProvinceDB(ProvinceTVItemID);
return(Json(appTaskModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult EmailDistributionListGenerateExcelFileJSON(int ParentTVItemID)
{
AppTaskModel appTaskModel = _EmailDistributionListService.EmailDistributionListGenerateExcelFileDB(ParentTVItemID);
return(Json(appTaskModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult ProvinceToolsCreateClassificationInputsKMLJSON(int ProvinceTVItemID)
{
AppTaskModel appTaskModel = _ProvinceToolsService.ProvinceToolsCreateClassificationInputsKMLDB(ProvinceTVItemID);
return(Json(appTaskModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult ProvinceToolsGenerateStatsJSON(int ProvinceTVItemID)
{
AppTaskModel appTaskModel = _ProvinceToolsService.ProvinceToolsGenerateStatsDB(ProvinceTVItemID);
return(Json(appTaskModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult ProvinceToolsCreateMWQMSitesAndPolSourceSitesKMLJSON(int ProvinceTVItemID)
{
AppTaskModel appTaskModel = _ProvinceToolsService.ProvinceToolsCreateMWQMSitesAndPolSourceSitesKMLDB(ProvinceTVItemID);
return(Json(appTaskModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult GenerateLinksBetweenMWQMSitesAndPolSourceSitesForCSSPWebToolsVisualizationJSON(int ProvinceTVItemID)
{
AppTaskModel appTaskModel = _ProvinceToolsService.GenerateLinksBetweenMWQMSitesAndPolSourceSitesForCSSPWebToolsVisualizationDB(ProvinceTVItemID);
return(Json(appTaskModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult GenerateClassificationInputs_XX_FromDB_kmlFromDataInCSSPDBJSON(int ProvinceTVItemID)
{
AppTaskModel appTaskModel = _ProvinceToolsService.GenerateClassificationInputs_XX_FromDB_kmlFromDataInCSSPDBDB(ProvinceTVItemID);
return(Json(appTaskModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult GenerateKMLFileClassificationForCSSPWebToolsVisualizationJSON(int ProvinceTVItemID)
{
AppTaskModel appTaskModel = _ProvinceToolsService.GenerateKMLFileClassificationForCSSPWebToolsVisualizationDB(ProvinceTVItemID);
return(Json(appTaskModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult GetAllPrecipitationForYearJSON(int ProvinceTVItemID, int Year)
{
AppTaskModel appTaskModel = _ProvinceToolsService.GetAllPrecipitationForYearDB(ProvinceTVItemID, Year);
return(Json(appTaskModel.Error, JsonRequestBehavior.AllowGet));
}
