/// <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();
}
protected void PrescriptionDetailsFormView_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
System.Threading.Thread.Sleep(1000);
// delete all this prescription's dependencies
PrescriptionOperations.DeleteDependencies(long.Parse(e.Keys["ID"].ToString()));
}
protected void PrescriptionFormView_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
// delete all this prescription's dependencies
PrescriptionOperations.DeleteDependencies(long.Parse(e.Keys["ID"].ToString()));
}
