/// <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())); }