public void CreateDatabase()
{
PangolinContext database = new PangolinContext();
database.Database.EnsureCreated();
Assert.IsTrue(File.Exists("Pangolin-Database.db"));
}
public static bool GenerateReportForPangolin(Pangolin Pangolin, string pathToSave, bool open)
{
try
{
// Create new Excel
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;
ExcelPackage excel = new ExcelPackage();
// DB
PangolinContext db = DatabaseManager.GetDatabase();
// Add Data
AddWorksheetToExcel("Pangolin Data", new Pangolin[] { Pangolin }, excel);
AddWorksheetToExcel("Daily Recording", db.DailyActivities.Where(p => p.ReferencePangolin == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Infant Feeding", db.InfantFeedings.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Veterinary Treatment", db.VeterinaryTreatments.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Interdepartmental Movement", db.InterdepartmentalMovements.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Measurements", db.PhysicalMeasurements.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Mortality", db.Mortalities.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Release", db.Releases.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Microchip", db.Microchips.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Tracking Device", db.TrackingDevices.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Criminal Cases", db.CriminalCases.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
AddWorksheetToExcel("Documents", db.Documents.Where(p => p.ReferenceNumber == Pangolin).ToArray(), excel);
// Save
FileInfo excelFile = new FileInfo(pathToSave);
excel.SaveAs(excelFile);
if (open)
{
Process.Start(new ProcessStartInfo(pathToSave)
{
UseShellExecute = true
});
}
return(true);
}
catch (Exception ex)
{
LogManager.logError(ex, "Error");
return(false);
}
}
