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