public int UpdateDataSetDBDetailsByDataSetID(DatasetTableDetails datasetTableDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetTableDetails record = _dbContext.DatasetTableDetails.Where(i => i.DatasetId == datasetTableDetails.DatasetId).FirstOrDefault();
if (record != null)
{
record.FullLoadQuery = datasetTableDetails.FullLoadQuery;
record.DeltaLoadQuery = datasetTableDetails.DeltaLoadQuery;
record.UpdatedDate = datasetTableDetails.UpdatedDate;
record.UpdatedBy = datasetTableDetails.UpdatedBy;
}
_dbContext.Entry(record).State = EntityState.Modified;
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
public DatasetTableDetails GetDatasetTableDetailsData(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetTableDetails datasetTableDetails = _dbContext.DatasetTableDetails.Find(id);
return(datasetTableDetails);
}
}
catch
{
throw;
}
}
public DatasetTableDetails GetDatasetTableDetailsData(int datasetId)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetTableDetails datasetTableDetails = _dbContext.DatasetTableDetails.Where(d => d.DatasetId == datasetId).FirstOrDefault();
return(datasetTableDetails);
}
}
catch
{
throw;
}
}
public int AddDatasetTableDetails(DatasetTableDetails datasetTableDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.DatasetTableDetails.Add(datasetTableDetails);
_dbContext.SaveChanges();
return(_dbContext.DatasetTableDetails.Max(d => d.DatasetDetailId));
}
}
catch
{
throw;
}
}
public int UpdateDatasetTableDetails(DatasetTableDetails datasetTableDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.Entry(datasetTableDetails).State = EntityState.Modified;
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
public int DeleteDatasetTableDetails(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetTableDetails datasetTableDetails = _dbContext.DatasetTableDetails.Find(id);
_dbContext.DatasetTableDetails.Remove(datasetTableDetails);
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
