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