/// <summary>
/// Delete all the dependencies of this visit
/// </summary>
/// <param name="id">ID of the Visit</param>
public static void DeleteDependencies(long id)
{
var ctx = new DataClassesDataContext();
// Visit's dependencies are Prescription and LabOrder
// delete all LabOrder
var labOrders = from l in ctx.LabOrders
where l.VisitID == id
select l;
foreach (var labOrder in labOrders)
{
LabOrderOperations.DeleteDependencies(labOrder.ID);
}
ctx.LabOrders.DeleteAllOnSubmit(labOrders);
//delete all Prescription
var prescriptions = from p in ctx.Prescriptions
where p.VisitID == id
select p;
foreach (var prescription in prescriptions)
{
PrescriptionOperations.DeleteDependencies(prescription.ID);
}
ctx.Prescriptions.DeleteAllOnSubmit(prescriptions);
//submit all changes
ctx.SubmitChanges();
}
public static void DeleteDependencies(long id)
{
var ctx = new DataClassesDataContext();
// doctor's dependencies are visit and lab order
// delete all visits
var visits = from v in ctx.Visits
where v.DoctorID == id
select v;
foreach (var visit in visits)
{
VisitOperations.DeleteDependencies(visit.ID);
}
ctx.Visits.DeleteAllOnSubmit(visits);
// delete all lab orders
var labOrders = from l in ctx.LabOrders
where l.DoctorID == id
select l;
foreach (var labOrder in labOrders)
{
LabOrderOperations.DeleteDependencies(labOrder.ID);
}
ctx.LabOrders.DeleteAllOnSubmit(labOrders);
// submit changes
ctx.SubmitChanges();
}
protected void LabOrderInfoFormView_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
System.Threading.Thread.Sleep(1000);
// delete all this lab order's dependencies
LabOrderOperations.DeleteDependencies(long.Parse(e.Keys["ID"].ToString()));
}
protected void LabOrderFormView_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
// delete all this lab order dependencies
LabOrderOperations.DeleteDependencies(long.Parse(e.Keys["ID"].ToString()));
}
