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