public void CanAddDevice()
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
context.Context.ExecuteStoreCommand("DELETE FROM Device");
context.Context.ExecuteStoreCommand("DELETE FROM PeripheralDevice");
context.Context.ExecuteStoreCommand("DELETE FROM FixedAsset");
Assert.AreEqual(context.Context.Devices.Count(), 0);
Assert.AreEqual(context.Context.PeripheralDevices.Count(), 0);
Assert.AreEqual(context.Context.FixedAssets.Count(), 0);
FixedAssetService transaction = new FixedAssetService();
FixedAsset asset = new FixedAsset()
{
inventory_number = "222222",
cassation = false,
date_of_activation = DateTime.Now
};
PeripheralDevice pd = new PeripheralDevice() { name = "Kamera" };
Device device = new Device() { model = "x400", producer = "Sony", PeripheralDevice = pd, FixedAsset = asset };
transaction.AddDevice(device);
Assert.AreEqual(context.Context.Devices.Count(), 1);
Assert.AreEqual(context.Context.PeripheralDevices.Count(), 1);
Assert.AreEqual(context.Context.FixedAssets.Count(), 1);
}
}
public void CantAddPeripheralDevice()
{
using(EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
FixedAssetService transaction = new FixedAssetService();
context.Context.ExecuteStoreCommand("DELETE FROM PeripheralDevice");
PeripheralDevice device = new PeripheralDevice() { name = "printer" };
transaction.AddPeripheralDevice(device);
Assert.AreEqual(context.Context.PeripheralDevices.Count(), 1);
device = context.Context.PeripheralDevices.FirstOrDefault(x => x.name == "printer");
Assert.IsNotNull(device);
}
}
public void CanEditDevice()
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
context.Context.ExecuteStoreCommand("DELETE FROM Device");
context.Context.ExecuteStoreCommand("DELETE FROM PeripheralDevice");
context.Context.ExecuteStoreCommand("DELETE FROM FixedAsset");
Assert.AreEqual(context.Context.Devices.Count(), 0);
Assert.AreEqual(context.Context.PeripheralDevices.Count(), 0);
Assert.AreEqual(context.Context.FixedAssets.Count(), 0);
FixedAssetService transaction = new FixedAssetService();
FixedAsset asset = new FixedAsset()
{
inventory_number = "222222",
cassation = false,
date_of_activation = DateTime.Now
};
PeripheralDevice pd = new PeripheralDevice() { name = "Kamera" };
Device device = new Device() { model = "x400", producer = "Sony", PeripheralDevice = pd, FixedAsset = asset };
transaction.AddDevice(device);
Assert.AreEqual(context.Context.Devices.Count(), 1);
Assert.AreEqual(context.Context.PeripheralDevices.Count(), 1);
Assert.AreEqual(context.Context.FixedAssets.Count(), 1);
pd = new PeripheralDevice() { name = "Aparat" };
context.Context.PeripheralDevices.AddObject(pd);
context.SaveChanges();
Assert.AreEqual(context.Context.PeripheralDevices.Count(), 2);
device = context.Context.Devices.FirstOrDefault(x => x.model == "x400");
Assert.IsNotNull(device);
device.PeripheralDevice = pd;
device.model = "x500";
transaction.EditDevice(device);
device = context.Context.Devices.FirstOrDefault(x => x.model == "x500");
Assert.IsNotNull(device);
Assert.AreEqual(device.model, "x500");
Assert.AreEqual(device.PeripheralDevice.name, "Aparat");
Assert.AreEqual(context.Context.Devices.Count(), 1);
}
}
public void AddPeripheralDevice(PeripheralDevice peripheralDevice)
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
try
{
context.Context.PeripheralDevices.AddObject(peripheralDevice);
context.SaveChanges();
}
catch (UpdateException)
{
throw new FaultException(string.Format(
"Nie udało się dodać urządzenia peryferyjnego. Popraw dane i spróbuj ponownie"));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
public void EditPeripheralDevice(PeripheralDevice peripheralDevice)
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
try
{
PeripheralDevice originalPeripheralDevice = context.Context.PeripheralDevices.FirstOrDefault(p => p.id == peripheralDevice.id);
context.Context.PeripheralDevices.ApplyCurrentValues(peripheralDevice);
context.SaveChanges();
}
catch (UpdateException)
{
throw new FaultException(string.Format(
"Nie udało się edytować urządzenia peryferyjnego. Popraw dane i spróbuj ponownie"));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
public void DeletePeripheralDevice(PeripheralDevice peripheralDevice)
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
try
{
context.Context.PeripheralDevices.Attach(peripheralDevice);
context.Context.PeripheralDevices.DeleteObject(peripheralDevice);
context.SaveChanges();
}
catch (UpdateException)
{
throw new FaultException(string.Format(
"Nie udało się usunąć urządzenia peryferyjnego. Prawdopodobnie nie istnieje"));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
private void FixupPeripheralDevice(PeripheralDevice previousValue)
{
if (IsDeserializing)
{
return;
}
if (previousValue != null && previousValue.Devices.Contains(this))
{
previousValue.Devices.Remove(this);
}
if (PeripheralDevice != null)
{
if (!PeripheralDevice.Devices.Contains(this))
{
PeripheralDevice.Devices.Add(this);
}
id_peripheral_device = PeripheralDevice.id;
}
if (ChangeTracker.ChangeTrackingEnabled)
{
if (ChangeTracker.OriginalValues.ContainsKey("PeripheralDevice")
&& (ChangeTracker.OriginalValues["PeripheralDevice"] == PeripheralDevice))
{
ChangeTracker.OriginalValues.Remove("PeripheralDevice");
}
else
{
ChangeTracker.RecordOriginalValue("PeripheralDevice", previousValue);
}
if (PeripheralDevice != null && !PeripheralDevice.ChangeTracker.ChangeTrackingEnabled)
{
PeripheralDevice.StartTracking();
}
}
}