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