/// <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> /// Generates the barrel convers kit. /// </summary> /// <param name="databasePath">The database path.</param> /// <param name="gunId">The gun identifier.</param> /// <param name="errOut">The error out.</param> /// <returns>System.String.</returns> /// <exception cref="System.Exception"></exception> private static string GenerateBarrelConversKit(string databasePath, long gunId, out string errOut) { string sAns = $" <BarrelConverstionKit_Details>{Environment.NewLine}"; errOut = ""; try { string sql = $"SELECT * from Gun_Collection_Ext where GID={gunId}"; List <BarrelSystems> lst = ExtraBarrelConvoKits.GetList(databasePath, sql, out errOut); if (errOut.Length > 0) { throw new Exception(errOut); } foreach (BarrelSystems l in lst) { sAns += $" <ModelName>{StringHelper(l.ModelName)}</ModelName>{Environment.NewLine}"; sAns += $" <Caliber>{StringHelper(l.Caliber)}</Caliber>{Environment.NewLine}"; sAns += $" <Finish>{StringHelper(l.Finish)}</Finish>{Environment.NewLine}"; sAns += $" <BarrelLength>{StringHelper(l.BarrelLength)}</BarrelLength>{Environment.NewLine}"; sAns += $" <PetLoads>{StringHelper(l.PetLoads)}</PetLoads>{Environment.NewLine}"; sAns += $" <Action>{StringHelper(l.Action)}</Action>{Environment.NewLine}"; sAns += $" <Feedsystem>{StringHelper(l.FeedSystem)}</Feedsystem>{Environment.NewLine}"; sAns += $" <Sights>{StringHelper(l.Sights)}</Sights>{Environment.NewLine}"; sAns += $" <PurchasedPrice>{l.PurchasedPrice}</PurchasedPrice>{Environment.NewLine}"; sAns += $" <PurchasedFrom>{StringHelper(l.PurchasedFrom)}</PurchasedFrom>{Environment.NewLine}"; sAns += $" <dtp>{StringHelper(l.PurchaseDate,true)}</dtp>{Environment.NewLine}"; sAns += $" <Height>{StringHelper(l.Height)}</Height>{Environment.NewLine}"; sAns += $" <IsDefault>{l.Idefault}</IsDefault>{Environment.NewLine}"; sAns += $" <BarrelLength>{StringHelper(l.BarrelLength)}</BarrelLength>{Environment.NewLine}"; } } catch (Exception e) { errOut = ErrorMessage("GenerateBarrelConversKit", e); } sAns += $" </BarrelConverstionKit_Details>{Environment.NewLine}"; return(sAns); }