static void ProductPackagingAndPackagingType() { bool boolSessionBegun = false; QBSessionManager sessionManager = new QBSessionManager(); try { IMsgSetRequest requestMsgSet; IMsgSetResponse responseMsgSet; sessionManager.OpenConnection("", _appName); sessionManager.BeginSession(qdbpath, ENOpenMode.omDontCare); boolSessionBegun = true; var version = QBFCLatestVersion(sessionManager); short ver = Convert.ToInt16(version); requestMsgSet = GetLatestMsgSetRequest(sessionManager); //sessionManager.CreateMsgSetRequest("US", ver, 0);; requestMsgSet.Attributes.OnError = ENRqOnError.roeStop; IUnitOfMeasureSetQuery query = requestMsgSet.AppendUnitOfMeasureSetQueryRq(); responseMsgSet = sessionManager.DoRequests(requestMsgSet); List<Packaging> items=new List<Packaging>(); IResponse response = responseMsgSet.ResponseList.GetAt(0); IUnitOfMeasureSetRetList unitOfMeasureSet = response.Detail as IUnitOfMeasureSetRetList; if (unitOfMeasureSet != null && unitOfMeasureSet.Count > 0) { for (var i = 0; i < unitOfMeasureSet.Count; i++) { IUnitOfMeasureSetRet unitOfMeasure = unitOfMeasureSet.GetAt(i); if (unitOfMeasure != null && unitOfMeasure.IsActive.GetValue()) { var baseunit = unitOfMeasure.BaseUnit; var p = new Packaging() { Name = unitOfMeasure.Name != null ? unitOfMeasure.Name.GetValue() : "", Description = unitOfMeasure.Name != null ? unitOfMeasure.Name.GetValue() : "", }; if(baseunit !=null) { p.Code = baseunit.Abbreviation != null ? baseunit.Abbreviation.GetValue() : ""; } if (string.IsNullOrEmpty(p.Code)) p.Code = p.Name; if (!string.IsNullOrEmpty(p.Name)) items.Add(p); } } } sessionManager.EndSession(); boolSessionBegun = false; sessionManager.CloseConnection(); if (items.Any()) { var files = items.ToCsv(); DumpExportFilesAsync(files, MasterDataCollective.ProductPackaging.ToString()); DumpExportFilesAsync(files, MasterDataCollective.ProductPackagingType.ToString()); } } catch (Exception ex) { if (boolSessionBegun) { sessionManager.EndSession(); sessionManager.CloseConnection(); } string error = (ex.Message.ToString() + "\nStack Trace: \n" + ex.StackTrace + "\nExiting the application"); Log(error); MessageBox.Show(error); } }
public async override Task<bool> InstallPackageAsync(Packaging.Core.PackageIdentity packageIdentity, System.IO.Stream packageStream, INuGetProjectContext nuGetProjectContext, CancellationToken token) { if (!packageStream.CanSeek) { throw new ArgumentException(NuGet.ProjectManagement.Strings.PackageStreamShouldBeSeekable); } nuGetProjectContext.Log(MessageLevel.Info, Strings.InstallingPackage, packageIdentity); packageStream.Seek(0, SeekOrigin.Begin); var zipArchive = new ZipArchive(packageStream); PackageReader packageReader = new PackageReader(zipArchive); var packageSupportedFrameworks = packageReader.GetSupportedFrameworks(); var projectFrameworks = _project.GetSupportedFrameworksAsync(token) .Result .Select(f => NuGetFramework.Parse(f.FullName)); var args = new Dictionary<string, object>(); args["Frameworks"] = projectFrameworks.Where( projectFramework => IsCompatible(projectFramework, packageSupportedFrameworks)).ToArray(); await _project.InstallPackageAsync( new NuGetPackageMoniker { Id = packageIdentity.Id, Version = packageIdentity.Version.ToNormalizedString() }, args, logger: null, progress: null, cancellationToken: token); return true; }
public Album( string name, Artist artist, Genre genre, IEnumerable <Song> songs, Packaging packaging, Edition edition) { if (name == null) { throw new ArgumentNullException("name"); } if (artist == null) { throw new ArgumentNullException("artist"); } if (songs == null) { throw new ArgumentNullException("songs"); } this.name = name; this.artist = artist; this.genre = genre; this.packaging = packaging; this.edition = edition; this.songs = new ReadOnlyCollection <Song>(songs.ToList()); foreach (var song in songs) { song.Album = this; } }
public async Task <bool> UpdateAsync(Packaging packaging) { try { if (packaging == null) { throw new ArgumentNullException(); } PackagingEntity entity = await _context.Packagings .FirstOrDefaultAsync(x => x.PackagingId.Equals(packaging.PackagingId)) .ConfigureAwait(false); if (entity != null) { _mapper.Map(packaging, entity); await _context.SaveChangesAsync().ConfigureAwait(false); return(true); } } catch (Exception e) { _context.DetachAll(); _logger.LogError(e, "Exception: {e} // Internal Error while updating Packaging: {packaging}", e.Message, JsonSerializer.Serialize(packaging)); } return(false); }
public Task PrihodPack(Packaging pack) { return(Task.Run(() => { var pck = Packaging.FindById(pack.Id); pck.Count += pack.Count; Task.Factory.StartNew(() => { Packaging.Update(pck); }).Wait(); ProductStatistics prod = new ProductStatistics(); prod.Count = pack.Count; prod.Date = DateTime.Now; Task.Factory.StartNew(() => { ProductStatistics.Create(prod); }).Wait(); ProductStatistics now = ProductStatistics.Get(x => x.Count == prod.Count && x.Date.Value.Day == prod.Date.Value.Day && x.Date.Value.Month == prod.Date.Value.Month && x.Date.Value.Year == prod.Date.Value.Year && x.Date.Value.Hour == prod.Date.Value.Hour && x.Date.Value.Minute == prod.Date.Value.Minute && x.Date.Value.Second == prod.Date.Value.Second).First(); Packaging_ProductStatistics statistics = new Packaging_ProductStatistics() { PackagingId = pack.Id, ProductStatisticsId = now.Id }; Task.Factory.StartNew(() => { Packaging_ProductStatistics.Create(statistics); }).Wait(); })); }
public async Task <string> Packaging(long foodId, Packaging packaging, int providerId, int createById) { packaging.PackagingDate = DateTime.Now; var FoodData = await GetFoodDataByID(foodId); if (!ValidateFoodData(FoodData, foodId)) { throw new InvalidDataException(MessageConstant.IVALID_DATA); } foreach (var p in FoodData.Providers) { if (p.ProviderId == providerId) { p.Packaging = packaging; } } var setting = new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore }; string newData = JsonConvert.SerializeObject(packaging, setting); return(await _service.SaveFoodData(FoodData, newData, _userRepository.GetById(createById).Username)); }
public IActionResult AddCart(int?id) { var cart = _service.newShoppingCartAdd2(id); ViewData["Pack"] = new SelectList(Packaging.GetValues(typeof(Packaging)).Cast <Packaging>()); ViewBag.First = ViewData["Pack"]; return(View(cart)); }
//Updates Packaging In The Database private void WriteToDatabase(Packaging packaging, string path) { if (ModelState.IsValid) { packaging.ImageUrl = path.Substring(path.LastIndexOf("images")); _context.Update(packaging); } }
public async Task <JsonResult> PrihInSklad(Packaging pack) { Packaging = new EFRepository <Packaging>(new ApplicationDbContext()); await sklad.PrihodPack(pack); pack.Name = Packaging.FindById(pack.Id).Name; return(Json(pack, JsonRequestBehavior.AllowGet)); }
public void InitializeRule() { BRule Rule = new BRule(PaymentType.PHY_PROD.ToString()); Packaging packaging = new Packaging(); Rule.RuleActionInstance += packaging.GeneratePackagingSlip; Rule.RuleActionInstance += packaging.CommissionToAgent; bRules.Add(Rule); }
public async Task <ActionResult> Create([Bind(Include = "PackagingID,Description,Stackable")] Packaging packaging) { if (ModelState.IsValid) { await packagingRepository.CreateAsync(packaging); return(RedirectToAction("Index")); } return(View(packaging)); }
public Packaging GetPackagingByDrugCode(int id) { Packaging packaging = databasePlaceholder.Get(id); if (packaging == null) { throw new HttpResponseException(HttpStatusCode.NotFound); } return(packaging); }
public async Task <ActionResult> Delete(int id) { Packaging packaging = await packagingRepository.FindPackagingsByIDAsync(id); if (packaging == null) { return(HttpNotFound()); } return(View(packaging)); }
static void Main(string[] args) { Packaging <string> stringPackage = new Packaging <string>(); ISetValue <string> setStringValue = stringPackage; setStringValue.SetData("Sample string"); // the line below causes a compile-time error IGetValue <object> getObjectValue = stringPackage; Console.WriteLine("{0}", getObjectValue.GetData()); }
public Letter(Guid id, string address, string message, DeliveryMethod method, Packaging packagingType, bool wrapped, string originator) { Wrapped = wrapped; Originator = originator; PackagingType = packagingType; Id = id; Address = address; Message = message; Method = method; Events = new List <Event>(); }
public PackagingEditPage(Object obj) { InitializeComponent(); if (obj == null) { packagingBindingSource.DataSource = new Packaging(); } else { packagingBindingSource.DataSource = obj; entity = (Packaging)obj; } }
private Packaging CreatePackaging(string id, string name, string description, decimal width, decimal height, decimal depth, LengthUnitOfMeasure measure) { var package = new Packaging { Name = name, Description = description, Width = width, Height = height, Depth = depth, PackageId = id }; return(package); }
public void PackageQty_MinDefault() { var packaging = new Packaging { Type = "One Piece" }; //price is Rs. 10 per piece of item var product = new Product { Name = "Watermelon", Price = 10 }; var scan = new InvoiceItem { Product = product, Quantity = 2, Packaging = packaging }; Assert.AreEqual(scan.GrossPrice, 20m); }
public static T DeserializeObjectFromStream <T>(MemoryStream input, JsonSerializerSettings settings) { Packaging.UnpackPackage(input, out byte[] json, out MemoryStream binaryData); try { SetBinaryDataStream(Thread.CurrentThread.ManagedThreadId, binaryData); var result = JsonConvert.DeserializeObject <T>(Encoding.UTF8.GetString(json), settings); return(result); } finally { RemoveBinaryDataStream(Thread.CurrentThread.ManagedThreadId); } }
public static MemoryStream SerializeObjectToStream(object value, Formatting formatting, JsonSerializerSettings settings) { try { SetBinaryDataStream(Thread.CurrentThread.ManagedThreadId); var jsonPart = JsonConvert.SerializeObject(value, formatting, settings); var result = Packaging.CreatePackage(Encoding.UTF8.GetBytes(jsonPart), GetBinaryDataStream(Thread.CurrentThread.ManagedThreadId).GetAllStream()); return(result); } finally { RemoveBinaryDataStream(Thread.CurrentThread.ManagedThreadId); } }
public void PackageQty_MinLtr() { // Bottle of 1 ltr. var packaging = new Packaging { Type = "1 Ltr Bottle", PackQty = 1000 /*ml*/ }; //price is 10 for 100 ml var product = new Product { Name = "Cooking Oil", Price = 10, PricePer = 100 /*ml*/ }; var scan = new InvoiceItem { Product = product, Quantity = 1, Packaging = packaging }; Assert.AreEqual(scan.GrossPrice, 100m); }
public void PackageQty_MinDozen() { // pack of 12 items sold together var packaging = new Packaging { Type = "Box of Dozen", PackQty = 12 }; //price is Rs. 10 per piece of item in qty var product = new Product { Name = "Bananas", Price = 10 }; var scan = new InvoiceItem { Product = product, Quantity = 2, Packaging = packaging }; Assert.AreEqual(scan.GrossPrice, 240m); }
public void Delete(PackagingBindingModel model) { using (var context = new FlowerShopDatabase()) { Packaging element = context.Packagings.FirstOrDefault(rec => rec.Id == model.Id); if (element != null) { context.Packagings.Remove(element); context.SaveChanges(); } else { CheckingElement(element); } } }
public int PackNumber(Packaging pack, int quantCar) { switch (pack) { case Packaging.PIECE: return(1); case Packaging.SHRINK_FILM: return(quantCar * 6); case Packaging.SALVER: return(quantCar * 12); case Packaging.TRAY: return(quantCar * 24); } return(0); }
public void InitializeState() { this.salesTax = new Tax { Name = "Sales Tax", Percentage = 10 }; this.importDuty = new Tax { Name = "Import Duty", Percentage = 5 }; this.boxPackaging = new Packaging { Type = "Box", PackageUnits = 1 }; this.bottlePackaging = new Packaging { Type = "Bottle", PackageUnits = 1 }; this.packetPackaging = new Packaging { Type = "Packet", PackageUnits = 1 }; this.localCategory = new ProductCategory() { Name = "Local", Taxes = new List <Tax> { salesTax } }; this.importCategory = new ProductCategory() { Name = "Imported", Taxes = new List <Tax> { salesTax, importDuty } }; this.stExemptLocalCategory = new ProductCategory() { Name = "ST Exempt", }; this.stExemptImportCategory = new ProductCategory() { Name = "ST Exempt", Taxes = new List <Tax> { importDuty } }; }
private Program() { this.salesTax = new Tax { Name = "Sales Tax", Percentage = 10 }; this.importDuty = new Tax { Name = "Import Duty", Percentage = 5 }; this.boxPackaging = new Packaging { Type = "Box", PackQty = 1 }; this.bottlePackaging = new Packaging { Type = "Bottle", PackQty = 1 }; this.packetPackaging = new Packaging { Type = "Packet", PackQty = 1 }; this.localCategory = new TaxCategory() { Name = "Local", Taxes = new List <Tax> { salesTax } }; this.importCategory = new TaxCategory() { Name = "Imported", Taxes = new List <Tax> { salesTax, importDuty } }; this.stExemptLocalCategory = new TaxCategory() { Name = "ST Exempt", }; this.stExemptImportCategory = new TaxCategory() { Name = "ST Exempt", Taxes = new List <Tax> { importDuty } }; }
public string PossiblyCorrupt(string message, Packaging packagingType) { var randomNumberGenerator = new Random(); var builder = new StringBuilder(message); switch (packagingType) { case Packaging.Envelope: for (var i = 0; i < message.Length; i++) { if (randomNumberGenerator.Next(0, 31) > 26) { builder[i] = (char)randomNumberGenerator.Next(32, 128); } } return(builder.ToString()); case Packaging.PaddedEnvelope: for (var i = 0; i < message.Length; i++) { if (randomNumberGenerator.Next(0, 31) > 28) { builder[i] = (char)randomNumberGenerator.Next(32, 128); } } return(builder.ToString()); case Packaging.Parcel: for (var i = 0; i < message.Length; i++) { if (randomNumberGenerator.Next(0, 31) > 29) { builder[i] = (char)randomNumberGenerator.Next(32, 128); } } return(builder.ToString()); } return(null); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Title,Type,Category,Description,ImageUrl,AltText,Contents,PackagingWidth,PackagingHeight")] Packaging packaging, IFormFile ImageUrl) { //Makes the local url where the image is located string[] paths = { _hostingEnvironment.WebRootPath, "images", packaging.Type + "s".ToLower() }; var upload = Path.Combine(paths); if (ImageUrl != null) { var path = Path.Combine(upload, ImageUrl.FileName); if (System.IO.File.Exists(path)) { WriteToDatabase(packaging, path); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } else { //Actually makes the url from the image to an image using (var fileStream = new FileStream(path, FileMode.Create)) { await ImageUrl.CopyToAsync(fileStream); WriteToDatabase(packaging, path); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } } else { if (ModelState.IsValid) { _context.Update(packaging); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } return(View(packaging)); }
public bool isValidBuy(Packaging Pack, int quantCar, int quantProd) { switch (Pack) { case Packaging.PIECE: return(true); case Packaging.SHRINK_FILM: if (quantCar * 6 <= quantProd) { return(true); } else { return(false); } case Packaging.SALVER: if (quantCar * 12 <= quantProd) { return(true); } else { return(false); } case Packaging.TRAY: if (quantCar * 24 <= quantProd) { return(true); } else { return(false); } } return(true); }
public T FindbyId(int id) { var packaging = new Packaging(); using (DBClass = new MSSQLDatabase()) { SqlCommand cmd = DBClass.GetStoredProcedureCommand("APP_GET_PACKAGING_BY_ID"); cmd.Parameters.AddWithValue("@PackagingId", id); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { packaging.PackagingID = int.Parse(reader[0].ToString()); packaging.VoucherCode = reader[1].ToString(); packaging.DepartementID = int.Parse(reader[2].ToString()); packaging.DestinationProduct = int.Parse(reader[3].ToString()); packaging.DestinationQty = decimal.Parse(reader[4].ToString()); //packaging.DestinationDate = DateTime.Parse(reader[5].ToString()); packaging.Note = reader[6].ToString(); packaging.PackagingDate = DateTime.Parse(reader[7].ToString()); } } return(packaging as T); }
internal static List <Packaging> getPackaging(string bidid) { var data = SqlHelper.ExecuteDataset(_myConnection, CommandType.StoredProcedure, "spATL_LBID_MRO", new SqlParameter("@BIDID", bidid)).Tables[0].AsEnumerable(); List <Packaging> lstPackaging = new List <Packaging>(); foreach (DataRow item in data) { Packaging mro = new Packaging(); mro.MRO_Number = Convert.ToInt32(item["MRO_Number"]); mro.CfsFileName = Convert.ToString(item["CfsFileName"]); mro.RunDate = Convert.ToDateTime(item["RunDate"]); mro.JobNumber = item["JobNumber"] != null?Convert.ToString(item["JobNumber"]) : ""; mro.ProjectName = Convert.ToString(item["ProjectName"]); mro.BidItemNumber = Convert.ToInt32(item["BidItemNumber"]); mro.BIDName = Convert.ToString(item["BIDName"]); mro.Qty = Convert.ToDecimal(item["Qty"]); mro.PartNum = Convert.ToString(item["PartNum"]); mro.Description = Convert.ToString(item["Description"]); lstPackaging.Add(mro); } return(lstPackaging); }
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam) { var result = new List <Packaging>(); using (DBClass = new MSSQLDatabase()) { SqlCommand cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_PACKAGING"); RoutinesParameterSetter.Set(ref cmd, keyValueParam); var reader = DBClass.ExecuteReader(cmd); while (reader.Read()) { var packaging = new Packaging(); packaging.PackagingID = int.Parse(reader[0].ToString()); packaging.VoucherCode = reader[1].ToString(); packaging.PackagingDate = DateTime.Parse(reader[2].ToString()); packaging.DestinationCode = reader[3].ToString(); packaging.DestinationName = reader[4].ToString(); packaging.DestinationQty = decimal.Parse(reader[5].ToString()); packaging.Note = reader[7].ToString(); result.Add(packaging); } } return(result as List <T>); }
internal ExcelDoughnutChart(ExcelDrawings drawings, XmlNode node, Uri uriChart, Packaging.ZipPackagePart part, XmlDocument chartXml, XmlNode chartNode) : base(drawings, node, uriChart, part, chartXml, chartNode) { //SetPaths(); }
internal ExcelTable(Packaging.ZipPackageRelationship rel, ExcelWorksheet sheet) : base(sheet.NameSpaceManager) { WorkSheet = sheet; TableUri = UriHelper.ResolvePartUri(rel.SourceUri, rel.TargetUri); RelationshipID = rel.Id; var pck = sheet._package.Package; Part=pck.GetPart(TableUri); TableXml = new XmlDocument(); LoadXmlSafe(TableXml, Part.GetStream()); init(); Address = new ExcelAddressBase(GetXmlNodeString("@ref")); }
internal ExcelVbaSignature(Packaging.ZipPackagePart vbaPart) { _vbaPart = vbaPart; GetSignature(); }
internal ExcelBarChart(ExcelDrawings drawings, XmlNode node, Uri uriChart, Packaging.ZipPackagePart part, XmlDocument chartXml, XmlNode chartNode) : base(drawings, node, uriChart, part, chartXml, chartNode) { SetChartNodeText(chartNode.Name); }
internal static Uri GetNewUri(Packaging.ZipPackage package, string sUri) { return GetNewUri(package, sUri, 1); }
public ExampleClient(PurchaseFactory factory) { _packaging = factory.CreatePackaging(); _deliveryDocument = factory.CreateDeliveryDocument(); }
internal ExcelOfPieChart(ExcelDrawings drawings, XmlNode node, Uri uriChart, Packaging.ZipPackagePart part, XmlDocument chartXml, XmlNode chartNode) : base(drawings, node, uriChart, part, chartXml, chartNode) { SetTypeProperties(); }
public PackageDependencyMetadata(Packaging.Core.PackageDependency serverData) { Id = serverData.Id; Range = serverData.VersionRange; }
internal ExcelSurfaceChart(ExcelDrawings drawings, XmlNode node, Uri uriChart, Packaging.ZipPackagePart part, XmlDocument chartXml, XmlNode chartNode) : base(drawings, node, uriChart, part, chartXml, chartNode) { Init(); }
internal static Uri GetNewUri(Packaging.ZipPackage package, string sUri) { var id = 1; return GetNewUri(package, sUri, ref id); }
private Uri GetNewUri(Packaging.ZipPackage package, string sUri) { int id = 1; Uri uri; do { uri = new Uri(string.Format(sUri, id++), UriKind.Relative); } while (package.PartExists(uri)); return uri; }
internal static ExcelChart GetChart(XmlElement chartNode, ExcelDrawings drawings, XmlNode node, Uri uriChart, Packaging.ZipPackagePart part, XmlDocument chartXml, ExcelChart topChart) { switch (chartNode.LocalName) { case "area3DChart": case "areaChart": case "stockChart": if (topChart == null) { return new ExcelChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelChart(topChart, chartNode); } case "surface3DChart": case "surfaceChart": if (topChart == null) { return new ExcelSurfaceChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelSurfaceChart(topChart, chartNode); } case "radarChart": if (topChart == null) { return new ExcelRadarChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelRadarChart(topChart, chartNode); } case "bubbleChart": if (topChart == null) { return new ExcelBubbleChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelBubbleChart(topChart, chartNode); } case "barChart": case "bar3DChart": if (topChart == null) { return new ExcelBarChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelBarChart(topChart, chartNode); } case "doughnutChart": if (topChart == null) { return new ExcelDoughnutChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelDoughnutChart(topChart, chartNode); } case "pie3DChart": case "pieChart": if (topChart == null) { return new ExcelPieChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelPieChart(topChart, chartNode); } case "ofPieChart": if (topChart == null) { return new ExcelOfPieChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelBarChart(topChart, chartNode); } case "lineChart": case "line3DChart": if (topChart == null) { return new ExcelLineChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelLineChart(topChart, chartNode); } case "scatterChart": if (topChart == null) { return new ExcelScatterChart(drawings, node, uriChart, part, chartXml, chartNode); } else { return new ExcelScatterChart(topChart, chartNode); } default: return null; } }
public async override Task<bool> UninstallPackageAsync(Packaging.Core.PackageIdentity packageIdentity, INuGetProjectContext nuGetProjectContext, CancellationToken token) { nuGetProjectContext.Log(MessageLevel.Info, Strings.UninstallingPackage, packageIdentity); var args = new Dictionary<string, object>(); await _project.UninstallPackageAsync( new NuGetPackageMoniker { Id = packageIdentity.Id, Version = packageIdentity.Version.ToNormalizedString() }, args, logger: null, progress: null, cancellationToken: token); return true; }
internal static Uri GetNewUri(Packaging.ZipPackage package, string sUri, ref int id) { Uri uri = new Uri(string.Format(sUri, id), UriKind.Relative); while (package.PartExists(uri)) { uri = new Uri(string.Format(sUri, ++id), UriKind.Relative); } return uri; }
internal ExcelPivotTable(Packaging.ZipPackageRelationship rel, ExcelWorksheet sheet) : base(sheet.NameSpaceManager) { WorkSheet = sheet; PivotTableUri = UriHelper.ResolvePartUri(rel.SourceUri, rel.TargetUri); Relationship = rel; var pck = sheet._package.Package; Part=pck.GetPart(PivotTableUri); PivotTableXml = new XmlDocument(); LoadXmlSafe(PivotTableXml, Part.GetStream()); init(); TopNode = PivotTableXml.DocumentElement; Address = new ExcelAddressBase(GetXmlNodeString("d:location/@ref")); _cacheDefinition = new ExcelPivotCacheDefinition(sheet.NameSpaceManager, this); LoadFields(); //Add row fields. foreach (XmlElement rowElem in TopNode.SelectNodes("d:rowFields/d:field", NameSpaceManager)) { int x; if (int.TryParse(rowElem.GetAttribute("x"), out x) && x >= 0) { RowFields.AddInternal(Fields[x]); } else { rowElem.ParentNode.RemoveChild(rowElem); } } ////Add column fields. foreach (XmlElement colElem in TopNode.SelectNodes("d:colFields/d:field", NameSpaceManager)) { int x; if(int.TryParse(colElem.GetAttribute("x"),out x) && x >= 0) { ColumnFields.AddInternal(Fields[x]); } else { colElem.ParentNode.RemoveChild(colElem); } } //Add Page elements //int index = 0; foreach (XmlElement pageElem in TopNode.SelectNodes("d:pageFields/d:pageField", NameSpaceManager)) { int fld; if (int.TryParse(pageElem.GetAttribute("fld"), out fld) && fld >= 0) { var field = Fields[fld]; field._pageFieldSettings = new ExcelPivotTablePageFieldSettings(NameSpaceManager, pageElem, field, fld); PageFields.AddInternal(field); } } //Add data elements //index = 0; foreach (XmlElement dataElem in TopNode.SelectNodes("d:dataFields/d:dataField", NameSpaceManager)) { int fld; if (int.TryParse(dataElem.GetAttribute("fld"), out fld) && fld >= 0) { var field = Fields[fld]; var dataField = new ExcelPivotTableDataField(NameSpaceManager, dataElem, field); DataFields.AddInternal(dataField); } } }
internal ImageInfo LoadImage(byte[] image, Uri uri, Packaging.ZipPackagePart imagePart) { var hashProvider = new SHA1CryptoServiceProvider(); var hash = BitConverter.ToString(hashProvider.ComputeHash(image)).Replace("-", ""); if (_images.ContainsKey(hash)) { _images[hash].RefCount++; } else { _images.Add(hash, new ImageInfo() { Uri = uri, RefCount = 1, Hash = hash, Part = imagePart }); } return _images[hash]; }
private void AddFlattennedPackageDependency( PackageDependencyGroup dependencyGroup, Packaging.Core.PackageDependency packageDependency, StringBuilder builder) { if (builder.Length > 0) { builder.Append("|"); } builder.Append(packageDependency.Id); builder.Append(":"); if (!packageDependency.VersionRange.Equals(VersionRange.All)) { builder.Append(packageDependency.VersionRange?.ToString("S", new VersionRangeFormatter())); } AddFlattenedFrameworkDependency(dependencyGroup, builder); }