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