public Task When_organizations_are_imported() { var data = _fixture .CreateMany <ImportedOrganization>(new Random().Next(1, 100)) .Select((@event, i) => { var expected = new OrganizationRecord { Id = i + 1, Code = @event.Code, SortableCode = Editor.Projections.OrganizationRecordProjection.GetSortableCodeFor(@event.Code), DbaseRecord = new OrganizationDbaseRecord { ORG = { Value = @event.Code }, LBLORG = { Value = @event.Name } }.ToBytes(_services.MemoryStreamManager, Encoding.UTF8) }; return(new { ImportedOrganization = @event, Expected = expected }); }).ToList(); return(new RoadRegistry.Product.Projections.OrganizationRecordProjection(new RecyclableMemoryStreamManager(), Encoding.UTF8) .Scenario() .Given(data.Select(d => d.ImportedOrganization)) .Expect(data.Select(d => d.Expected))); }
public OrganizationRecordProjection(RecyclableMemoryStreamManager manager, Encoding encoding) { if (manager == null) { throw new ArgumentNullException(nameof(manager)); } if (encoding == null) { throw new ArgumentNullException(nameof(encoding)); } When <Envelope <ImportedOrganization> >(async(content, envelope, token) => { var organization = new OrganizationRecord { Code = envelope.Message.Code, SortableCode = GetSortableCodeFor(envelope.Message.Code), DbaseRecord = new OrganizationDbaseRecord { ORG = { Value = envelope.Message.Code }, LBLORG = { Value = envelope.Message.Name }, }.ToBytes(manager, encoding) }; await content.AddAsync(organization, token); }); }
public ArrayList getAllOrgization() { SQL = "SELECT org_account_number,ISNULL(dba_name,'') as dba_name," + "RTRIM(ISNULL(class_code,'')) as class_code FROM organization " + "WHERE elt_account_number = " + elt_account_number + " and isnull(dba_name,'') <> '' order by dba_name"; DataSet ds = new DataSet(); ArrayList lst = new ArrayList(); try { SqlDataAdapter ad = new SqlDataAdapter(SQL, Con); ad.Fill(ds); GeneralUtility util = new GeneralUtility(); util.removeNull(ref ds, 0); OrganizationRecord org1 = new OrganizationRecord(); org1.Dba_name = "Select"; org1.Org_account_number = -1; lst.Add(org1); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { OrganizationRecord org = new OrganizationRecord(); org.Org_account_number = Int32.Parse(ds.Tables[0].Rows[i]["org_account_number"].ToString()); org.Dba_name = ds.Tables[0].Rows[i]["dba_name"].ToString(); org.Class_code = ds.Tables[0].Rows[i]["class_code"].ToString(); lst.Add(org); } } catch (Exception ex) { throw ex; } return(lst); }