private static void addConfigOption(string name, bool func, XDocument doc) { if (func) doc.Element("Config").Add(new XElement(name, "1")); else doc.Element("Config").Add(new XElement(name, "0")); }
public void saveToXML() { XDocument xdoc = new XDocument (); string xmlShell = @"<save><board></board><players></players><turn></turn> </save>"; xdoc = XDocument.Parse (xmlShell); for (int x = 0; x < 15; x++) { XElement row = new XElement ("row"); for (int y = 0; y < 15; y++) { row.Add(new XElement("column",board[x][y])); } xdoc.Element("save").Element ("board").Add (row); } for (int i = 0; i < players.Count; i++) { XElement player = new XElement ("player"); player.Add (new XElement ("name", players [i].GetName ())); player.Add (new XElement ("bricks", players [i].GetLetters ())); player.Add (new XElement ("score", players [i].GetPoints())); xdoc.Element("save").Element("players").Add(player); } xdoc.Element("save").Element("turn").SetValue (playerturn); xdoc.Save ("Savestate.xml"); }
private void Button_CreateProject_Click(object sender, RoutedEventArgs e) { XDocument newProject = new XDocument( new XElement("Project", new XElement("Name"), new XElement("SDNumber"), new XElement("Watchfolder"), new XElement("MezzaninePassFolder"), new XElement("WebPassFolder"), new XElement("FailFolder"), new XElement("Keyword"), new XElement("ToEmailOnFail")) ); foreach (var element in newProject.Element("Project").Elements()) { XML_Element_Entry entry = new XML_Element_Entry(); entry.Label_element.Content = element.Name; entry.ShowDialog(); newProject.Element("Project").Element(element.Name).Value = entry.TextBox_value.Text; } newProject.Save(@"\\cob-hds-1\compression\QC\QCing\otherFiles\projects\" + newProject.Element("Project").Element("Name").Value + ".xml"); }
public static XDocument LoadXML(string XMLfile) { XDocument LoadedXML; if (XMLfile == OverwatchINI) { Settings = XDocument.Load(Utilities.OverwatchINI); if (WinUsername != (Settings.Element("Settings").Element("UserInfo").Element("Usernames").Element("Windows").Element("WinUsername").Value)) { WinUsername = Settings.Element("Settings").Element("UserInfo").Element("Usernames").Element("Windows").Element("WinUsername").Value; } if (AvatarLocation != (Settings.Element("Settings").Element("UserInfo").Element("Usernames").Element("Windows").Element("AvatarLocation").Value)) { AvatarLocation = Settings.Element("Settings").Element("UserInfo").Element("Usernames").Element("Windows").Element("AvatarLocation").Value; } if ((Settings.Element("Settings").Element("HardwareInfo").Element("Processor").Element("Name").Value != "")) { CPUName = Settings.Element("Settings").Element("HardwareInfo").Element("Processor").Element("Name").Value; } if (Settings.Element("Settings").Element("HardwareInfo").Element("Processor").Element("Frequency").Value != "") { CPUFreq = Settings.Element("Settings").Element("HardwareInfo").Element("Processor").Element("Frequency").Value; } if (Settings.Element("Settings").Element("HardwareInfo").Element("MotherBoard").Value != "") { MotherboardName = Settings.Element("Settings").Element("HardwareInfo").Element("MotherBoard").Value; } LoadedXML = Settings; } else { LoadedXML = XDocument.Load(XMLfile); } return LoadedXML; }
public Entity(XDocument document) { id = uint.Parse(document.Element("entity").Attribute("id").Value); name = document.Element("entity").Attribute("name").Value; componentsXML = document.Element("entity").Element("components").Elements().ToList<XElement>(); }
public ActionResult Export() { var content = _contentManager .Query(VersionOptions.Published) .List(); XDocument export = new XDocument(); export.Add(new XElement("Orchard")); export.Element("Orchard").Add(new XElement("Data")); foreach(var contentItem in content) { export.Element("Orchard").Element("Data").Add(_contentManager.Export(contentItem)); } StringBuilder xml = new StringBuilder(); XmlWriterSettings settings = new XmlWriterSettings() {Encoding = Encoding.UTF8, Indent = true, NewLineHandling = NewLineHandling.Entitize, NewLineOnAttributes = true}; using (XmlWriter w = XmlWriter.Create(xml, settings)) { export.WriteTo(w); w.Flush(); } return new ContentResult() { Content = xml.ToString(), ContentType = "text/xml", ContentEncoding = Encoding.UTF8 }; }
public void addTask(XDocument xdoc) { XDocument message; XDocument header; Dictionary<string, string> headers = new Dictionary<string,string>(); string title = xdoc.Element("message").Element("task").Element("title") != null ? xdoc.Element("message").Element("task").Element("title").Value : "\'\'"; string notes = xdoc.Element("message").Element("task").Element("notes") != null ? xdoc.Element("message").Element("task").Element("notes").Value : "\'\'"; string startdatetime = xdoc.Element("message").Element("task").Element("startdatetime") != null ? xdoc.Element("message").Element("task").Element("startdatetime").Value : "\'\'"; string enddatetime = xdoc.Element("message").Element("task").Element("enddatetime") != null ? xdoc.Element("message").Element("task").Element("enddatetime").Value : "\'\'"; string place = xdoc.Element("message").Element("task").Element("place") != null ? xdoc.Element("message").Element("task").Element("place").Value : "\'\'"; OdbcDataReader r = adapter.executeQuery("insert ignore into scheduler.task(title, notes, startdatetime, enddatetime, place, fkuser) values(\'" + title + "\', \'" + notes + "\', \'" + startdatetime + "\', \'" + enddatetime + "\', \'" + place + "\', " + userId + ")", true); if (adapter.affectedRows() > 0) { message = formatter.createMessage("Task added.", "popup", "0"); headers.Add("content_length", message.ToString().Length.ToString()); headers.Add("message_type", "popup"); } else { message = formatter.createMessage("Error while adding task.", "popup", "1"); headers.Add("content_length", message.ToString().Length.ToString()); headers.Add("message_type", "popup"); } header = formatter.createHeader(headers); sendHeader(header); sendMessage(message); getTasks(); }
private static XElement GetMetaWebLogElement(XDocument document) { // ReSharper disable PossibleNullReferenceException try { IEnumerable<XElement> apiElements; if (document.Root.Attributes().Any(x => x.IsNamespaceDeclaration && x.Value == RsdNamespace)) { apiElements = document .Element(XName.Get("rsd", RsdNamespace)) .Element(XName.Get("service", RsdNamespace)) .Element(XName.Get("apis", RsdNamespace)) .Elements(XName.Get("api", RsdNamespace)); } else { apiElements = document .Element(XName.Get("rsd")) .Element(XName.Get("service")) .Element(XName.Get("apis")) .Elements(XName.Get("api")); } return apiElements.SingleOrDefault(e => e.Attribute("name").Value.ToLower() == "metaweblog"); } catch (NullReferenceException) { return null; } // ReSharper restore PossibleNullReferenceException }
////This is a basic function that adds an item to an xdocument. It is called by various other functions. ////It receives the name of the XDocument, the filename that identifies where it is stored, the name of the item, ////whether it is enabled, and the string for the combination such as in salvage or empty for mobs and trophies, ////the GUID as a string -- which may or may not be kept, and a bool for if it is a partial name, and the number of subitems in the xml file ////the function simply adds the item to the file and then saves the file. private void addMyItem(XDocument xdoc, string filename, string mid, bool mexact, int mitem) { try { switch (mitem) { case 1: xdoc.Element("GameItems").Add(new XElement("item", new XElement("key", sname), new XElement("checked", mchecked), new XElement("isexact", mexact), new XElement("Guid", mid))); break; case 2: xdoc.Element("GameItems").Add(new XElement("item", new XElement("key", sname), new XElement("checked", mchecked), new XElement("isexact", mexact), new XElement("Guid", mMaxLoot))); break; } xdoc.Save(filename); if (xdoc == xdocTrophies) { populateTrophysListBox(); } else if (xdoc == xdocMobs) { populateMobsListBox(); } } catch (Exception ex) { LogError(ex); } }
public void loadServerConfig() { xdoc = XDocument.Load("../../../config/server_config.xml"); BindIpInput.Text = xdoc.Element("config").Element("server_config").Element("bind_ip").Value; BindPortInput.Text = xdoc.Element("config").Element("server_config").Element("bind_port").Value; singleton.log("Server config loaded."); }
private void saveXml() { XDocument xmlOutput = new XDocument( new XDeclaration("1.0", "utf-8", "yes"), new XComment("Jueki's Own3d.tv Stream Manager Configuration"), new XElement("streams") ); foreach(ListViewItem lv in listView1.Items) { xmlOutput.Element("streams").Add( new XElement("stream", new XElement("name", lv.Text), new XElement("id", lv.SubItems[2].Text) ) ); } xmlOutput.Element("streams").Add( new XElement("config", new XElement("gui", new XElement("width", this.Size.Width.ToString()), new XElement("height", this.Size.Height.ToString()) ) ) ); xmlOutput.Save("streams.xml"); }
public void CanAddNode() { var document = new XDocument(new XElement("document", new XElement("element1"), new XElement("element2"))); var file = Path.Combine(Path.GetTempPath(), Path.GetRandomFileName()); document.Save(file); try { var mock = new Mock<ILogger>(); var task = new XmlAddNodeTaskExecutor { File = new FileInfo(file), XPath = "/document", NodeXml = "<element3 />", Logger = mock.Object }; task.CallExecuteTask(); document = XDocument.Load(file); Assert.That(document.Root, Is.Not.Null); // ReSharper disable PossibleNullReferenceException Assert.That(document.Root.Descendants().Count(), Is.EqualTo(3)); Assert.That(document.Element("document").Element("element1"), Is.Not.Null); Assert.That(document.Element("document").Element("element2"), Is.Not.Null); Assert.That(document.Element("document").Element("element3"), Is.Not.Null); // ReSharper restore PossibleNullReferenceException var desiredLogMessage = string.Format(Resources.XmlAddNodeTaskLogMessage, task.NodeXml, task.XPath, file); mock.Verify(logger => logger.Log(It.Is<Level>(l => l == Level.Info), It.Is<string>(s => s.Equals(desiredLogMessage)))); } finally { File.Delete(file); } }
internal OpfFile(string fileName) { Document = XDocument.Load(fileName); _metadata = Document.Element("metadata"); _manifest = Document.Element("manifest"); _spine = Document.Element("spine"); }
protected void btnSave_Click(object sender, EventArgs e) { doc = XDocument.Load(Server.MapPath("~/App_Data/Images.xml")); if (this.drpLetters.SelectedIndex > 0) // Edit mode { IEnumerable<XElement> elements = doc.Element("Images").Elements("Image").Where(an => an.Attribute("id").Value == this.drpLetters.SelectedValue); foreach (XElement item in elements) { item.Attribute("isActive").Value = this.chkIsActive.Checked.ToString(); item.Element("Title").Value = this.txtTitle.Text; } doc.Save(Server.MapPath("~/App_Data/Images.xml")); if (this.fluLetter.HasFile) { if (this.fluLetter.PostedFile.ContentType.Equals("image/pjpeg") || this.fluLetter.PostedFile.ContentType.Equals("image/x-png")) { string file = string.Format("{0}/{1}.jpg", Server.MapPath("~/LettImg"), this.drpLetters.SelectedValue); System.IO.File.Delete(file); this.fluLetter.PostedFile.SaveAs(file); } else { this.lblMessage.Text = "فرمت عکس jpg نمیباشد"; } } this.lblMessage.Text = Public.EDITMESSAGE; } else // Add mode { if (this.fluLetter.HasFile) { if (this.fluLetter.PostedFile.ContentType.Equals("image/pjpeg") || this.fluLetter.PostedFile.ContentType.Equals("image/x-png")) { string maxId = doc.Element("Images").Elements("Image").Max(tst => tst.Attribute("id").Value); string nextId = maxId == null ? "1" : (byte.Parse(maxId) + 1).ToString(); doc.Element("Images").Add(new XElement("Image", new XAttribute("id", nextId), new XAttribute("isActive", this.chkIsActive.Checked.ToString()), new XElement("Title", this.txtTitle.Text.Trim()))); doc.Save(Server.MapPath("~/App_Data/Images.xml")); this.fluLetter.PostedFile.SaveAs(string.Format("{0}/{1}.jpg", Server.MapPath("~/LettImg"), nextId)); this.lblMessage.Text = Public.SAVEMESSAGE; } else { this.lblMessage.Text = "فرمت عکس jpg نمیباشد"; } } } this.drpLetters.DataSource = doc.Element("Images").Elements("Image").Select(an => new { Id = an.Attribute("id").Value, Title = an.Element("Title").Value }); this.drpLetters.DataBind(); this.drpLetters.Items.Insert(0, "- جدید -"); this.drpLetters.SelectedIndex = 0; this.chkIsActive.Checked = false; this.txtTitle.Text = null; this.imgLetter.ImageUrl = null; }
public ThemeSettings(XDocument settingDoc) { XElement firing = settingDoc.Element("themeSettings").Element("firingTypes"); foreach (XElement ft in firing.Elements()) this._firingTypes.Add(ft.Value); XElement damage = settingDoc.Element("themeSettings").Element("damageTypes"); foreach (XElement dt in damage.Elements()) this._damageTypes.Add(dt.Value); }
private void button2_Click(object sender, EventArgs e) { try { if (!System.IO.Directory.Exists(@"D:\")) { Program.MessageError("Sticker", "Drive D:", "Not found.", false); } else { if (!System.IO.Directory.Exists(@"D:\EmrCheckup")) { System.IO.DirectoryInfo di = System.IO.Directory.CreateDirectory(@"D:\EmrCheckup"); di.Attributes = System.IO.FileAttributes.Directory | System.IO.FileAttributes.Hidden; } if (!System.IO.File.Exists(@"D:\EmrCheckup\PrinterSticker.xml")) { new XDocument( new XElement("PrinterCls", new XElement("Report", new XAttribute("id", "Wristband"), new XElement("Printer", comboAutoDropDownWidth1.Text), new XElement("Paper", ((PrinterPaperSize)comboAutoDropDownWidth2.SelectedItem).Name) ) ) ).Save(@"D:\EmrCheckup\PrinterSticker.xml"); } else { System.Xml.Linq.XDocument xml = System.Xml.Linq.XDocument.Load(@"D:\EmrCheckup\PrinterSticker.xml"); var wb = xml.Element("PrinterCls").Elements("Report").Where(x => x.Attribute("id").Value == "Wristband").FirstOrDefault(); if (wb == null) { xml.Element("PrinterCls").Add( new XElement("Report", new XAttribute("id", "Wristband"), new XElement("Printer", comboAutoDropDownWidth1.Text), new XElement("Paper", ((PrinterPaperSize)comboAutoDropDownWidth2.SelectedItem).Name) ) ); } else { wb.Element("Printer").Value = comboAutoDropDownWidth1.Text; wb.Element("Paper").Value = ((PrinterPaperSize)comboAutoDropDownWidth2.SelectedItem).Name; } xml.Save(@"D:\EmrCheckup\PrinterSticker.xml"); } } } catch (Exception ex) { } }
private Thread LoadThread(XDocument doc) { Thread thread = new Thread(); thread.ID = (int)doc.Element("thread").Attribute("id"); thread.NumArticles = (int)doc.Element("thread").Attribute("numarticles"); thread.Link = doc.Element("thread").Attribute("link").Value; thread.TermsOfUse = doc.Element("thread").Attribute("termsofuse").Value; thread.Subject = doc.Element("thread").Element("subject").Value; return thread; }
private void Form1_Load(object sender, EventArgs e) { xmlDoc = XDocument.Load("CMAInterestCalc.xml"); yMoney = int.Parse(xmlDoc.Element("CMA_INTEREST_CALC").Element("LastMoney").Value); yInterest = int.Parse(xmlDoc.Element("CMA_INTEREST_CALC").Element("LastInterest").Value); lblYesterdayMoney.Text = "전일금액 : " + string.Format(korInfo, "{0:C}", yMoney); lblYesterdayInterest.Text = "전일이자 : " + string.Format(korInfo, "{0:C}", yInterest); }
public override void parse(XDocument doc) { MarketCat retour = new MarketCat(); String atom = "{http://www.w3.org/2005/Atom}"; String defaultXlmns = "{http://schemas.zune.net/catalog/apps/2008/02}"; retour = new MarketCat() { Id = doc.Element(atom + "entry").Element(atom + "id").Value, Title = doc.Element(atom + "entry").Element(atom + "title").Value }; OnComplete(retour); }
private XElement GetRootElem(XDocument document, string rootElementName) { var rootElement = document.Element(rootElementName); if (rootElement == null) { if (document.Root != null) rootElement = document.Root.Element(rootElementName); else rootElement = document.Element(rootElementName); } return rootElement; }
public WmsCapabilities(XDocument doc) : this() { if (doc.Root.Name == "ServiceExceptionReport") { ServiceExceptionReport = new ServiceExceptionReport(doc.Root, ""); return; } var node = doc.Element(XName.Get("WMT_MS_Capabilities")); if (node == null) node = doc.Element(XName.Get("WMS_Capabilities")); if (node == null) { // try load root node with xmlns="http://www.opengis.net/wms" node = doc.Element(XName.Get("WMS_Capabilities", "http://www.opengis.net/wms")); if (node == null) { throw WmsParsingException.ElementNotFound("WMS_Capabilities or WMT_MS_Capabilities"); } } var att = node.Attribute(XName.Get("version")); if (att == null) throw WmsParsingException.AttributeNotFound("version"); Version = new WmsVersion(att.Value); var @namespace = Version.Version == WmsVersionEnum.Version_1_3_0 ? "http://www.opengis.net/wms" : string.Empty; XmlObject.Namespace = @namespace; att = node.Attribute("updateSequence"); if (att != null) UpdateSequence = int.Parse(att.Value, NumberFormatInfo.InvariantInfo); var element = node.Element(XName.Get("Service", @namespace)); if (element == null) { XmlObject.Namespace = @namespace = string.Empty; element = node.Element(XName.Get("Service", @namespace)); } if (element == null) throw WmsParsingException.ElementNotFound("Service"); Service = new Service(element, @namespace); element = node.Element(XName.Get("Capability", @namespace)); if (element == null) throw WmsParsingException.ElementNotFound("Capability"); Capability = new Capability(element, @namespace); }
public void AddToDoc(XDocument xdoc, XNamespace ns) { ConsoleHelper.WriteLine(" Adding proj ref: '" + this.include + "'", true); XElement newref = new XElement(ns + "ProjectReference", new XAttribute("Include", this.include), new XElement(ns + "Project", this.project), new XElement(ns + "Name", this.name) ); // Sort insert var groups = from el in xdoc.Element(ns + "Project").Elements(ns + "ItemGroup") where el.Element(ns + "ProjectReference") != null select el; if (groups.Count() == 0) { groups = from el in xdoc.Element(ns + "Project").Elements(ns + "ItemGroup") select el; XElement newgroup = new XElement(ns + "ItemGroup", newref); groups.Last().AddAfterSelf(newgroup); } else { var refs = from el in groups.Elements(ns + "ProjectReference") where el.Attribute("Include") != null orderby el.Attribute("Include").Value select el; if (this.include.CompareTo(refs.First().Attribute("Include").Value) < 0) { groups.ElementAt(0).AddFirst(newref); } else if (this.include.CompareTo(refs.Last().Attribute("Include").Value) > 0) { refs.Last().AddAfterSelf(newref); } else { for (int i = 0; i < refs.Count() - 1; i++) { string inc1 = refs.ElementAt(i).Attribute("Include").Value; string inc2 = refs.ElementAt(i + 1).Attribute("Include").Value; if (this.include.CompareTo(inc1) > 0 && this.include.CompareTo(inc2) < 0) { refs.ElementAt(i).AddAfterSelf(newref); } } } } }
public bool Create(Collage collage) { try { if (collage.id == 1) //add the second collage { doc = new XDocument(); XElement p = new XElement("collages"); XElement c = new XElement("collage"); XElement d = new XElement("id"); d.Value = "1"; c.Add(d); XElement i = new XElement("collageName"); i.Value = collage.collageName; c.Add(i); foreach (var a in collage.storyId) { XElement s = new XElement("storyId"); s.Value = a.ToString(); c.Add(s); } p.Add(c); doc.Add(p); } else { doc = XDocument.Load(paths); doc.Element("collages") .Elements("collage") .Where(items => items.Element("id").Value == (collage.id - 1).ToString()).FirstOrDefault() .AddAfterSelf(new XElement("collage", new XElement("id", collage.id), new XElement("collageName", collage.collageName))); foreach (var b in collage.storyId) { doc.Element("collages") .Elements("collage") .Where(items => items.Element("id").Value == collage.id.ToString()).FirstOrDefault() .Add(new XElement("storyId", b.ToString())); } } doc.Save(paths); } catch { return false; } return true; }
public LastUpdatesResponse MapXMLToEpisodeLastUpdates(XDocument xml) { return new LastUpdatesResponse{ Timestamp = (string)xml.Element("updates").Attribute("at"), UpdatesCount = (string)xml.Element("updates").Attribute("found"), Sorting = (string)xml.Element("updates").Attribute("sorting"), ShowingPeriod = (string)xml.Element("updates").Attribute("showing"), Shows = xml.Descendants("show").Select(x=>new LastUpdatesShowResult{ ShowId = (int)x.Element("id"), Last = (string)x.Element("last"), LatestEpisode = (string)x.Element("lastepisode"), }).ToList(), }; }
/// <summary> /// Returns response status, contained in the lfm tag attribute /// </summary> /// <param name="xml">XDocument object to be checked</param> /// <returns>Status of the response</returns> public static int CheckStatus(XDocument xml) { try { string status = xml.Element("lfm").Attribute("status").Value; if (status.ToLower() == "ok") return 0; else { string code = xml.Element("lfm").Element("error").Attribute("code").Value; return Int32.Parse(code); } } catch (NullReferenceException ex) { throw new ArgumentException("Wrong XML tree. Can't parse.", ex); } }
public static XDocument GenerateTypeMapping(XDocument mslDocument) { XElement mappingElement = mslDocument.Element(XName.Get("Mapping", mslNamespace.NamespaceName)); if (mappingElement == null || mappingElement.IsEmpty) return null; XElement entityContainerMappingElement = mappingElement.Element(XName.Get("EntityContainerMapping", mslNamespace.NamespaceName)); if (entityContainerMappingElement == null || entityContainerMappingElement.IsEmpty) return null; foreach (XElement entitySetMapping in entityContainerMappingElement.Elements(mslNamespace + "EntitySetMapping")) { string name = entitySetMapping.Attribute("Name").Value; string storeEntitySet = entitySetMapping.Attribute("StoreEntitySet").Value; string typeName = entitySetMapping.Attribute("TypeName").Value; XElement entityTypeMapping = new XElement(mslNamespace + "EntityTypeMapping", new XAttribute("TypeName", string.Format("IsTypeOf({0})", typeName))); XElement mappingFragment = null; entityTypeMapping.Add(mappingFragment = new XElement(mslNamespace + "MappingFragment", new XAttribute("StoreEntitySet", storeEntitySet))); foreach (XElement property in entitySetMapping.Elements()) mappingFragment.Add(property); entitySetMapping.RemoveAll(); entitySetMapping.AddAttribute("Name", name); entitySetMapping.Add(entityTypeMapping); } return mslDocument; }
static void Main(string[] args) { Config config = new Config(); if (args.Length == 0) { config.ShowDialog(); } else { bool isEagle = false; try { Xml.XDocument xDocument = Xml.XDocument.Load(args[0]); Xml.XElement xEagle = xDocument.Element("eagle"); if (xEagle.Name == "eagle") { isEagle = true; } } catch { } if (isEagle) { //System.Windows.Forms.MessageBox.Show("Eagle" + config.EagleFilePath + "\n" + "\"" + args[0] + "\""); System.Diagnostics.Process.Start(config.EagleFilePath, "\"" + args[0] + "\""); } else { //System.Windows.Forms.MessageBox.Show("KiCad" + config.KiCadFilePath + "\n" + "\"" + args[0] + "\""); System.Diagnostics.Process.Start(config.KiCadFilePath, "\"" + args[0] + "\""); } } }
public XElement UserElement(XDocument doc, string username) { var result = from user in doc.Element("Users").Elements("User") where user.Element("Username").Value == username select user; return result.SingleOrDefault(); }
public static ICompleteState GenerateState(XDocument xmlDocument) { var completeState = new CompleteState(); var rootElement = xmlDocument.Element("CompleteState"); if(rootElement == null) { throw new Exception("Error parsing Xml, there is no root node"); } var soundStateNodes = rootElement.Elements("SoundStates"); foreach (var ambientStateNode in soundStateNodes.Elements("SoundState")) { var soundTypeAttribute = ambientStateNode.Attribute("SoundTypeIdentifier"); var soundState = SoundStateFactory.GetState(soundTypeAttribute.Value); soundState.PopulateFromXml(ambientStateNode); completeState.SoundStates.Add(soundState); } var quickSoundStateNodes = rootElement.Elements("QuickSoundStates"); foreach (var quickSoundStateNode in quickSoundStateNodes.Elements("SoundState")) { var soundTypeAttribute = quickSoundStateNode.Attribute("SoundTypeIdentifier"); var soundState = SoundStateFactory.GetState(soundTypeAttribute.Value); soundState.PopulateFromXml(quickSoundStateNode); completeState.QuickSoundStates.Add(soundState); } return completeState; }
public static Situation Parse(XDocument doc) { var ns = XNamespace.Get("http://datex2.eu/schema/2/2_0"); var situation = new Situation(); var root = doc.Element(ns + "situation"); var situationRecord = root.Element(ns + "situationRecord"); situation.SituationId = situationRecord.Attribute("id").Value; situation.Version = situationRecord.Attribute("version").Value; situation.CreationTime = DateTime.Parse(situationRecord.Element(ns + "situationRecordCreationTime").Value); situation.VersionTime = DateTime.Parse(situationRecord.Element(ns + "situationRecordVersionTime").Value); situation.Severity = root.Element(ns + "overallSeverity").Value; situation.Probability = situationRecord.Element(ns + "probabilityOfOccurrence").Value; var location = situationRecord .Element(ns + "groupOfLocations") .Element(ns + "locationForDisplay"); situation.Location = new Location() { Latitude = double.Parse(location.Element(ns + "latitude").Value), Longitude = double.Parse(location.Element(ns + "longitude").Value), }; var locationExtension = situationRecord .Element(ns + "groupOfLocations") .Element(ns + "locationExtension") .Element(ns + "locationExtension"); situation.RoadNumber = locationExtension.Element(ns + "roadNumber").Value; situation.CountyNumber = ParseInt(locationExtension.Element(ns + "countyNumber")); situation.MunicipalityNumber = ParseInt(locationExtension.Element(ns + "municipalityNumber")); return situation; }
//Возвращает список названий public static List<string> GetLessonNames(XDocument Lessons, string Class) { List<string> Names = new List<string>(); foreach (string Lesson in Lessons.Element("Lessons").Elements(Class).Elements("name")) Names.Add(TextDeriver(Lesson)); return Names; }
//Возвращает список предметов public static string[] LessonParse(XDocument Lessons, string Class) { string[] New = new string[0]; foreach (string Lesson in Lessons.Element("Lessons").Elements(Class).Elements("LessIds")) New = HelpDeriver(Lesson); return New; }
public Config() { InitializeComponent(); try { string s = System.Reflection.Assembly.GetExecutingAssembly().Location; System.IO.FileInfo fileInfo = new System.IO.FileInfo(s); string startup_path = fileInfo.Directory.FullName; string settingsFile = System.IO.Path.Combine(startup_path, "settings.xml"); Xml.XDocument xDocument = Xml.XDocument.Load(settingsFile); Xml.XElement setting = xDocument.Element("schLauncherSettings"); textBoxKiCad.Text = setting.Element("KiCadPath").Value; textBoxEagle.Text = setting.Element("EaglePath").Value; } catch { } }
public void SaveCustomer(Customer _C) { if (!File.Exists(CustomerStorage)) { XmlWriterSettings xmlWriterSettings = new XmlWriterSettings(); xmlWriterSettings.Indent = true; xmlWriterSettings.NewLineOnAttributes = true; using (XmlWriter xmlWriter = XmlWriter.Create(CustomerStorage, xmlWriterSettings)) { xmlWriter.WriteStartDocument(); xmlWriter.WriteStartElement("Customers"); xmlWriter.WriteStartElement("Customer"); xmlWriter.WriteElementString("CID", _C.ID); xmlWriter.WriteElementString("FirstName", _C.FirstName); xmlWriter.WriteElementString("LastName", _C.LastName); xmlWriter.WriteElementString("TimeStamp", DateTimeOffset.Now.ToUnixTimeMilliseconds().ToString()); xmlWriter.WriteEndElement(); xmlWriter.WriteEndElement(); xmlWriter.WriteEndDocument(); xmlWriter.Flush(); xmlWriter.Close(); } } else { System.Xml.Linq.XDocument xDocument = XDocument.Load(CustomerStorage); XElement root = xDocument.Element("Customers"); IEnumerable <XElement> rows = root.Descendants("Customer"); XElement firstRow = rows.First(); firstRow.AddBeforeSelf( new XElement("Customer", new XElement("CID", _C.ID), new XElement("FirstName", _C.FirstName), new XElement("LastName", _C.LastName), new XElement("TimeStamp", DateTimeOffset.Now.ToUnixTimeMilliseconds().ToString()))); xDocument.Save(CustomerStorage); } }
public static bool ContainsValue(string name) { return(xDoc.Element(name) != null); }
public string OrderFileImport(string FileName, string CallType) { int ValidRecords = 0; int InValidRecords = 0; try { accessfileName = FileName + SiteConfigurationManager.GetAppSettingKey("FileImportExtension"); fileName = ClaimHelper.CompanyId + "_" + FileName; FileName = fileName + SiteConfigurationManager.GetAppSettingKey("FileImportExtension"); string logImport = null; string rootFolderPath = SiteConfigurationManager.GetAppSettingKey("TemplatePath") + "orderFile\\"; string destinationPath = rootFolderPath + "\\Archive\\"; string fullPathToExcel = rootFolderPath + accessfileName; string fullpathToArchive = destinationPath + accessfileName; string OrderResult = null; LoggerDataAccess loggerDataAccess = new LoggerDataAccess(); logImport = loggerDataAccess.LogFileImport(FileName, "IMP_FL_INITIATED", ValidRecords.ToString(), InValidRecords.ToString(), null, null); ImportFileHistoryID = logImport; if (logImport == "File is already processed.") { return("File is already processed."); } if (string.IsNullOrEmpty(logImport)) { throw new Exception("Invalid response from Log File Import."); } if (new FileInfo(fullpathToArchive).Exists == false) { string connString = string.Format("Provider =Microsoft.ACE.OLEDB.12.0;Data Source=" + fullPathToExcel + ";Extended Properties='Excel 12.0;HDR=yes'", fullPathToExcel); DataTable dt = FileManager.GetDataTable("SELECT * FROM [Sheet1$]", connString); Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("en-GB"); Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-GB"); var date = DateTime.Now; if (CallType == "Order") { if (dt != null) { var distinctOrders = dt.AsEnumerable().Select(c => Convert.ToString(c["VendorOrderID"])).Distinct().ToList <string>(); //ValidRecords = distinctOrders.Count(); foreach (var order in distinctOrders) { var orders = dt.AsEnumerable().Where(x => Convert.ToString(x["VendorOrderID"]) == order).ToList(); if (orders != null && orders.Count() > 0) { string pickupLatitude = null; string pickupLongitude = null; string dropoffLatitude = null; string dropoffLongitude = null; var first = orders[0]; //first["PICKUPHOUSE_FLATNO"].ToString() + first["PickupAddress"].ToString() + ", " + first["PICKUPCITY"].ToString() + ", " + first["PICKUPSTATE"].ToString() + " " + first["PICKUPPINCODE"].ToString() + ", " + first["PICKUPCOUNTRY"].ToString(), //AIzaSyB9PgorTUksSwiRCNNTkfEEu1gaHIGG0Rw string Pickupaddress = first["PickupAddress"].ToString() + ", " + first["PICKUPAREA_LOCALITY"].ToString() + ", " + first["PICKUPCITY"].ToString() + ", " + first["PICKUPSTATE"].ToString() + " " + first["PICKUPPINCODE"].ToString() + ", " + first["PICKUPCOUNTRY"].ToString(); string PickuprequestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false?key=AIzaSyB9PgorTUksSwiRCNNTkfEEu1gaHIGG0Rw", Uri.EscapeDataString(Pickupaddress)); WebRequest request = WebRequest.Create(PickuprequestUri); WebResponse response = request.GetResponse(); System.Xml.Linq.XDocument xdoc = XDocument.Load(response.GetResponseStream()); XElement result = xdoc.Element("GeocodeResponse").Element("result"); if (result != null) { XElement locationElement = result.Element("geometry").Element("location"); XElement pickuplat = locationElement.Element("lat"); XElement pickuplng = locationElement.Element("lng"); pickupLatitude = pickuplat.Value; pickupLongitude = pickuplng.Value; } string DropOffaddress = first["DROPOFFADDRESS"].ToString() + ", " + first["DROPOFFAREA_LOCALITY"].ToString() + ", " + first["DROPOFFCITY"].ToString() + ", " + first["DROPOFFSTATE"].ToString() + " " + first["DROPOFFPINCODE"].ToString() + ", " + first["DROPOFFCOUNTRY"].ToString(); string DropoffrequestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false", Uri.EscapeDataString(DropOffaddress)); WebRequest requestD = WebRequest.Create(DropoffrequestUri); WebResponse responseD = requestD.GetResponse(); System.Xml.Linq.XDocument xdocD = XDocument.Load(responseD.GetResponseStream()); XElement resultD = xdocD.Element("GeocodeResponse").Element("result"); if (resultD != null) { XElement locationElementD = resultD.Element("geometry").Element("location"); XElement dropOfflat = locationElementD.Element("lat"); XElement dropOfflng = locationElementD.Element("lng"); dropoffLatitude = dropOfflat.Value; dropoffLongitude = dropOfflng.Value; } LogistikaOrderHeader tOrder = new LogistikaOrderHeader { //ClientOrderSource = "FileImport_" + first["ServiceCode"].ToString(), CallType = "Portal", ClientOrderSource = "FileImport_" + FileName,//Convert.ToString(System.DateTime.Now), ServiceCode = first["ServiceCode"].ToString(), OrderType = first["OrderType"].ToString(), FreightType = first["FreightType"].ToString(), OrderByName = first["OrderByName"].ToString(), OrderByPhoneNumber = first["OrderByPhoneNumber"].ToString(), OrderByEmail = first["OrderByEmail"].ToString(), PickUpDate = Convert.ToDateTime(first["PickUpDate"].ToString()), VendorOrderID = first["VendorOrderID"].ToString(), Payment = new Payment { Amount = Convert.ToDouble(first["CHARGEDAMOUNT"].ToString()), PaymentMethod = first["PAYMENTMODE"].ToString() }, PickupAddress = new List <Address> { new Address() { AddressLine1 = first["PickupAddress"].ToString(), Suite = first["PICKUPHOUSE_FLATNO"].ToString(), Locality = first["PICKUPAREA_LOCALITY"].ToString(), City = first["PICKUPCITY"].ToString(), StateCode = first["PICKUPSTATE"].ToString(), PostalCode = first["PICKUPPINCODE"].ToString(), CountryCode = first["PICKUPCOUNTRY"].ToString(), LandMark = first["PICKUPLANDMARK"].ToString(), Instruction = first["PICKUPINSTRUCTION"].ToString(), Latitude = pickupLatitude, Longitude = pickupLongitude } }, DropoffAddress = new List <Address> { new Address() { AddressLine1 = first["DROPOFFADDRESS"].ToString(), Suite = first["DROPOFFHOUSE_FLATNO"].ToString(), Locality = first["DROPOFFAREA_LOCALITY"].ToString(), City = first["DROPOFFCITY"].ToString(), StateCode = first["DROPOFFSTATE"].ToString(), PostalCode = first["DROPOFFPINCODE"].ToString(), CountryCode = first["DROPOFFCOUNTRY"].ToString(), LandMark = first["DROPOFFLANDMARK"].ToString(), Instruction = first["DROPOFFINSTRUCTION"].ToString(), DropOffDate = Convert.ToDateTime(first["DropOffDate"].ToString()), Name = first["DROPOFFNAME"].ToString(), PhoneNumber = first["DROPOFFPHONE"].ToString(), Latitude = dropoffLatitude, Longitude = dropoffLongitude } } }; tOrder.LineItem = orders.Select(s => new LogistikaOrderLineItem { Item = s["ITEM"].ToString(), //ItemType_FK = Convert.ToInt32(s["ItemType_FK"].ToString()), ShipmentType = s["ShipmentType"].ToString(), GoodsType = s["GOODSTYPE"].ToString(), UOM = s["UOM"].ToString(), Quantity = Convert.ToInt32(s["NOOFITEMS"].ToString()), Weight = Convert.ToDouble(s["WEIGHT"].ToString()), Length = Convert.ToDouble(s["Length"].ToString()), Width = Convert.ToDouble(s["Width"].ToString()), Height = Convert.ToDouble(s["Height"].ToString()), IsPackagingRequiredFlag = Convert.ToBoolean(s["ISPACKAGINGREQUIRED?"].ToString()), IsPermitVerifiedFlag = Convert.ToBoolean(s["ISPERMITVERIFIED?"].ToString()) }).ToList(); OrderResult = createOrder(tOrder); if (string.IsNullOrEmpty(OrderResult) || OrderResult.Contains("File import Failed")) { InValidRecords = InValidRecords + 1; } if (OrderResult.StartsWith("H")) { ValidRecords = ValidRecords + 1; } } } } } string[] fileList = Directory.GetFiles(rootFolderPath, FileName); if (Directory.Exists(rootFolderPath)) { foreach (string file in fileList) { FileInfo mFile = new FileInfo(file); if (new FileInfo(destinationPath + "\\" + mFile.Name).Exists == false) { mFile.MoveTo(destinationPath + "\\" + mFile.Name); } } } } else if (new FileInfo(fullpathToArchive).Exists == true) { return("File was already processed"); } if (!string.IsNullOrEmpty(OrderResult)) { logImport = loggerDataAccess.LogFileImport(FileName, "IMP_FL_SCCS", ValidRecords.ToString(), InValidRecords.ToString(), null, ImportFileHistoryID); return(FileName + ":- File imported successully."); } logImport = loggerDataAccess.LogFileImport(FileName, "IMP_FL_FLD", ValidRecords.ToString(), InValidRecords.ToString(), "IncorrectFileLayout", ImportFileHistoryID); return(FileName + ":- File import Failed."); } catch (Exception ex) { string eFileName; string errorFileName; LoggerDataAccess eloggerDataAccess = new LoggerDataAccess(); eFileName = "OrderError_" + fileName + "_" + DateTime.Now.ToString("MMddyyyyHH"); errorFileName = "OrderFile\\error\\" + eFileName + ".error.txt"; string filePath = SiteConfigurationManager.GetAppSettingKey("TemplatePath") + errorFileName; if (!string.IsNullOrEmpty(fileName)) { //fileName = fileName + SiteConfigurationManager.GetAppSettingKey("FileImportExtension"); var v = FileManager.FileErrorLog(filePath, ex.Message, "Error with File"); eloggerDataAccess.LogFileImport(FileName, "IMP_FL_FLD", ValidRecords.ToString(), InValidRecords.ToString(), errorFileName, ImportFileHistoryID); } return(FileName + ":- File import Failed."); } }
private void TestPrinterFrm_Load(object sender, EventArgs e) { try { string pathReport = @"\\10.88.26.55\Report\RG\Wristband.rpt"; ReportDocument doc = new ReportDocument(); doc.Load(pathReport); doc.SetParameterValue("@tpr_id", 154524); doc.SetParameterValue("@print_user", "TEST01"); doc.SetParameterValue("@mrt_code", "RG120"); SetDBLogonForReport(doc); crystalReportViewer1.ReportSource = doc; var printerQuery = new ManagementObjectSearcher("SELECT * from Win32_Printer"); List <Printer> pt = new List <Printer>(); foreach (var printer in printerQuery.Get()) { pt.Add(new Printer { dis = printer.GetPropertyValue("Name").ToString(), val = printer.GetPropertyValue("Name").ToString() }); } comboAutoDropDownWidth1.DataSource = pt; comboAutoDropDownWidth1.DisplayMember = "dis"; comboAutoDropDownWidth1.ValueMember = "val"; if (System.IO.File.Exists(@"D:\EmrCheckup\PrinterSticker.xml")) { System.Xml.Linq.XDocument xml = System.Xml.Linq.XDocument.Load(@"D:\EmrCheckup\PrinterSticker.xml"); var wb = xml.Element("PrinterCls").Elements("Report").Where(x => x.Attribute("id").Value == "Wristband").FirstOrDefault(); if (wb != null) { string prn = wb.Element("Printer").Value; string pan = wb.Element("Paper").Value; comboAutoDropDownWidth1.SelectedValue = prn; comboAutoDropDownWidth1_SelectionChangeCommitted(null, null); for (int i = 0; i < comboAutoDropDownWidth2.Items.Count; i++) { if (((PrinterPaperSize)comboAutoDropDownWidth2.Items[i]).Name == pan) { comboAutoDropDownWidth2.SelectedValue = ((PrinterPaperSize)comboAutoDropDownWidth2.Items[i]).Kind; } } //for (int i = 0; i < comboAutoDropDownWidth1.Items.Count; i++) //{ // if (comboAutoDropDownWidth1.Items[i].ToString() == wb.Element("Printer").Value) // { // comboAutoDropDownWidth1.SelectedValue = wb.Element("Printer").Value; // for (int j = 0; j < comboAutoDropDownWidth2.Items.Count; j++) // { // if (((PrinterPaperSize)comboAutoDropDownWidth2.Items[j]).Name == wb.Element("Paper").Value) // { // comboAutoDropDownWidth2.SelectedIndex = j; // break; // } // } // break; // } //} } } } catch { } }
static void Main(string[] args) { string pwd1 = null; string pwd2 = null; //pwd1 = Logistika.Service.Common.Encryption.EncryptionManager.BasicEncrypt(User.Password); //pwd2 = Logistika.Service.Common.Encryption.EncryptionManager.Encrypt(User.Password, User.Contact.Email); ////--aHVycnlyMTI = pwd1 = Logistika.Service.Common.Encryption.EncryptionManager.BasicDecrypt("aHVycnlyMTI="); pwd2 = Logistika.Service.Common.Encryption.EncryptionManager.BasicDecrypt("aHVycnkxMg=="); Console.ReadKey(); return; string FileName = null; string rootFolderPath = @"C:\API\Logistika\LogistikaService\Test\Files\ToFiles\"; string destinationPath = @"C:\API\Logistika\LogistikaService\Test\Files\Archive\"; FileName = "USERS_05222018_1.xlsx"; string fullPathToExcel = rootFolderPath + FileName; //ie C:\Temp\YourExcel.xls string fullpathToArchive = destinationPath + FileName; //ie C:\Temp\YourExcel.xls if (new FileInfo(fullpathToArchive).Exists == false) { string connString = string.Format("Provider =Microsoft.ACE.OLEDB.12.0;Data Source=" + fullPathToExcel + ";Extended Properties='Excel 12.0;HDR=yes'", fullPathToExcel); DataTable dt = FileManager.GetDataTable("SELECT * FROM [Sheet1$]", connString); Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture("en-GB"); Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-GB"); var date = DateTime.Now; var type = "user"; IList <Country> PhoneCode = null; if (type == "Order") { if (dt != null) { var distinctOrders = dt.AsEnumerable().Select(c => Convert.ToString(c["VendorOrderID"])).Distinct().ToList <string>(); foreach (var order in distinctOrders) { var orders = dt.AsEnumerable().Where(x => Convert.ToString(x["VendorOrderID"]) == order).ToList(); if (orders != null && orders.Count() > 0) { string pickupLatitude = null; string pickupLongitude = null; string dropoffLatitude = null; string dropoffLongitude = null; var first = orders[0]; //first["PICKUPHOUSE_FLATNO"].ToString() + first["PickupAddress"].ToString() + ", " + first["PICKUPCITY"].ToString() + ", " + first["PICKUPSTATE"].ToString() + " " + first["PICKUPPINCODE"].ToString() + ", " + first["PICKUPCOUNTRY"].ToString(), //AIzaSyB9PgorTUksSwiRCNNTkfEEu1gaHIGG0Rw string Pickupaddress = first["PickupAddress"].ToString() + ", " + first["PICKUPAREA_LOCALITY"].ToString() + ", " + first["PICKUPCITY"].ToString() + ", " + first["PICKUPSTATE"].ToString() + " " + first["PICKUPPINCODE"].ToString() + ", " + first["PICKUPCOUNTRY"].ToString(); string PickuprequestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false?key=AIzaSyB9PgorTUksSwiRCNNTkfEEu1gaHIGG0Rw", Uri.EscapeDataString(Pickupaddress)); WebRequest request = WebRequest.Create(PickuprequestUri); WebResponse response = request.GetResponse(); System.Xml.Linq.XDocument xdoc = XDocument.Load(response.GetResponseStream()); XElement result = xdoc.Element("GeocodeResponse").Element("result"); if (result != null) { XElement locationElement = result.Element("geometry").Element("location"); XElement pickuplat = locationElement.Element("lat"); XElement pickuplng = locationElement.Element("lng"); pickupLatitude = pickuplat.Value; pickupLongitude = pickuplng.Value; } string DropOffaddress = first["DROPOFFADDRESS"].ToString() + ", " + first["DROPOFFAREA_LOCALITY"].ToString() + ", " + first["DROPOFFCITY"].ToString() + ", " + first["DROPOFFSTATE"].ToString() + " " + first["DROPOFFPINCODE"].ToString() + ", " + first["DROPOFFCOUNTRY"].ToString(); string DropoffrequestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false", Uri.EscapeDataString(DropOffaddress)); WebRequest requestD = WebRequest.Create(DropoffrequestUri); WebResponse responseD = requestD.GetResponse(); System.Xml.Linq.XDocument xdocD = XDocument.Load(responseD.GetResponseStream()); XElement resultD = xdocD.Element("GeocodeResponse").Element("result"); if (resultD != null) { XElement locationElementD = resultD.Element("geometry").Element("location"); XElement dropOfflat = locationElementD.Element("lat"); XElement dropOfflng = locationElementD.Element("lng"); dropoffLatitude = dropOfflat.Value; dropoffLongitude = dropOfflng.Value; } LogistikaOrderHeader tOrder = new LogistikaOrderHeader { //ClientOrderSource = "FileImport_" + first["ServiceCode"].ToString(), CallType = "Portal", ClientOrderSource = "FileImport_" + Convert.ToString(System.DateTime.Now), ServiceCode = first["ServiceCode"].ToString(), OrderType = first["OrderType"].ToString(), FreightType = first["FreightType"].ToString(), OrderByName = first["OrderByName"].ToString(), OrderByPhoneNumber = first["OrderByPhoneNumber"].ToString(), OrderByEmail = first["OrderByEmail"].ToString(), PickUpDate = Convert.ToDateTime(first["PickUpDate"].ToString()), VendorOrderID = first["VendorOrderID"].ToString(), Payment = new Payment { Amount = Convert.ToDouble(first["CHARGEDAMOUNT"].ToString()), PaymentMethod = first["PAYMENTMODE"].ToString() }, PickupAddress = new List <Address> { new Address() { AddressLine1 = first["PickupAddress"].ToString(), Suite = first["PICKUPHOUSE_FLATNO"].ToString(), Locality = first["PICKUPAREA_LOCALITY"].ToString(), City = first["PICKUPCITY"].ToString(), StateCode = first["PICKUPSTATE"].ToString(), PostalCode = first["PICKUPPINCODE"].ToString(), CountryCode = first["PICKUPCOUNTRY"].ToString(), LandMark = first["PICKUPLANDMARK"].ToString(), Instruction = first["PICKUPINSTRUCTION"].ToString(), Latitude = pickupLatitude, Longitude = pickupLongitude } }, DropoffAddress = new List <Address> { new Address() { AddressLine1 = first["DROPOFFADDRESS"].ToString(), Suite = first["DROPOFFHOUSE_FLATNO"].ToString(), Locality = first["DROPOFFAREA_LOCALITY"].ToString(), City = first["DROPOFFCITY"].ToString(), StateCode = first["DROPOFFSTATE"].ToString(), PostalCode = first["DROPOFFPINCODE"].ToString(), CountryCode = first["DROPOFFCOUNTRY"].ToString(), LandMark = first["DROPOFFLANDMARK"].ToString(), Instruction = first["DROPOFFINSTRUCTION"].ToString(), DropOffDate = Convert.ToDateTime(first["DropOffDate"].ToString()), Name = first["DROPOFFNAME"].ToString(), PhoneNumber = first["DROPOFFPHONE"].ToString(), Latitude = dropoffLatitude, Longitude = dropoffLongitude } } }; tOrder.LineItem = orders.Select(s => new LogistikaOrderLineItem { Item = s["ITEM"].ToString(), //ItemType_FK = Convert.ToInt32(s["ItemType_FK"].ToString()), ShipmentType = s["ShipmentType"].ToString(), GoodsType = s["GOODSTYPE"].ToString(), UOM = s["UOM"].ToString(), Quantity = Convert.ToInt32(s["NOOFITEMS"].ToString()), Weight = Convert.ToDouble(s["WEIGHT"].ToString()), Length = Convert.ToDouble(s["Length"].ToString()), Width = Convert.ToDouble(s["Width"].ToString()), Height = Convert.ToDouble(s["Height"].ToString()), IsPackagingRequiredFlag = Convert.ToBoolean(s["ISPACKAGINGREQUIRED?"].ToString()), IsPermitVerifiedFlag = Convert.ToBoolean(s["ISPERMITVERIFIED?"].ToString()) }).ToList(); var service = new OrderBusinessComponent(new Logistika.Service.Common.DataAccess.Config.OrderDataAccess()); service.createOrder(tOrder); } } } } if (type == "user") { for (int i = 0; i < dt.Rows.Count; i++) { LogistikaUser User = new LogistikaUser() { BranchId = dt.Rows[i]["BranchId"].ToString(), FirstName = dt.Rows[i]["FirstName"].ToString(), MiddleName = dt.Rows[i]["MiddleName"].ToString(), LastName = dt.Rows[i]["LastName"].ToString(), DateOfBirth = Convert.ToDateTime(dt.Rows[i]["DateOfBirth"].ToString()), Designation = dt.Rows[i]["EmployeeRole"].ToString(), JobTitle = dt.Rows[i]["EmployeeTitle"].ToString(), Contact = new Contact() { Email = dt.Rows[i]["PrimaryEmail"].ToString(), Phone = dt.Rows[i]["Phone"].ToString(), Mobile = dt.Rows[i]["MobileNo"].ToString(), }, Password = dt.Rows[i]["Password"].ToString(), Gender = dt.Rows[i]["Gender"].ToString(), OtherInfo = new List <DropdownData> { new DropdownData() { Text = "LicenseNumber", Value = dt.Rows[i]["LicenseNumber"].ToString(), }, new DropdownData() { Text = "LicenceClass", Value = dt.Rows[i]["LicenceClass"].ToString(), }, new DropdownData() { Text = "Experience", Value = dt.Rows[i]["Experience"].ToString(), }, new DropdownData() { Text = "MonthlyWage", Value = dt.Rows[i]["MonthlyWage"].ToString(), } }, StartDate = Convert.ToDateTime(dt.Rows[i]["StartDate"].ToString()), EndDate = Convert.ToDateTime(dt.Rows[i]["EndDate"].ToString()), Active = Convert.ToBoolean(dt.Rows[i]["IsActive"].ToString()), Addresses = new List <Address> { new Address() { AddressLine1 = dt.Rows[i]["AddressLine1"].ToString(), Suite = dt.Rows[i]["SuiteNo"].ToString(), //Locality = dt.Rows[i]["Locality"].ToString(), City = dt.Rows[i]["City"].ToString(), StateCode = dt.Rows[i]["State"].ToString(), PostalCode = dt.Rows[i]["PinCode"].ToString(), CountryCode = dt.Rows[i]["CountryCode"].ToString(), LandMark = dt.Rows[i]["LandMark"].ToString() } } }; var Pservice = new UserBusinessComponent(new UserDataAccess()); PhoneCode = Pservice.GetCountryInfo(dt.Rows[i]["CountryCode"].ToString()); //PhoneCode = _userDataAccess.GetCountryInfo(dt.Rows[i]["CountryCode"].ToString()); if (User.Contact.Mobile.StartsWith("0")) { User.Contact.Mobile = User.Contact.Mobile.TrimStart('0'); User.Contact.Mobile = PhoneCode[0].PhoneCode + User.Contact.Mobile; } else if (!User.Contact.Mobile.StartsWith("0")) { User.Contact.Mobile = PhoneCode[0].PhoneCode + User.Contact.Mobile; } if (User.Contact.Phone.StartsWith("0")) { User.Contact.Phone = User.Contact.Phone.TrimStart('0'); User.Contact.Phone = PhoneCode[0].PhoneCode + User.Contact.Phone; } else if (!User.Contact.Phone.StartsWith("0")) { User.Contact.Phone = PhoneCode[0].PhoneCode + User.Contact.Phone; } var service = new UserBusinessComponent(new UserDataAccess()); service.SaveUser(User, null); } } if (type == "fleet") { for (int i = 0; i < dt.Rows.Count; i++) { Fleet Fleet = new Fleet() { FleetID = dt.Rows[i]["FleetID"].ToString(), Make = dt.Rows[i]["Make"].ToString(), Model = dt.Rows[i]["Model"].ToString(), ModelYear = Convert.ToInt32(dt.Rows[i]["ModelYear"].ToString()), Colour = dt.Rows[i]["Colour"].ToString(), StartingMileage = Convert.ToInt32(dt.Rows[i]["StartingMileage"].ToString()), Payload = dt.Rows[i]["Payload"].ToString(), OwnerShipType = dt.Rows[i]["OwnerShipType"].ToString(), OverallLength = dt.Rows[i]["OverallLength"].ToString(), OverallWidth = dt.Rows[i]["OverallWidth"].ToString(), OverallHeight = dt.Rows[i]["OverallHeight"].ToString(), IsActive = Convert.ToBoolean(dt.Rows[i]["IsActive"].ToString()) }; var service = new UserBusinessComponent(new UserDataAccess()); service.SaveFleet(Fleet, null, "File"); } } //Console.ReadLine(); string[] fileList = Directory.GetFiles(rootFolderPath, "*.xlsx"); if (Directory.Exists(rootFolderPath)) { foreach (string file in fileList) { FileInfo mFile = new FileInfo(file); if (new FileInfo(destinationPath + "\\" + mFile.Name).Exists == false) { mFile.MoveTo(destinationPath + "\\" + mFile.Name); } } } } }
private List <string> UpdateShortCutXML(string sysConfigText) { List <string> returnAttachments = new List <string>(); if (string.IsNullOrWhiteSpace(sysConfigText)) { return(returnAttachments); } System.Xml.Linq.XDocument sysConfigDoc = System.Xml.Linq.XDocument.Parse(sysConfigText, LoadOptions.PreserveWhitespace); sysConfigDoc.Declaration = new XDeclaration("1.0", "utf-8", null); // Find the <Shortcut> Node so we can update its values XElement shortcutNode = sysConfigDoc.Descendants("Shortcut").FirstOrDefault(); if (shortcutNode == null) // Create the node if missing { if (sysConfigDoc.Element("configuration") == null) { sysConfigDoc.Add(new XElement("configuration")); } sysConfigDoc.Element("configuration").Add(new XElement("Shortcut")); shortcutNode = sysConfigDoc.Element("configuration").Element("Shortcut"); } shortcutNode.SetElementValue("Company", ((Session)oTrans.Session).CompanyID); shortcutNode.SetElementValue("Plant", ((Session)oTrans.Session).PlantID); shortcutNode.SetElementValue("AppServerURL", ((Session)oTrans.Session).AppServer); shortcutNode.SetElementValue("DateTime", DateTime.Now.ToString()); shortcutNode.SetElementValue("Originator", ((Session)oTrans.Session).UserID); // Set the <Process> child nodes XElement processNode = shortcutNode.Element("Process"); if (processNode == null) { shortcutNode.Add(new XElement("Process")); processNode = shortcutNode.Element("Process"); } processNode.SetElementValue("ProcessID", "ITAR001"); // MenuID is normally stored in XXXDef.SysCharacter01 processNode.SetElementValue("Description", "UD01 Notify"); // Set the RecordIDS node and its child elements XElement recordIDsElement = shortcutNode.Element("RecordIDS"); if (recordIDsElement == null) { shortcutNode.Add(new XElement("RecordIDS")); recordIDsElement = shortcutNode.Element("RecordIDS"); } var keyFieldsValues = GetKeyValues(); var keyFieldTypes = GetKeyTpes(); var keyFields = GetKeyFields(); recordIDsElement.SetAttributeValue("KeyFields", keyFields); recordIDsElement.SetAttributeValue("KeyFieldsType", "System.String"); recordIDsElement.SetAttributeValue("TableName", "UD001List"); recordIDsElement.SetAttributeValue("DataSourceType", "UD01ListDataSet"); recordIDsElement.SetElementValue("RecordID", keyFieldsValues); StringBuilder sb = new StringBuilder(); //StringWriter swriter = new StringWriter(sb); using (StringWriter writer = new Utf8StringWriter(sb)) { sysConfigDoc.Save(writer); } returnAttachments.Add(sb.ToString()); return(returnAttachments); }
public void SaveDepot(Depot _D) { if (!File.Exists(DepotStorage)) { XmlWriterSettings xmlWriterSettings = new XmlWriterSettings(); xmlWriterSettings.Indent = true; xmlWriterSettings.NewLineOnAttributes = true; using (XmlWriter xmlWriter = XmlWriter.Create(DepotStorage, xmlWriterSettings)) { xmlWriter.WriteStartDocument(); xmlWriter.WriteStartElement("Depots"); xmlWriter.WriteStartElement("Depot"); xmlWriter.WriteElementString("DID", _D.ID); xmlWriter.WriteElementString("Owner", _D.Owner.ID); xmlWriter.WriteStartElement("Stocks"); foreach (KeyValuePair <Stock, uint> _s in _D.Stocks) { xmlWriter.WriteStartElement("Stock"); xmlWriter.WriteAttributeString("SID", _s.Key.ID); xmlWriter.WriteAttributeString("Amount", _s.Value.ToString()); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); xmlWriter.WriteStartElement("IssuedOrders"); foreach (Order _o in _D.IssuedOrders) { xmlWriter.WriteStartElement("IssuedOrder"); xmlWriter.WriteAttributeString("OID", _o.id); xmlWriter.WriteAttributeString("BoerseID", _o.idBoerse); xmlWriter.WriteAttributeString("Type", _o.type); xmlWriter.WriteAttributeString("Amount", _o.amount.ToString()); xmlWriter.WriteEndElement(); } xmlWriter.WriteEndElement(); xmlWriter.WriteElementString("TimeStamp", DateTimeOffset.Now.ToUnixTimeMilliseconds().ToString()); xmlWriter.WriteElementString("Worth", _D.Worth.ToString()); xmlWriter.WriteEndElement(); xmlWriter.WriteEndElement(); xmlWriter.WriteEndDocument(); xmlWriter.Flush(); xmlWriter.Close(); } } else { System.Xml.Linq.XDocument xDocument = XDocument.Load(DepotStorage); XElement root = xDocument.Element("Depots"); IEnumerable <XElement> rows = root.Descendants("Depot"); IEnumerable <XElement> stockrows = rows.Descendants("Stocks"); XElement firstRow = rows.First(); //firstRow.AddBeforeSelf( // new XElement("Depot", // new XElement("DID", _D.ID), // new XElement("Owner", _D.Owner.ID), // new XElement("Stocks", // _D.Stocks.Select( stock => new XElement("kjasddkljsdafkj", stock.Key.ID) ), // _D.Stocks.Select(stock => new XAttribute("Amount", stock.Value.ToString()))), // new XElement("TimeStamp", DateTimeOffset.Now.ToUnixTimeMilliseconds().ToString()))); firstRow.AddBeforeSelf( new XElement("Depot", new XElement("DID", _D.ID), new XElement("Owner", _D.Owner.ID), new XElement("Stocks", _D.Stocks.Select(stock => new XElement("Stock", new XAttribute("SID", stock.Key.ID), new XAttribute("Amount", stock.Value.ToString())))), new XElement("IssuedOrders", _D.IssuedOrders.Select(order => new XElement("IssuedOrder", new XAttribute("OID", order.id), new XAttribute("BoerseID", order.idBoerse), new XAttribute("Type", order.type), new XAttribute("Amount", order.amount)))), new XElement("TimeStamp", DateTimeOffset.Now.ToUnixTimeMilliseconds().ToString()), new XElement("Worth", _D.Worth.ToString()))); xDocument.Save(DepotStorage); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack && !Page.IsPostBack) { if (this.UserSettings == null || this.TabId == null) { throw new Exception("Find Invite Control missing parameters"); } if (this.IsInviteOnly) { panelManualSearch.Visible = false; atiFoundPanel.Visible = true; // ScriptManager.RegisterStartupScript(this, Page.GetType(), "ContactInviteList", "$(function(){ Aqufit.Page.atiContactInviteScript.generateStreamDom('{}'); });", true); } if (this.IsInviteOnly && this.GroupSettings != null) { atiContactInviteScript.UserSettings = this.GroupSettings; atiFoundFriendListScript.ControlMode = DesktopModules_ATI_Base_controls_ATI_FriendListScript.Mode.GROUP_INVITE; } else { atiContactInviteScript.UserSettings = this.UserSettings; atiFoundFriendListScript.ControlMode = DesktopModules_ATI_Base_controls_ATI_FriendListScript.Mode.FRIEND_REQUEST; } if (Request[Parameters.OAuth_Token] != null && Request[Parameters.OAuth_Verifier] != null && Context.Items["s"] != null) { this.IsOAuthPostback = true; string serviceType = ((string)Context.Items["s"]).ToLower(); string returnUri = string.Empty; if (this.IsInviteOnly && this.GroupSettings != null) { atiContactInviteScript.UserSettings = this.GroupSettings; returnUri = "http://" + Request.Url.Host + ResolveUrl("~/") + TabId + "/" + GroupSettings.UserName + "/" + serviceType + "/contacts"; } else { atiContactInviteScript.UserSettings = this.UserSettings; returnUri = "http://" + Request.Url.Host + ResolveUrl("~/") + TabId + "/" + UserSettings.UserName + "/" + serviceType + "/contacts"; } IOAuthSession oauthSession = OAuthSessionFactory.createSession(serviceType, returnUri); string requestTokenString = Request[Parameters.OAuth_Token]; string verifier = Request[Parameters.OAuth_Verifier]; IToken requestToken = (IToken)Session[requestTokenString]; IToken accessToken; try { accessToken = oauthSession.ExchangeRequestTokenForAccessToken(requestToken, verifier); oauthSession.AccessToken = accessToken; Session[requestTokenString] = null; Session[accessToken.Token] = accessToken; //Response.Write(test); ContactSearchResults(oauthSession.GetContactsEmails()); } catch (OAuthException authEx) { Session["problem"] = authEx.Report; Response.Write(authEx.Message + "<br/><br/>" + authEx.StackTrace); return; } } else if (Request["ConsentToken"] != null) // We have a windows live login ( OMFG I wish they had OAuth sorted out like the rest of the world ) { string ConsentToken = Request["ConsentToken"]; System.Collections.Specialized.NameValueCollection consent = HttpUtility.ParseQueryString(HttpUtility.UrlDecode(ConsentToken)); string uri = "https://livecontacts.services.live.com/@L@" + consent["lid"] + "/rest/LiveContacts/Contacts/"; //string uri2 = "https://livecontacts.services.live.com/users/@L@" + consent["lid"] + "/rest/livecontacts"; System.Net.WebRequest request = System.Net.HttpWebRequest.Create(uri); request.Method = "GET"; request.Headers.Add("UserAgent", "Windows Live Data Interactive SDK"); request.ContentType = "application/xml; charset=utf-8"; request.Headers.Add("Authorization", "DelegatedToken dt=\"" + consent["delt"] + "\""); request.Headers["Cookie"] = Response.Headers["Set-Cookie"]; System.Net.WebResponse response = request.GetResponse(); System.IO.Stream responseStream = response.GetResponseStream(); System.IO.StreamReader streamReader = new System.IO.StreamReader(responseStream); string resString = streamReader.ReadToEnd(); System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Parse(resString); //<Contacts> // <Contact><ID>b41c2cec-e5c7-426c-b8e6-0043e7cdaeb0</ID> // <Profiles><Personal><FirstName>Krista</FirstName><LastName>Greeves</LastName><UniqueName>bluegirl</UniqueName><SortName>Greeves,Krista</SortName><DisplayName>bluegirl</DisplayName></Personal></Profiles> // <Emails> // <Email><ID>1</ID><EmailType>Personal</EmailType><Address>[email protected]</Address><IsIMEnabled>false</IsIMEnabled><IsDefault>true</IsDefault></Email> // </Emails></Contact> // Affine.Data.json.Contact[] contactList = doc.Element("Contacts").Descendants("Email").Select(c => new Affine.Data.json.Contact() { Email = c.Element("Address").Value }).OrderBy(c => c.Email).ToArray(); // We need to find all the contacts that are in the system now. //ContactSearchResults(contactList); ContactSearchResults(doc.Element("Contacts").Descendants("Email").Select(c => c.Element("Address").Value).ToArray()); } SetupOauth(); } }
private void QueryComplete(string s) { System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Parse(s); address = doc.Element("GeocodeResponse").Element("result").Element("formatted_address").Value; UpdateText(); }