public List <string> GetCoreTableNames(int datasetId)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetMaster dataSetmaster = _dbContext.DatasetMaster.Where(d => d.DatasetId == datasetId).FirstOrDefault();
if (dataSetmaster.DataSetTypeId != null && dataSetmaster.DataSetTypeId != 0)
{
List <int> tableIds = _dbContext.DatafeedTypeTableRelationship.Where(r => r.DatafeedTypeId == dataSetmaster.DataSetTypeId).Select(t => t.TableId).ToList();
if (tableIds != null && tableIds.Count > 0)
{
var query = _dbContext.CoreTableDetails.Where(t => tableIds.Contains(t.CoreTableId)).Select(p => p.TableName).Distinct().OrderBy(p => p);
return(query.ToList());
}
else
{
var query = _dbContext.CoreTableDetails.Select(p => p.TableName).Distinct().OrderBy(p => p);
return(query.ToList());
}
}
else
{
var query = _dbContext.CoreTableDetails.Select(p => p.TableName).Distinct().OrderBy(p => p);
return(query.ToList());
}
}
}
catch
{
throw;
}
}
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;
}
}
public void UpdateStatusForDataset(ZionContext dbContext, int datasetId, string status)
{
DatasetMaster dataset = (from ds in dbContext.DatasetMaster
where (ds.DatasetId == datasetId)
select ds).FirstOrDefault();
dbContext.Attach(dataset);
dataset.Status = status;
}
public DatasetMaster GetDatasetMasterData(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetMaster datasetMaster = _dbContext.DatasetMaster.Find(id);
return(datasetMaster);
}
}
catch
{
throw;
}
}
public int AddDataset(DatasetMaster datasetMaster)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.DatasetMaster.Add(datasetMaster);
_dbContext.SaveChanges();
return(_dbContext.DatasetMaster.Max(d => d.DatasetId));
}
}
catch
{
throw;
}
}
public int DeleteDatasetMaster(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetMaster datasetMaster = _dbContext.DatasetMaster.Find(id);
_dbContext.DatasetMaster.Remove(datasetMaster);
_dbContext.SaveChanges();
}
return(1);
}
catch
{
throw;
}
}
