public int UpdateDatasetMaster(DatasetMaster datasetMaster) { int datasetId = datasetMaster.DatasetId; string status = datasetMaster.Status; try { using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString)) { _dbContext.Entry(datasetMaster).State = EntityState.Modified; //Update the status of heirarchy 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); _dbContext.SaveChanges(); } return(1); } catch { throw; } }
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 UpdateInterfaceHeirarchyStatus(ZionContext _dbContext, int interfaceId, string status) { IngestionDataAccess ingestionDAL = new IngestionDataAccess(_connectionString); OutgestionDataAccess outgestionDAL = new OutgestionDataAccess(_connectionString); DatasetMasterDataAccess dsDAL = new DatasetMasterDataAccess(_connectionString); TemplateDataAccess dtDAL = new TemplateDataAccess(_connectionString); List <DatasetMaster> datasets = _dbContext.DatasetMaster.Where(ds => ds.InterfaceId == interfaceId).ToList(); datasets.ForEach(ds => UpdateDatasetHeirarchyStatus(_dbContext, ds.DatasetId, status, ingestionDAL, outgestionDAL, dsDAL, dtDAL) ); }