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