public DeletePmsResponse DeletePmsConfigDetails(int id) { var response = new DeletePmsResponse(); try { var pmsConfigDetails = DataContext.PmsConfigDetails .Include(x => x.ScoreIndicators) .Single(x => x.Id == id); foreach (var scoreIndicator in pmsConfigDetails.ScoreIndicators.ToList()) { DataContext.ScoreIndicators.Remove(scoreIndicator); } DataContext.PmsConfigDetails.Remove(pmsConfigDetails); DataContext.SaveChanges(); response.IsSuccess = true; response.Message = "Pms Config Detail item has been deleted successfully"; } catch (DbUpdateException dbUpdateException) { response.Message = dbUpdateException.Message; } return response; }
public DeletePmsResponse DeletePmsSummary(int id) { var response = new DeletePmsResponse(); try { var pmsSummary = new PmsSummary { Id = id }; DataContext.PmsSummaries.Attach(pmsSummary); DataContext.Entry(pmsSummary).State = EntityState.Deleted; DataContext.SaveChanges(); response.IsSuccess = true; response.Message = "Pms Summary item has been deleted successfully"; } catch (DbUpdateException dbUpdateException) { response.Message = dbUpdateException.Message; } return response; }
public DeletePmsResponse DeletePmsSummary(int id) { var response = new DeletePmsResponse(); try { var pmsSummary = DataContext.PmsSummaries .Include(x => x.ScoreIndicators) .Include(x => x.PmsConfigs) .Include(x => x.PmsConfigs.Select(y => y.ScoreIndicators)) .Include(x => x.PmsConfigs.Select(y => y.PmsConfigDetailsList)) .Include(x => x.PmsConfigs.Select(y => y.PmsConfigDetailsList.Select(z => z.ScoreIndicators))) .Single(x => x.Id == id); foreach (var scoreIndicator in pmsSummary.ScoreIndicators.ToList()) { DataContext.ScoreIndicators.Remove(scoreIndicator); } foreach (var pmsConfig in pmsSummary.PmsConfigs.ToList()) { foreach (var pmsConfigDetailse in pmsConfig.PmsConfigDetailsList.ToList()) { foreach (var score in pmsConfigDetailse.ScoreIndicators.ToList()) { DataContext.ScoreIndicators.Remove(score); } DataContext.PmsConfigDetails.Remove(pmsConfigDetailse); } foreach (var score in pmsConfig.ScoreIndicators.ToList()) { DataContext.ScoreIndicators.Remove(score); } DataContext.PmsConfigs.Remove(pmsConfig); } DataContext.PmsSummaries.Remove(pmsSummary); DataContext.SaveChanges(); response.IsSuccess = true; response.Message = "Pms Summary item has been deleted successfully"; } catch (DbUpdateException dbUpdateException) { response.Message = dbUpdateException.Message; } return response; }