public Device UpdateDevice(DeviceDTO _deviceDTO)
{
try
{
Device data = new Device
{
Id = _deviceDTO.Id,
Imei = _deviceDTO.Imei,
SimCardNumber = _deviceDTO.SimCardNumber,
Enabled = _deviceDTO.Enabled,
Created = _deviceDTO.Created,
CreatedBy = _deviceDTO.CreatedBy
};
using (var context = new DeviceManagementPortalContext())
{
context.Entry(data).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
context.SaveChanges();
}
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
public Int32 DeleteDeviceBackend(Int32 id)
{
try
{
using (var context = new DeviceManagementPortalContext())
{
context.Remove(context.DeviceBackend.Find(id));
context.SaveChanges();
}
return(id);
}
catch (Exception ex)
{
throw ex;
}
}
public List <DeviceBackend> List()
{
try
{
List <DeviceBackend> li_deviceBackends = new List <DeviceBackend>();
using (var context = new DeviceManagementPortalContext())
{
li_deviceBackends = context.DeviceBackend.ToList();
}
return(li_deviceBackends);
}
catch (Exception ex)
{
throw ex;
}
}
public DeviceBackend CreateDeviceBackend(DeviceBackendDTO _deviceBackendDTO)
{
try
{
DeviceBackend data = new DeviceBackend
{
DeviceId = _deviceBackendDTO.DeviceId,
BackendId = _deviceBackendDTO.BackendId
};
using (var context = new DeviceManagementPortalContext())
{
context.DeviceBackend.Add(data);
context.SaveChanges();
}
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
public Backend CreateBackend(BackendDTO _backendDTO)
{
try
{
Backend data = new Backend
{
Name = _backendDTO.Name,
Address = _backendDTO.Address
};
using (var context = new DeviceManagementPortalContext())
{
context.Backend.Add(data);
context.SaveChanges();
}
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
public DeviceBackend UpdateDeviceBackend(DeviceBackendDTO _deviceBackendDTO)
{
try
{
DeviceBackend data = new DeviceBackend
{
Id = _deviceBackendDTO.Id,
DeviceId = _deviceBackendDTO.DeviceId,
BackendId = _deviceBackendDTO.BackendId
};
using (var context = new DeviceManagementPortalContext())
{
context.Entry(data).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
context.SaveChanges();
}
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
public Backend UpdateBackend(BackendDTO _backendDTO)
{
try
{
Backend data = new Backend
{
Id = _backendDTO.Id,
Name = _backendDTO.Name,
Address = _backendDTO.Address
};
using (var context = new DeviceManagementPortalContext())
{
context.Entry(data).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
context.SaveChanges();
}
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
public Device CreateDevice(DeviceDTO _deviceDTO)
{
try
{
Device data = new Device
{
Imei = _deviceDTO.Imei,
SimCardNumber = _deviceDTO.SimCardNumber,
Enabled = _deviceDTO.Enabled,
Created = DateTime.Now,
CreatedBy = _deviceDTO.CreatedBy
};
using (var context = new DeviceManagementPortalContext())
{
context.Device.Add(data);
context.SaveChanges();
}
return(data);
}
catch (Exception ex)
{
throw ex;
}
}
