public string Backup(BackupReason Reason)
{
string CurrentTime = DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss.f");
string DatabaseBackupName = DATABASE_NAME + "_" + CurrentTime + "." + DATABASE_EXTENSION + "." + DATABASE_BACKUP_EXTENSION;
string BackupFolder = String.Empty;
if (Reason == BackupReason.Automatic)
{
BackupFolder = BACKUP_AUTO_FOLDER;
}
else if (Reason == BackupReason.User)
{
BackupFolder = BACKUP_FOLDER;
}
this.Save(BackupFolder, DatabaseBackupName);
return(DatabaseBackupName);
}
private static string EmailBody(BackupRequest backupRequest)
{
StringBuilder sb = new StringBuilder();
try
{
int _urgentBackupRequestResponseTimeInMinutes = 0;
int _standardBackupRequestResponseTimeInMinutes = 0;
BackupReason backupReason = null;
List <BackupRequestShiftAndDate> backupRequestShiftsAndDates = new List <BackupRequestShiftAndDate>();
using (MTCDbContext db = new MTCDbContext())
{
_urgentBackupRequestResponseTimeInMinutes = Convert.ToInt32(Utilities.GetApplicationSettingValue("UrgentBackupRequestResponseTimeInMinutes"));
_standardBackupRequestResponseTimeInMinutes = Convert.ToInt32(Utilities.GetApplicationSettingValue("StandardBackupRequestResponseTimeInMinutes"));
backupReason = db.BackupReasons.Find(backupRequest.BackupReasonId);
backupRequestShiftsAndDates = db.BackupRequestShiftsAndDates.Where(p => p.BackupRequestId == backupRequest.Id).ToList();
}
string requestPriority = "Standard (You have up to " + _standardBackupRequestResponseTimeInMinutes / 60 + " hours to respond)";
if (backupRequest.RequestIsUrgent)
{
requestPriority = "Urgent (You have up to " + _urgentBackupRequestResponseTimeInMinutes + " minutes to respond)";
}
sb.Append("<h3>1. The following Back-up Truck Service Request has been entered into LATATrax.</h3>");
sb.Append("<table>");
sb.Append("<tr>");
sb.Append("<td>Request #</td>");
sb.Append("<td>" + backupRequest.RequestNumber + "</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td>Request Priority</td>");
sb.Append("<td>" + requestPriority + "</td>");
sb.Append("</tr>");
using (var de = new MTCDBEntities())
{
sb.Append("<tr>");
sb.Append("<td>Requesting Contractor:</td>");
var contractor = de.Contractors.FirstOrDefault(p => p.ContractorID == backupRequest.ContractorId);
if (contractor != null)
{
sb.Append("<td>" + contractor.ContractCompanyName + "</td>");
}
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td>Beat needing Back-up:</td>");
var beat = de.BeatDatas.FirstOrDefault(p => p.ID == backupRequest.BeatId);
if (beat != null)
{
sb.Append("<td>" + beat.BeatName + "</td>");
}
sb.Append("</tr>");
}
sb.Append("<tr>");
sb.Append("<td>Dates and Shifts Back-up Needed:</td>");
sb.Append("<td>");
foreach (var b in backupRequestShiftsAndDates)
{
var shifts = "";
if (b.AMRequested)
{
shifts = " AM ";
}
if (b.MIDRequested)
{
shifts += " MID ";
}
if (b.PMRequested)
{
shifts += " PM ";
}
sb.Append("<span><b>" + b.BackupDate.ToString("MM/dd/yyyy") + "</b> " + shifts + "</span><br />");
}
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td>Back-up Reason Code:</td>");
if (backupReason != null)
{
sb.Append("<td>" + backupReason.ReasonCode + " - " + backupReason.Reason + "</td>");
}
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td>Requestor's Comments:</td>");
sb.Append("<td>" + backupRequest.Comments + "</td>");
sb.Append("</tr>");
sb.Append("<tr>");
sb.Append("<td><br/></td>");
sb.Append("</tr>");
sb.Append("</table>");
}
catch
{
}
return(sb.ToString());
}
