private async Task <ChemicalDto> AddInk(ChemicalForImportExcelDto chemicalDto) { var result = new ChemicalDto(); using (var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted }, TransactionScopeAsyncFlowOption.Enabled)) { var supname = await _repoSup.FindAll().FirstOrDefaultAsync(x => x.Name.ToUpper().Equals(chemicalDto.Supplier.ToUpper())); if (supname != null) { result.SupplierID = supname.ID; } else { } var process = await _repoProcess.FindAll().FirstOrDefaultAsync(x => x.Name.ToUpper().Equals(chemicalDto.Process.ToUpper())); if (process != null) { result.ProcessID = process.ID; } else { } // result.CreatedBy = inkDto.CreatedBy; scope.Complete(); return(result); } }
// GET: ProductsController/Create //public ActionResult Create() //{ // return View(); //} public ActionResult Create() { var suppliers = _SupplierRepo.FindAll() .Select(q => new SelectListItem { Text = q.CompanyName, Value = q.Id.ToString() }); var model = new ProductViewModel { Suppliers = suppliers }; return(View(model)); }
public async Task <List <ScheduleUpdateDto> > GetDetailSchedule(int scheduleID) { var nameProcess = _repoScheduleUpdate.FindAll().FirstOrDefault(x => x.ID == scheduleID).Treatment; var idProcess = _repoProcess.FindAll().FirstOrDefault(x => x.Name == nameProcess).ID; var lists = await _repoScheduleUpdate.FindAll() .Where(x => x.ID == scheduleID) .ProjectTo <ScheduleUpdateDto>(_configMapper) .OrderByDescending(x => x.ID).Select(x => new ScheduleUpdateDto { ID = x.ID, ModelName = x.ModelName, ModelNo = x.ModelNo, Part = x.Part, ArticleNo = x.ArticleNo, Treatment = x.Treatment, Process = x.Process, ApprovalStatus = x.ApprovalStatus, FinishedStatus = x.FinishedStatus, CreatedDate = x.CreatedDate, UpdateTime = x.UpdateTime, CreatedBy = x.CreatedBy, ProductionDate = x.ProductionDate, EstablishDate = x.EstablishDate, Parts = _repoPart.FindAll().Where(y => y.ScheduleID == scheduleID).ToList(), Supplier = _repoSup.FindAll().Where(y => y.ProcessID == idProcess && y.isShow == true).ToList(), TreatmentWay = _repoTreatmentWay.FindAll().Where(y => y.processID == idProcess).ToList() }).ToListAsync(); return(lists); }
public async Task <string> AddRangeAsync(List <IngredientForImportExcelDto> model) { var suppliers = await _repoSupplier.FindAll().ToListAsync(); var ingredientList = _repoIngredient.FindAll(); string error = string.Empty; foreach (var item in model) { var checkMaterial = ingredientList.FirstOrDefault(x => x.MaterialNO.Equals(item.MaterialNO)); var checkName = ingredientList.FirstOrDefault(x => x.Name.Equals(item.Name)); if (checkMaterial != null) { error = $"Material# {item.MaterialNO} already exists in the database"; break; } if (checkName != null) { error = $"Ingredient Name {item.Name} already exists in the database"; break; } } if (error != string.Empty) { return(error); } model.ForEach(item => { item.isShow = true; var supply = suppliers.FirstOrDefault(x => x.Name.ToLower().Equals(item.SupplierName.ToSafetyString().ToLower())); item.SupplierID = supply != null ? supply.ID : 0; }); var ingredients = _mapper.Map <List <Ingredient> >(model); _repoIngredient.AddRange(ingredients); try { await _repoIngredient.SaveAll(); return("ok"); } catch { return("Error"); } }
public GetAllSupplierResponse GetAllSuppliers() { GetAllSupplierResponse response = new GetAllSupplierResponse(); IEnumerable <Supplier> suppliers = _supplierRepository .FindAll(); if (suppliers != null) { response.SupplierFound = true; response.Suppliers = suppliers.ConvertToSupplierViews(); } else { response.SupplierFound = false; } return(response); }
// GET: SupplierController public ActionResult Index() { var suppliers = _repo.FindAll().ToList(); var parishes = _parishRepo.FindAll() .Select(q => new SelectListItem { Text = q.Parishes, Value = q.Id.ToString() });; var model = _mapper.Map <List <Supplier>, List <SupplierViewModel> >(suppliers); return(View(model)); // var DeliveryStatus = _repo.FindAll(); //var DeliveryModel = _mapper.Map<List<SupplierViewModel>>(DeliveryStatus); //var model = new DeliveryStatusViewModel //{ // TotalDelivery = DeliveryModel.Count, // Delivered = DeliveryModel.Count(q => q.Approved == true), // PendingDelivery = DeliveryModel.Count(q => q.Approved == null), // NotDelivered = DeliveryModel.Count(q => q.Approved == false) // //Products = DeliveryModel //}; // return View(model); //var SupplierModel = _mapper.Map<List<SupplierViewModel>>(suppliers); //var model1 = new DeliveryStatusViewModel // return View(model); //{ // TotalDelivery = SupplierModel.Count, // PendingDelivery = SupplierModel.Count(q => q.Approved == null), // NotDelivered = SupplierModel.Count(q => q.Approved == false), // //suppliers = SupplierModel //}; //return View(model); }
//Lấy danh sách Brand và phân trang public async Task <PagedList <SuppilerDto> > GetWithPaginations(PaginationParams param) { var lists = _repoLine.FindAll().ProjectTo <SuppilerDto>(_configMapper).OrderBy(x => x.ID); return(await PagedList <SuppilerDto> .CreateAsync(lists, param.PageNumber, param.PageSize)); }
public List <SupplierModel> GetAll() { List <Supplier> data = _supplierRepository.FindAll(a => a.IsActive).ToList(); return(data.ConvertToListModel().ToList()); }