public void CanAddMembershipUser()
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
context.Context.ExecuteStoreCommand("DELETE FROM MembershipUser");
FixedAssetService transaction = new FixedAssetService();
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 = "******"
};
transaction.AddMembershipUser(user);
Assert.AreEqual(context.Context.MembershipUsers.Count(), 1);
user = context.Context.MembershipUsers.FirstOrDefault(x => x.login == "user123");
Assert.IsNotNull(user);
}
}
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 CantAddMembershipUser()
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
context.Context.ExecuteStoreCommand("DELETE FROM MembershipUser");
FixedAssetService transaction = new FixedAssetService();
MembershipUser user = new MembershipUser()
{
login = "******",
name = "Jan",
surname = "Kowalski",
};
transaction.AddMembershipUser(user);
Assert.AreEqual(context.Context.MembershipUsers.Count(), 1);
user = context.Context.MembershipUsers.FirstOrDefault(x => x.login == "user123");
Assert.IsNotNull(user);
}
}
public void AddMembershipUser(MembershipUser membershipUser)
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
try
{
context.Context.MembershipUsers.AddObject(membershipUser);
context.SaveChanges();
}
catch (UpdateException)
{
throw new FaultException(string.Format(
"Nie udało się dodać użytkownika. Popraw dane i spróbuj ponownie"));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
public void DeleteMembershipUser(MembershipUser membershipUser)
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
try
{
context.Context.MembershipUsers.Attach(membershipUser);
context.Context.MembershipUsers.DeleteObject(membershipUser);
context.SaveChanges();
}
catch (UpdateException)
{
throw new FaultException(string.Format(
"Nie udało się usunąć użytkownika. Prawdopodobnie nie istnieje"));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
public void EditMembershipUser(MembershipUser membershipUser)
{
using (EF_ZMT_DbContext.EF_ZMT_DbContext context = new EF_ZMT_DbContext.EF_ZMT_DbContext())
{
try
{
MembershipUser originalRole = context.Context.MembershipUsers.FirstOrDefault(r => r.login == membershipUser.login);
context.Context.MembershipUsers.ApplyCurrentValues(membershipUser);
context.SaveChanges();
}
catch (UpdateException)
{
throw new FaultException(string.Format(
"Nie udało się edytować użytkownika. Popraw dane i spróbuj ponownie"));
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
}
private void FixupMembershipUser(MembershipUser previousValue)
{
if (IsDeserializing)
{
return;
}
if (previousValue != null && previousValue.Licences.Contains(this))
{
previousValue.Licences.Remove(this);
}
if (MembershipUser != null)
{
if (!MembershipUser.Licences.Contains(this))
{
MembershipUser.Licences.Add(this);
}
created_by = MembershipUser.login;
}
if (ChangeTracker.ChangeTrackingEnabled)
{
if (ChangeTracker.OriginalValues.ContainsKey("MembershipUser")
&& (ChangeTracker.OriginalValues["MembershipUser"] == MembershipUser))
{
ChangeTracker.OriginalValues.Remove("MembershipUser");
}
else
{
ChangeTracker.RecordOriginalValue("MembershipUser", previousValue);
}
if (MembershipUser != null && !MembershipUser.ChangeTracker.ChangeTrackingEnabled)
{
MembershipUser.StartTracking();
}
}
}
