public static void AddNewConsumerRow(TestConsumerModel consumer) { aeghealthEntities context = new aeghealthEntities(); tblConsumer consumerdata = new tblConsumer() { ConsumerID = consumer.ConsumerID, GroupID = consumer.GroupID, LN = consumer.LN, FN = consumer.FN, MI = consumer.MI, LNSoundex = consumer.LNSoundex, MlAddr1 = consumer.MlAddr1, MlCity = consumer.MlCity, MlState = consumer.MlState, MlZip = consumer.MlZip, AcTel = consumer.AcTel, Tel = consumer.Tel, C_SSN = consumer.C_SSN, DOB = consumer.DOB, bChildren = consumer.bChildren, MaritalStatusID = consumer.MaritalStatusID, bFamilyIns = consumer.bFamilyIns, bHasDr = consumer.bHasDr, DrLocCit = consumer.DrLocCit, DrLocSt = consumer.DrLocSt, Gender = consumer.Gender, EmploymentStatusID = consumer.EmploymentStatusID, CreatedByID = consumer.CreatedByID }; context.tblConsumers.Add(consumerdata); context.SaveChanges(); }
private IList <TestConsumerModel> HydrateConsumerValues() { var returnList = new List <TestConsumerModel>(); var consumerData = new TestConsumerModel { GroupID = 12345, LN = "Mctest", FN = "Tester", MI = "T", LNSoundex = "Sdn", MlAddr1 = "123 Test St", MlCity = "Nashville", MlState = "TN", MlZip = "37211", AcTel = "615", Tel = "615", C_SSN = "123456789", DOB = Convert.ToDateTime("1/1/1982"), bChildren = 0, MaritalStatusID = 113, bFamilyIns = 1, bHasDr = 1, DrLocCit = "Nashville", DrLocSt = "TN", Gender = "M", EmploymentStatusID = 18, bFamHisCancer = 0, bFamHisHd = 0, bFamHisDiabetes = 0, InsCarrier = "Testinsurace", CreatedByID = 68, Update_SSN = "123121234", Update_MlAddr1 = "124 Updated St" }; returnList.Add(consumerData); return(returnList); }