public static JournalQueryOperationList GetJournal(string sTrackingID)
{
List <Journal> lstJournals;
JournalQueryOperationList queryResult;
JournalQueryOperation operationAux;
using (JournalContext dbConText = new JournalContext())
{
lstJournals = dbConText.Journal.Where(j => j.TrackingId.Equals(sTrackingID)).ToList();
queryResult = new JournalQueryOperationList();
queryResult.Operations = new List <JournalQueryOperation>();
foreach (Journal journal in lstJournals)
{
operationAux = new JournalQueryOperation()
{
Operation = journal.Operation,
Calculation = journal.Calculation,
Date = journal.Date.ToString()
};
queryResult.Operations.Add(operationAux);
}
}
return(queryResult);
}
public static void SetJournal(string sTrackingId, IOperation oOperacion, IOperationResult oResult)
{
using (JournalContext dbConText = new JournalContext())
{
Journal oJournal = new Journal()
{
TrackingId = sTrackingId,
Calculation = string.Format("{0}{1}", oOperacion.GetCalculation(), oResult.GetResult()),
Operation = oOperacion.GetOperation(),
Date = DateTime.Now
};
dbConText.Journal.Add(oJournal);
dbConText.SaveChanges();
}
}
