protected void VisitDetailsFormView_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
System.Threading.Thread.Sleep(1000);
// delete all its dependencies first
VisitOperations.DeleteDependencies(long.Parse(e.Keys["ID"].ToString()));
}
protected void VisitsFromPatientGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
System.Threading.Thread.Sleep(1000);
// delete all its dependencies
VisitOperations.DeleteDependencies(long.Parse(e.Keys["ID"].ToString()));
}
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();
}
public static void DeleteDependencies(long id)
{
var ctx = new DataClassesDataContext();
// Hospital dependencies are Visits
// delete all visits
var visits = from v in ctx.Visits
where v.HospitalID == id
select v;
foreach (var visit in visits)
{
VisitOperations.DeleteDependencies(visit.ID);
}
ctx.Visits.DeleteAllOnSubmit(visits);
// submit changes
ctx.SubmitChanges();
}
public static void DeleteDependencies(long id)
{
var ctx = new DataClassesDataContext();
// ICD's dependencies are Visits
// select all Visits associated with this ICD
var visits = from v in ctx.Visits
where v.ICDID == id
select v;
// delete all those visits' dependencies
foreach (var visit in visits)
{
VisitOperations.DeleteDependencies(visit.ID);
}
// delete all those visits
ctx.Visits.DeleteAllOnSubmit(visits);
ctx.SubmitChanges();
}
/// <summary>
/// Delete all the dependencies of this patient
/// </summary>
/// <param name="id">The patient ID</param>
public static void DeleteDependencies(long id)
{
var ctx = new DataClassesDataContext();
// patient only has visit dependency
// Delete all visits belong to this patient
// first, select all visits belong to this patients
var visits = from v in ctx.Visits
where v.PatientID == id
select v;
// delete all the visits dependencies first
foreach (var visit in visits)
{
VisitOperations.DeleteDependencies(visit.ID);
}
// delete the visits
ctx.Visits.DeleteAllOnSubmit(visits);
// submit all the changes
ctx.SubmitChanges();
}
