public static void DeleteDependencies(long id)
{
var ctx = new DataClassesDataContext();
// Prescription's dependency is PrescriptionDetail
var prescriptionDetails = from p in ctx.PrescriptionDetails
where p.PrescriptionID == id
select p;
foreach (var prescriptionDetail in prescriptionDetails)
{
PrescriptionDetailOperations.DeleteDependencies(prescriptionDetail.ID);
}
ctx.PrescriptionDetails.DeleteAllOnSubmit(prescriptionDetails);
// submit all changes
ctx.SubmitChanges();
}
public static void DeleteDependencies(long id)
{
var ctx = new DataClassesDataContext();
// drug's denpendency is prescription detail
var prescriptionDetails = from p in ctx.PrescriptionDetails
where p.DrugID == id
select p;
// delete all their dependencies
foreach (var prescriptionDetail in prescriptionDetails)
{
PrescriptionDetailOperations.DeleteDependencies(prescriptionDetail.ID);
}
// delete all those prescription details
ctx.PrescriptionDetails.DeleteAllOnSubmit(prescriptionDetails);
ctx.SubmitChanges();
}
