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