public ContractLoader(string dataFilepath, string schemaFilepath) { Console.WriteLine($"Used data file [{dataFilepath}]"); Console.WriteLine($"Used schema file [{schemaFilepath}]"); /* Clean DB for debug purpose */ db.individuals.RemoveRange(db.individuals); db.subjectRoles.RemoveRange(db.subjectRoles); db.contracts.RemoveRange(db.contracts); db.SaveChanges(); ReadDataFile(dataFilepath, schemaFilepath); }
public async Task AddRangeOfContractsAsync(List <Core.Contract.Contract> contracts) { await _context.Contracts.AddRangeAsync(contracts); _context.SaveChanges(); }
//private readonly ILogger<AddRemoveRequestService> _logger; public void SubmitAddRemoveRequest(AddRemoveRequestCompositeEntity addRemoveRequestCompositeEntity) { try { using (ContractDbContext contractDetailsEntities = new ContractDbContext()) { var config = new MapperConfiguration(cfg => { cfg.CreateMap <ContractAmendmentRequestARDetailsDTO, ContractAmendmentRequestARDetails>(); cfg.CreateMap <UserInfoDTO, UserInfo>(); } ); var mapper = new Mapper(config); //UserInfo userInfo1 = mapper.Map<UserInfo>(addRemoveRequestCompositeEntity.UserInfo); UserInfo userInfo = new UserInfo(); userInfo = GetEntityByDTOKey(addRemoveRequestCompositeEntity.UserInfo); // _logger.LogInformation("Logging from addremoverequestservice"); //UserInfo userInfo = mapper. userMap<UserInfo>(addRemoveRequestCompositeEntity.UserInfo); var customerNumber = addRemoveRequestCompositeEntity.AssociatedSoldTo; //var ContractAmendmentAr = new List<ContractAmendmentRequestARDetails>(); //ContractAmendmentAr = ContractAmendmentRequestARs(addRemoveRequestCompositeEntity); var entityID = userInfo.Entity_ID; var email = userInfo.EMail; ContractAmendmentRequest contractAmendmentRequest = new ContractAmendmentRequest { // ContractAmendmentRequestID = 98373, SubmissionDateTime = System.DateTime.UtcNow, EntityID = entityID, SAPResponseDateTime = System.DateTime.UtcNow, SAPResponseDetails = " ", CustomerNumber = customerNumber, Description = " ", Status = (short)AddRemoveRequestStatus.InProgress, Type = (short)AddRemoveRequestType.AddRemove, LastModifiedDate = System.DateTime.UtcNow, LastModifiedBy = "xyz", IsArchived = false, UserEmail = email, }; // contractDetailsEntities.Entry(contractAmendmentRequest).State = EntityState.Added; //contractDetailsEntities.ContractAmendmentRequest.Add(contractAmendmentRequest); contractDetailsEntities.ContractAmendmentRequest.Add(contractAmendmentRequest); contractDetailsEntities.SaveChanges(); string contractSalesOrg = string.Empty; string sAgreementNumber = string.Empty; //contractAmendmentRequest.ContractAmendmentRequestARDetails = ContractAmendmentRequestARs(addRemoveRequestCompositeEntity); foreach (ContractAmendmentRequestARDetailsDTO contractAmendmentRequestARDetailsDTO in addRemoveRequestCompositeEntity.ContractAddRemoveRequestDetails) { ContractAmendmentRequestARDetails contractAmendmentRequestARDetails = mapper.Map <ContractAmendmentRequestARDetails>(contractAmendmentRequestARDetailsDTO); contractAmendmentRequest.ContractAmendmentRequestARDetails.Add(contractAmendmentRequestARDetails); //contractDetailsEntities.Entry(contractAmendmentRequestARDetails).State = EntityState.Added; //contractDetailsEntities.ContractAmendmentRequestARDetails.Add(contractAmendmentRequestARDetails); //contractAmendmentRequest.ContractAmendmentRequestARDetails.Add(contractAmendmentRequestARDetails); } contractDetailsEntities.Entry(contractAmendmentRequest).State = EntityState.Modified; try { contractDetailsEntities.SaveChanges(); } catch (Exception e) { throw e; } //Send SAP request ContractAmendmentSAPService contractAmendmentSAPServices = new ContractAmendmentSAPService(); AddRemoveRequestSAPResponse addRemoveRequestSAPResponse = null; try { addRemoveRequestSAPResponse = contractAmendmentSAPServices.SendSAPRequest(addRemoveRequestCompositeEntity.ContractAddRemoveRequestDetails).GetAwaiter().GetResult(); } catch (Exception ex) { addRemoveRequestSAPResponse = CreateFailureSAPResponse(addRemoveRequestCompositeEntity.ContractAddRemoveRequestDetails, sAgreementNumber); // objlog.LogException(ex, -1, null, "AddRemoveRequestService", System.Diagnostics.TraceEventType.Error, "", "SubmitAddRemoveRequest"); // LogHelper.LogExceptionMessage(ex); //logger.LogException(ex); } finally { UpdateSAPResponse(contractAmendmentRequest, addRemoveRequestSAPResponse); // persist the changes to database. contractDetailsEntities.SaveChanges(); } } } catch (Exception ex) { throw ex; } }