/// <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); }