public int UpdateInterfaceDbDetailsByInterfaceId(InterfaceDbDetails interfaceDbDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
InterfaceDbDetails record = _dbContext.InterfaceDbDetails.Where(i => i.InterfaceId == interfaceDbDetails.InterfaceId).FirstOrDefault();
if (record != null)
{
record.HostName = interfaceDbDetails.HostName;
record.DatabaseName = interfaceDbDetails.DatabaseName;
record.UserName = interfaceDbDetails.UserName;
record.Password = interfaceDbDetails.Password;
record.Port = interfaceDbDetails.Port;
record.SchemaName = interfaceDbDetails.SchemaName;
record.DbType = interfaceDbDetails.DbType;
record.UpdatedDate = interfaceDbDetails.UpdatedDate;
record.UpdatedBy = interfaceDbDetails.UpdatedBy;
}
_dbContext.Entry(record).State = EntityState.Modified;
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
public InterfaceDbDetails GetInterfaceDbDetailsData(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
InterfaceDbDetails interfaceDbDetails = _dbContext.InterfaceDbDetails.Find(id);
return(interfaceDbDetails);
}
}
catch
{
throw;
}
}
public InterfaceDbDetails GetDetailsByInterfaceId(int interfaceId)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
InterfaceDbDetails interfacedbDetails = _dbContext.InterfaceDbDetails.Where(i => i.InterfaceId == interfaceId).FirstOrDefault();
return(interfacedbDetails);
}
}
catch
{
throw;
}
}
public int AddInterfaceDbDetails(InterfaceDbDetails interfaceDbDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.InterfaceDbDetails.Add(interfaceDbDetails);
_dbContext.SaveChanges();
return(_dbContext.InterfaceDbDetails.Max(i => i.InterfaceDbId));
}
}
catch
{
throw;
}
}
public int UpdateInterfaceDbDetails(InterfaceDbDetails interfaceDbDetails)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
_dbContext.Entry(interfaceDbDetails).State = EntityState.Modified;
_dbContext.SaveChanges();
}
return(1);
}
catch
{
throw;
}
}
public int DeleteInterfaceDbDetails(int id)
{
try
{
using (_dbContext = string.IsNullOrEmpty(_connectionString) ? _dbContext : new ZionContext(_connectionString))
{
InterfaceDbDetails interfaceDbDetails = _dbContext.InterfaceDbDetails.Find(id);
_dbContext.InterfaceDbDetails.Remove(interfaceDbDetails);
_dbContext.SaveChanges();
return(1);
}
}
catch
{
throw;
}
}
