public IActionResult Get(Guid id) { try { var file = _contractRefactorService.GetFileByResourceGuid(id, Core.Entities.EnumGlobal.ResourceType.LaborCategoryRates.ToString()); var model = _mapper.Map <LaborCategoryRatesViewModel>(file); if (model != null) { var filePath = $"{documentRoot}{model.FilePath}"; var data = CsvValidationHelper.ReadFile(filePath, (Models.ViewModels.EnumGlobal.UploadMethodName)UploadMethodName.SubcontractorLaborBillingRates); var listdata = data.Select(x => new { ContractGuid = id, SubContractor = x.SubContractor, LaborCode = x.LaborCode, EmployeeName = x.EmployeeName, Rate = x.Rate, StartDate = x.StartDate, EndDate = x.EndDate }).ToList(); return(Json(new { data = listdata })); } IEnumerable <dynamic> nullList = new List <dynamic>(); return(Json(new { data = nullList })); } catch (Exception ex) { ModelState.AddModelError(ex.ToString(), ex.Message); return(BadRequest(ModelState)); } }
public IActionResult Get(Guid id) { try { //var model = _employeeBillingRatesService.GetEmployeeBillingRatesById(id); var file = _contractRefactorService.GetFileByResourceGuid(id, Core.Entities.EnumGlobal.ResourceType.EmployeeBillingRates.ToString()); if (file != null) { var model = ContractsMapper.MapContractFilesToEmployeeBillingRatesViewModel(file); var filePath = $"{documentRoot}/{model.FilePath}"; var contractViewModels = CsvValidationHelper.ReadFile(filePath, (Models.ViewModels.EnumGlobal.UploadMethodName)UploadMethodName.EmployeeBillingRate); var data = contractViewModels.Select(x => new { ContractGuid = id, LaborCode = x.LaborCode, EmployeeName = x.EmployeeName, Rate = x.Rate, StartDate = x.StartDate, EndDate = x.EndDate }).ToList(); return(Json(new { data = data })); } return(Json(new { data = new List <dynamic>() })); } catch (Exception ex) { ModelState.AddModelError(ex.ToString(), ex.Message); return(BadRequest(ModelState)); } }
public IActionResult Get(Guid id) { try { var file = _contractRefactorService.GetFileByResourceGuid(id, Core.Entities.EnumGlobal.ResourceType.WorkBreakDownStructure.ToString()); if (file != null) { var model = _mapper.Map <ContractWBSViewModel>(file); var filePath = $"{documentRoot}/{model.FilePath}"; var data = CsvValidationHelper.ReadFile(filePath, (Models.ViewModels.EnumGlobal.UploadMethodName)UploadMethodName.WorkBreakDownStructure); var listdata = data.Select(x => new { ContractGuid = id, WBSCode = x.WBSCode, Description = x.Description, Value = x.Value, ContractType = x.ContractType, InvoiceAtThisLevel = x.InvoiceAtThisLevel }).ToList(); return(Json(new { data = listdata })); } return(Json(new { data = new List <dynamic>() })); } catch (Exception ex) { ModelState.AddModelError(ex.ToString(), ex.Message); return(BadRequest(ModelState)); } }