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