public async Task <IActionResult> OnGetAsync()
{
try
{
if (TempData.NotNullOrEmpty() && TempData.Peek(FindSubKey) != null)
{
Input = TempData.Get <SubmissionSearchInputModel>(FindSubKey);
TempData.Keep(FindSubKey);
}
else
{
Input = new SubmissionSearchInputModel();
}
await PopulateDropDowns();
SuccessMessage = TempData.Get <string>("EditSuccess") ?? TempData.Get <string>("DeleteSuccess") ?? string.Empty;
Msd1SearchResultList = _msd1SubmissionSearch.GenerateMsd1ViewModelFilteredOnSearchCriteria(Input, false);
}
catch (Exception e)
{
ModelState.AddModelError("CustomError", "There has been an error connecting to the database");
_logger.LogError(e.Message);
}
return(Page());
}
public async Task <IActionResult> OnPostSearch()
{
try
{
if (Input.DateEntered != null)
{
if (!ValidateDate())
{
ModelState.AddModelError("CustomError", "Please check the format of your date");
Input = new SubmissionSearchInputModel();
}
}
Msd1SearchResultList = _msd1SubmissionSearch.GenerateMsd1ViewModelFilteredOnSearchCriteria(Input, false);
await PopulateDropDowns();
if (Msd1SearchResultList.Count == 0)
{
ModelState.AddModelError("CustomError", "No records have been found matching the above criteria");
}
}
catch (Exception e)
{
ModelState.AddModelError("CustomError", "There has been an error");
_logger.LogError(e.Message);
}
TempData.Put(FindSubKey, Input);
return(Page());
}
public IActionResult OnGetExport(SubmissionSearchInputModel searchInputs)
{
var msd1SummarySearchResultList = _msd1SubmissionSearch.GenerateMsd1ViewModelFilteredOnSearchCriteria(searchInputs, true);
var byteArrayCsvData = _csvExtractor.GenerateMsd1CsvExtract(msd1SummarySearchResultList);
var csvDownloadFileName = "MSD1SearchResults" + DateTime.Now.ToShortDateString() + ".csv";
return(File(byteArrayCsvData, "text/csv", csvDownloadFileName));
}
public List <Msd1SummaryViewModel> GenerateMsd1ViewModelFilteredOnSearchCriteria(SubmissionSearchInputModel searchModel, bool resultToBeExported)
{
_searchFilterDictionary.Clear();
CreateSearchDictionary(searchModel);
if (_searchFilterDictionary.Count == 0)
{
return(new List <Msd1SummaryViewModel>());
}
CreateMsd1List(_searchFilterDictionary, MSDData.MSD1);
if (_msd1Queryable == null)
{
return(new List <Msd1SummaryViewModel>());
}
AddToSummaryViewModel();
PopulateShipAndSenderDetails();
if (resultToBeExported)
{
PopulateAdditionalDetailsForCsvExport();
}
return(_msd1SummarySearchResultList);
}
private void CreateSearchDictionary(SubmissionSearchInputModel searchModel)
{
if (!string.IsNullOrWhiteSpace(searchModel.RecordRef))
{
_searchFilterDictionary.Add("RecordRef", searchModel.RecordRef);
}
if (!string.IsNullOrWhiteSpace(searchModel.ShipName))
{
_searchFilterDictionary.Add("ShipName", searchModel.ShipName);
}
if (!string.IsNullOrWhiteSpace(searchModel.SelectedCargoType))
{
_searchFilterDictionary.Add("CargoType", searchModel.SelectedCargoType);
}
if (!string.IsNullOrWhiteSpace(searchModel.StatisticalPort))
{
_searchFilterDictionary.Add("StatisticalPort", searchModel.StatisticalPort);
}
if (!string.IsNullOrWhiteSpace(searchModel.SenderId))
{
_searchFilterDictionary.Add("SenderID", searchModel.SenderId);
}
if (!string.IsNullOrWhiteSpace(searchModel.SubmissionRef))
{
_searchFilterDictionary.Add("SubmissionRef", searchModel.SubmissionRef);
}
if (!string.IsNullOrWhiteSpace(searchModel.Agent))
{
_searchFilterDictionary.Add("Agent", searchModel.Agent);
}
if (!string.IsNullOrWhiteSpace(searchModel.Line))
{
_searchFilterDictionary.Add("Line", searchModel.Line);
}
if (!string.IsNullOrWhiteSpace(searchModel.ReportingPort))
{
_searchFilterDictionary.Add("ReportingPort", searchModel.ReportingPort);
}
if (!string.IsNullOrWhiteSpace(searchModel.Port))
{
_searchFilterDictionary.Add("Port", searchModel.Port);
}
if (!string.IsNullOrWhiteSpace(searchModel.IMO))
{
_searchFilterDictionary.Add("IMO", searchModel.IMO);
}
if (!string.IsNullOrWhiteSpace(searchModel.Year))
{
_searchFilterDictionary.Add("Year", searchModel.Year);
}
if (!string.IsNullOrWhiteSpace(searchModel.Quarter))
{
_searchFilterDictionary.Add("Quarter", searchModel.Quarter);
}
if (!string.IsNullOrWhiteSpace(searchModel.DateEntered))
{
_searchFilterDictionary.Add("DateEntered", searchModel.DateEntered);
}
if (!string.IsNullOrWhiteSpace(searchModel.Source))
{
_searchFilterDictionary.Add("Source", searchModel.Source);
}
}
