internal async Task <JsonResult> BoxChange(Consolidation boxdata) { SqlConnection cn = null; try { cn = Connection.GetConnection(); SqlCommand smd = new SqlCommand("consolidation_box_change", cn) { CommandType = CommandType.StoredProcedure }; smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output; smd.Parameters.AddWithValue("@slot_id", boxdata.SlotId); smd.Parameters.AddWithValue("@box_id", boxdata.BoxId); smd.Parameters.AddWithValue("@location_id", boxdata.LocationId); await smd.ExecuteNonQueryAsync().ConfigureAwait(false); string json = smd.Parameters["@jsonOutput"].Value.ToString(); smd.Dispose(); JArray arr = JArray.Parse(json); return(new JsonResult(arr)); } catch (Exception) { throw; } finally { Connection.CloseConnection(ref cn); } }
internal async Task <JsonResult> ScanBarcode(Consolidation scandata) { SqlConnection cn = null; try { cn = Connection.GetConnection(); SqlCommand smd = new SqlCommand("consolidation_scan_barcode", cn) { CommandType = CommandType.StoredProcedure }; smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output; smd.Parameters.AddWithValue("@email_id", scandata.EmailId); smd.Parameters.AddWithValue("@barcode", scandata.Barcode); smd.Parameters.AddWithValue("@cage_id", scandata.CageId); smd.Parameters.AddWithValue("@location_id", scandata.LocationId); smd.Parameters.AddWithValue("@sorting_zone", scandata.SortingZone); await smd.ExecuteNonQueryAsync().ConfigureAwait(false); string json = smd.Parameters["@jsonOutput"].Value.ToString(); smd.Dispose(); JArray arr = JArray.Parse(json); return(new JsonResult(arr)); } catch (Exception) { throw; } finally { Connection.CloseConnection(ref cn); } }
public async Task <JsonResult> BoxChange([FromBody] Consolidation boxdata) { try { return(await _consolidationLogic.BoxChange(boxdata).ConfigureAwait(false)); } catch (Exception ee) { return(await _consolidationLogic.SendRespose("False", ee.Message).ConfigureAwait(false)); } }
public async Task <JsonResult> ScanSlot([FromBody] Consolidation slotdata) { try { return(await _consolidationLogic.ScanSlot(slotdata).ConfigureAwait(false)); } catch (Exception ee) { return(await _consolidationLogic.SendRespose("False", ee.Message).ConfigureAwait(false)); } }
void ProcessPackageFramework(PackageArchiveReader package, NuGetFramework framework) { if (!consolidations.TryGetValue(framework, out var consolidation)) { consolidation = new Consolidation(framework); consolidations.Add(framework, consolidation); } foreach (var assemblyName in GetItems(package.GetFrameworkItems(), framework)) { consolidation.FrameworkAssemblyReferences.Add(new FrameworkAssemblyReference( assemblyName, new [] { framework })); } package.CopyFiles( workPath, GetItems(package.GetLibItems(), framework), (sourceFile, targetPath, fileStream) => { var targetDirectory = Path.GetDirectoryName(targetPath); if (!consolidation.AssemblySearchPaths.Contains(targetDirectory)) { consolidation.AssemblySearchPaths.Add(targetDirectory); } Directory.CreateDirectory(targetDirectory); using (var targetStream = File.Open( targetPath, FileMode.Create, FileAccess.Write)) fileStream.CopyTo(targetStream); consolidation.Assemblies.Add(targetPath); return(targetPath); }, null, default); consolidation.AssemblySearchPaths.AddRange(package .GetPackageDependencies() .Where(d => d.TargetFramework == framework) .SelectMany(d => d.Packages) .Select(d => NuGetLocalRepoHelper.GetPackageAssemblySearchPath( d.Id, d.VersionRange, framework)) .Where(d => d != null)); }
internal CacheSource ToCacheSource() { var cs = new CacheSource(); cs.Type = Type; if (ConnectionId != 0) { cs.ConnectionId = ConnectionId; } if (IsWorksheetSource != null) { if (IsWorksheetSource.Value) { cs.WorksheetSource = new WorksheetSource(); if ((WorksheetSourceReference != null) && (WorksheetSourceReference.Length > 0)) { cs.WorksheetSource.Reference = WorksheetSourceReference; } if ((WorksheetSourceName != null) && (WorksheetSourceName.Length > 0)) { cs.WorksheetSource.Name = WorksheetSourceName; } if ((WorksheetSourceSheet != null) && (WorksheetSourceSheet.Length > 0)) { cs.WorksheetSource.Sheet = WorksheetSourceSheet; } if ((WorksheetSourceId != null) && (WorksheetSourceId.Length > 0)) { cs.WorksheetSource.Id = WorksheetSourceId; } } else { cs.Consolidation = Consolidation.ToConsolidation(); } } else { if (ExtensionList != null) { cs.CacheSourceExtensionList = (CacheSourceExtensionList)ExtensionList.CloneNode(true); } } return(cs); }
internal void FromCacheSource(CacheSource cs) { SetAllNull(); if (cs.Type != null) { Type = cs.Type.Value; } if (cs.ConnectionId != null) { ConnectionId = cs.ConnectionId.Value; } if (cs.WorksheetSource != null) { if (cs.WorksheetSource.Reference != null) { WorksheetSourceReference = cs.WorksheetSource.Reference.Value; } if (cs.WorksheetSource.Name != null) { WorksheetSourceName = cs.WorksheetSource.Name.Value; } if (cs.WorksheetSource.Sheet != null) { WorksheetSourceSheet = cs.WorksheetSource.Sheet.Value; } if (cs.WorksheetSource.Id != null) { WorksheetSourceId = cs.WorksheetSource.Id.Value; } IsWorksheetSource = true; } else if (cs.Consolidation != null) { Consolidation.FromConsolidation(cs.Consolidation); IsWorksheetSource = false; } else if (cs.CacheSourceExtensionList != null) { ExtensionList = (CacheSourceExtensionList)cs.CacheSourceExtensionList.CloneNode(true); IsWorksheetSource = null; } }
internal Consolidation ToConsolidation() { Consolidation c = new Consolidation(); if (this.AutoPage != true) { c.AutoPage = this.AutoPage; } if (this.Pages.Count > 0) { Page pg; c.Pages = new Pages() { Count = (uint)this.Pages.Count }; foreach (List <string> ls in this.Pages) { pg = new Page() { Count = (uint)ls.Count }; foreach (string s in ls) { pg.Append(new PageItem() { Name = s }); } c.Pages.Append(pg); } } c.RangeSets = new RangeSets() { Count = (uint)this.RangeSets.Count }; foreach (SLRangeSet rs in this.RangeSets) { c.RangeSets.Append(rs.ToRangeSet()); } return(c); }
internal void FromConsolidation(Consolidation c) { this.SetAllNull(); if (c.AutoPage != null) { this.AutoPage = c.AutoPage.Value; } Page pg; PageItem pgi; List <string> listPage; SLRangeSet rs; using (OpenXmlReader oxr = OpenXmlReader.Create(c)) { while (oxr.Read()) { if (oxr.ElementType == typeof(Page)) { listPage = new List <string>(); pg = (Page)oxr.LoadCurrentElement(); using (OpenXmlReader oxrPage = OpenXmlReader.Create(pg)) { while (oxrPage.Read()) { if (oxrPage.ElementType == typeof(PageItem)) { pgi = (PageItem)oxrPage.LoadCurrentElement(); listPage.Add(pgi.Name.Value); } } } this.Pages.Add(listPage); } else if (oxr.ElementType == typeof(RangeSet)) { rs = new SLRangeSet(); rs.FromRangeSet((RangeSet)oxr.LoadCurrentElement()); this.RangeSets.Add(rs); } } } }
internal Consolidation ToConsolidation() { var c = new Consolidation(); if (AutoPage != true) { c.AutoPage = AutoPage; } if (Pages.Count > 0) { Page pg; c.Pages = new Pages { Count = (uint)Pages.Count }; foreach (var ls in Pages) { pg = new Page { Count = (uint)ls.Count }; foreach (var s in ls) { pg.Append(new PageItem { Name = s }); } c.Pages.Append(pg); } } c.RangeSets = new RangeSets { Count = (uint)RangeSets.Count }; foreach (var rs in RangeSets) { c.RangeSets.Append(rs.ToRangeSet()); } return(c); }
internal void FromConsolidation(Consolidation c) { this.SetAllNull(); if (c.AutoPage != null) this.AutoPage = c.AutoPage.Value; Page pg; PageItem pgi; List<string> listPage; SLRangeSet rs; using (OpenXmlReader oxr = OpenXmlReader.Create(c)) { while (oxr.Read()) { if (oxr.ElementType == typeof(Page)) { listPage = new List<string>(); pg = (Page)oxr.LoadCurrentElement(); using (OpenXmlReader oxrPage = OpenXmlReader.Create(pg)) { while (oxrPage.Read()) { if (oxrPage.ElementType == typeof(PageItem)) { pgi = (PageItem)oxrPage.LoadCurrentElement(); listPage.Add(pgi.Name.Value); } } } this.Pages.Add(listPage); } else if (oxr.ElementType == typeof(RangeSet)) { rs = new SLRangeSet(); rs.FromRangeSet((RangeSet)oxr.LoadCurrentElement()); this.RangeSets.Add(rs); } } } }
internal SLCacheSource Clone() { var cs = new SLCacheSource(); cs.Type = Type; cs.ConnectionId = ConnectionId; cs.IsWorksheetSource = IsWorksheetSource; cs.WorksheetSourceReference = WorksheetSourceReference; cs.WorksheetSourceName = WorksheetSourceName; cs.WorksheetSourceSheet = WorksheetSourceSheet; cs.WorksheetSourceId = WorksheetSourceId; cs.Consolidation = Consolidation.Clone(); if (ExtensionList != null) { cs.ExtensionList = (CacheSourceExtensionList)ExtensionList.CloneNode(true); } return(cs); }
internal Consolidation ToConsolidation() { Consolidation c = new Consolidation(); if (this.AutoPage != true) c.AutoPage = this.AutoPage; if (this.Pages.Count > 0) { Page pg; c.Pages = new Pages() { Count = (uint)this.Pages.Count }; foreach (List<string> ls in this.Pages) { pg = new Page() { Count = (uint)ls.Count }; foreach (string s in ls) { pg.Append(new PageItem() { Name = s }); } c.Pages.Append(pg); } } c.RangeSets = new RangeSets() { Count = (uint)this.RangeSets.Count }; foreach (SLRangeSet rs in this.RangeSets) { c.RangeSets.Append(rs.ToRangeSet()); } return c; }