public ActionResult SearchOutlet(string city) { // List<String> outletPhone= new List<String>(); String outletPhone = null; System.Collections.Generic.IEnumerable <System.Xml.Linq.XElement> stores; System.Xml.Linq.XDocument xmlDoc = System.Xml.Linq.XDocument.Load(System.Web.HttpContext.Current.Server.MapPath("~/Outlets/Outlets.xml")); stores = from o in xmlDoc.Descendants("City") select o; Boolean flag = false; foreach (var entry in stores) { string tempCity = entry.Element("Name").Value; if (string.Equals(tempCity, city, StringComparison.OrdinalIgnoreCase) == true) { flag = true; outletPhone = "Call: " + entry.Element("Phone").Value; break; } } if (flag == false) { outletPhone = "Sorry! No phone number of our outlet found in your city. Call the Pizzeria toll free number 555-0100."; } return(Content(outletPhone)); }
public ActionResult MovieRatings() { System.Xml.Linq.XDocument xmlDoc = System.Xml.Linq.XDocument.Load(System.Web.HttpContext.Current.Server.MapPath("~/MovieRatings/MovieRating.xml")); var movies = from m in xmlDoc.Descendants("Movie") select m; string strResponse = "<table style='width:100%; padding:30px;'>"; foreach (var mov in movies) { strResponse += getRow("Movie Name", mov.Element("Name").Value); strResponse += getRow("Director", mov.Element("Director").Value); strResponse += getRow("Producer", mov.Element("Producer").Value); strResponse += getRow("Cast", mov.Element("Cast").Value); string rating = ""; for (int i = 0; i < Convert.ToInt32(mov.Element("Rating").Value); i++) { //rating += "<img src=\"" + System.Web.HttpContext.Current.Server.MapPath("~/Images/Star.png") + "\" style='height:20px; width:20px;'/>"; rating += "<img src='../../Images/Star.png' style='height:20px; width:20px;'/>"; } strResponse += getRow("Rating", rating); //to insert blank row after each movie rating record strResponse += getRow("<br/>", "<br/>"); } strResponse += "</table>"; ViewBag.movieRatings = strResponse; return(View()); }
public decimal getDiscountedPrice(String promoCode, decimal price) { decimal discountedPrice = 0.0M; System.Collections.Generic.IEnumerable <System.Xml.Linq.XElement> discounts; System.Xml.Linq.XDocument xmlDoc = System.Xml.Linq.XDocument.Load(System.Web.HttpContext.Current.Server.MapPath("~/PromoCode/PromoCode.xml")); discounts = from c in xmlDoc.Descendants("Discount") select c; Boolean flag = false; foreach (var entry in discounts) { string code = entry.Element("PromoCode").Value; if (string.Equals(code, promoCode, StringComparison.OrdinalIgnoreCase) == true) { decimal discount = Convert.ToDecimal(entry.Element("DiscountPercentage").Value) / 100; discountedPrice = price - (price * discount); flag = true; break; } } if (flag == false) { discountedPrice = price; } return(discountedPrice); }
public static async System.Threading.Tasks.Task <IQueryable <IndicativeExchangeRates.Model.Currency> > GetData() { string responseBody = string.Empty; using (System.Net.Http.HttpResponseMessage response = await ServiceClient.GetHttpResponse()) { if (response.IsSuccessStatusCode) { using (System.Net.Http.HttpContent content = response.Content) { responseBody = await content.ReadAsStringAsync(); } } else { Log.Logger.Instance.Error(new Exception($"UserName:{Authentication.AuthService.UserName} - Exchange rate data is not available. Response is {response.StatusCode.ToString()}")); throw new Exception("No data available!"); } } if (responseBody.EndsWith(@"</Tarih_Date")) { responseBody = responseBody.Replace("</Tarih_Date", "</Tarih_Date>"); } System.Xml.Linq.XDocument document = System.Xml.Linq.XDocument.Parse(responseBody); var resultSet = (from result in document.Descendants("Currency") .Where(result => result.Descendants("Isim").Any()) .Where(result => result.Descendants("CurrencyName").Any()) .Where(result => result.LastAttribute != null) .Where(result => result.Descendants("ForexBuying").Any()) .Where(result => result.Descendants("ForexSelling").Any()) .Where(result => result.Descendants("BanknoteBuying").Any()) .Where(result => result.Descendants("BanknoteSelling").Any()) select new IndicativeExchangeRates.Model.Currency { Tarih = document.Root.Attribute("Tarih").Value.Trim(), Date = document.Root.Attribute("Date").Value.Trim(), Bulten_No = document.Root.Attribute("Bulten_No").Value.Trim(), CrossOrder = result.Attribute("CrossOrder").Value.Trim(), Kod = result.Attribute("Kod").Value.Trim(), CurrencyCode = result.Attribute("CurrencyCode").Value.Trim(), Unit = Convert.ToByte(result.Element("Unit").Value.Trim()), Isim = result.Element("Isim").Value.Trim(), CurrencyName = result.Element("CurrencyName").Value.Trim(), ForexBuying = (!string.IsNullOrWhiteSpace(result.Element("ForexBuying").Value.Trim()) ? Convert.ToDecimal(result.Element("ForexBuying").Value.Trim()) : default(decimal?)), ForexSelling = (!string.IsNullOrWhiteSpace(result.Element("ForexSelling").Value.Trim()) ? Convert.ToDecimal(result.Element("ForexSelling").Value.Trim()) : default(decimal?)), BanknoteBuying = (!string.IsNullOrWhiteSpace(result.Element("BanknoteBuying").Value.Trim()) ? Convert.ToDecimal(result.Element("BanknoteBuying").Value.Trim()) : default(decimal?)), BanknoteSelling = (!string.IsNullOrWhiteSpace(result.Element("BanknoteSelling").Value.Trim()) ? Convert.ToDecimal(result.Element("BanknoteSelling").Value.Trim()) : default(decimal?)), CrossRateUSD = (!string.IsNullOrWhiteSpace(result.Element("CrossRateUSD").Value.Trim()) ? Convert.ToDecimal(result.Element("CrossRateUSD").Value.Trim()) : default(decimal?)), CrossRateOther = (!string.IsNullOrWhiteSpace(result.Element("CrossRateOther").Value.Trim()) ? Convert.ToDecimal(result.Element("CrossRateOther").Value.Trim()) : default(decimal?)) }).AsQueryable(); return(resultSet); }
public decimal GetRate(string code) { string url = string.Empty; var date = DateTime.Now; if (date.Date == DateTime.Today) { url = "http://www.tcmb.gov.tr/kurlar/today.xml"; } else { url = string.Format("http://www.tcmb.gov.tr/kurlar/{0}{1}/{2}{1}{0}.xml", date.Year, addZero(date.Month), addZero(date.Day)); } System.Xml.Linq.XDocument document = System.Xml.Linq.XDocument.Load(url); Dictionary <string, string> dic = new Dictionary <string, string>(); var result = document.Descendants("Currency") .Where(v => v.Element("ForexBuying") != null && v.Element("ForexBuying").Value.Length > 0) .Select(v => new Currency { Code = v.Attribute("Kod").Value, Rate = decimal.Parse(v.Element("ForexBuying").Value) }).ToList(); return(result.FirstOrDefault(s => s.Code == code).Rate); }
public static List <SceneUnderstandingObjects.Element> ParseObjXml(string xml) { System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Load(xml); var queriedData = doc.Descendants("Element").Select(i => new SceneUnderstandingObjects.Element() { tag = i.Element("tag").Value, id = System.Convert.ToInt32(i.Element("id").Value), objfilename = i.Element("objfilename").Value, cldfilename = i.Element("cldfilename").Value, position = i.Descendants("position").Select(j => new Vector3() { x = (float)j.Element("x"), y = (float)j.Element("y"), z = (float)j.Element("z") }).ToList(), forward = i.Elements("forward").Select(j => new Vector3() { x = (float)j.Element("x"), y = (float)j.Element("y"), z = (float)j.Element("z") }).FirstOrDefault(), bBoxMinPoint = i.Elements("bBoxMinPoint").Select(j => new Vector3() { x = (float)j.Element("x"), y = (float)j.Element("y"), z = (float)j.Element("z") }).FirstOrDefault(), bBoxMaxPoint = i.Elements("bBoxMaxPoint").Select(j => new Vector3() { x = (float)j.Element("x"), y = (float)j.Element("y"), z = (float)j.Element("z") }).FirstOrDefault() }).ToList(); return(queriedData); }
private static void AddValueToHtForSingleNode(System.Xml.Linq.XDocument xDoc, System.Xml.Linq.XNamespace msbuild, string element) { var des = xDoc.Descendants(msbuild + element).FirstOrDefault(); if (des != null) { htCheck.Add(element, string.IsNullOrEmpty(des.Value) ? null : des.Value); } }
//http://msdn.microsoft.com/en-us/library/dn189154.aspx public static void UpdatePlayReadyConfigurationXMLFile(Guid keyId, string contentKeyB64) { System.Xml.Linq.XNamespace xmlns = "http://schemas.microsoft.com/iis/media/v4/TM/TaskDefinition#"; string keyDeliveryServiceUriStr = "http://playready.directtaps.net/pr/svc/rightsmanager.asmx"; Uri keyDeliveryServiceUri = new Uri(keyDeliveryServiceUriStr); string xmlFileName = Path.Combine(Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location) + @"\..\..", @"MediaEncryptor_PlayReadyProtection.xml"); // Prepare the encryption task template System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Load(xmlFileName); var licenseAcquisitionUrlEl = doc .Descendants(xmlns + "property") .Where(p => p.Attribute("name").Value == "licenseAcquisitionUrl") .FirstOrDefault(); var contentKeyEl = doc .Descendants(xmlns + "property") .Where(p => p.Attribute("name").Value == "contentKey") .FirstOrDefault(); var keyIdEl = doc .Descendants(xmlns + "property") .Where(p => p.Attribute("name").Value == "keyId") .FirstOrDefault(); // Update the "value" property for each element. if (licenseAcquisitionUrlEl != null) { licenseAcquisitionUrlEl.Attribute("value").SetValue(keyDeliveryServiceUri); } if (contentKeyEl != null) { contentKeyEl.Attribute("value").SetValue(contentKeyB64); } if (keyIdEl != null) { keyIdEl.Attribute("value").SetValue(keyId); } doc.Save(xmlFileName); }
public (string asin, int price) GetAmazonUsingAPI(string toyName) { try { var keyword = toyName.Replace(" ", " "); var helper = new Helper.SignedRequestHelper(MY_AWS_ACCESS_KEY_ID, MY_AWS_SECRET_KEY, DESTINATION, ASSOCIATE_TAG); IDictionary <string, string> request = new Dictionary <string, String> { ["Service"] = "AWSECommerceService", ["Operation"] = "ItemSearch", ["SearchIndex"] = "All", ["ResponseGroup"] = "Medium", ["Keywords"] = keyword }; var requestUrl = helper.Sign(request); System.Xml.Linq.XDocument xml = System.Xml.Linq.XDocument.Load(requestUrl); System.Xml.Linq.XNamespace ns = xml.Root.Name.Namespace; var errorMessageNodes = xml.Descendants(ns + "Message").ToList(); if (errorMessageNodes.Any()) { var message = errorMessageNodes[0].Value; return(null, 0); } var item = xml.Descendants(ns + "Item").FirstOrDefault(); var asin = item?.Descendants(ns + "ASIN").FirstOrDefault()?.Value; var offerSummary = item?.Descendants(ns + "OfferSummary").FirstOrDefault(); var price = offerSummary?.Descendants(ns + "LowestNewPrice").FirstOrDefault()?.Descendants(ns + "Amount").FirstOrDefault()?.Value; return(asin, price != null ? Convert.ToInt32(price) : 0); } catch (Exception) { throw; } finally { Task.Delay(Delay).Wait(); } }
public string GetDataFromXml(string value, string attributeName) { if (string.IsNullOrEmpty(value)) { return(string.Empty); } System.Xml.Linq.XDocument document = System.Xml.Linq.XDocument.Parse(value); // get the Element with the attribute name specified System.Xml.Linq.XElement element = document.Descendants().Where(ele => ele.Attributes().Any(attr => attr.Name == attributeName)).FirstOrDefault(); return(element == null ? string.Empty : element.Value); }
public static Book GetBook(string repo_path) { System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Load(repo_path); var bks = from books in doc.Descendants("book") select new Book { Folder = (string)books.Attribute("folder"), Pages = (from pages in doc.Descendants("page") select new Page { Src = String.Format( "{0}/{1}", (string)books.Attribute("folder"), (string)pages.Attribute("src") ) }).ToList() }; return(bks.ToList().First()); }
public StateMachine(System.Xml.Linq.XDocument document) { BeginState = document.Root.Attribute("beginState").Value; string endState = document.Root.Attribute("endState").Value; EndStates.Add(endState); States = new List <State>(); //States = (from x in document.Descendants("State") // select new State() { Name = x.Attribute("name").Value, Display = x.Attribute("display").Value }).ToList(); foreach (var x in document.Descendants("State")) { var state = new State() { Name = x.Attribute("name").Value, Display = x.Attribute("display").Value }; var isnav = x.Attribute("isNavigate"); if (isnav != null && Boolean.TryParse(isnav.Value, out bool isNav)) { state.IsNavigate = isNav; var order = x.Attribute("order"); if (order != null && Int32.TryParse(order.Value, out int i)) { state.SortOrder = i; } } States.Add(state); } Transitions = (from x in document.Descendants("Transition") select new Transition() { Name = x.Attribute("name").Value, OriginState = x.Attribute("origin").Value, DestinationState = x.Attribute("destination").Value, SortOrder = Convert.ToInt32(x.Attribute("order").Value) }).ToList(); }
public ActionResult Index() { var pizzas = GetItems(12); System.Collections.Generic.IEnumerable <System.Xml.Linq.XElement> discounts; System.Xml.Linq.XDocument xmlDoc = System.Xml.Linq.XDocument.Load(System.Web.HttpContext.Current.Server.MapPath("~/PromoCode/PromoCode.xml")); discounts = from c in xmlDoc.Descendants("Discount") select c; foreach (var entry in discounts) { @ViewBag.Code = entry.Element("PromoCode").Value; @ViewBag.Discount = entry.Element("DiscountPercentage").Value; } return(View(pizzas)); }
public async Task <ActionResult <string> > GetStockAsync() { try { string result = await _stockClient.GetStringAsync(_stockProviderUrl); //convert to XML to extract the stock value System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Parse(result.Trim('\"')); var price = doc.Descendants("LastPrice").FirstOrDefault(); return(price.Value); } catch (Exception e) { return(e.ToString()); } }
public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Conductor updateConductor = Conductor.GetConductorFromNode(element); System.Xml.Linq.XElement conductorNode = element.Element(Constants.Conductor.conductorElement); if (conductorNode == null) { continue; } object newValue = conductorNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateConductor, newValue, columnName); } }
/// <summary> /// Updates the existing database Instrument on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Artist.artistElement); foreach (System.Xml.Linq.XElement element in eventElements) { Instrument updateInstrument = Instrument.GetInstrumentFromNode(element); if (updateInstrument == null) { continue; } object newValue = element.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateInstrument, newValue, columnName); } }
public ActionResult ImportEmployees(string tbFilePath) { string strResponse; strResponse = "<font style='font-size:18pt;'><b>Entered employees are .... </b><br><br><br></font>"; if (!string.IsNullOrEmpty(tbFilePath)) { try { System.Xml.Linq.XDocument xmlDoc = System.Xml.Linq.XDocument.Load(tbFilePath); var emps = from e in xmlDoc.Descendants("Employee") select e; foreach (var emp in emps) { Employee.Models.Employee newEmployee = new Employee.Models.Employee(); newEmployee.Employee_Name = emp.Element("Name").Value; newEmployee.EmployeeManagerID = Convert.ToInt32(emp.Element("Manager").Value); newEmployee.Salary = Convert.ToInt32(emp.Element("Salary").Value); db.Employees.Add(newEmployee); db.SaveChanges(); } strResponse = "<font style='font-size:18pt;'><b>Employee name added successfully in the database.</b><br><br><br></font>"; } catch (System.Exception exx) { Console.WriteLine(exx.Message); strResponse = exx.Message; strResponse = exx.Source + " " + exx.StackTrace; // strResponse = exx.StackTrace; // strResponse = "<font style='font-size:18pt;color:red;'><b>Invalid file path.</b><br><br><br></font>"; } } else { strResponse = "<font style='font-size:18pt;color:red;'><b>Please specify a valid file path.</b><br><br><br></font>"; } ViewBag.response = strResponse; return(View()); }
public ImportResult Import(System.IO.Stream fileStream) { string contentXml = GetContentXml(fileStream); ImportResult result = new ImportResult(); System.Xml.Linq.XDocument doc = System.Xml.Linq.XDocument.Parse(contentXml); System.Collections.Generic.IEnumerable <System.Xml.Linq.XElement> rows = doc.Descendants("{urn:oasis:names:tc:opendocument:xmlns:table:1.0}table-row").Skip(1); foreach (System.Xml.Linq.XElement row in rows) { ImportRow(row, result); //, companyId, year, result); } return(result); }
public static List <ProductDetail> GetProductDetailsData() { string path = AppDomain.CurrentDomain.GetData("DataDirectory").ToString() + "\\Configuration\\ProductsDetail.xml"; if (System.IO.File.Exists(path)) { System.Xml.Linq.XDocument xdoc = System.Xml.Linq.XDocument.Load(path); return((from lv1 in xdoc.Descendants("Product") select new ProductDetail() { productcode = lv1.Descendants("ProductCode").FirstOrDefault().Value.Replace(" ", ""), CertName = lv1.Descendants("ProductName").FirstOrDefault().Value.Replace(" ", ""), URL = lv1.Descendants("URL").FirstOrDefault() != null ? lv1.Descendants("URL").FirstOrDefault().Value.Replace(" ", "") : string.Empty, MobileFriendly = Convert.ToBoolean(lv1.Descendants("MobileFriendly").FirstOrDefault().Value.Replace(" ", "")), InstantDelivery = Convert.ToBoolean(lv1.Descendants("InstantDelivery").FirstOrDefault().Value.Replace(" ", "")), DocSigning = Convert.ToBoolean(lv1.Descendants("DocSigning").FirstOrDefault().Value.Replace(" ", "")), ScanProduct = Convert.ToBoolean(lv1.Descendants("ScanProduct").FirstOrDefault().Value.Replace(" ", "")), BusinessValid = Convert.ToBoolean(lv1.Descendants("BusinessValid").FirstOrDefault().Value.Replace(" ", "")), SanSupport = Convert.ToBoolean(lv1.Descendants("SanSupport").FirstOrDefault().Value.Replace(" ", "")), WildcardSupport = Convert.ToBoolean(lv1.Descendants("WildcardSupport").FirstOrDefault().Value.Replace(" ", "")), GreenBar = Convert.ToBoolean(lv1.Descendants("GreenBar").FirstOrDefault().Value.Replace(" ", "")), IssuanceTime = lv1.Descendants("IssuanceTime").FirstOrDefault().Value.Replace(" ", ""), Warranty = lv1.Descendants("Warranty").FirstOrDefault().Value.Replace(" ", ""), SiteSeal = lv1.Descendants("SiteSeal").FirstOrDefault().Value.Replace(" ", ""), StarRating = lv1.Descendants("StarRating").FirstOrDefault().Value.Replace(" ", ""), SealInSearch = Convert.ToBoolean(lv1.Descendants("SealInSearch").FirstOrDefault().Value.Replace(" ", "")), VulnerabilityAssessment = Convert.ToBoolean(lv1.Descendants("VulnerabilityAssessment").FirstOrDefault().Value.Replace(" ", "")), ValidationType = lv1.Descendants("ValidationType").FirstOrDefault().Value.Replace(" ", ""), ServerLicense = lv1.Descendants("ServerLicense").FirstOrDefault().Value.Replace(" ", ""), ShortDesc = lv1.Descendants("ShortDesc").FirstOrDefault() != null ? lv1.Descendants("ShortDesc").FirstOrDefault().Value.Replace(" ", "") : string.Empty, LongDesc = lv1.Descendants("LongDesc").FirstOrDefault() != null ? lv1.Descendants("LongDesc").FirstOrDefault().Value.Replace(" ", "") : string.Empty, ProductDatasheetUrl = lv1.Descendants("ProductDatasheetUrl").FirstOrDefault() != null ? lv1.Descendants("ProductDatasheetUrl").FirstOrDefault().Value.Replace(" ", "") : string.Empty, VideoUrl = lv1.Descendants("VideoUrl").FirstOrDefault() != null ? lv1.Descendants("VideoUrl").FirstOrDefault().Value.Replace(" ", "") : string.Empty, SimilarProducts = lv1.Descendants("SimilarProducts").FirstOrDefault() != null ? lv1.Descendants("SimilarProducts").FirstOrDefault().Value.Replace(" ", "") : string.Empty, SealType = lv1.Descendants("SealType").FirstOrDefault() != null ? lv1.Descendants("SealType").FirstOrDefault().Value.Replace(" ", "") : string.Empty }).ToList()); } else { return(null); } }
/// <summary> /// Updates the existing database Venue on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Venue updateVenue = Venue.GetVenueFromNode(element); if (updateVenue == null) { continue; } System.Xml.Linq.XElement venueNode = element.Element(Constants.Venue.venueElement); object newValue = (string)venueNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateVenue, newValue, columnName); } }
/// <summary> /// Updates the existing database TypeGroup on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { EventTypeGroup updateTypeGroup = EventTypeGroup.GetEventTypeGroupFromNode(element); if (updateTypeGroup == null) { continue; } System.Xml.Linq.XElement typeGroupNode = element.Element(Constants.EventTypeGroup.typeGroupElement); object newValue = typeGroupNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateTypeGroup, newValue, columnName); } }
/// <summary> /// Updates the existing database Project on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Project updateProject = Project.GetProjectFromNode(element); if (updateProject == null) { continue; } System.Xml.Linq.XElement projectNode = element.Element(Constants.Project.projectElement); object newValue = projectNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateProject, newValue, columnName); } }
/// <summary> /// Updates the existing database Orchestra on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Orchestra updateOrchestra = Orchestra.GetOrchestraFromNode(element); if (updateOrchestra == null) { continue; } System.Xml.Linq.XElement orchestraNode = element.Element(Constants.Orchestra.orchestraElement); object newValue = orchestraNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateOrchestra, newValue, columnName); } }
/// <summary> /// Updates the existing database Season on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { Season updateSeason = Season.GetSeasonFromNode(element); if (updateSeason == null) { continue; } System.Xml.Linq.XElement seasonNode = element.Element(Constants.Season.seasonElement); object newValue = seasonNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateSeason, newValue, columnName); } }
public static List <PageUrl> GetProductDetailSlugs() { string path = AppDomain.CurrentDomain.GetData("DataDirectory").ToString() + "\\Configuration\\pageconfiguration.xml"; if (System.IO.File.Exists(path)) { System.Xml.Linq.XDocument xdoc = System.Xml.Linq.XDocument.Load(path); return((from lv1 in xdoc.Descendants("ProductPage") select new PageUrl { Description = lv1.Descendants("Description").FirstOrDefault() != null ? lv1.Descendants("Description").FirstOrDefault().Value.Replace("\n", "").Replace("\r", "").Trim() : "", Keywords = lv1.Descendants("Keywords").FirstOrDefault() != null ? lv1.Descendants("Keywords").FirstOrDefault().Value.Replace("\n", "").Replace("\r", "").Trim() : "", SlugUrl = lv1.Descendants("InternalProductCode").Select(x => x.Attribute("data-url").Value.Replace("\n", "").Replace("\r", "").Trim()).FirstOrDefault(), ProductCode = lv1.Descendants("InternalProductCode").FirstOrDefault() != null ? lv1.Descendants("InternalProductCode").FirstOrDefault().Value.Replace("\n", "").Replace("\r", "").Trim() : "", Title = lv1.Descendants("Title").FirstOrDefault() != null ? lv1.Descendants("Title").FirstOrDefault().Value.Replace("\n", "").Replace("\r", "").Trim() : "" }).ToList()); } else { return(null); } }
/// <summary> /// Updates the existing database WorkArtist on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement eventElement in eventElements) { var workElements = eventElement.Descendants(Constants.Work.workElement); foreach (var workElement in workElements) { Work workItem = Work.GetWorkFromNode(workElement); IEnumerable <System.Xml.Linq.XElement> workArtistElements = workElement.Descendants(Constants.WorkArtist.workArtistElement); foreach (var workArtistElement in workArtistElements) { int artistID = 0; int.TryParse((string)workArtistElement.GetXElement(Constants.WorkArtist.workArtistIDElement), out artistID); WorkArtist updateWorkArtist = WorkArtist.GetWorkArtistByID(artistID, workItem.WorkID); updateWorkArtist = WorkArtist.BuildWorkArtist(workArtistElement, artistID, updateWorkArtist); if (updateWorkArtist == null) { continue; } object newValue = (string)workArtistElement.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateWorkArtist, newValue, columnName); BsoArchiveEntities.UpdateObject(updateWorkArtist.Artist, newValue, columnName); BsoArchiveEntities.UpdateObject(updateWorkArtist.Instrument, newValue, columnName); BsoArchiveEntities.Current.Save(); } } } }
/// <summary> /// Update given column from xml given the tag name /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> /// <remarks> /// Read Composer information from OPAS XML and update the Composer Column based upon appropriate tagName /// </remarks> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { IEnumerable <System.Xml.Linq.XElement> composerElements = element.Descendants(Constants.Work.workComposerElement); foreach (System.Xml.Linq.XElement composer in composerElements) { Composer updateComposer = Composer.GetComposerFromNode(composer); if (updateComposer == null) { continue; } object newValue = composer.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateComposer, newValue, columnName); } } }
/// <summary> /// Updates the existing database Work on the column name using the /// XML document parsed using the tagName. /// </summary> /// <param name="doc"></param> /// <param name="columnName"></param> /// <param name="tagName"></param> public void UpdateData(System.Xml.Linq.XDocument doc, string columnName, string tagName) { IEnumerable <System.Xml.Linq.XElement> eventElements = doc.Descendants(Constants.Event.eventElement); foreach (System.Xml.Linq.XElement element in eventElements) { //System.Xml.Linq.XElement workNode = element.Element(Constants.Work.workElement); var workNodes = element.Descendants(Constants.Work.workElement); foreach (var workNode in workNodes) { Work updateWork = Work.GetWorkFromNode(workNode); if (updateWork == null) { continue; } object newValue = (string)workNode.GetXElement(tagName); BsoArchiveEntities.UpdateObject(updateWork, newValue, columnName); } } }
public ActionResult ImportJeansItems(string tbFilePath) { string strResponse; if (!string.IsNullOrEmpty(tbFilePath)) { try { System.Xml.Linq.XDocument xmlDoc = System.Xml.Linq.XDocument.Load(tbFilePath); var Jeanses = from g in xmlDoc.Descendants("Jeans") select g; foreach (var Jeans in Jeanses) { Jeans newJeans = new Jeans(); newJeans.Details = Jeans.Element("Details").Value; newJeans.Jeans_Name = Jeans.Element("Name").Value; newJeans.JeansCategoryID = Convert.ToInt32(Jeans.Element("Category").Value); newJeans.Price = Convert.ToInt32(Jeans.Element("Price").Value); db.Jeanses.Add(newJeans); db.SaveChanges(); } strResponse = "<font style='font-size:18pt;'><b>Jeans items added successfully in the database.</b><br><br><br></font>"; } catch (System.Exception ex) { strResponse = "<font style='font-size:18pt;color:red;'><b>Invalid file path.</b><br><br><br></font>"; } } else { strResponse = "<font style='font-size:18pt;color:red;'><b>Please specify a valid file path.</b><br><br><br></font>"; } ViewBag.response = strResponse; return(View()); }
public void ProcessRequest(HttpContext context) { string filePath = context.Request.PhysicalPath; using (System.IO.FileStream stream = new System.IO.FileStream(filePath, System.IO.FileMode.Open)) { System.Xml.Linq.XDocument xDocument = System.Xml.Linq.XDocument.Load(stream); var allUsers = from user in xDocument.Descendants("User") select new { FirstName = user.Element("FirstName").Value, LastName = user.Element("LastName").Value }; context.Response.Write("<html><body><table border='1'>"); foreach (var user in allUsers) { context.Response.Write("<tr>"); context.Response.Write("<td>" + user.FirstName + "</td>"); context.Response.Write("<td>" + user.LastName + "</td>"); context.Response.Write("</tr>"); } context.Response.Write("</table></body></html>"); } }