static void ProcessClaimsUsingEntityFramework() { try { object dataDir = AppDomain.CurrentDomain.GetData("DataDirectory"); if (dataDir == null) { AppDomain.CurrentDomain.SetData("DataDirectory", Directory.GetCurrentDirectory()); } AutoClaimSQL sql = new AutoClaimSQL(); XmlSerializer xmlSerializer = new XmlSerializer(typeof(MitchellClaimType)); MitchellClaimType claim = new MitchellClaimType(); string[] files = Directory.GetFiles("../../NewClaims", "*.xml"); foreach (string fileName in files) { using (StreamReader reader = new StreamReader(fileName)) { claim = (MitchellClaimType)xmlSerializer.Deserialize(reader); sql.NewClaim(claim); } } claim = sql.ReadClaim(claim.ClaimNumber); files = Directory.GetFiles("../../ClaimUpdates", "*.xml"); foreach (string fileName in files) { using (StreamReader reader = new StreamReader(fileName)) { MitchellClaimType claimUpdates = (MitchellClaimType)xmlSerializer.Deserialize(reader); sql.UpdateClaim(claimUpdates); } } claim = sql.ReadClaim(claim.ClaimNumber); foreach (var c in sql.FindClaims(claim.LossDate, DateTime.UtcNow)) { Console.WriteLine(c); } foreach (var c in sql.FindClaims(claim.LossDate + TimeSpan.FromDays(1), DateTime.UtcNow)) { Console.WriteLine(c); // should not get here } sql.DeleteClaim(claim.ClaimNumber); claim = sql.ReadClaim(claim.ClaimNumber); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
static void ProcessClaimsUsingEntityFramework() { try { object dataDir = AppDomain.CurrentDomain.GetData("DataDirectory"); if (dataDir == null) AppDomain.CurrentDomain.SetData("DataDirectory", Directory.GetCurrentDirectory()); AutoClaimSQL sql = new AutoClaimSQL(); XmlSerializer xmlSerializer = new XmlSerializer(typeof(MitchellClaimType)); MitchellClaimType claim = new MitchellClaimType(); string[] files = Directory.GetFiles("../../NewClaims", "*.xml"); foreach (string fileName in files) { using (StreamReader reader = new StreamReader(fileName)) { claim = (MitchellClaimType)xmlSerializer.Deserialize(reader); sql.NewClaim(claim); } } claim = sql.ReadClaim(claim.ClaimNumber); files = Directory.GetFiles("../../ClaimUpdates", "*.xml"); foreach (string fileName in files) { using (StreamReader reader = new StreamReader(fileName)) { MitchellClaimType claimUpdates = (MitchellClaimType)xmlSerializer.Deserialize(reader); sql.UpdateClaim(claimUpdates); } } claim = sql.ReadClaim(claim.ClaimNumber); foreach (var c in sql.FindClaims(claim.LossDate, DateTime.UtcNow)) Console.WriteLine(c); foreach (var c in sql.FindClaims(claim.LossDate + TimeSpan.FromDays(1), DateTime.UtcNow)) Console.WriteLine(c); // should not get here sql.DeleteClaim(claim.ClaimNumber); claim = sql.ReadClaim(claim.ClaimNumber); } catch (Exception ex) { Console.WriteLine(ex.Message); } }