public static ReferenceTable Create() { ReferenceTable t = new ReferenceTable(); t.ReferenceTableValues = new List <ReferenceTableValue>(); list.Add(":1234567890=≠≤!["); list.Add(" /STUVWXYZ],(→≡~"); list.Add("-JKLMNOPQR%$*↑↓>"); list.Add("+ABCDEFGHI<.)≥?;"); for (int row = 0; row <= 3; row++) { for (int col = 0; col <= 15; col++) { char cc = list[row].Substring(col, 1).ToCharArray()[0]; ReferenceTableValue rf = new ReferenceTableValue( String.Format("{0:X}", row), String.Format("{0:X}", col), cc); t.ReferenceTableValues.Add(rf); } } return(t); }
private static void AddTestData(DIAContext context) { var testUser1 = new Claim { ClaimIDNumber = "DI1000000001", ClaimTypeCode = 1639, ClaimantID = 1, EffectiveDate = Convert.ToDateTime("1/25/2017") }; context.Claims.Add(testUser1); var testUser2 = new Claim { ClaimIDNumber = "DI1000000002", ClaimTypeCode = 1639, ClaimantID = 2, EffectiveDate = Convert.ToDateTime("2/25/2017") }; context.Claims.Add(testUser2); var testUser3 = new Claim { ClaimIDNumber = "DI1000000003", ClaimTypeCode = 1639, ClaimantID = 2, Id = 4, EffectiveDate = Convert.ToDateTime("3/25/2017") }; context.Claims.Add(testUser3); context.SaveChanges(); var testUser4 = new Person { Id = 1, DOB = Convert.ToDateTime("3/25/1997"), FirstName = "John", LastName = "Doe", ECN = "00023333", Email = "*****@*****.**" }; context.Persons.Add(testUser4); context.SaveChanges(); var testUser5 = new PersonPhoneNumber { PersonID = 1, PhoneNumber = "111-222-3333", PhoneNumberTypeCode = 440, IsPrimary = true, }; context.PersonPhoneNumbers.Add(testUser5); context.SaveChanges(); var testUser5a = new PersonPhoneNumber { PersonID = 1, PhoneNumber = "124-222-3333", PhoneNumberTypeCode = 439, IsPrimary = false, }; context.PersonPhoneNumbers.Add(testUser5a); context.SaveChanges(); var testUser6 = new PersonAddress { PersonID = 1, AddressLine1 = "123 main st", City = "fremont", StateCode = 361, ZipCode = "94539", AddressTypeCode = 438 }; context.PersonAddresses.Add(testUser6); context.SaveChanges(); var testUser7 = new PersonAddress { PersonID = 1, AddressLine1 = "456 main st", City = "sacramento", StateCode = 361, ZipCode = "93539", AddressTypeCode = 437 }; context.PersonAddresses.Add(testUser7); context.SaveChanges(); var locale1 = new LocalizationRecord { Key = "abouttitle", ResourceKey = "PersonController", Text = "this is a test", LocalizationCulture = "en-US" }; context.LocalizationRecords.Add(locale1); context.SaveChanges(); var reftable = new ReferenceTable { TableName = "Claim_Type" }; context.ReferenceTables.Add(reftable); context.SaveChanges(); //int refid = reftable.Id; var reftablevalue = new ReferenceTableValue { TableName = "Claim_Type", Key = "Disability Claim" }; context.ReferenceTableValues.Add(reftablevalue); var reftablevalue2 = new ReferenceTableValue { TableName = "Claim_Type", Key = "PFL Claim" }; var reftablevalue3 = new ReferenceTableValue { TableName = "Job_Category", Key = "light", Text = "lightxxxxxxxxxxxxxxxxxx" }; var reftablevalue4 = new ReferenceTableValue { TableName = "Job_Category", Key = "medium", Text = "medium cccccccccccccccccccccccccccccc" }; var reftablevalue5 = new ReferenceTableValue { TableName = "Job_Category", Key = "heavy" }; var reftablevalue6 = new ReferenceTableValue { TableName = "State_Code", Key = "CA", Id = 361 }; var reftablevalue7 = new ReferenceTableValue { TableName = "State_Code", Key = "NY", Id = 362 }; var reftablevalue8 = new ReferenceTableValue { TableName = "State_Code", Key = "Name", Text = "Name in Italien", ResourceKey = "PersonController", LocalizationCulture = "en-US" }; ReferenceTableValue reftablevalue9 = new ReferenceTableValue() { TableName = "State_Code", Key = "Name", Text = "Name in english", ResourceKey = "PersonController", LocalizationCulture = "es-MX" }; context.ReferenceTableValues.Add(reftablevalue2); context.ReferenceTableValues.Add(reftablevalue3); context.ReferenceTableValues.Add(reftablevalue4); context.ReferenceTableValues.Add(reftablevalue5); context.ReferenceTableValues.Add(reftablevalue6); context.ReferenceTableValues.Add(reftablevalue7); context.ReferenceTableValues.Add(reftablevalue8); context.ReferenceTableValues.Add(reftablevalue9); context.SaveChanges(); }