private void DeleteML(int queryId) { try { using (TransactionScope ts = new TransactionScope()) { MeasurementLocationBO objMeasurementLocation = new MeasurementLocationBO(this.ObjContext); if (queryId > 0) { objMeasurementLocation.ID = queryId; objMeasurementLocation.GetObject(); foreach (SizeChartBO schart in objMeasurementLocation.SizeChartsWhereThisIsMeasurementLocation) { SizeChartBO objSizeChart = new SizeChartBO(this.ObjContext); objSizeChart.ID = schart.ID; objSizeChart.GetObject(); objSizeChart.Delete(); this.ObjContext.SaveChanges(); } objMeasurementLocation.Delete(); } this.ObjContext.SaveChanges(); ts.Complete(); } } catch (Exception ex) { IndicoLogging.log.Error("Error occured while Deleting the Measurement Location", ex); } }
private void DeleteSize(int queryId) { try { if (queryId > 0) { using (TransactionScope ts = new TransactionScope()) { SizeBO objSize = new SizeBO(this.ObjContext); objSize.ID = queryId; objSize.GetObject(); List <int> lstSizeCharts = objSize.SizeChartsWhereThisIsSize.Select(o => o.ID).ToList(); foreach (int sizeChart in lstSizeCharts) { SizeChartBO objSizeChart = new SizeChartBO(this.ObjContext); objSizeChart.ID = sizeChart; objSizeChart.GetObject(); objSizeChart.Delete(); } objSize.Delete(); this.ObjContext.SaveChanges(); ts.Complete(); } } else { if (Session["ListSizes"] != null) { List <KeyValuePair <int, SizeBO> > lstEmptyList = (List <KeyValuePair <int, SizeBO> >)Session["ListSizes"]; KeyValuePair <int, SizeBO> objSize = lstEmptyList.Where(m => m.Key == queryId).FirstOrDefault(); lstEmptyList.Remove(objSize); Session["ListSizes"] = lstEmptyList; } } } catch (Exception ex) { IndicoLogging.log.Error("Error occured while Deleting the Size", ex); } }