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)
);
}
