public int UpdateDataSetSftpDetailsByDataSetID(DatasetFileDetails datasetFileDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetFileDetails record = _dbContext.DatasetFileDetails.Where(i => i.DatasetId == datasetFileDetails.DatasetId).FirstOrDefault();
if (record != null)
{
record.FullFileName = datasetFileDetails.FullFileName;
record.DeltaFileName = datasetFileDetails.DeltaFileName;
record.FolderLocation = datasetFileDetails.FolderLocation;
record.FileExtension = datasetFileDetails.FileExtension;
record.FileDelimiter = datasetFileDetails.FileDelimiter;
record.UpdatedDate = datasetFileDetails.UpdatedDate;
record.UpdatedBy = datasetFileDetails.UpdatedBy;
record.ArchiveLocation = datasetFileDetails.ArchiveLocation;
record.ContainsHeader = datasetFileDetails.ContainsHeader;
record.ContainsTrailer = datasetFileDetails.ContainsTrailer;
record.ArchiveOutboundFile = datasetFileDetails.ArchiveOutboundFile;
}
_dbContext.Entry(record).State = EntityState.Modified;
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
public DatasetFileDetails GetDatasetFileDetailsData(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetFileDetails datasetFileDetails = _dbContext.DatasetFileDetails.Find(id);
return(datasetFileDetails);
}
}
catch
{
throw;
}
}
public int AddDatasetFileDetails(DatasetFileDetails datasetFileDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.DatasetFileDetails.Add(datasetFileDetails);
_dbContext.SaveChanges();
return(_dbContext.DatasetFileDetails.Max(d => d.DatasetDetailId));
}
}
catch
{
throw;
}
}
public DatasetFileDetails GetDetailsByDataSetId(int dataSetId)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetFileDetails datasetFileDetails = _dbContext.DatasetFileDetails
.Where(d => d.DatasetId == dataSetId).FirstOrDefault();
return(datasetFileDetails);
}
}
catch
{
throw;
}
}
public int DeleteDatasetFileDetails(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
DatasetFileDetails datasetFileDetails = _dbContext.DatasetFileDetails.Find(id);
_dbContext.DatasetFileDetails.Remove(datasetFileDetails);
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
public int UpdateDatasetFileDetails(DatasetFileDetails datasetFileDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.Entry(datasetFileDetails).State = EntityState.Modified;
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
