/// <summary>
/// Construct a <code>Settings</code> form with no weapon list
/// </summary>
/// <param name="uic">Calling UIController</param>
/// <param name="configReader">A configuration reader</param>
public Settings(Controller.UIController uic, ConfigReader configReader)
: this(uic, configReader, new List<string>())
{
MessageBox.Show("This is the first time you have run SANTA. Please specify the paths for the report template, database, and log file.", "First run", MessageBoxButtons.OK, MessageBoxIcon.Information);
firstRun = true;
}
/// <summary>
/// Given Pixel Data, convert the data to inches, generate new statists based on them, and generate the report based on the new data.
/// </summary>
/// <param name="data">Data points in pixels.</param>
/// <param name="stats">Statistics in pixels.</param>
/// <param name="configReader"></param>
public static void GenerateReport(Datatype.ImageData data, Datatype.Stats stats, ConfigReader configReader)
{
IList<Datatype.DoublePoint> newPoints = convertToInches(data, stats);
newPoints = verticallyFlip(newPoints);
newPoints = translatePoints(newPoints);
//To test the GenerateReport Class, add points from a known set of statistics into the
//following field. Then any report generated will be from this set.
/*newPoints = new List<Datatype.DoublePoint>();
newPoints.Add(new Datatype.DoublePoint(-6, 1.5));
newPoints.Add(new Datatype.DoublePoint(0, -1.4));
newPoints.Add(new Datatype.DoublePoint(-0.3, 1.6));
newPoints.Add(new Datatype.DoublePoint(-3.6, -4.2));
newPoints.Add(new Datatype.DoublePoint(1.1, -1.5));
newPoints.Add(new Datatype.DoublePoint(-3.4, 0.2));
newPoints.Add(new Datatype.DoublePoint(0.7, -2.4));
newPoints.Add(new Datatype.DoublePoint(-3.8, 3.6));
newPoints.Add(new Datatype.DoublePoint(-0.5, -3.2));
newPoints.Add(new Datatype.DoublePoint(2.7, -2.4));
newPoints = translatePoints(newPoints);*/
Datatype.Stats newStats = Stats.GenerateStatistics(newPoints);
try
{
ExcelReportGenerator.GenerateReport(newPoints, data, newStats, configReader);
}
catch (System.InvalidOperationException)
{
//Do nothing for now.
}
}
/// <summary>
/// Constructs a <code>Master</code> object by initializing the
/// <code>ConfigReader</code> and the <code>UIController</code>.
/// </summary>
public Master()
{
_configReader = new ConfigReader();
bool firstUse = _configReader.getValue("First Use").Equals("True");
if (firstUse) {
_configReader.setValue("First Use", "False");
}
new UIController(this, firstUse);
}
/// <summary>
/// Construct a <code>Settings</code> form.
/// </summary>
/// <param name="uic">Calling UIController</param>
/// <param name="configReader">A configuration reader</param>
/// <param name="weapons">The current weapon list</param>
public Settings(Controller.UIController uic, ConfigReader configReader, List<String> weapons)
{
InitializeComponent();
_uic = uic;
_reader = configReader;
_weapons = weapons;
InitializeValues();
this.Closing += new CancelEventHandler(Settings_Closing);
}
/// <summary>
/// Adds a weapon name to the database.
/// </summary>
/// <param name="weaponName">The weapon name to add to the database.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <exception cref="OleDbException">A connection-level error occurred while opening the connection.</exception>
/// <exception cref="InvalidOperationException">The INSERT INTO Weapon command failed.</exception>
public static void AddWeaponName(String weaponName, ConfigReader configReader)
{
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location"))) {
openConnection(conn);
using (OleDbCommand command = new OleDbCommand()) {
command.Connection = conn;
command.CommandText = "INSERT INTO Weapon (WeaponName) VALUES (?)";
command.Prepare();
setStringParameter(command, "WeaponName", weaponName);
try {
command.ExecuteNonQuery();
} catch (InvalidOperationException e) {
Log.LogError("Could not perform INSERT INTO Weapon.", "SQL", command.CommandText);
throw e;
}
}
}
}
/// <summary>
/// Adds a caliber unit to the database.
/// </summary>
/// <param name="caliberUnit">The <c>CaliberUnit</c> to add to the database.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <exception cref="OleDbException">A connection-level error occurred while opening the connection.</exception>
/// <exception cref="InvalidOperationException">The INSERT INTO Caliber command failed.</exception>
public static void AddCaliberUnit(Datatype.CaliberUnit caliberUnit, ConfigReader configReader)
{
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location")))
{
openConnection(conn);
using (OleDbCommand command = new OleDbCommand()) {
command.Connection = conn;
command.CommandText = "INSERT INTO Caliber (UnitName, UnitsPerInch) VALUES (?, ?)";
command.Prepare();
setStringParameter(command, "UnitName", caliberUnit.unitName);
command.Parameters.Add("UnitsPerInch", OleDbType.Double).Value = caliberUnit.unitsPerInch;
try {
command.ExecuteNonQuery();
} catch (InvalidOperationException e) {
Log.LogError("Could not perform INSERT INTO Caliber.", "SQL", command.CommandText);
throw e;
}
}
}
}
/// <summary>
/// Returns all of the caliber options already in the database with their IDs.
/// </summary>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <returns>A Hashtable where the keys are the caliberIDs as ints and the values are
/// caliber names as Strings.</returns>
/// <exception cref="OleDbException">A connection-level error occurred while opening the connection.</exception>
public static List<Datatype.CaliberUnit> GetCaliberUnits(ConfigReader configReader)
{
List<Datatype.CaliberUnit> calibers = new List<Datatype.CaliberUnit>();
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location")))
{
openConnection(conn);
using (OleDbCommand command = new OleDbCommand("SELECT * FROM Caliber", conn)) {
using (OleDbDataReader reader = command.ExecuteReader()) {
while (reader.Read()) {
// We could trust that the columns are index 0, 1, and 2,
// but let's use the specific column name for safety.
int caliberUnitID = reader.GetInt32(reader.GetOrdinal("CaliberID"));
String unitName = reader.GetString(reader.GetOrdinal("UnitName"));
double unitsPerInch = reader.GetDouble(reader.GetOrdinal("UnitsPerInch"));
calibers.Add(new Datatype.CaliberUnit(caliberUnitID, unitName, unitsPerInch));
}
}
}
}
return calibers;
}
/// <summary>
/// Inserts an <c>ImageData</c> object into the <c>Target</c> table.
/// </summary>
/// <param name="imageData">The <c>ImageData</c> to insert.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <exception cref="OleDbException">A connection-level error occurred while opening the connection.</exception>
/// <exception cref="InvalidOperationException">The INSERT INTO Target command failed.</exception>
/// <exception cref="ArgumentException">The caliber or weapon name was not found in the database.</exception>
/// <returns>The <c>targetID</c> of the newly-inserted record.</returns>
private static int InsertData(Datatype.ImageData imageData, ConfigReader configReader)
{
int targetID = -1;
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location"))) {
openConnection(conn);
if (!CaliberIDExists(imageData.caliber.caliberUnitID, configReader)) {
Log.LogError("Caliber to insert not found in database.", "unitID",
imageData.caliber.caliberUnitID.ToString(), "unitName", imageData.caliber.unitName,
"unitsPerInch", imageData.caliber.unitsPerInch.ToString());
throw new ArgumentException("Caliber to insert does not exist.", "caliber");
}
if (!WeaponExists(imageData.weaponName, configReader)) {
Log.LogError("Weapon name to insert not found in database.", "weaponName", imageData.weaponName);
throw new ArgumentException("Weapon name to insert not found in database.", "weaponName");
}
using (OleDbCommand command = new OleDbCommand()) {
command.Connection = conn;
command.CommandText = "INSERT INTO Target (OrigFilename, ReportFilename, DateTimeFired, DateTimeProcessed, ShooterLName, ShooterFName, RangeLocation, DistanceUnits, Distance, Temperature, WeaponName, SerialNumber, WeaponNotes, CaliberID, CaliberValue, LotNumber, ProjectileMassGrains, AmmunitionNotes, ShotsFired, ShotLocations, Scale, ROI) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
command.Prepare();
setStringParameter(command, "OrigFilename", imageData.origFilename);
setStringParameter(command, "ReportFilename", imageData.reportFilename);
command.Parameters.Add("DateTimeFired", OleDbType.Date).Value = imageData.dateTimeFired;
command.Parameters.Add("DateTimeProcessed", OleDbType.Date).Value = DateTime.Now;
setStringParameter(command, "ShooterLName", imageData.shooterLName);
setStringParameter(command, "ShooterFName", imageData.shooterFName);
setStringParameter(command, "RangeLocation", imageData.rangeLocation);
command.Parameters.Add("DistanceUnits", OleDbType.UnsignedTinyInt).Value = imageData.distanceUnits;
command.Parameters.Add("Distance", OleDbType.Integer).Value = imageData.distance;
command.Parameters.Add("Temperature", OleDbType.UnsignedTinyInt).Value = imageData.temperature;
setStringParameter(command, "WeaponName", imageData.weaponName);
setStringParameter(command, "SerialNumber", imageData.serialNumber);
command.Parameters.Add("WeaponNotes", OleDbType.LongVarWChar).Value = imageData.weaponNotes == null ? "" : imageData.weaponNotes;
command.Parameters.Add("CaliberID", OleDbType.Integer).Value = imageData.caliber.caliberUnitID;
command.Parameters.Add("CaliberValue", OleDbType.Double).Value = imageData.caliberValue;
setStringParameter(command, "LotNumber", imageData.lotNumber);
command.Parameters.Add("ProjectileMassGrains", OleDbType.Integer).Value = imageData.projectileMassGrains;
command.Parameters.Add("AmmunitionNotes", OleDbType.LongVarWChar).Value = imageData.ammunitionNotes == null ? "" : imageData.ammunitionNotes;
command.Parameters.Add("ShotsFired", OleDbType.Integer).Value = imageData.shotsFired;
StringBuilder pointStringBuilder = new StringBuilder();
foreach (Point point in imageData.points) {
pointStringBuilder.Append(point.X);
pointStringBuilder.Append(",");
pointStringBuilder.Append(point.Y);
pointStringBuilder.Append(",");
}
command.Parameters.Add("ShotLocations", OleDbType.LongVarWChar).Value = pointStringBuilder.ToString();
StringBuilder scaleStringBuilder = new StringBuilder();
scaleStringBuilder.Append(imageData.scale.horizontal.X);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.horizontal.Y);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.middle.X);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.middle.Y);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.vertical.X);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.vertical.Y);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.horizontalLength);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.verticalLength);
setStringParameter(command, "Scale", scaleStringBuilder.ToString());
StringBuilder ROIStringBuilder = new StringBuilder();
ROIStringBuilder.Append(imageData.regionOfInterest.topLeft.X);
ROIStringBuilder.Append(",");
ROIStringBuilder.Append(imageData.regionOfInterest.topLeft.Y);
ROIStringBuilder.Append(",");
ROIStringBuilder.Append(imageData.regionOfInterest.bottomRight.X);
ROIStringBuilder.Append(",");
ROIStringBuilder.Append(imageData.regionOfInterest.bottomRight.Y);
setStringParameter(command, "ROI", ROIStringBuilder.ToString());
try {
command.ExecuteNonQuery();
} catch (InvalidOperationException e) {
Log.LogError("Could not perform INSERT INTO Target.", "SQL", command.CommandText);
throw e;
}
}
using (OleDbCommand command = new OleDbCommand("SELECT MAX(TargetID) FROM Target", conn)) {
using (OleDbDataReader reader = command.ExecuteReader()) {
if (reader.Read()) {
targetID = reader.GetInt32(0);
} else {
Log.LogError("Unable to get the maximum TargetID.", "SQL", command.CommandText);
}
}
}
}
return targetID;
}
/// <summary>
/// Returns true if the given <c>caliberID</c> is in the database.
/// </summary>
/// <param name="caliberID">The <c>caliberID</c> to find.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <returns>True if the given <c>caliberID</c> is in the database.</returns>
private static Boolean CaliberIDExists(int caliberID, ConfigReader configReader)
{
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location"))) {
openConnection(conn);
using (OleDbCommand command = new OleDbCommand()) {
command.Connection = conn;
command.CommandText = "SELECT CaliberID FROM Caliber WHERE CaliberID = ?";
command.Prepare();
command.Parameters.Add("CaliberID", OleDbType.Integer).Value = caliberID;
using (OleDbDataReader reader = command.ExecuteReader()) {
return reader.HasRows;
}
}
}
}
/// <summary>
/// Loads a <c>CaliberUnit</c> from the database.
/// </summary>
/// <param name="caliberID">The <paramref name="caliberID"/> of the <c>CaliberUnit</c>.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <returns>The <c>CaliberUnit</c> from the database.</returns>
/// <exception cref="OleDbException">A connection-level error occurred while opening the connection.</exception>
private static Datatype.CaliberUnit GetCaliberUnit(int caliberID, ConfigReader configReader)
{
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location"))) {
openConnection(conn);
using (OleDbCommand command = new OleDbCommand()) {
command.Connection = conn;
command.CommandText = "SELECT * FROM Caliber WHERE CaliberID = ?";
command.Prepare();
command.Parameters.Add("CaliberID", OleDbType.Integer).Value = caliberID;
using (OleDbDataReader reader = command.ExecuteReader()) {
if (reader.Read()) {
// We could trust that the columns are index 0, 1, and 2,
// but let's use the specific column name for safety.
int caliberUnitID = reader.GetInt32(reader.GetOrdinal("CaliberID"));
String unitName = reader.GetString(reader.GetOrdinal("UnitName"));
double unitsPerInch = reader.GetDouble(reader.GetOrdinal("UnitsPerInch"));
if (caliberID != caliberUnitID) {
Log.LogError("IDs do not match in GetCaliberUnit().", "caliberID", caliberID.ToString(),
"caliberUnitID", caliberUnitID.ToString());
}
return new Datatype.CaliberUnit(caliberUnitID, unitName, unitsPerInch);
}
}
}
}
Log.LogError("Caliber unit not found in database.", "unitID", caliberID.ToString());
throw new Exception("Error in GetCaliberUnit()");
}
/// <summary>
/// Saves an <c>ImageData</c> object to the <c>Target</c> table.
/// </summary>
/// <param name="imageData">The <c>ImageData</c> to save.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <exception cref="OleDbException">A connection-level error occurred while opening the connection.</exception>
/// <exception cref="InvalidOperationException">The SQL command failed.</exception>
/// <exception cref="ArgumentException">The caliber or weapon name was not found in the database.</exception>
/// <returns>The <c>targetID</c> of the saved record.</returns>
public static int SaveData(Datatype.ImageData imageData, ConfigReader configReader)
{
if (imageData.targetID == -1) {
return InsertData(imageData, configReader);
} else {
return UpdateData(imageData, configReader);
}
}
/// <summary>See <c>MSAccess.AddWeaponName()</c>.</summary>
public static void AddWeaponName(String weaponName, ConfigReader configReader)
{
MSAccess.AddWeaponName(weaponName, configReader);
}
/// <summary>
/// Returns true if the given <c>weaponName</c> is in the database.
/// </summary>
/// <param name="caliberID">The <c>weaponName</c> to find.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <returns>True if the given <c>weaponName</c> is in the database.</returns>
private static Boolean WeaponExists(String weaponName, ConfigReader configReader)
{
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location"))) {
openConnection(conn);
using (OleDbCommand command = new OleDbCommand()) {
command.Connection = conn;
command.CommandText = "SELECT WeaponName FROM Weapon WHERE WeaponName = ?";
command.Prepare();
setStringParameter(command, "WeaponName", weaponName);
using (OleDbDataReader reader = command.ExecuteReader()) {
return reader.HasRows;
}
}
}
}
/// <summary>See <c>MSAccess.SaveData()</c>.</summary>
public static int SaveData(Datatype.ImageData imageData, ConfigReader configReader)
{
return MSAccess.SaveData(imageData, configReader);
}
/// <summary>See <c>MSAccess.GetCaliberUnits()</c>.</summary>
public static List<Datatype.CaliberUnit> GetCaliberUnits(ConfigReader configReader)
{
return MSAccess.GetCaliberUnits(configReader);
}
/// <summary>
/// Generates a report to an excel file.
/// </summary>
/// <param name="data">Data to save.</param>
/// <param name="stats">The statistics on the data.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the sample report.</param>
public static void GenerateReport(Datatype.ImageData data, Datatype.Stats stats, ConfigReader configReader)
{
UnitConverter.GenerateReport(data, stats, configReader);
}
private static void insertStat(ExcelWorksheet reportWorksheet, string configName, double statValue, ConfigReader reader)
{
String output = "=IF(" + reader.getValue("Cell To Determine Unit of Measure") + " =\"Statistics (in inches):\", " + statValue + ", IF(" + reader.getValue("Cell To Determine Unit of Measure") + " =\"Statistics (in centimeters):\", " + (statValue * 2.54) + ", " + (statValue * minutesOfAngleConverter) + "))";
reportWorksheet.Cells[reader.getValue(configName)].Formula = output;
}
/// <summary>See <c>MSAccess.AddCaliberUnit()</c>.</summary>
public static void AddCaliberUnit(Datatype.CaliberUnit caliberUnit, ConfigReader configReader)
{
MSAccess.AddCaliberUnit(caliberUnit, configReader);
}
public static void GenerateReport(IList<Datatype.DoublePoint> newPoints, Datatype.ImageData data, Datatype.Stats stats, ConfigReader reader)
{
string imagePath = data.origFilename;
string savePath = data.reportFilename;
if (savePath == null)
{
throw new NullReferenceException("A save path must be provided in order for the report to save");
}
//Open Excel File
ExcelFile excelFile = new ExcelFile();
try
{
excelFile.LoadXlsx(reader.getValue("Template Location"),
XlsxOptions.PreserveKeepOpen);
}
//Catch and report error if directory is not valid
catch (System.IO.DirectoryNotFoundException)
{
MessageBox.Show("A report could not be generated. Please check the configuration file for errors. " +
"The path to the default template contains a directory that doesn't seem to exist.", "Directory Not Found",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
throw new System.InvalidOperationException("DirectoryNotFoundException");
}
//Catch and return error if file is not found.
catch (System.IO.FileNotFoundException)
{
MessageBox.Show("A report could not be generated. Please check the configuration file for errors. " +
"The file name given doesn't seem to exist.", "File Not Found",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
throw new System.InvalidOperationException("FileNotFoundException");
}
//Catch and report error if the file is already opened and locked
catch (System.IO.IOException)
{
MessageBox.Show("A report could not be generated because the template file is locked. " +
"Please close any application that may be using the file and try again.", "File Could Not Load",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
throw new System.InvalidOperationException("FileLoadException");
}
ExcelWorksheet reportWorksheet = excelFile.Worksheets[0];
ExcelWorksheet otherStatsWorksheet = excelFile.Worksheets[1];
//Set row fill color.
Color rowFillColor = Color.FromArgb(219, 229, 241);
//Check that data.distance != 0
if (data.distance == 0)
{
throw new DivideByZeroException("Data.distance cannot be 0");
}
//Determine minutes of angle factor. If yards, use the literal data.distance; else convert to yards.
if (data.distanceUnits == SANTA.Datatype.UnitsOfMeasure.Yard)
{
minutesOfAngleConverter = minutesOfAngleConversionFactor*100/data.distance;
} else if (data.distanceUnits == SANTA.Datatype.UnitsOfMeasure.Meter)
{
minutesOfAngleConverter = minutesOfAngleConversionFactor*100/(data.distance*1.0936133);
} else
{
//Should never get here, but exception will trigger if we do.
throw new InstanceNotFoundException("Distance Units are not of a known datatype.");
}
// Column width of 8, 30, 16, 9, 9, 9, 9, 4 and 5 characters.
reportWorksheet.Columns[0].Width = 285/7*256;
reportWorksheet.Columns[1].Width = 107/7*256;
reportWorksheet.Columns[2].Width = 12*(256 - 24);
reportWorksheet.Columns[3].Width = 12*(256 - 24);
reportWorksheet.Columns[4].Width = 12*(256 - 24);
reportWorksheet.Columns[5].Width = 12*(256 - 24);
reportWorksheet.Columns[6].Width = 12*(256 - 24);
reportWorksheet.Columns[7].Width = 12*(256 - 24);
// Fill in cell data
placeValue(reportWorksheet, "Target Distance", data.distance);
reportWorksheet.Cells[reader.getValue("Shooter Name")].Value = data.shooterFName + " " + data.shooterLName;
reportWorksheet.Cells[reader.getValue("Shoot Date")].Value = data.dateTimeFired;
reportWorksheet.Cells[reader.getValue("Shoot Date")].Style.NumberFormat = reader.getValue("Date Format");
reportWorksheet.Cells[reader.getValue("Range Name")].Value = data.rangeLocation;
reportWorksheet.Cells[reader.getValue("Temperature")].Value = Datatype.ImageData.tempDetails[(int) data.temperature];
reportWorksheet.Cells[reader.getValue("Target Distance")].Value = data.distance + " " + data.distanceUnits;
if (data.shotsFired == newPoints.Count)
{
reportWorksheet.Cells[reader.getValue("Shots Fired")].Value = data.shotsFired;
}
else
{
reportWorksheet.Cells[reader.getValue("Shots Fired")].Value = newPoints.Count.ToString() + " found of " + data.shotsFired.ToString() + " indicated";
}
reportWorksheet.Cells[reader.getValue("Weapon Name")].Value = data.weaponName;
reportWorksheet.Cells[reader.getValue("Weapon Serial Number")].Value = data.serialNumber;
reportWorksheet.Cells[reader.getValue("Ammo Caliber")].Value = data.caliberValue + " " + data.caliber.unitName;
reportWorksheet.Cells[reader.getValue("Ammo Lot Number")].Value = data.lotNumber;
reportWorksheet.Cells[reader.getValue("Ammo Mass")].Value = data.projectileMassGrains + " grains";
reportWorksheet.Cells[reader.getValue("Target ID")].Value = "Target ID: " + data.targetID;
reportWorksheet.Cells[reader.getValue("Weapon Notes")].Value = "Weapon Notes: " + data.weaponNotes;
reportWorksheet.Cells[reader.getValue("Ammo Notes")].Value = "Ammo Notes: " + data.ammunitionNotes;
//Fill in the shot records
Random generator = new Random();
for (int i = 0; i < newPoints.Count && i < 50; i++)
{
//TODO: Set first point of x, y, z values (or specify each point)
insertPoints(reportWorksheet, "G" + (i + 15).ToString(), newPoints[i].X, reader);
insertPoints(reportWorksheet, "H" + (i + 15).ToString(), newPoints[i].Y, reader);
//Color every other row in the shot record table.
if (i % 2 == 1)
{
reportWorksheet.Cells["F" + (i + 15).ToString()].Style.FillPattern.SetSolid(rowFillColor);
reportWorksheet.Cells["G" + (i + 15).ToString()].Style.FillPattern.SetSolid(rowFillColor);
reportWorksheet.Cells["H" + (i + 15).ToString()].Style.FillPattern.SetSolid(rowFillColor);
}
}
//Fill in the color for
for (int i = newPoints.Count; i < 50; i = i + 2)
{
//if the first time through, we are on an odd instead of an even, put us back on evens.
if (i%2 == 0)
{
i++;
}
reportWorksheet.Cells["F" + (i + 15).ToString()].Style.FillPattern.SetSolid(rowFillColor);
reportWorksheet.Cells["G" + (i + 15).ToString()].Style.FillPattern.SetSolid(rowFillColor);
reportWorksheet.Cells["H" + (i + 15).ToString()].Style.FillPattern.SetSolid(rowFillColor);
}
//Display stats
insertStat(reportWorksheet, "Extreme Spread X", stats.extremeSpreadX, reader);
insertStat(reportWorksheet, "Extreme Spread Y", stats.extremeSpreadY, reader);
insertStat(reportWorksheet, "Extreme Spread", stats.extremeSpread, reader);
insertStat(reportWorksheet, "Mean Radius", stats.meanRadius, reader);
insertStat(reportWorksheet, "Sigma X", stats.sigmaX, reader);
insertStat(reportWorksheet, "Sigma Y", stats.sigmaY, reader);
insertStat(reportWorksheet, "Furthest Left", stats.furthestLeft, reader);
insertStat(reportWorksheet, "Furthest Right", stats.furthestRight, reader);
insertStat(reportWorksheet, "Highest Round", stats.highestRound, reader);
insertStat(reportWorksheet, "Lowest Round", stats.lowestRound, reader);
insertStat(reportWorksheet, "CEP", stats.CEPRadius, reader);
//Add a small image of the pic in the upper right corner.
Bitmap image = new Bitmap(imagePath);
int width = image.Width;
int height = image.Height;
double aspectRatio = (double)width / (double)height;
image.Dispose();
if (aspectRatio > (double)reportImageWidth / (double)reportImageHeight)
{
double newHeight = (double)reportImageWidth / aspectRatio * 0.9; // The 0.9 is a fudge factor because GemBox doesn't know how to scale things properly.
reportWorksheet.Pictures.Add(imagePath, new Rectangle(0, (int) ((reportImageHeight - newHeight) * 0.5), reportImageWidth, (int) (newHeight + 0.5)));
}
else
{
double newWidth = (double)reportImageHeight * aspectRatio / 0.9; // The 0.9 is a fudge factor because GemBox doesn't know how to scale things properly.
reportWorksheet.Pictures.Add(imagePath, new Rectangle((int) ((reportImageWidth - newWidth) * 0.5), 0, (int) (newWidth + 0.5), reportImageHeight));
}
//Add CEP Data
otherStatsWorksheet.Cells[reader.getValue("X Offset")].Value = stats.center.X;
otherStatsWorksheet.Cells[reader.getValue("Y Offset")].Value = stats.center.Y;
otherStatsWorksheet.Cells[reader.getValue("Mean X Offset")].Value = stats.center.X;
otherStatsWorksheet.Cells[reader.getValue("Mean Y Offset")].Value = stats.center.Y;
otherStatsWorksheet.Cells[reader.getValue("CEP Radius")].Formula = "=IF(Report!" + reader.getValue("CEP Toggle Cell") + " =\"CEP Off\", " + 0 + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in inches)\", " + stats.CEPRadius + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in centimeters)\", " + (stats.CEPRadius * 2.54) + ", " + (stats.CEPRadius * minutesOfAngleConverter) + ")))";
otherStatsWorksheet.Cells[reader.getValue("Mean Radius Circle")].Formula = "=IF(Report!" + reader.getValue("Mean Radius Toggle Cell") + " =\"Mean Radius Off\", " + 0 + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in inches)\", " + stats.meanRadius + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in centimeters)\", " + (stats.meanRadius * 2.54) + ", " + (stats.meanRadius * minutesOfAngleConverter) + ")))";
otherStatsWorksheet.Cells[reader.getValue("Extreme Spread x1")].Formula = "=IF(Report!" + reader.getValue("Extreme Spread Toggle Cell") + " =\"Extreme Spread Off\", " + 0 + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in inches)\", " + stats.extremePoints[0].X + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in centimeters)\", " + (stats.extremePoints[0].X * 2.54) + ", " + (stats.extremePoints[0].X * minutesOfAngleConverter) + ")))";
otherStatsWorksheet.Cells[reader.getValue("Extreme Spread x2")].Formula = "=IF(Report!" + reader.getValue("Extreme Spread Toggle Cell") + " =\"Extreme Spread Off\", " + 0 + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in inches)\", " + stats.extremePoints[1].X + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in centimeters)\", " + (stats.extremePoints[1].X * 2.54) + ", " + (stats.extremePoints[1].X * minutesOfAngleConverter) + ")))";
otherStatsWorksheet.Cells[reader.getValue("Extreme Spread y1")].Formula = "=IF(Report!" + reader.getValue("Extreme Spread Toggle Cell") + " =\"Extreme Spread Off\", " + 0 + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in inches)\", " + stats.extremePoints[0].Y + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in centimeters)\", " + (stats.extremePoints[0].Y * 2.54) + ", " + (stats.extremePoints[0].Y * minutesOfAngleConverter) + ")))";
otherStatsWorksheet.Cells[reader.getValue("Extreme Spread y2")].Formula = "=IF(Report!" + reader.getValue("Extreme Spread Toggle Cell") + " =\"Extreme Spread Off\", " + 0 + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in inches)\", " + stats.extremePoints[1].Y + ", IF(Report!" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in centimeters)\", " + (stats.extremePoints[1].Y * 2.54) + ", " + (stats.extremePoints[1].Y * minutesOfAngleConverter) + ")))";
//Generate CEP Circle formula data
for (int cell = 0; cell <= 39; cell++)
{
otherStatsWorksheet.Cells["B" + (cell + 9).ToString()].Formula = "=$B$3+A" + (cell + 9).ToString();
otherStatsWorksheet.Cells["C" + (cell + 9).ToString()].Formula = "=SQRT(ABS(POWER($B$5,2)-POWER(B" + (cell + 9).ToString() + ",2))) +$B$4";
otherStatsWorksheet.Cells["D" + (cell + 9).ToString()].Formula = "=$B$4 - SQRT(ABS(POWER($B$5,2)-POWER(B" + (cell + 9).ToString() + ",2)))";
}
//Generate Mean Circle formula data
for (int cell = 0; cell <= 39; cell++)
{
otherStatsWorksheet.Cells["M" + (cell + 9).ToString()].Formula = "=$M$3+L" + (cell + 9).ToString();
otherStatsWorksheet.Cells["N" + (cell + 9).ToString()].Formula = "=SQRT(ABS(POWER($M$5,2)-POWER(M" + (cell + 9).ToString() + ",2))) +$M$4";
otherStatsWorksheet.Cells["O" + (cell + 9).ToString()].Formula = "=$M$4 - SQRT(ABS(POWER($M$5,2)-POWER(M" + (cell + 9).ToString() + ",2)))";
}
try
{
//Write Report
excelFile.SaveXlsx(savePath);
}
catch (System.IO.IOException)
{
MessageBox.Show("A report could not be generated. The file you attempted to save to is busy. Please close all applications using " + savePath +
" and press ok to continue.", "File Open", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
throw new System.InvalidOperationException("DirectoryNotFoundException");
}
finally
{
//Close Report
excelFile.ClosePreservedXlsx();
}
//Check to see what to do with report now
switch (reader.getValue("Open Excel By Default").ToString())
{
case "nothing":
break;
case "prompt":
DialogResult response = MessageBox.Show("Would you like to open the report you just created?", "Open report?",
MessageBoxButtons.YesNo);
if (response == DialogResult.Yes)
{
openReportWithExcel(savePath);
}
break;
case "open":
openReportWithExcel(savePath);
break;
}
}
private static void insertPoints(ExcelWorksheet reportWorksheet, string configName, double statValue, ConfigReader reader)
{
String output = "=IF(" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in inches)\", " + statValue + ", IF(" + reader.getValue("Cell To Determine Unit of Points") + " =\"Shot Record (in centimeters)\", " + (statValue * 2.54) + ", " + (statValue * minutesOfAngleConverter) + "))";
reportWorksheet.Cells[configName].Formula = output;
}
/// <summary>See <c>MSAccess.GetWeaponNames()</c>.</summary>
public static List<String> GetWeaponNames(ConfigReader configReader)
{
return MSAccess.GetWeaponNames(configReader);
}
/// <summary>
/// Updates an existing <c>ImageData</c> object in the <c>Target</c> table.
/// </summary>
/// <param name="imageData">The <c>ImageData</c> to update.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <exception cref="OleDbException">A connection-level error occurred while opening the connection.</exception>
/// <exception cref="InvalidOperationException">The UPDATE Target command failed.</exception>
/// <exception cref="ArgumentException">The caliber or weapon name was not found in the database.</exception>
/// <returns>The <c>targetID</c> of the updated record.</returns>
private static int UpdateData(Datatype.ImageData imageData, ConfigReader configReader)
{
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location"))) {
openConnection(conn);
if (!CaliberIDExists(imageData.caliber.caliberUnitID, configReader)) {
Log.LogError("Caliber to insert not found in database.", "unitID",
imageData.caliber.caliberUnitID.ToString(), "unitName", imageData.caliber.unitName,
"unitsPerInch", imageData.caliber.unitsPerInch.ToString());
throw new ArgumentException("Caliber to insert does not exist.", "caliber");
}
if (!WeaponExists(imageData.weaponName, configReader)) {
Log.LogError("Weapon name to insert not found in database.", "weaponName", imageData.weaponName);
throw new ArgumentException("Weapon name to insert not found in database.", "weaponName");
}
using (OleDbCommand command = new OleDbCommand()) {
command.Connection = conn;
command.CommandText = "UPDATE Target SET OrigFilename = ?, ReportFilename = ?, DateTimeFired = ?, DateTimeProcessed = ?, ShooterLName = ?, ShooterFName = ?, RangeLocation = ?, DistanceUnits = ?, Distance = ?, Temperature = ?, WeaponName = ?, SerialNumber = ?, WeaponNotes = ?, CaliberID = ?, CaliberValue = ?, LotNumber = ?, ProjectileMassGrains = ?, AmmunitionNotes = ?, ShotsFired = ?, ShotLocations = ?, Scale = ?, ROI = ? WHERE TargetID = ?";
command.Prepare();
setStringParameter(command, "OrigFilename", imageData.origFilename);
setStringParameter(command, "ReportFilename", imageData.reportFilename);
command.Parameters.Add("DateTimeFired", OleDbType.Date).Value = imageData.dateTimeFired;
command.Parameters.Add("DateTimeProcessed", OleDbType.Date).Value = DateTime.Now;
setStringParameter(command, "ShooterLName", imageData.shooterLName);
setStringParameter(command, "ShooterFName", imageData.shooterFName);
setStringParameter(command, "RangeLocation", imageData.rangeLocation);
command.Parameters.Add("DistanceUnits", OleDbType.UnsignedTinyInt).Value = imageData.distanceUnits;
command.Parameters.Add("Distance", OleDbType.Integer).Value = imageData.distance;
command.Parameters.Add("Temperature", OleDbType.UnsignedTinyInt).Value = imageData.temperature;
setStringParameter(command, "WeaponName", imageData.weaponName);
setStringParameter(command, "SerialNumber", imageData.serialNumber);
command.Parameters.Add("WeaponNotes", OleDbType.LongVarWChar).Value = imageData.weaponNotes;
command.Parameters.Add("CaliberID", OleDbType.Integer).Value = imageData.caliber.caliberUnitID;
command.Parameters.Add("CaliberValue", OleDbType.Double).Value = imageData.caliberValue;
setStringParameter(command, "LotNumber", imageData.lotNumber);
command.Parameters.Add("ProjectileMassGrains", OleDbType.Integer).Value = imageData.projectileMassGrains;
command.Parameters.Add("AmmunitionNotes", OleDbType.LongVarWChar).Value = imageData.ammunitionNotes;
command.Parameters.Add("ShotsFired", OleDbType.Integer).Value = imageData.shotsFired;
StringBuilder pointStringBuilder = new StringBuilder();
foreach (Point point in imageData.points) {
pointStringBuilder.Append(point.X);
pointStringBuilder.Append(",");
pointStringBuilder.Append(point.Y);
pointStringBuilder.Append(",");
}
command.Parameters.Add("ShotLocations", OleDbType.LongVarWChar).Value = pointStringBuilder.ToString();
StringBuilder scaleStringBuilder = new StringBuilder();
scaleStringBuilder.Append(imageData.scale.horizontal.X);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.horizontal.Y);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.middle.X);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.middle.Y);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.vertical.X);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.vertical.Y);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.horizontalLength);
scaleStringBuilder.Append(",");
scaleStringBuilder.Append(imageData.scale.verticalLength);
setStringParameter(command, "Scale", scaleStringBuilder.ToString());
StringBuilder ROIStringBuilder = new StringBuilder();
ROIStringBuilder.Append(imageData.regionOfInterest.topLeft.X);
ROIStringBuilder.Append(",");
ROIStringBuilder.Append(imageData.regionOfInterest.topLeft.Y);
ROIStringBuilder.Append(",");
ROIStringBuilder.Append(imageData.regionOfInterest.bottomRight.X);
ROIStringBuilder.Append(",");
ROIStringBuilder.Append(imageData.regionOfInterest.bottomRight.Y);
setStringParameter(command, "ROI", ROIStringBuilder.ToString());
command.Parameters.Add("TargetID", OleDbType.Integer).Value = imageData.targetID;
try {
command.ExecuteNonQuery();
} catch (InvalidOperationException e) {
Log.LogError("Could not perform UPDATE Target.", "SQL", command.CommandText);
throw e;
}
}
}
return imageData.targetID;
}
/// <summary>
/// Loads a list of weapon names from the database.
/// </summary>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <returns>A list of all weapon names in the database.</returns>
/// <exception cref="OleDbException">A connection-level error occurred while opening the connection.</exception>
public static List<String> GetWeaponNames(ConfigReader configReader)
{
List<String> weaponNames = new List<String>();
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location"))) {
openConnection(conn);
using (OleDbCommand command = new OleDbCommand("SELECT WeaponName FROM Weapon", conn)) {
using (OleDbDataReader reader = command.ExecuteReader()) {
while (reader.Read()) {
// We could trust that the column is index 0,
// but let's use the specific column name for safety.
weaponNames.Add(reader.GetString(reader.GetOrdinal("WeaponName")));
}
}
}
}
return weaponNames;
}
/// <summary>
/// Tests saving and loading the same data.
/// </summary>
/// <param name="savedData">The data to save and load back out.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <returns>The <c>TargetID</c> of the loaded data.</returns>
public static int TestMSAccessSaveAndLoadData(Datatype.ImageData savedData, ConfigReader configReader)
{
int targetID = SaveData(savedData, configReader);
if (targetID < 0) {
throw new Exception("Save data failed");
}
Datatype.ImageData loadedData = LoadData(targetID, configReader);
if (loadedData.targetID != targetID
|| !loadedData.origFilename.Equals(savedData.origFilename)
|| !loadedData.reportFilename.Equals(savedData.reportFilename)
|| !loadedData.dateTimeFired.Date.Equals(savedData.dateTimeFired.Date)
|| !loadedData.shooterLName.Equals(savedData.shooterLName)
|| !loadedData.shooterFName.Equals(savedData.shooterFName)
|| !loadedData.rangeLocation.Equals(savedData.rangeLocation)
|| loadedData.distanceUnits != savedData.distanceUnits
|| loadedData.distance != savedData.distance
|| loadedData.temperature != savedData.temperature
|| !loadedData.weaponName.Equals(savedData.weaponName)
|| !loadedData.serialNumber.Equals(savedData.serialNumber)
|| !loadedData.weaponNotes.Equals(savedData.weaponNotes)
|| loadedData.caliber.caliberUnitID != savedData.caliber.caliberUnitID
|| loadedData.caliberValue != savedData.caliberValue
|| !loadedData.lotNumber.Equals(savedData.lotNumber)
|| loadedData.projectileMassGrains != savedData.projectileMassGrains
|| !loadedData.weaponNotes.Equals(savedData.weaponNotes)
|| !loadedData.ammunitionNotes.Equals(savedData.ammunitionNotes)
|| loadedData.shotsFired != savedData.shotsFired) {
throw new Exception("Loaded data not identical to saved data");
}
if (!loadedData.scale.horizontal.Equals(savedData.scale.horizontal)
|| !loadedData.scale.middle.Equals(savedData.scale.middle)
|| !loadedData.scale.vertical.Equals(savedData.scale.vertical)
|| loadedData.scale.horizontalLength != savedData.scale.horizontalLength
|| loadedData.scale.verticalLength != savedData.scale.verticalLength) {
throw new Exception("Loaded data not identical to saved data");
}
if (!loadedData.regionOfInterest.topLeft.Equals(savedData.regionOfInterest.topLeft)
|| !loadedData.regionOfInterest.bottomRight.Equals(savedData.regionOfInterest.bottomRight)) {
throw new Exception("Loaded data not identical to saved data");
}
// TODO: Points untested
System.Console.WriteLine("Success");
return targetID;
}
/// <summary>
/// Loads an <c>ImageData</c> from the database.
/// </summary>
/// <param name="targetID">The <paramref name="targetID"/> of the target to load.</param>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
/// <returns>The <c>ImageData</c> corresponding to the <paramref name="targetID"/>.</returns>
/// <exception cref="OleDbException">A connection-level error occurred while opening the connection.</exception>
public static Datatype.ImageData LoadData(int targetID, ConfigReader configReader)
{
Datatype.ImageData imageData = new Datatype.ImageData();
using (OleDbConnection conn = new OleDbConnection(configReader.getValue("Database Location"))) {
openConnection(conn);
using (OleDbCommand command = new OleDbCommand()) {
command.Connection = conn;
command.CommandText = "SELECT * FROM Target WHERE TargetID = ?";
command.Prepare();
command.Parameters.Add("TargetID", OleDbType.Integer).Value = targetID;
using (OleDbDataReader reader = command.ExecuteReader()) {
if (reader.Read()) {
imageData.targetID = reader.GetInt32(reader.GetOrdinal("TargetID"));
if (imageData.targetID != targetID) {
throw new Exception("Error in LoadData()");
}
imageData.origFilename = reader.GetString(reader.GetOrdinal("OrigFilename"));
imageData.reportFilename = reader.GetString(reader.GetOrdinal("ReportFilename"));
imageData.dateTimeFired = reader.GetDateTime(reader.GetOrdinal("DateTimeFired"));
imageData.dateTimeProcessed = reader.GetDateTime(reader.GetOrdinal("DateTimeProcessed"));
imageData.shooterLName = reader.GetString(reader.GetOrdinal("ShooterLName"));
imageData.shooterFName = reader.GetString(reader.GetOrdinal("ShooterFName"));
imageData.rangeLocation = reader.GetString(reader.GetOrdinal("RangeLocation"));
imageData.distanceUnits = (Datatype.UnitsOfMeasure)reader.GetByte(reader.GetOrdinal("DistanceUnits"));
imageData.distance = reader.GetInt32(reader.GetOrdinal("Distance"));
imageData.temperature = (Datatype.ImageData.Temperature)reader.GetByte(reader.GetOrdinal("Temperature"));
imageData.weaponName = reader.GetString(reader.GetOrdinal("WeaponName"));
imageData.serialNumber = reader.GetString(reader.GetOrdinal("SerialNumber"));
imageData.weaponNotes = reader.GetString(reader.GetOrdinal("WeaponNotes"));
imageData.caliber = GetCaliberUnit(reader.GetInt32(reader.GetOrdinal("CaliberID")), configReader);
imageData.caliberValue = reader.GetDouble(reader.GetOrdinal("CaliberValue"));
imageData.lotNumber = reader.GetString(reader.GetOrdinal("LotNumber"));
imageData.projectileMassGrains = reader.GetInt32(reader.GetOrdinal("ProjectileMassGrains"));
imageData.ammunitionNotes = reader.GetString(reader.GetOrdinal("AmmunitionNotes"));
imageData.shotsFired = reader.GetInt32(reader.GetOrdinal("ShotsFired"));
String points = reader.GetString(reader.GetOrdinal("ShotLocations"));
String[] pointElements = points.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (pointElements.Length % 2 != 0) {
Log.LogWarning("A Points field has invalid values.", "targetID", targetID.ToString(),
"SQL", command.CommandText);
} else {
for (int i = 0; i < pointElements.Length; i += 2) {
imageData.points.Add(new Point(Int32.Parse(pointElements[i]), Int32.Parse(pointElements[i + 1])));
}
}
String scale = reader.GetString(reader.GetOrdinal("Scale"));
String[] scaleElements = scale.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (scaleElements.Length != 8) {
Log.LogWarning("A Scale field has invalid values.", "targetID", targetID.ToString(),
"SQL", command.CommandText);
} else {
imageData.scale.horizontal = new Point(Int32.Parse(scaleElements[0]), Int32.Parse(scaleElements[1]));
imageData.scale.middle = new Point(Int32.Parse(scaleElements[2]), Int32.Parse(scaleElements[3]));
imageData.scale.vertical = new Point(Int32.Parse(scaleElements[4]), Int32.Parse(scaleElements[5]));
imageData.scale.horizontalLength = float.Parse(scaleElements[6]);
imageData.scale.verticalLength = float.Parse(scaleElements[7]);
}
String ROI = reader.GetString(reader.GetOrdinal("ROI"));
String[] ROIElements = ROI.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
if (ROIElements.Length != 4) {
Log.LogWarning("An ROI field has invalid values.", "targetID", targetID.ToString(),
"SQL", command.CommandText);
} else {
imageData.regionOfInterest.topLeft = new Point(Int32.Parse(ROIElements[0]), Int32.Parse(ROIElements[1]));
imageData.regionOfInterest.bottomRight = new Point(Int32.Parse(ROIElements[2]), Int32.Parse(ROIElements[3]));
}
} else {
Log.LogInfo("Target ID not found.", "targetID", targetID.ToString(), "SQL", command.CommandText);
return null;
}
}
}
}
return imageData;
}
/*public static void GenerateTestReport(ConfigReader configReader) {
Console.WriteLine("~~Generating Test Report~~");
Console.WriteLine("Generating Dummy Report Data...");
Datatype.ImageData testData = GenerateTestData();
Datatype.Stats testStats = GenerateTestStatistics(testData.points);
ExcelReportGenerator.GenerateReport(testData, testStats, configReader);
}
private static Datatype.ImageData GenerateTestData()
{
Datatype.ImageData data = new Datatype.ImageData();
data.shooterFName = "Jeff";
data.shooterLName = "Johnson";
data.dateTimeFired = new DateTime(2009, 01, 13);
data.rangeLocation = "Hulbert Field";
data.temperature = Datatype.ImageData.Temperature.Ambient;
data.distance = 100;
data.shotsFired = 20;
data.weaponName = "Glock 19 Jet 192";
data.serialNumber = "8AZK018";
data.caliber = new Datatype.CaliberUnit(1, "0.45 cal", 40);
data.caliber.caliberUnitID = 1;
data.caliber.caliber = "0.45 cal";
data.lotNumber = "59A";
data.projectileMassGrains = 10;
data.points = new List<Point>();
Random generator = new Random();
for (int i = 0; i < 20; i++)
{
if (i < 6)
{
Point p = new Point(generator.Next(1, 100), generator.Next(1, 100));
data.points.Add(p);
}
else if (i < 14)
{
Point p = new Point(3 * generator.Next(1, 100), 3 * generator.Next(1, 100));
data.points.Add(p);
}
else
{
Point p = new Point(5 * generator.Next(1, 100), 5 * generator.Next(1, 100));
data.points.Add(p);
}
}
return data;
}
private static Datatype.Stats GenerateTestStatistics(IList<Point> points)
{
Datatype.Stats stats = new Datatype.Stats();
Random generator = new Random();
stats.meanRadius = 3;
stats.highestRound = 1;
stats.lowestRound = 1;
stats.furthestLeft = 2;
stats.furthestRight = 3;
stats.extremeSpreadX = 2;
stats.extremeSpreadY = 2;
stats.extremeSpread = 1;
stats.sigmaX = 2;
stats.sigmaY = 2;
stats.center = new Point(generator.Next(1, 100), generator.Next(1, 100));
stats = Stats.GenerateStatistics(points);
return stats;
} */
/// <summary>
/// Tests the MSAccess class.
/// </summary>
/// <param name="configReader">The <c>ConfigReader</c> with the path to the database.</param>
public static void TestMSAccess(ConfigReader configReader)
{
// Test insert
Datatype.ImageData savedData = Datatype.ImageData.GenerateTestData();
int targetID = TestMSAccessSaveAndLoadData(savedData, configReader);
// Test update
savedData.targetID = targetID;
int targetID2 = TestMSAccessSaveAndLoadData(savedData, configReader);
}
/// <summary>See <c>MSAccess.LoadData()</c>.</summary>
public static Datatype.ImageData LoadData(int targetID, ConfigReader configReader)
{
return MSAccess.LoadData(targetID, configReader);
}