public int UpdateInterfaceSftpDetailsByInterfaceId(InterfaceSftpDetails interfaceSftpDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
InterfaceSftpDetails record = _dbContext.InterfaceSftpDetails.Where(i => i.InterfaceId == interfaceSftpDetails.InterfaceId).FirstOrDefault();
if (record != null)
{
record.HostName = interfaceSftpDetails.HostName;
record.UserName = interfaceSftpDetails.UserName;
record.Password = interfaceSftpDetails.Password;
record.Port = interfaceSftpDetails.Port;
record.SshKey = interfaceSftpDetails.SshKey;
record.Passphrase = interfaceSftpDetails.Passphrase;
record.UpdatedDate = interfaceSftpDetails.UpdatedDate;
record.UpdatedBy = interfaceSftpDetails.UpdatedBy;
}
_dbContext.Entry(record).State = EntityState.Modified;
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
public InterfaceSftpDetails GetInterfaceSftpDetailsData(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
InterfaceSftpDetails interfaceSftpDetails = _dbContext.InterfaceSftpDetails.Find(id);
return(interfaceSftpDetails);
}
}
catch
{
throw;
}
}
public InterfaceSftpDetails GetDetailsByInterfaceId(int interfaceId)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
InterfaceSftpDetails interfaceSftpDetails = _dbContext.InterfaceSftpDetails.Where(i => i.InterfaceId == interfaceId).FirstOrDefault();
return(interfaceSftpDetails);
}
}
catch
{
throw;
}
}
public int AddInterfaceSftpDetails(InterfaceSftpDetails interfaceSftpDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.InterfaceSftpDetails.Add(interfaceSftpDetails);
_dbContext.SaveChanges();
return(_dbContext.InterfaceSftpDetails.Max(i => i.InterfaceSftpId));
}
}
catch
{
throw;
}
}
public int UpdateInterfaceSftpDetails(InterfaceSftpDetails interfaceSftpDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.Entry(interfaceSftpDetails).State = EntityState.Modified;
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
public int DeleteInterfaceSftpDetails(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
InterfaceSftpDetails interfaceSftpDetails = _dbContext.InterfaceSftpDetails.Find(id);
_dbContext.InterfaceSftpDetails.Remove(interfaceSftpDetails);
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
