public void UpdateDatasetStatus(int datasetId, string status) { try { using (ZionContext dbContext = new ZionContext(_connectionString)) { IngestionDataAccess ingestionDAL = new IngestionDataAccess(_connectionString); ingestionDAL.MappingStatusUpdateForDatasetId(dbContext, datasetId, status == "Active" ? true : false); ingestionDAL.TempMappingStatusUpdateForDatasetId(dbContext, datasetId, status == "Active" ? true : false); OutgestionDataAccess outgestionDAL = new OutgestionDataAccess(_connectionString); outgestionDAL.OutgestionStatusUpdateForDatasetId(dbContext, datasetId, status == "Active" ? true : false); _datasetMasterDAL.UpdateStatusForDataset(dbContext, datasetId, status); dbContext.SaveChanges(); } } catch { throw; } }