public static ManufacturersBussinessItemsRepository GetManufacturersBussinessItemsRepository(IUnitOfWork unitOfWork)
{
var repository = new ManufacturersBussinessItemsRepository();
repository.UnitOfWork = unitOfWork;
return(repository);
}
public ExecuteResultEntity <ManufacturersBussinessItems> CreateOrUpdateBussinessItems(ManufacturersBussinessItems entity)
{
try
{
ManufacturersBussinessItemsRepository repo = RepositoryHelper.GetManufacturersBussinessItemsRepository(database);
var result = from q in repo.All()
where q.Id == entity.Id
select q;
if (!result.Any())
{
repo.Add(entity);
repo.UnitOfWork.Commit();
}
else
{
var dbdata = result.Single();
Update(entity.Manufacturers, true);
}
repo.UnitOfWork.Commit();
var rtn = from q in repo.All()
where q.Id == entity.Id
select q;;
return(ExecuteResultEntity <ManufacturersBussinessItems> .CreateResultEntity(rtn.SingleOrDefault()));
}
catch (Exception ex)
{
return(ExecuteResultEntity <ManufacturersBussinessItems> .CreateErrorResultEntity(ex));
}
}
/// <summary>
/// 連動下拉單查詢交易品項
/// </summary>
/// <param name="MaterialCategoriesId"></param>
/// <returns></returns>
public Task <ExecuteResultEntity <ICollection <ManufacturersBussinessItems> > > GetBussinessItemsListWithMaterialCategoriesAsync(Guid MaterialCategoriesId)
{
//, Guid TranscationCategoriesId, Guid TicketPeriodId
try
{
ManufacturersBussinessItemsRepository repo = RepositoryHelper.GetManufacturersBussinessItemsRepository();
database = repo.UnitOfWork;
var matchedresult = repo
.Where(w => w.MaterialCategoriesId == MaterialCategoriesId)
.Distinct()
.ToList();
return(Task.FromResult(ExecuteResultEntity <ICollection <ManufacturersBussinessItems> > .CreateResultEntity(
new Collection <ManufacturersBussinessItems>(matchedresult))));
}
catch (Exception ex)
{
return(Task.FromResult(ExecuteResultEntity <ICollection <ManufacturersBussinessItems> > .CreateErrorResultEntity(ex)));
}
}
public ManufacturersManageController()
{
BussinessItemsRepo = RepositoryHelper.GetManufacturersBussinessItemsRepository(database);
}
