public LogMessage SaveMeasureFilesInExcel(IMeasureRepository repo, Workbook template)
{
LogMessage log = new LogMessage();
string directoryToSave = $"{ repo.GetMeasuresDirectory() }\\Excel\\";
Directory.CreateDirectory(directoryToSave);
foreach (var measure in repo.Measures)
{
string measureName = measure.GetName();
List <double> frictionFactors = measure.GetFrictionFactors();
log.Info += $"{measureName} loaded.\n";
CopyFrictionFactorsIntoExcel(frictionFactors, template);
FormatChart(frictionFactors.Count, template);
template.SaveCopyAs($"{directoryToSave}{measureName}.xlsx");
log.Info += $"{measureName} saved.\n";
}
return(log);
}
public EntryController(IDeviceRepository deviceRepository, IMeasureRepository repository,
UserManager <ApplicationUser> userManager, IHubContext <DeviceHub> hubContext)
{
_repository = repository;
_deviceRepository = deviceRepository;
_hubContext = hubContext;
}
//Constructor
public MeasureController()
{
UnitOfWork unitOfWork = new UnitOfWork();
this._measureRepository = new MeasureRepository(unitOfWork);
this._caching = new CacheManagement();
}
/// <summary>
/// コンストラクター
/// 引数が指定されている
/// 指定されたRepositoriesを参照する
/// </summary>
/// <param name="measureRepository"></param>
public LatestViewModel(IMeasureRepository measureRepository)
{
// ①共通のインスタンス（インターフェースの場合）
_measureRepository = measureRepository;
// ②共通のインスタンス（具象クラスの場合）
//_measureRepository = new MeasureRepository(measureRepository);
}
public MeasuresController(IMeasureRepository measureRepository, IMeasureReadModelRepository measureReadModelRepository, IProfileDomainService profileDomainService, IIdentityService identityService, IDomainNotificationHandler domainNotificationHandler, IMediator mediator, ILogger <MeasuresController> logger)
: base(domainNotificationHandler, mediator, logger)
{
_measureReadModelRepository = measureReadModelRepository;
_profileDomainService = profileDomainService;
_currentProfileId = identityService.GetUserId();
}
public MeasureViewModelFactory([Import] IMeasureRepository measureRepository, [Import] IResponsibleSubjectViewModelFactory responsibleSubjectViewModelFactory,
[ImportMany] IEnumerable <IRelatedElementProvider> relatedElementProvider)
{
m_MeasureRepository = measureRepository;
m_ResponsibleSubjectViewModelFactory = responsibleSubjectViewModelFactory;
m_RelatedElementProviders = relatedElementProvider.ToArray();
}
public MeasureService(IMeasureRepository measureRepository
, IMessageSession messageSession
)
{
_measureRepository = measureRepository;
_messageSession = messageSession;
}
public ListMeasureQueryHandlerTest()
{
var repository = new Mock <IMeasureRepository>();
repository.Setup(x => x.ListAsync(It.IsAny <Expression <Func <Domain.Entities.Measure, bool> > >(),
It.IsAny <string>(), It.IsAny <int>(), It.IsAny <int>()))
.ReturnsAsync((Expression <Func <Domain.Entities.Measure, bool> > filter,
string orderBy, int page, int qtyPerPage) =>
{
var func = filter.Compile();
var value = func.Invoke(Domain.Entities.Measure.New("test", StatusEnum.Disable, TenantId.New()));
if (value)
{
return(Pagination <Domain.Entities.Measure> .Empty);
}
else
{
return(Pagination <Domain.Entities.Measure> .New(new Domain.Entities.Measure[]
{
Domain.Entities.Measure.New("test 1", StatusEnum.Disable, TenantId.New())
}, 1, 1, 1));
}
});
_measureRepository = repository.Object;
}
public LatestViewModel(IMeasureRepository measureRepository)
{
_measureRepository = measureRepository;
var entity = _measureRepository.GetLatest();
MeasureDate = entity.MeasureDate.DisplayValue;
MeasureValue = entity.MeasureValue.DisplayValue;
}
public EntryController(AppState appState, IUserRepository userRepository, IDeviceRepository deviceRepository, IMeasureRepository repository,
UserManager <ApplicationUser> userManager)
{
_appState = appState;
_userRepository = userRepository;
_deviceRepository = deviceRepository;
_repository = repository;
_userManager = userManager;
}
protected internal UnitsPage(IUnitsRepository r, IMeasureRepository m, IUnitTermsRepository t, IUnitFactorRepository f) : base(r)
{
PageTitle = "Units";
Measures = createMeasures(m);
Terms = new List <UnitTermView>();
Factors = new List <UnitFactorView>();
terms = t;
factors = f;
}
public static void Create(IMeasureRepository repository)
{
//Lock ロックの中の処理をしている間は_entitiesの値をみにきてもロックが抜けるまで待つ、抜けたら使いたい人が通る
lock (((ICollection)_entities).SyncRoot)
{
_entities.Clear();
_entities.AddRange(repository.GetLatests());
}
}
public MeasureListViewModel(IMeasureRepository measureRepository)
{
_measureRepository = measureRepository;
foreach (var entity in _measureRepository.GetData())
{
Measures.Add(new MeasureListViewModelMeasure(entity));
}
}
public LatestViewModel(IMeasureRepository measureRepository)
{
_measureRepository = measureRepository ?? throw new ArgumentNullException(nameof(measureRepository));
var entity = _measureRepository.GetLatest();
MeasureDate = entity.MeasureDate.DisplayValue;
MeasureValue = entity.MeasureValue.DisplayValue;
}
public MeasureListViewModel(IMeasureRepository measureRepository)
{
_measureRepository = measureRepository ?? throw new ArgumentNullException(nameof(measureRepository));
foreach (var entity in _measureRepository.GetData())
{
Measures.Add(new MeasureListViewModelMeasure(entity));
}
}
public HomeController(IIngredientRepository repoService, IRecipeRepository repoRecipe, IIngredientLineRepository repoLine, IMeasureRepository repoMeasure,
IRecipeCommentRepository repoComment)
{
repository = repoService;
recipeRepo = repoRecipe;
lineRepo = repoLine;
measureRepo = repoMeasure;
commentRepo = repoComment;
}
public MeasureManagementViewModel([Import] IMeasureRepository contextRepository, [Import] IMeasureViewModelFactory measureViewModelFactory)
{
m_Repository = contextRepository;
m_MeasureViewModelFactory = measureViewModelFactory;
m_Repository.ContextChanged += (s, e) => Application.Current.Dispatcher.Invoke(Reload);
Reload();
FlyoutActivated = true;
}
/// <summary>
/// リストを作成する
/// </summary>
/// <param name="repository">計測リポジトリー</param>
public static void Create(IMeasureRepository repository)
{
// publicになっているので複数からアクセスされる可能性がある
// 一つだけのアクセスlockで保証する
lock (((ICollection)_entities).SyncRoot) {
_entities.Clear();
// リストを取得
_entities.AddRange(repository.GetLatests());
}
}
public MeasureCommandHandler(IMeasureRepository measureRepository, IMeasureCategoryRepository measureCategoryRepository, IMapper mapper, IStorageService storageService, IOptions <ContainerOptions> containerOptions, IIdentityService identityService, IMediator mediator, IUnitOfWork <ICommunityDbContext> unitOfWork, ILogger <MeasureCommandHandler> logger)
: base(identityService, mediator, unitOfWork, logger)
{
_measureRepository = measureRepository;
_measureCategoryRepository = measureCategoryRepository;
_mapper = mapper;
_storageService = storageService;
_containerOptions = containerOptions;
_currentProfileId = GetCurrentProfileId();
}
private static IEnumerable <SelectListItem> createMeasures(IMeasureRepository r)
{
var list = new List <SelectListItem>();
var measures = r.Get().GetAwaiter().GetResult();
foreach (var m in measures)
{
list.Add(new SelectListItem(m.Data.Name, m.Data.Id));
}
return(list);
}
public ArticleViewModel(IArticleRepository articleRepository, ITaxRepository taxRepository,
IMeasureRepository measureRepository, IArticleTypeRepository articleTypeRepository,
IArticlePriceTypeRepository articlePriceTypeRepository)
{
_articleRepository = articleRepository;
_taxRepository = taxRepository;
_measureRepository = measureRepository;
_articleTypeRepository = articleTypeRepository;
_articlePriceTypeRepository = articlePriceTypeRepository;
Header = $"{_measureRepository.GetEntities().Count()}";
}
public GetMeasureQueryHandlerTest()
{
var repository = new Mock <IMeasureRepository>();
repository.Setup(x => x.GetAsync(It.IsAny <MeasureId>()))
.ReturnsAsync((MeasureId coloId) =>
{
//TODO: change to full entity
return(Domain.Entities.Measure.New("blue", StatusEnum.Enable, TenantId.New()));
});
_measureRepository = repository.Object;
}
private void CreateRepository()
{
var repository = new Mock <IMeasureRepository>();
repository.Setup(x => x.UpdateAsync(It.IsAny <Domain.Entities.Measure>()))
.Callback(() =>
{
updated = true;
});
//mudar pra setar valor em variável x = true;
_measureRepository = repository.Object;
}
private void CreateRepository()
{
var repository = new Mock <IMeasureRepository>();
repository.Setup(x => x.DeleteAsync(It.IsAny <MeasureId>()))
.Callback(() =>
{
deleted = true;
});
//mudar pra setar valor em variável x = true;
_measureRepository = repository.Object;
}
public void SaveMeasureFilesInExcel(IMeasureRepository repo, Workbook template)
{
foreach (var m in repo.Measures)
{
int currentRow = 1;
Worksheet sheet = (Worksheet)template.Worksheets[1];
List <double> frictionFactors = m.GetFrictionFactors();
foreach (var f in frictionFactors)
{
sheet.Cells[currentRow++, "B"] = f;
}
template.SaveAs(m.GetFileName());
}
template.Close();
}
public void SaveMeasureFilesInExcel(IMeasureRepository repo, Workbook template)
{
Application excel = new Application();
Workbook temp = excel.Workbooks.Open(@"C:\Users\pawel.iwanowski\Desktop\test\template.xlsx");
foreach (var m in repo.Measures)
{
int currentRow = 1;
Worksheet sheet = (Worksheet)temp.Worksheets[1];
List <double> frictionFactors = m.GetFrictionFactors();
foreach (var f in frictionFactors)
{
sheet.Cells[currentRow++, "B"].Value = f;
}
Console.WriteLine($"Excel value = {sheet.Cells[5, "B"]}");
//template.SaveAs(m.GetFileName());
//temp.SaveAs(@"C:\test");
}
temp.Close();
}
public DeleteModel(IMeasureTermsRepository r, IMeasureRepository m) : base(r, m)
{
}
public GasMeasureController(IMeasureRepository measureRepository) => this.measureRepository = measureRepository;
internal testClass(IMeasureRepository r, IMeasureTermsRepository t) : base(r, t)
{
}
public MeasureSaveViewModel(IMeasureRepository measureRepository)
{
_measureRepository = measureRepository;
_measureDate = GetDateTime();
}
