public Task <CertificationRM> GetCertificationForOperatingContext(int associateId, int operatingContextId, int certificationId) { ValidateAssociateExists(associateId); OperatingContext operatingContext = ValidateOperatingContextExists(operatingContextId); return(Task.FromResult(_mapper.Map <Certification, CertificationRM>( _context.Certifications.SingleOrDefault(c => c.Id == operatingContext.CertificationId && c.Id == certificationId)))); }
public async void AddAssociateOperatingContext(Associate associate, OperatingContext operatingContext) { int operatingContextId = _context.OperatingContexts.ToList().Last().Id; AssociateOperatingContext association = new AssociateOperatingContext(associate.Id, operatingContextId); _context.AssociateOperatingContexts.Add(association); await _context.SaveChangesAsync(); }
private void UpdateOperatingContext(Commands.V1.OperatingContext.Update cmd) { OperatingContext operatingContext = _repository.GetOperatingContext(cmd.OperatingContextId); if (operatingContext == null) { throw new InvalidOperationException($"OperatingContext with id {cmd.OperatingContextId} cannot be found"); } _repository.UpdateOperatingContext(operatingContext); }
public bool CertificationExistsForOperatingContext(Certification certification, int operatingContextId) { OperatingContext operatingContext = _context.OperatingContexts.FirstOrDefault(oc => oc.Id == operatingContextId); if (operatingContext == null) { return(false); } return(operatingContext.CertificationId != null); }
public void AddCertificationForOperatingContext(Certification certification, int operatingContextId) { OperatingContext operatingContext = _context.OperatingContexts.SingleOrDefault(oc => oc.Id == operatingContextId); if (operatingContext == null) { throw new InvalidOperationException("OperatingContext not found."); } operatingContext.Certification = certification; }
private OperatingContext ValidateOperatingContextExists(int operatingContextId) { OperatingContext operatingContext = _context.OperatingContexts.SingleOrDefault(a => a.Id == operatingContextId); if (operatingContext == null) { throw new InvalidOperationException("OperatingContext not found."); } return(operatingContext); }
private OperatingContextRM CreateOperatingContextForCustomer(Commands.V1.OperatingContext.CreateForCustomer cmd) { OperatingContext operatingContext = new OperatingContext(_operatingContexts++, OperatingContextTypeLookup.OperatingContextTypes[cmd.OperatingContextType], cmd.FacilityId, cmd.ThirdPartySupplierId, ExternalAssociateTypeLookup.ActingAssociateTypes[cmd.ActingBATypeID], cmd.CertificationId, cmd.IsDeactivating, cmd.LegacyId, cmd.PrimaryAddressId, cmd.PrimaryEmailId, cmd.PrimaryPhoneId, cmd.ProviderType, cmd.StartDate, StatusCodeLookup.StatusCodes[cmd.Status]); if (_repository.OperatingContextExistsForCustomer(operatingContext, cmd.CustomerId)) { throw new InvalidOperationException($"Operating context already exists for Customer {cmd.CustomerId}"); } _repository.AddOperatingContextForCustomer(operatingContext, cmd.CustomerId); return(Conversions.GetOperatingContextRM(operatingContext)); }
private OperatingContextRM CreateOperatingContextForAssociate(Commands.V1.OperatingContext.CreateForAssociate cmd) { Associate associate = _repository.GetAssociate(AssociateId.FromInt(cmd.AssociateId)); if (associate == null) { throw new InvalidOperationException($"Associate with id {cmd.AssociateId} cannot be found"); } OperatingContext operatingContext = new OperatingContext(_operatingContexts++, OperatingContextTypeLookup.OperatingContextTypes[cmd.OperatingContextType], cmd.FacilityId, cmd.ThirdPartySupplierId, ExternalAssociateTypeLookup.ActingAssociateTypes[cmd.ActingBATypeID], cmd.CertificationId, cmd.IsDeactivating, cmd.LegacyId, cmd.PrimaryAddressId, cmd.PrimaryEmailId, cmd.PrimaryPhoneId, cmd.ProviderType, cmd.StartDate, StatusCodeLookup.StatusCodes[cmd.Status]); _repository.AddOperatingContextForAssociate(operatingContext, associate.Id); return(Conversions.GetOperatingContextRM(operatingContext)); }
public void AddOperatingContext(AssociateId id, OperatingContext entity) { using SqlCommand cmd = Db.Connection.CreateCommand(); Db.Connection.Open(); cmd.Transaction = Db.Connection.BeginTransaction("AddOperatingContext"); try { cmd.CommandText = "insert into OperatingContext(ActingBATypeId, CertificationId, FacilityId, IsDeactivating, LegacyId, OperatingContextTypeId, ProviderTypeId) VALUES( " + "@ActingBATypeId, @CertificationId, @FacilityId, @IsDeactivating, @LegacyId, @OperatingContextTypeId, @ProviderTypeId)"; cmd.Parameters.AddWithValue("@ActingBATypeId", (int)entity.ActingBAType); cmd.Parameters.AddWithValue("@CertificationId", entity.CertificationId.Value); cmd.Parameters.AddWithValue("@FacilityId", entity.FacilityId.Value); cmd.Parameters.AddWithValue("@IsDeactivating", entity.IsDeactivating); cmd.Parameters.AddWithValue("@LegacyId", entity.LegacyId); cmd.Parameters.AddWithValue("@OperatingContextTypeId", (int)entity.OperatingContextType); cmd.Parameters.AddWithValue("@ProviderTypeId", (int)entity.ProviderType); int operatingContextId = (int)cmd.ExecuteScalar(); cmd.CommandText = "INSERT INTO AssociateOperatingContext (AssociateId, OperatingContextId) VALUES ( " + "@AssociateId, @OperatingContextId)"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@AssociateId", id); cmd.Parameters.AddWithValue("@OperatingContextId", operatingContextId); cmd.ExecuteNonQuery(); cmd.Transaction.Commit(); } catch (Exception) { cmd.Transaction.Rollback(); throw; } }
public static OperatingContextRM GetOperatingContextRM(OperatingContext operatingContext) { // ReSharper disable once UseObjectOrCollectionInitializer OperatingContextRM operatingContextRM = new OperatingContextRM(); operatingContextRM.Id = operatingContext.Id; operatingContextRM.ActingBAType = operatingContext.ActingBATypeId; operatingContextRM.CertificationId = operatingContext.CertificationId; operatingContextRM.FacilityId = operatingContext.FacilityId; operatingContextRM.IsDeactivating = operatingContext.IsDeactivating; operatingContextRM.LegacyId = operatingContext.LegacyId; operatingContextRM.OperatingContextType = operatingContext.OperatingContextTypeId; operatingContextRM.PrimaryAddress = operatingContext.PrimaryAddressId; operatingContextRM.PrimaryEmail = operatingContext.PrimaryEmailId; operatingContextRM.PrimaryPhone = operatingContext.PrimaryPhoneId; operatingContextRM.ProviderType = operatingContext.ProviderTypeId; operatingContextRM.StartDate = operatingContext.StartDate; operatingContextRM.Status = operatingContext.StatusCodeId; operatingContextRM.ThirdPartySupplierId = operatingContext.ThirdPartySupplierId; return(operatingContextRM); }
public void AddOperatingContextForAssociate(OperatingContext operatingContext, int associateId) { try { _context.OperatingContexts.Add(operatingContext); _context.AssociateOperatingContexts.Add(new AssociateOperatingContext { OperatingContextId = operatingContext.Id, AssociateId = associateId }); } catch { OperatingContext toRemove = _context.OperatingContexts.SingleOrDefault(oc => oc.Id == operatingContext.Id); if (toRemove != null) { _context.OperatingContexts.Remove(toRemove); } throw; } }
public void AddOperatingContextForCustomer(OperatingContext operatingContext, int customerId) { _context.OperatingContextCustomers.Add(new OperatingContextCustomer(customerId, operatingContext.Id)); }
public void AddOperatingContext(OperatingContext operatingContext) { _context.OperatingContexts.Add(operatingContext); _context.SaveChanges(); }
public void UpdateOperatingContext(OperatingContext operatingContext) { _context.OperatingContexts[operatingContext.Id] = operatingContext; }
public bool OperatingContextExistsForAssociate(OperatingContext operatingContext, int associateId) { return(_context.AssociateOperatingContexts.Exists(aoc => aoc.AssociateId == associateId && aoc.AssociateId == associateId)); }
public bool OperatingContextExistsForCustomer(OperatingContext operatingContext, int customerId) { return(_context.OperatingContextCustomers.Exists(occ => occ.OperatingContextId == operatingContext.Id && occ.CustomerId == customerId)); }
public void AddOperatingContext(OperatingContext operatingContext) { _context.OperatingContexts.Add(operatingContext); }