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