public void TestUDCListModel()
{
UDCListModel udc = new UDCListModel("Data Source=isostore:/Test1.sdf", true);
UserModel testUser = new UserModel("1", "foo", "bar", "");
udc.addUser(testUser);
Assert.Equals(testUser, udc.UsersByFirstName[0]);
Assert.IsTrue(udc.SubmitChanges());
udc.LoadListsFromDatabase();
Assert.Equals(testUser, udc.UsersByFirstName[0]);
GroupModel testGroup = new GroupModel("TestGroup");
udc.addGroup(testGroup);
udc.addToGroup(testUser, testGroup);
Assert.IsTrue(udc.GroupList[0].Users.Contains(testUser));
CallLogEntry testEntry = new CallLogEntry();
CallLogModel testLog = new CallLogModel(1);
testLog.addEntry(testEntry);
testUser.CallLogs.Add(testLog);
Assert.IsTrue(udc.SubmitChanges());
Assert.IsTrue(testUser.CallLogs.Any());
Assert.Equals(testUser.CallLogs.First(), testLog);
udc.removeGroup("TestGroup");
Assert.IsTrue(udc.GroupList.Count == 0);
}
public void removeFromGroup(UserModel u, GroupModel g)
{
var junction = from GroupMapModel gmm in udc.JunctionTable where gmm.UserID.Equals(u.UserID) && gmm.GroupName.Equals(g.GroupName) select gmm;
GroupMapModel junctionModel;
if (junction.Any())
{
junctionModel = junction.First();
udc.JunctionTable.DeleteOnSubmit(junctionModel);
udc.SubmitChanges();
}
}
public void addToGroup(UserModel u, GroupModel g)
{
GroupMapModel junctionModel = new GroupMapModel(g.GroupName, u.ID);
//JunctionTable.InsertOnSubmit(junctionModel);
g.addJunction(junctionModel);
udc.SubmitChanges();
}
public bool addGroup(GroupModel Group)
{
udc.GroupTable.InsertOnSubmit(Group);
try
{
udc.SubmitChanges();
}
catch (Exception dbe)
{
return false;
}
GroupList.Add(Group);
GroupList.OrderBy(g => g.GroupName);
return true;
}
public void GroupTapped(GroupModel gm)
{
navService.UriFor<GroupPageViewModel>().
WithParam(x => x.GroupName, gm.GroupName).
Navigate();
}
protected override void OnViewReady(object view)
{
base.OnViewReady(view);
if (GroupName != null)
{
var tmpGroup = from g in udc.GroupList where g.GroupName.Equals(GroupName) select g;
if (tmpGroup.Any())
{
Group = tmpGroup.First();
// User information (in Property Items) is now accessible
NotifyOfPropertyChange("Items");
}
}
}
