public void CanAddLicence()
{
using(EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
context.Context.ExecuteStoreCommand("DELETE FROM Licence");
context.Context.ExecuteStoreCommand("DELETE FROM MembershipUser");
context.Context.ExecuteStoreCommand("DELETE FROM Kind");
context.Context.ExecuteStoreCommand("DELETE FROM FixedAsset");
FixedAssetService transaction = new FixedAssetService();
FixedAsset asset = new FixedAsset()
{
id = 2222,
inventory_number = "aaaa",
date_of_activation = DateTime.Now,
cassation = false
};
MembershipUser user = new MembershipUser()
{
login = "******",
email = "*****@*****.**",
creation_date = DateTime.Now,
is_online = false,
name = "Jan",
surname = "Kowalski",
is_active = true,
last_login_date = DateTime.Now,
password = "******"
};
Kind kind = new Kind() { name = "Oprogramowanie" };
Licence licence = new Licence() { inventory_number = "xxxx",
name = "Windows XP",
created_by = user.login,
MembershipUser = user,
FixedAsset = asset,
Kind = kind,
last_modified_login = user.login,
last_modified_date = DateTime.Now
};
transaction.AddLicence(licence);
Assert.AreEqual(context.Context.Licences.Count(), 1);
licence = context.Context.Licences.FirstOrDefault(x => x.inventory_number == "xxxx");
Assert.IsNotNull(licence);
Assert.AreEqual(licence.name, "Windows XP");
}
}
public void CanAddKind()
{
using(EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
context.Context.ExecuteStoreCommand("DELETE FROM Kind");
FixedAssetService transaction = new FixedAssetService();
Kind kind = new Kind() { name = "N491" };
transaction.AddKind(kind);
Assert.AreEqual(context.Context.Kinds.Count(), 1);
kind = context.Context.Kinds.FirstOrDefault(x => x.name == "N491");
Assert.IsNotNull(kind);
}
}
public void AddKind(Kind kind)
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
try
{
context.Context.Kinds.AddObject(kind);
context.SaveChanges();
}
catch (UpdateException)
{
throw new FaultException(string.Format(
"Nie udało się dodać rodzaju. Popraw dane i spróbuj ponownie"));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
public void DeleteKind(Kind kind)
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
try
{
context.Context.Kinds.Attach(kind);
context.Context.Kinds.DeleteObject(kind);
context.SaveChanges();
}
catch (UpdateException)
{
throw new FaultException(string.Format(
"Nie udało się usunąć rodzaju. Prawdopodobnie nie istnieje"));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
public void EditKind(Kind kind)
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
try
{
Kind originalKind = context.Context.Kinds.FirstOrDefault(k => k.id == kind.id);
context.Context.Kinds.ApplyCurrentValues(kind);
context.SaveChanges();
}
catch (UpdateException)
{
throw new FaultException(string.Format(
"Nie udało się edytować rodzaju. Popraw dane i spróbuj ponownie"));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
private void FixupKind(Kind previousValue)
{
if (IsDeserializing)
{
return;
}
if (previousValue != null && previousValue.Licences.Contains(this))
{
previousValue.Licences.Remove(this);
}
if (Kind != null)
{
if (!Kind.Licences.Contains(this))
{
Kind.Licences.Add(this);
}
id_kind = Kind.id;
}
if (ChangeTracker.ChangeTrackingEnabled)
{
if (ChangeTracker.OriginalValues.ContainsKey("Kind")
&& (ChangeTracker.OriginalValues["Kind"] == Kind))
{
ChangeTracker.OriginalValues.Remove("Kind");
}
else
{
ChangeTracker.RecordOriginalValue("Kind", previousValue);
}
if (Kind != null && !Kind.ChangeTracker.ChangeTrackingEnabled)
{
Kind.StartTracking();
}
}
}
public void GetFixedAssetsByKindId()
{
Kind rodzaj = new Kind { id = 1, name = "Zestawy komputerowe" };
Mock<IFixedAssetRepository> mock = new Mock<IFixedAssetRepository>();
mock.Setup(a => a.FixedAssets).Returns(new FixedAsset[]
{
new FixedAsset { id = 1, inventory_number = "002/4/11111", id_kind = rodzaj.id },
new FixedAsset { id = 2, inventory_number = "002/4/22222", id_kind = 5 },
new FixedAsset { id = 3, inventory_number = "002/4/33333", id_kind = 3 },
new FixedAsset { id = 4, inventory_number = "002/4/44444", id_kind = rodzaj.id},
new FixedAsset { id = 5, inventory_number = "002/4/55555", id_kind = 2 },
new FixedAsset { id = 6, inventory_number = "002/4/66666", id_kind = rodzaj.id }
}.AsQueryable());
FixedAssetController ctrl = new FixedAssetController(mock.Object);
object[] temp = ctrl.GetFixedAssetsByKindId(rodzaj.id);
Assert.AreEqual(temp.Length, 3);
Assert.AreEqual(((FixedAsset)temp[2]).inventory_number, "002/4/66666");
temp = ctrl.GetFixedAssetsByKindId(2);
Assert.AreEqual(temp.Length, 1);
temp = ctrl.GetFixedAssetsByKindId(8);
Assert.AreEqual(temp.Length, 0);
}