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