void saveTransmissionInfo(int recordCount)
{
using(OluContext oluContext = new OluContext())
{
transmissionFile.RecordCount = recordCount;
transmissionFile.SentToOpmdate = DateTime.Now;
oluContext.EhriTransmissionfile.Add(transmissionFile);
oluContext.SaveChanges();
}
}
public void UpdateCount(int processedCount)
{
using (OluContext db = new OluContext())
{
var trainingRecord = (from t in db.EhriTrainingfileinfo
where t.TrainingFileInfoId == FileID
select t).First();
trainingRecord.SavedRecordCount = processedCount;
db.SaveChanges();
}
}
private void addFile(string fileName)
{
FileID = Guid.NewGuid().ToString();
EhriTrainingfileinfo tf = new EhriTrainingfileinfo();
tf.TrainingFileInfoId = FileID;
tf.FileName = fileName;
tf.Loaded = DateTime.Now;
tf.FileRecordCount = getFileRecordCount(fileName);
using (OluContext db = new OluContext())
{
db.EhriTrainingfileinfo.Add(tf);
db.SaveChanges();
}
}
public void Write()
{
Logger.Log.Record("Preparing records for EHRI Transmission");
int recordsToSendCount = 0;
using(OluContext oluContext = new OluContext())
{
List<EhriTraining> records = (from t in oluContext.EhriTraining
where t.ProcessStatus == "R"
select t).ToList();
recordsToSendCount = records.Count;
xmlWriter.WriteEhriFile(records,fileName);
foreach(EhriTraining record in records)
{
record.TransmissionFileId = transmissionFile.TransmissionFileId;
record.LastUpdatedDate = DateTime.Now;
record.ProcessStatus = "S";
oluContext.EhriTraining.Update(record);
}
oluContext.SaveChanges();
}
saveTransmissionInfo(recordsToSendCount);
Logger.Log.Record("EHRI Transmission records updated");
}
