// Send to Excel Implementation
public async Task Send2Excel()
{
IEnumerable <PackageType> lst = null;
using (var ctx = new PackageTypeRepository())
{
lst = await ctx.GetPackageTypesByExpressionNav(vloader.FilterExpression, vloader.NavigationExpression).ConfigureAwait(continueOnCapturedContext: false);
}
if (lst == null || !lst.Any())
{
MessageBox.Show("No Data to Send to Excel");
return;
}
var s = new ExportToExcel <PackageTypeExcelLine, List <PackageTypeExcelLine> >
{
dataToPrint = lst.Select(x => new PackageTypeExcelLine
{
PackageCode = x.PackageCode,
PackageDescription = x.PackageDescription
}).ToList()
};
using (var sta = new StaTaskScheduler(numberOfThreads: 1))
{
await Task.Factory.StartNew(s.GenerateReport, CancellationToken.None, TaskCreationOptions.None, sta).ConfigureAwait(false);
}
}
internal async void OnCurrentPackageTypeIDChanged(object sender, NotificationEventArgs <string> e)
{
using (PackageTypeRepository ctx = new PackageTypeRepository())
{
CurrentPackageType = await ctx.GetPackageType(e.Data).ConfigureAwait(continueOnCapturedContext: false);
}
NotifyPropertyChanged(m => CurrentPackageType);
}
public async Task SelectAll()
{
IEnumerable <PackageType> lst = null;
using (var ctx = new PackageTypeRepository())
{
lst = await ctx.GetPackageTypesByExpressionNav(vloader.FilterExpression, vloader.NavigationExpression).ConfigureAwait(continueOnCapturedContext: false);
}
SelectedPackageTypes = new ObservableCollection <PackageType>(lst);
}
private async Task LoadPackageTypes()
{
using (var ctx = new PackageTypeRepository())
{
var res = await ctx.PackageTypes().ConfigureAwait(false);
if (res != null)
{
packageTypes = new ObservableCollection <PackageType>(res);
}
}
}
public IList <PackageType> LoadRange(int startIndex, int count, SortDescriptionCollection sortDescriptions, out int overallCount)
{
try
{
if (FilterExpression == null)
{
FilterExpression = "All";
}
using (var ctx = new PackageTypeRepository())
{
var r = ctx.LoadRange(startIndex, count, FilterExpression, navExp, IncludesLst);
overallCount = r.Result.Item2;
return(r.Result.Item1.ToList());
}
}
catch (Exception ex)
{
StatusModel.Message(ex.Message);
overallCount = 0;
return(new List <PackageType>());
}
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.Configure <CookiePolicyOptions>(options =>
{
// This lambda determines whether user consent for non-essential cookies is needed for a given request.
options.CheckConsentNeeded = context => true;
options.MinimumSameSitePolicy = SameSiteMode.None;
});
services.AddSession(options => {
options.IdleTimeout = TimeSpan.FromMinutes(15);
});
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);
services.AddDbContext <EntityFrameWorkMagicContext>(options =>
options.UseSqlServer(Configuration.GetConnectionString("EntityFrameWorkMagicContext")));
// DI
var connectionString = Environment.GetEnvironmentVariable("SQL_CONNECTION") ?? Configuration.GetConnectionString("ConnMsSQL");
var projectRepository = new ProjectRepository(connectionString);
var componentRepository = new ComponentRepository(connectionString);
var ossIndexRepository = new OssIndexRepository(connectionString);
var ossIndexVulnerabilitiesRepository = new OssIndexVulnerabilitiesRepository(connectionString);
var reportRepository = new ReportRepository(connectionString);
var reportLinesRepository = new ReportLinesRepository(connectionString);
var packageTypeRepository = new PackageTypeRepository();
var httpWebRequestFactory = new HttpWebRequestFactory();
var coordinatesService = new CoordinatesService();
var jsonConvertService = new JsonConvertService();
var ossReportService = new OssReportService(
reportRepository,
componentRepository,
ossIndexRepository,
reportLinesRepository,
coordinatesService,
httpWebRequestFactory,
jsonConvertService,
ossIndexVulnerabilitiesRepository);
services.AddTransient <IProjectRepository>(s => projectRepository);
services.AddTransient <IComponentRepository>(s => componentRepository);
services.AddTransient <IOssIndexRepository>(s => ossIndexRepository);
services.AddTransient <IOssIndexVulnerabilitiesRepository>(s => ossIndexVulnerabilitiesRepository);
services.AddTransient <IReportRepository>(s => reportRepository);
services.AddTransient <IReportLinesRepository>(s => reportLinesRepository);
services.AddTransient <IPackageTypeRepository>(s => packageTypeRepository);
services.AddSingleton <IJsonConvertService>(jsonConvertService);
services.AddSingleton <ICoordinatesService>(coordinatesService);
services.AddSingleton <ISelectListItemService>(new SelectListItemService(projectRepository, packageTypeRepository));
services.AddSingleton <IScoreService>(new ScoreService(reportRepository, reportLinesRepository, ossIndexRepository, ossIndexVulnerabilitiesRepository));
services.AddSingleton <IScoreClassService>(new ScoreClassService());
services.AddSingleton <IBreadcrumbReportService>(new BreadcrumbReportService());
services.AddSingleton <IOssReportService>(ossReportService);
services.AddSingleton <IOssIndexStatusService>(new OssIndexStatusService(
reportRepository,
reportLinesRepository,
ossIndexRepository));
services.AddSingleton <IApiCallerService>(new ApiCallerService(
ossIndexRepository,
ossReportService));
services.AddSingleton <ICoordinatePartsFactory>(new CoordinatePartsFactory());
services.AddSingleton <IHttpWebRequestFactory>(httpWebRequestFactory);
}
