private void UpdateDatasetHeirarchyStatus(ZionContext _dbContext, int datasetId, string status,
                                           IngestionDataAccess ingestionDAL, OutgestionDataAccess outgestionDAL, DatasetMasterDataAccess dsDAL,
                                           TemplateDataAccess dtDAL)
 {
     //Update the status of heirarchy
     ingestionDAL.MappingStatusUpdateForDatasetId(_dbContext, datasetId, status == "Active" ? true : false);
     ingestionDAL.TempMappingStatusUpdateForDatasetId(_dbContext, datasetId, status == "Active" ? true : false);
     dsDAL.UpdateStatusForDataset(_dbContext, datasetId, status);
     //dtDAL.TemplateStatusUpdateForDatasetId(_dbContext, datasetId, status);
     outgestionDAL.OutgestionStatusUpdateForDatasetId(_dbContext, datasetId, status == "Active" ? true : false);
 }
        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;
            }
        }