private XmlNode AddTransactionsToXML(XmlDocument xml, EveMarketMonitorApp.DatabaseClasses.EMMADataSet.TransactionsDataTable transactions, long APIEntityID, bool forCorp, int walletID) { XmlNode rowSet = NewTransactionsRowset(xml); foreach (EveMarketMonitorApp.DatabaseClasses.EMMADataSet.TransactionsRow transaction in transactions) { if (transaction.ID < 9000000000000000000) { if (transaction.BuyerID == APIEntityID) { if (!forCorp || transaction.BuyerWalletID == walletID) { XmlNode node = AddTransRow(xml, APIEntityID, transaction, true, forCorp); rowSet.AppendChild(node); } } if (transaction.SellerID == APIEntityID) { if (!forCorp || transaction.SellerWalletID == walletID) { XmlNode node = AddTransRow(xml, APIEntityID, transaction, false, forCorp); rowSet.AppendChild(node); } } } } return rowSet; }
private XmlNode AddTransRow(XmlDocument xml, long APIEntityID, EveMarketMonitorApp.DatabaseClasses.EMMADataSet.TransactionsRow transaction, bool clientSeller, bool forCorp) { XmlNode row = xml.CreateNode(XmlNodeType.Element, "row", ""); XmlAttribute datetimeAtt = xml.CreateAttribute("transactionDateTime", ""); datetimeAtt.Value = transaction.DateTime.ToString("s", System.Globalization.CultureInfo.InvariantCulture); row.Attributes.Append(datetimeAtt); XmlAttribute idAtt = xml.CreateAttribute("transactionID", ""); idAtt.Value = transaction.ID.ToString(); row.Attributes.Append(idAtt); XmlAttribute quantityAtt = xml.CreateAttribute("quantity", ""); quantityAtt.Value = transaction.Quantity.ToString(); row.Attributes.Append(quantityAtt); XmlAttribute typeNameAtt = xml.CreateAttribute("typeName", ""); typeNameAtt.Value = Items.GetItemName(transaction.ItemID); row.Attributes.Append(typeNameAtt); XmlAttribute typeIDAtt = xml.CreateAttribute("typeID", ""); typeIDAtt.Value = transaction.ItemID.ToString(); row.Attributes.Append(typeIDAtt); XmlAttribute priceAtt = xml.CreateAttribute("price", ""); priceAtt.Value = transaction.Price.ToString(System.Globalization.CultureInfo.InvariantCulture); row.Attributes.Append(priceAtt); XmlAttribute clientIDAtt = xml.CreateAttribute("clientID", ""); clientIDAtt.Value = clientSeller ? transaction.SellerID.ToString() : transaction.BuyerID.ToString(); row.Attributes.Append(clientIDAtt); XmlAttribute clientNameAtt = xml.CreateAttribute("clientName", ""); clientNameAtt.Value = Names.GetName(clientSeller ? transaction.SellerID : transaction.BuyerID); row.Attributes.Append(clientNameAtt); XmlAttribute stationIDAtt = xml.CreateAttribute("stationID", ""); stationIDAtt.Value = transaction.StationID.ToString(); row.Attributes.Append(stationIDAtt); XmlAttribute stationNameAtt = xml.CreateAttribute("stationName", ""); stationNameAtt.Value = Stations.GetStationName(transaction.StationID); row.Attributes.Append(stationNameAtt); XmlAttribute transTypeAtt = xml.CreateAttribute("transactionType", ""); transTypeAtt.Value = clientSeller ? "buy" : "sell"; row.Attributes.Append(transTypeAtt); XmlAttribute transForAtt = xml.CreateAttribute("transactionFor", ""); transForAtt.Value = !forCorp ? "personal" : "corporation"; row.Attributes.Append(transForAtt); XmlAttribute journalIDAtt = xml.CreateAttribute("journalTransactionID", ""); journalIDAtt.Value = "0"; row.Attributes.Append(journalIDAtt); return row; }
private XmlNode AddMarketOrderToXML(XmlDocument xml, EveMarketMonitorApp.DatabaseClasses.EMMADataSet.OrdersDataTable marketOrders) { XmlNode rowSet = NewMarketOrderRowset(xml); foreach (EveMarketMonitorApp.DatabaseClasses.EMMADataSet.OrdersRow order in marketOrders) { XmlNode node = AddMarketOrderRow(xml, order); rowSet.AppendChild(node); } return rowSet; }
private XmlNode AddMarketOrderRow(XmlDocument xml, EveMarketMonitorApp.DatabaseClasses.EMMADataSet.OrdersRow order) { XmlNode row = xml.CreateNode(XmlNodeType.Element, "row", ""); XmlAttribute idAtt = xml.CreateAttribute("orderID", ""); idAtt.Value = order.EveOrderID.ToString(); row.Attributes.Append(idAtt); XmlAttribute charAtt = xml.CreateAttribute("charID", ""); charAtt.Value = order.OwnerID.ToString(); row.Attributes.Append(charAtt); XmlAttribute stationAtt = xml.CreateAttribute("stationID", ""); stationAtt.Value = order.StationID.ToString(); row.Attributes.Append(stationAtt); XmlAttribute volEnteredAtt = xml.CreateAttribute("volEntered", ""); volEnteredAtt.Value = order.TotalVol.ToString(); row.Attributes.Append(volEnteredAtt); XmlAttribute volRemainingAtt = xml.CreateAttribute("volRemaining", ""); volRemainingAtt.Value = order.RemainingVol.ToString(); row.Attributes.Append(volRemainingAtt); XmlAttribute minVolumeAtt = xml.CreateAttribute("minVolume", ""); minVolumeAtt.Value = order.MinVolume.ToString(); row.Attributes.Append(minVolumeAtt); XmlAttribute stateAtt = xml.CreateAttribute("orderState", ""); if(order.OrderState == 1) { stateAtt.Value = "1"; } if(order.OrderState == 2) { stateAtt.Value = "2"; } if(order.OrderState == 3) { stateAtt.Value = "3"; } if(order.OrderState == 4) { stateAtt.Value = "4"; } if(order.OrderState == 5) { stateAtt.Value = "5"; } if(order.OrderState == 999) { stateAtt.Value = "0"; } if(order.OrderState == 1000) { stateAtt.Value = "2"; } if(order.OrderState == 1001) { stateAtt.Value = "0"; } if(order.OrderState == 2000) { stateAtt.Value = "2"; } row.Attributes.Append(stateAtt); XmlAttribute typeAtt = xml.CreateAttribute("typeID", ""); typeAtt.Value = order.ItemID.ToString(); row.Attributes.Append(typeAtt); XmlAttribute rangeAtt = xml.CreateAttribute("range", ""); rangeAtt.Value = order.Range.ToString(); row.Attributes.Append(rangeAtt); XmlAttribute walletAtt = xml.CreateAttribute("accountKey", ""); walletAtt.Value = order.WalletID.ToString(); row.Attributes.Append(walletAtt); XmlAttribute durationAtt = xml.CreateAttribute("duration", ""); durationAtt.Value = order.Duration.ToString(); row.Attributes.Append(durationAtt); XmlAttribute escrowAtt = xml.CreateAttribute("escrow", ""); escrowAtt.Value = order.Escrow.ToString(System.Globalization.NumberFormatInfo.InvariantInfo); row.Attributes.Append(escrowAtt); XmlAttribute priceAtt = xml.CreateAttribute("price", ""); priceAtt.Value = order.Price.ToString(System.Globalization.NumberFormatInfo.InvariantInfo); row.Attributes.Append(priceAtt); XmlAttribute bidAtt = xml.CreateAttribute("bid", ""); bidAtt.Value = order.BuyOrder ? "1" : "0"; row.Attributes.Append(bidAtt); XmlAttribute issuedAtt = xml.CreateAttribute("issued", ""); issuedAtt.Value = order.Issued.ToString("s", System.Globalization.CultureInfo.InvariantCulture); row.Attributes.Append(issuedAtt); return row; }
private XmlNode AddJournalToXML(XmlDocument xml, EveMarketMonitorApp.DatabaseClasses.EMMADataSet.JournalDataTable journalEntries, long APIEntityID, bool forCorp, int walletID) { XmlNode rowSet = NewJournalRowset(xml); foreach (EveMarketMonitorApp.DatabaseClasses.EMMADataSet.JournalRow journalEntry in journalEntries) { if (journalEntry.SenderID == APIEntityID || (forCorp && journalEntry.SCorpID == APIEntityID)) { if (!forCorp || journalEntry.SWalletID == walletID) { XmlNode node = AddJournalRow(xml, APIEntityID, journalEntry, true, forCorp); rowSet.AppendChild(node); } } if (journalEntry.RecieverID == APIEntityID || (forCorp && journalEntry.RCorpID == APIEntityID)) { if (!forCorp || journalEntry.RWalletID == walletID) { XmlNode node = AddJournalRow(xml, APIEntityID, journalEntry, false, forCorp); rowSet.AppendChild(node); } } } return rowSet; }
private XmlNode AddJournalRow(XmlDocument xml, long APIEntityID, EveMarketMonitorApp.DatabaseClasses.EMMADataSet.JournalRow journalEntry, bool currentUserIsSender, bool forCorp) { XmlNode row = xml.CreateNode(XmlNodeType.Element, "row", ""); XmlAttribute idAtt = xml.CreateAttribute("refID", ""); idAtt.Value = journalEntry.ID.ToString(); row.Attributes.Append(idAtt); XmlAttribute dateAtt = xml.CreateAttribute("date", ""); dateAtt.Value = journalEntry.Date.ToString("s", System.Globalization.CultureInfo.InvariantCulture); row.Attributes.Append(dateAtt); XmlAttribute typeAtt = xml.CreateAttribute("refTypeID", ""); typeAtt.Value = journalEntry.TypeID.ToString(); row.Attributes.Append(typeAtt); XmlAttribute fromNameAtt = xml.CreateAttribute("ownerName1", ""); fromNameAtt.Value = Names.GetName(journalEntry.SenderID); row.Attributes.Append(fromNameAtt); XmlAttribute fromIDAtt = xml.CreateAttribute("ownerID1", ""); fromIDAtt.Value = journalEntry.SenderID.ToString(); row.Attributes.Append(fromIDAtt); XmlAttribute toNameAtt = xml.CreateAttribute("ownerName2", ""); toNameAtt.Value = Names.GetName(journalEntry.RecieverID); row.Attributes.Append(toNameAtt); XmlAttribute toIDAtt = xml.CreateAttribute("ownerID2", ""); toIDAtt.Value = journalEntry.RecieverID.ToString(); row.Attributes.Append(toIDAtt); XmlAttribute argNameAtt = xml.CreateAttribute("argName1", ""); argNameAtt.Value = currentUserIsSender ? journalEntry.SArgName : journalEntry.RArgName; row.Attributes.Append(argNameAtt); XmlAttribute argIDAtt = xml.CreateAttribute("argID1", ""); argIDAtt.Value = currentUserIsSender ? journalEntry.SArgID.ToString() : journalEntry.RArgID.ToString(); row.Attributes.Append(argIDAtt); XmlAttribute amountAtt = xml.CreateAttribute("amount", ""); amountAtt.Value = journalEntry.Amount.ToString(System.Globalization.CultureInfo.InvariantCulture); row.Attributes.Append(amountAtt); XmlAttribute balanceAtt = xml.CreateAttribute("balance", ""); balanceAtt.Value = currentUserIsSender ? journalEntry.SBalance.ToString() : journalEntry.RBalance.ToString(); row.Attributes.Append(balanceAtt); XmlAttribute reasonAtt = xml.CreateAttribute("reason", ""); reasonAtt.Value = journalEntry.Reason; row.Attributes.Append(reasonAtt); return row; }
private XmlNode AddIndustryJobRow(XmlDocument xml, EveMarketMonitorApp.DatabaseClasses.EMMADataSet.IndustryJobsRow job) { XmlNode row = xml.CreateNode(XmlNodeType.Element, "row", ""); XmlAttribute idAtt = xml.CreateAttribute("jobID", ""); idAtt.Value = job.ID.ToString(); row.Attributes.Append(idAtt); XmlAttribute assemblyLineIDAtt = xml.CreateAttribute("assemblyLineID", ""); assemblyLineIDAtt.Value = job.AssemblyLineID.ToString(); row.Attributes.Append(assemblyLineIDAtt); XmlAttribute containerIDAtt = xml.CreateAttribute("containerID", ""); containerIDAtt.Value = job.ContainerID.ToString(); row.Attributes.Append(containerIDAtt); XmlAttribute installedItemIDAtt = xml.CreateAttribute("installedItemID", ""); installedItemIDAtt.Value = job.InstalledItemID.ToString(); row.Attributes.Append(installedItemIDAtt); XmlAttribute installedItemLocationIDAtt = xml.CreateAttribute("installedItemLocationID", ""); installedItemLocationIDAtt.Value = job.InstalledItemLocationID.ToString(); row.Attributes.Append(installedItemLocationIDAtt); XmlAttribute installedItemQuantityAtt = xml.CreateAttribute("installedItemQuantity", ""); installedItemQuantityAtt.Value = job.InstalledItemQuantity.ToString(); row.Attributes.Append(installedItemQuantityAtt); XmlAttribute installedItemProductivityLevelAtt = xml.CreateAttribute("installedItemProductivityLevel", ""); installedItemProductivityLevelAtt.Value = job.InstalledItemPL.ToString(); row.Attributes.Append(installedItemProductivityLevelAtt); XmlAttribute installedItemMaterialLevelAtt = xml.CreateAttribute("installedItemMaterialLevel", ""); installedItemMaterialLevelAtt.Value = job.InstalledItemME.ToString(); row.Attributes.Append(installedItemMaterialLevelAtt); XmlAttribute installedItemLicensedProductionRunsRemainingAtt = xml.CreateAttribute("installedItemLicensedProductionRunsRemaining", ""); installedItemLicensedProductionRunsRemainingAtt.Value = job.InstalledItemRunsRemaining.ToString(); row.Attributes.Append(installedItemLicensedProductionRunsRemainingAtt); XmlAttribute outputLocationIDAtt = xml.CreateAttribute("outputLocationID", ""); outputLocationIDAtt.Value = job.OutputLcoationID.ToString(); row.Attributes.Append(outputLocationIDAtt); XmlAttribute installerIDAtt = xml.CreateAttribute("installerID", ""); installerIDAtt.Value = job.InstallerID.ToString(); row.Attributes.Append(installerIDAtt); XmlAttribute runsAtt = xml.CreateAttribute("runs", ""); runsAtt.Value = job.JobRuns.ToString(); row.Attributes.Append(runsAtt); XmlAttribute licensedProductionRunsAtt = xml.CreateAttribute("licensedProductionRuns", ""); licensedProductionRunsAtt.Value = job.OutputRuns.ToString(); row.Attributes.Append(licensedProductionRunsAtt); EveDataSet.staStationsRow station = Stations.GetStation(job.OutputLcoationID); if (station != null) { XmlAttribute installedInSolarSystemIDAtt = xml.CreateAttribute("installedInSolarSystemID", ""); installedInSolarSystemIDAtt.Value = station.solarSystemID.ToString(); row.Attributes.Append(installedInSolarSystemIDAtt); } XmlAttribute containerLocationIDAtt = xml.CreateAttribute("containerLocationID", ""); containerLocationIDAtt.Value = job.OutputLcoationID.ToString(); row.Attributes.Append(containerLocationIDAtt); XmlAttribute materialMultiplierAtt = xml.CreateAttribute("materialMultiplier", ""); materialMultiplierAtt.Value = job.MaterialModifier.ToString(System.Globalization.NumberFormatInfo.InvariantInfo); row.Attributes.Append(materialMultiplierAtt); XmlAttribute charMaterialMultiplierAtt = xml.CreateAttribute("charMaterialMultiplier", ""); charMaterialMultiplierAtt.Value = job.CharMaterialModifier.ToString(System.Globalization.NumberFormatInfo.InvariantInfo); row.Attributes.Append(charMaterialMultiplierAtt); XmlAttribute timeMultiplierAtt = xml.CreateAttribute("timeMultiplier", ""); timeMultiplierAtt.Value = job.TimeMultiplier.ToString(System.Globalization.NumberFormatInfo.InvariantInfo); row.Attributes.Append(timeMultiplierAtt); XmlAttribute charTimeMultiplierAtt = xml.CreateAttribute("charTimeMultiplier", ""); charTimeMultiplierAtt.Value = job.CharTimeMultiplier.ToString(System.Globalization.NumberFormatInfo.InvariantInfo); row.Attributes.Append(charTimeMultiplierAtt); XmlAttribute installedItemTypeIDAtt = xml.CreateAttribute("installedItemTypeID", ""); installedItemTypeIDAtt.Value = job.InstalledItemTypeID.ToString(); row.Attributes.Append(installedItemTypeIDAtt); XmlAttribute outputTypeIDAtt = xml.CreateAttribute("outputTypeID", ""); outputTypeIDAtt.Value = job.OutputTypeID.ToString(); row.Attributes.Append(outputTypeIDAtt); XmlAttribute containerTypeIDAtt = xml.CreateAttribute("containerTypeID", ""); containerTypeIDAtt.Value = job.ContainerTypeID.ToString(); row.Attributes.Append(containerTypeIDAtt); XmlAttribute installedItemCopyAtt = xml.CreateAttribute("installedItemCopy", ""); installedItemCopyAtt.Value = job.InstalledItemCopy ? "1" : "0"; row.Attributes.Append(installedItemCopyAtt); XmlAttribute completedAtt = xml.CreateAttribute("completed", ""); completedAtt.Value = job.Completed ? "1" : "0"; row.Attributes.Append(completedAtt); XmlAttribute completedSuccessfullyAtt = xml.CreateAttribute("completedSuccessfully", ""); completedSuccessfullyAtt.Value = job.CompletedSuccessfully ? "1" : "0"; row.Attributes.Append(completedSuccessfullyAtt); XmlAttribute installedItemFlagAtt = xml.CreateAttribute("installedItemFlag", ""); installedItemFlagAtt.Value = job.InstalledItemFlag.ToString(); row.Attributes.Append(installedItemFlagAtt); XmlAttribute outputFlagAtt = xml.CreateAttribute("outputFlag", ""); outputFlagAtt.Value = job.OutputFlag.ToString(); row.Attributes.Append(outputFlagAtt); XmlAttribute activityAtt = xml.CreateAttribute("activityID", ""); activityAtt.Value = job.ActivityID.ToString(); row.Attributes.Append(activityAtt); XmlAttribute completedStatusAtt = xml.CreateAttribute("completedStatus", ""); completedStatusAtt.Value = job.CompletedStatus.ToString(); row.Attributes.Append(completedStatusAtt); XmlAttribute installTimeAtt = xml.CreateAttribute("installTime", ""); installTimeAtt.Value = job.InstallTime.ToString("s", System.Globalization.CultureInfo.InvariantCulture); row.Attributes.Append(installTimeAtt); XmlAttribute beginProductionTimeAtt = xml.CreateAttribute("beginProductionTime", ""); beginProductionTimeAtt.Value = job.BeginProductionTime.ToString("s", System.Globalization.CultureInfo.InvariantCulture); row.Attributes.Append(beginProductionTimeAtt); XmlAttribute endProductionTimeAtt = xml.CreateAttribute("endProductionTime", ""); endProductionTimeAtt.Value = job.EndProductionTime.ToString("s", System.Globalization.CultureInfo.InvariantCulture); row.Attributes.Append(endProductionTimeAtt); XmlAttribute pauseProductionTimeAtt = xml.CreateAttribute("pauseProductionTime", ""); pauseProductionTimeAtt.Value = job.PauseProductionTime.ToString("s", System.Globalization.CultureInfo.InvariantCulture); row.Attributes.Append(pauseProductionTimeAtt); return row; }