/// <summary>
/// Maintances the details.
/// </summary>
/// <param name="databasePath">The database path.</param>
/// <param name="xmlPath">The XML path.</param>
/// <param name="gunId">The gun identifier.</param>
/// <param name="errOut">The error out.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
public static bool MaintanceDetails(string databasePath, string xmlPath, long gunId, out string errOut)
{
bool bAns = false;
errOut = "";
try
{
XmlDocument doc = new XmlDocument();
doc.Load(xmlPath);
XmlNodeList elemlist = doc.GetElementsByTagName("Maintance_Details");
foreach (XmlNode xn in elemlist)
{
string name = Helpers.FormatFromXml(GetXmlNode(xn["Name"]));
string opDate = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["OpDate"])), true);
string opDueDate = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["OpDueDate"])), true);
long rndFired = Convert.ToInt32(Helpers.FormatFromXml(GetXmlNode(xn["RndFired"])));
string ammoUsed = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["ammoUsed"])));
string notes = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["Notes"])));
if (!MaintancePlans.Exists(databasePath, name, out errOut))
{
if (!MaintancePlans.Add(databasePath, name, "N/A from Import", "N/A from Import", "N/A from Import", "N/A from Import", out errOut))
{
throw new Exception(errOut);
}
}
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
long maintenancePlansId = MaintancePlans.GetId(databasePath, name, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
//Thread.Sleep(1000);
long defaultBarrelId =
ExtraBarrelConvoKits.GetDefaultBarrelId(databasePath, gunId, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
if (!Firearms.MaintanceDetails.Add(databasePath, name, gunId, maintenancePlansId, opDate, opDueDate, rndFired, notes, ammoUsed, defaultBarrelId, rndFired > 0, out errOut))
{
throw new Exception(errOut);
}
//Thread.Sleep(1000);
}
bAns = true;
}
catch (Exception e)
{
errOut = ErrorMessage("MaintanceDetails", e);
}
return(bAns);
}
/// <summary>
/// Barrels the converstion kit details.
/// </summary>
/// <param name="databasePath">The database path.</param>
/// <param name="xmlPath">The XML path.</param>
/// <param name="gunId">The gun identifier.</param>
/// <param name="errOut">The error out.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
public static bool BarrelConverstionKitDetails(string databasePath, string xmlPath, long gunId, out string errOut)
{
bool bAns = false;
errOut = "";
try
{
XmlDocument doc = new XmlDocument();
doc.Load(xmlPath);
XmlNodeList elemlist = doc.GetElementsByTagName("BarrelConverstionKit_Details");
foreach (XmlNode xn in elemlist)
{
string modelName = Helpers.FormatFromXml(GetXmlNode(xn["ModelName"]));
string caliber = Helpers.FormatFromXml(GetXmlNode(xn["Caliber"]));
string finish = Helpers.FormatFromXml(GetXmlNode(xn["Finish"]));
string barrelLength = Helpers.FormatFromXml(GetXmlNode(xn["BarrelLength"]));
string petLoads = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["petLoads"])));
string action = Helpers.FormatFromXml(GetXmlNode(xn["Action"]));
string feedsystem = Helpers.FormatFromXml(GetXmlNode(xn["Feedsystem"]));
string sights = Helpers.FormatFromXml(GetXmlNode(xn["Sights"]));
string purchasedPrice = Helpers.FormatFromXml(GetXmlNode(xn["PurchasedPrice"]));
string purchasedFrom = Helpers.FormatFromXml(GetXmlNode(xn["PurchasedFrom"]));
string dtp = Helpers.FormatFromXml(GetXmlNode(xn["dtp"]));
string height = Helpers.FormatFromXml(GetXmlNode(xn["Height"]));
string type = Helpers.FormatFromXml(GetXmlNode(xn["Type"]));
bool isDefault = Convert.ToInt32(Helpers.FormatFromXml(GetXmlNode(xn["IsDefault"]))) == 1;
if (!ExtraBarrelConvoKits.Exists(databasePath, gunId, modelName, caliber, finish,
barrelLength, petLoads, action, feedsystem, sights, purchasedPrice,
purchasedFrom, height, type, isDefault, out errOut))
{
if (!ExtraBarrelConvoKits.Add(databasePath, gunId, modelName, caliber, finish,
barrelLength, petLoads, action, feedsystem, sights, purchasedPrice,
purchasedFrom, height, type, isDefault, dtp, out errOut))
{
throw new Exception(errOut);
}
}
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
}
bAns = true;
}
catch (Exception e)
{
errOut = ErrorMessage("BarrelConverstionKitDetails", e);
}
return(bAns);
}
/// <summary>
/// Guns the smith details.
/// </summary>
/// <param name="databasePath">The database path.</param>
/// <param name="xmlPath">The XML path.</param>
/// <param name="gunId">The gun identifier.</param>
/// <param name="errOut">The error out.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
public static bool GunSmithDetails(string databasePath, string xmlPath, long gunId, out string errOut)
{
bool bAns = false;
errOut = "";
try
{
XmlDocument doc = new XmlDocument();
doc.Load(xmlPath);
XmlNodeList elemlist = doc.GetElementsByTagName("GunSmith_Details");
foreach (XmlNode xn in elemlist)
{
string gsmith = Helpers.FormatFromXml(GetXmlNode(xn["gsmith"]));
string sdate = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["sdate"])), true);
string rdate = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["rdate"])), true);
string od = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["od"])));
string notes = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["notes"])));
if (!PeopleAndPlaces.GunSmiths.Exists(databasePath, gsmith, out errOut))
{
if (!PeopleAndPlaces.GunSmiths.Add(databasePath, gsmith, out errOut))
{
throw new Exception(errOut);
}
}
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
long gunSmithId = PeopleAndPlaces.GunSmiths.GetId(databasePath, gsmith, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
if (!Firearms.GunSmithDetails.Add(databasePath, gunId, gsmith, gunSmithId, od, notes, sdate, rdate, out errOut))
{
throw new Exception(errOut);
}
}
bAns = true;
}
catch (Exception e)
{
errOut = ErrorMessage("Accessories", e);
}
return(bAns);
}
/// <summary>
/// Accessorieses the specified database path.
/// </summary>
/// <param name="databasePath">The database path.</param>
/// <param name="xmlPath">The XML path.</param>
/// <param name="gunId">The gun identifier.</param>
/// <param name="errOut">The error out.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
/// <exception cref="System.Exception"></exception>
public static bool Accessories(string databasePath, string xmlPath, long gunId, out string errOut)
{
bool bAns = false;
errOut = "";
try
{
XmlDocument doc = new XmlDocument();
doc.Load(xmlPath);
XmlNodeList elemlist = doc.GetElementsByTagName("Accessories");
foreach (XmlNode xn in elemlist)
{
string manufacturer = Helpers.FormatFromXml(GetXmlNode(xn["Manufacturer"]));
string model = Helpers.FormatFromXml(GetXmlNode(xn["Model"]));
string serialNumber = Helpers.FormatFromXml(GetXmlNode(xn["SerialNumber"]));
string condition = Helpers.FormatFromXml(GetXmlNode(xn["Condition"]));
string notes = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["Notes"])));
string use = Helpers.FormatFromXml(GetXmlNode(xn["Use"]));
double purValue = Convert.ToDouble(Helpers.FormatFromXml(GetXmlNode(xn["PurValue"])));
double appValue = Convert.ToDouble(Helpers.FormatFromXml(GetXmlNode(xn["appValue"])));
Boolean civ = Convert.ToBoolean(Helpers.FormatFromXml(GetXmlNode(xn["civ"])));
Boolean ic = Convert.ToBoolean(Helpers.FormatFromXml(GetXmlNode(xn["ic"])));
if (!Firearms.Accessories.Add(databasePath, gunId, manufacturer, model, serialNumber, condition,
notes, use, purValue, appValue, civ, ic, out errOut))
{
throw new Exception(errOut);
}
}
bAns = true;
}
catch (Exception e)
{
errOut = ErrorMessage("Accessories", e);
}
return(bAns);
}
/// <summary>
/// Get the details from the xml file and insert it into the database, this is the main
/// information of the firearm and needs to be ran first before the other import function.
/// </summary>
/// <param name="databasePath">The database path.</param>
/// <param name="xmlPath">The string path.</param>
/// <param name="ownerId">The owner identifier.</param>
/// <param name="useNumberCatOnly">if set to <c>true</c> [use number cat only].</param>
/// <param name="errOut">The error out.</param>
/// <returns><c>true</c> if XXXX, <c>false</c> otherwise.</returns>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
/// <exception cref="System.Exception"></exception>
public static bool Details(string databasePath, string xmlPath, int ownerId, bool useNumberCatOnly, out string errOut)
{
bool bAns = false;
errOut = "";
try
{
XmlDocument doc = new XmlDocument();
string serialNumber = "";
string fullName = "";
doc.Load(xmlPath);
XmlNodeList elemlist = doc.GetElementsByTagName("Details");
foreach (XmlNode xn in elemlist)
{
fullName = Helpers.FormatFromXml(GetXmlNode(xn["FullName"]));
string manufacturer = Helpers.FormatFromXml(GetXmlNode(xn["Manufacturer"]));
string modelName = Helpers.FormatFromXml(GetXmlNode(xn["ModelName"]));
serialNumber = Helpers.FormatFromXml(GetXmlNode(xn["SerialNumber"]));
string sType = Helpers.FormatFromXml(GetXmlNode(xn["Type"]));
string caliber = Helpers.FormatFromXml(GetXmlNode(xn["Caliber"]));
string finish = Helpers.FormatFromXml(GetXmlNode(xn["Finish"]));
string condition = Helpers.FormatFromXml(GetXmlNode(xn["Condition"]));
string customId = Helpers.FormatFromXml(GetXmlNode(xn["CustomID"]));
string natId = Helpers.FormatFromXml(GetXmlNode(xn["NatID"]));
string gripId = Helpers.FormatFromXml(GetXmlNode(xn["GripID"]));
string weight = Helpers.FormatFromXml(GetXmlNode(xn["Weight"]));
string height = Helpers.FormatFromXml(GetXmlNode(xn["Height"]));
string barrelLength = Helpers.FormatFromXml(GetXmlNode(xn["BarrelLength"]));
string action = Helpers.FormatFromXml(GetXmlNode(xn["Action"]));
string feedsystem = Helpers.FormatFromXml(GetXmlNode(xn["Feedsystem"]));
string sights = Helpers.FormatFromXml(GetXmlNode(xn["Sights"]));
string purchasedPrice = Helpers.FormatFromXml(GetXmlNode(xn["PurchasedPrice"]));
string purchasedFrom = Helpers.FormatFromXml(GetXmlNode(xn["PurchasedFrom"]));
string appraisedValue = Helpers.FormatFromXml(GetXmlNode(xn["AppraisedValue"]));
string appraisalDate = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["AppraisalDate"])), true);
string appraisedBy = Helpers.FormatFromXml(GetXmlNode(xn["AppraisedBy"]));
string insuredValue = Helpers.FormatFromXml(GetXmlNode(xn["InsuredValue"]));
string sgChoke = Helpers.FormatFromXml(GetXmlNode(xn["SGChoke"]));
string storageLocation = Helpers.FormatFromXml(GetXmlNode(xn["StorageLocation"]));
string conditionComments = Helpers.FormatFromXml(GetXmlNode(xn["ConditionComments"]));
string additionalNotes = Helpers.FormatFromXml(GetXmlNode(xn["AdditionalNotes "]));
string produced = Helpers.FormatFromXml(GetXmlNode(xn["Produced"]));
string isCandR = Helpers.FormatFromXml(GetXmlNode(xn["IsCandR"]));
string petLoads = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["PetLoads"])));
string dtp = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["dtp"])), true);
string importer = Helpers.FormatFromXml(GetXmlNode(xn["Importer"]));
string reManDt = Helpers.FormatFromXml(GetXmlNode(xn["ReManDT"]));
bool bBoundBook = Convert.ToBoolean(Helpers.FormatFromXml(GetXmlNode(xn["BoundBook"])));
string sCaliber3 = Helpers.FormatFromXml(GetXmlNode(xn["Caliber3"]));
string sTwist = Helpers.FormatFromXml(GetXmlNode(xn["TwistOfRate"]));
string sTrigger = Helpers.FormatFromXml(GetXmlNode(xn["TriggerPull"]));
string sClassification = Helpers.FormatFromXml(GetXmlNode(xn["Classification"]));
string sDateOfCr = XmlExport.StringHelper(Helpers.FormatFromXml(GetXmlNode(xn["DateofCR"])), true);
string strBarWid = Helpers.FormatFromXml(GetXmlNode(xn["BarWid"]));
string strBarHei = Helpers.FormatFromXml(GetXmlNode(xn["BarHei"]));
string sClassIiiOwner = Helpers.FormatFromXml(GetXmlNode(xn["ClassIiiOwner"]));
bool isClassIii = Convert.ToBoolean(Helpers.FormatFromXml(GetXmlNode(xn["IsClassIII"])));
string poi = Helpers.FormatFromXml(GetXmlNode(xn["POI"]));
long manId = Manufacturers.GetId(databasePath, manufacturer, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
long modId = Models.GetId(databasePath, modelName, manId, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
long lGripId = Grips.GetId(databasePath, gripId, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
long lNatId = Nationality.GetId(databasePath, natId, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
GunTypes.UpdateGunType(databasePath, sType, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
if (!MyCollection.Add(databasePath, useNumberCatOnly, ownerId, manId, fullName, modelName, modId, serialNumber, sType, caliber,
finish, condition, customId, lNatId, lGripId, weight, height, gripId, barrelLength, strBarWid, strBarHei, action, feedsystem,
sights, purchasedPrice, purchasedFrom, appraisedValue, appraisalDate, appraisedBy, insuredValue, storageLocation, conditionComments,
additionalNotes, produced, petLoads, dtp, Convert.ToBoolean(isCandR), importer, reManDt, poi, sgChoke, Convert.ToBoolean(bBoundBook), sTwist, sTrigger, sCaliber3, sClassification, sDateOfCr, isClassIii, sClassIiiOwner, false, false, out errOut))
{
throw new Exception(errOut);
}
}
long id = MyCollection.GetLastId(databasePath, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
bAns = MyCollection.Verify(databasePath, id, fullName, serialNumber, out errOut);
if (errOut.Length > 0)
{
throw new Exception(errOut);
}
}
catch (Exception ex)
{
errOut = ErrorMessage("Details", ex);
}
return(bAns);
}
