/// <summary>
/// Check for any Overdue uploads and email if necessary
/// </summary>
private static void CheckForOverdueUploads()
{
try
{
AddDebugInfo(new DebugInfo("CheckForOverdueUploads called.", DebugInfoTypeEnum.Developer));
var overdueSchemas = _dataSetSchemaService.GetOverDue();
//send reminder emails
if (overdueSchemas.Count > 0)
{
AddDebugInfo(new DebugInfo(overdueSchemas.Count + " overdue reminder emails will be sent.", DebugInfoTypeEnum.EmailSent));
}
foreach (var schema in overdueSchemas)
{
var template = String.Format("{0}\\EmailTemplates\\UploadReminder.txt", ConfigurationManager.AppSettings["FileRoot"]);
var emailText = new System.Text.StringBuilder();
emailText.Append(File.ReadAllText(template));
emailText.Replace("#Schema#", schema.Title);
emailText.Replace("#LastUploadDate#", schema.DateLastUploadedTo.ToString());
emailText.Replace("#DatashareURL#", ConfigurationManager.AppSettings["DatashareURL"]);
SendEmail(schema.OwnerEmail, emailText.ToString(), true, "Overdue upload reminder");
AddDebugInfo(new DebugInfo(String.Format(@"Schema: {0}. Overdue upload reminder sent to:""{1}""", schema.Title, schema.OwnerEmail), DebugInfoTypeEnum.EmailSent));
schema.DateLastReminded = DateTime.Now;
_dataSetSchemaService.Save(schema);
}
}
catch (Exception ex)
{
AddDebugInfo(new DebugInfo(String.Format(@"CheckForOverdueUploads threw an error: {0}", ex.Message), DebugInfoTypeEnum.Error), ex);
RestartService("DataShare.Service", 10000);
}
}
public ActionResult Edit(DataSetSchema dsSchema, string categoryName, string schemaName, string showfields)
{
ViewBag.SchemaName = schemaName;
ViewBag.CategoryName = categoryName;
try
{
dsSchema.Category = _categoryService.Get(categoryName);
dsSchema.Definition = _dataSetSchemaService.Get(schemaName).Definition;
if (!ModelState.IsValid)
{
PopulateDsSchemaWithEsdValues(dsSchema);
return(View("Edit", dsSchema));
}
SaveEsdLinks(dsSchema); /*save esd links before populating esd values as it will disappear when populated*/
PopulateDsSchemaWithEsdValues(dsSchema);
_dataSetSchemaService.Save(dsSchema);
//ViewBag.Message = "<p class='note'></p>";
ResetBreadCrumbsCache();
TempData["SchemaSourceErrorMessage"] = "Schema definition successfully saved.";
return(RedirectToAction("Edit", new { categoryName, schemaName, showfields = showfields }));
//return View("Edit", dsSchema);
}
catch (Exception ex)
{
Elmah.ErrorLog.GetDefault(null).Log(new Elmah.Error(ex));
dsSchema.Category = _categoryService.Get(categoryName);
dsSchema.Definition = _dataSetSchemaService.Get(schemaName).Definition;
ViewBag.Message = string.Format("<p class='warning'>Unable to save schema definition. {0}.</p>", ex.Message);
return(View(dsSchema));
}
}
