public static PatientDocument[] GetPatientFileDetails(Patient patient)
{
EntityModelContainer context = new EntityModelContainer(GetEntityConnection());
PatientDocument[] result = context.PatientDocuments.Execute(MergeOption.NoTracking).Where(pd => pd.PatientId == patient.Id).ToArray();
for (int i = 0; i < result.Length; i++)
{
int id = result[i].Id;
DocumentStickyNote[] documentStickyNotes =
context.DocumentStickyNotes.Execute(MergeOption.NoTracking).Where(sn => sn.PatientDocumentId == id).ToArray();
if (documentStickyNotes.Length!=0)
result[i].DocumentStickyNotes.AddRange(documentStickyNotes);
}
context.Dispose();
return result;
}
public static void BeginTransaction()
{
StackFrame stackFrame = new StackFrame(1);
MethodBase callerMethod = stackFrame.GetMethod();
Type callerType = callerMethod.DeclaringType;
if (!_listContext.ContainsKey(callerType))
{
EntityModelContainer context = new EntityModelContainer(GetEntityConnection());
context.ContextOptions.LazyLoadingEnabled = true;
_listContext.Add(callerType, context);
context.SavingChanges += new EventHandler(context_SavingChanges);
}
}
private static int GetAccountantSerialByColumnName(string columnName)
{
EntityModelContainer context = new EntityModelContainer(GetEntityConnection());
ObjectResult<int?> serial = context.AccountantPagesCounterIncrementor(columnName);
return serial.First().Value;
}