public void Remove(int Id)
{
using (var db = new LumenContext())
{
var loc = db.Devices.SingleOrDefault(x => x.Id == Id);
db.Devices.Remove(loc);
db.SaveChanges();
}
}
public List <Location> GetAll()
{
List <Location> result = null;
using (var db = new LumenContext())
{
result = db.Locations.ToList();
}
return(result);
}
public List <Manufacturer> GetAll()
{
List <Manufacturer> result = null;
using (var db = new LumenContext())
{
result = db.Manufacturers.ToList();
}
return(result);
}
public List <Policy> GetAll()
{
List <Policy> result = null;
using (var db = new LumenContext())
{
result = db.Policies.ToList();
}
return(result);
}
public List <Model> GetAll(int manufacturerId)
{
List <Model> result = null;
using (var db = new LumenContext())
{
result = db.Models.Where(x => x.Manufacturer.Id == manufacturerId).ToList();
}
return(result);
}
public void Add(Device device)
{
using (var db = new LumenContext())
{
device.Location = db.Locations.Single(x => x.Id == device.Location.Id);
device.Policy = db.Policies.Single(x => x.Id == device.Policy.Id);
device.Manufacturer = db.Manufacturers.Single(x => x.Id == device.Manufacturer.Id);
device.Model = db.Models.Single(x => x.Id == device.Model.Id);
db.Devices.Add(device);
db.SaveChanges();
}
}
public Device GetById(int Id)
{
Device result;
using (var db = new LumenContext())
{
result = db.Devices
.Include("Location")
.Include("Policy")
.Include("Manufacturer")
.Include("Model")
.Single(x => x.Id == Id);
}
return(result);
}
public List <Device> GetAll(string user)
{
List <Device> result = null;
using (var db = new LumenContext())
{
result = db.Devices
.Include("Location")
.Include("Policy")
.Include("Manufacturer")
.Include("Model")
.Where(x => x.UserEmail == user).ToList();
}
return(result);
}
public void Edit(Device device)
{
using (var db = new LumenContext())
{
var dev = db.Devices.SingleOrDefault(x => x.Id == device.Id);
dev.IpAddress = device.IpAddress;
dev.IpType = device.IpType;
dev.LoginEnablePassword = device.LoginEnablePassword;
dev.LoginIpAddress = device.LoginIpAddress;
dev.LoginPassword = device.LoginPassword;
dev.LoginUserName = device.LoginUserName;
dev.NIC1DefaultGateway = device.NIC1DefaultGateway;
dev.NIC1IpAddress = device.NIC1NATIpAddress;
dev.NIC1SubNetMask = device.NIC1SubNetMask;
dev.NIC1NATIpAddress = device.NIC1NATIpAddress;
dev.NIC2DefaultGateway = device.NIC2DefaultGateway;
dev.NIC2IpAddress = device.NIC2IpAddress;
dev.NIC2SubNetMask = device.NIC2SubNetMask;
dev.NickName = device.NickName;
dev.ZipCode = device.ZipCode;
device.Location = db.Locations.Single(x => x.Id == device.Location.Id);
device.Policy = db.Policies.Single(x => x.Id == device.Policy.Id);
device.Manufacturer = db.Manufacturers.Single(x => x.Id == device.Manufacturer.Id);
device.Model = db.Models.Single(x => x.Id == device.Model.Id);
dev.Location = device.Location;
dev.Policy = device.Policy;
dev.Manufacturer = device.Manufacturer;
dev.Model = device.Model;
db.SaveChanges();
}
}
