public void Delete(DalUsersTest e)
{
if (context.Database.Connection.State != ConnectionState.Open)
{
context.Database.Connection.Open();
}
UsersTests ut = context.Set <UsersTests>().
FirstOrDefault(a => a.id == e.Id);
context.Set <UsersTests>().Remove(ut);
}
public void FinishTest(DalUser user)
{
if (!IsUserTested(user))
{
return;
}
Users ormuser = context.Set <Users>().FirstOrDefault(users => users.id == user.Id);
UsersTests ormutest = context.Set <UsersTests>().FirstOrDefault(tests =>
tests.UserId == user.Id &&
tests.EndingTime == null);
Tests ormtest = context.Set <Tests>().FirstOrDefault(tests => tests.id == ormutest.TestId);
//marks and other stuff will be in bll
ormutest.EndingTime = DateTime.Now;
}
public void Update(DalUsersTest entity)
{
if (context.Database.Connection.State != ConnectionState.Open)
{
context.Database.Connection.Open();
}
UsersTests ut = context.Set <UsersTests>().
FirstOrDefault(a => a.id == entity.Id);
ut.BeginningTime = entity.BeginningTime;
ut.EndingTime = entity.EndingTime;
ut.MarkForTest = entity.MarkForTest;
ut.RightAnswersCount = entity.RightAnswersCount;
ut.TestId = entity.TestId;
ut.UserId = entity.UserId;
}
public void Create(DalUsersTest e)
{
if (context.Database.Connection.State != ConnectionState.Open)
{
context.Database.Connection.Open();
}
UsersTests ut = new UsersTests()
{
id = e.Id,
BeginningTime = e.BeginningTime,
EndingTime = e.EndingTime,
MarkForTest = e.MarkForTest,
RightAnswersCount = e.RightAnswersCount,
TestId = e.TestId,
UserId = e.UserId
};
context.Set <UsersTests>().Add(ut);
}
public DalUsersTest GetLastResult(DalUser user)
{
if (context.Database.Connection.State != ConnectionState.Open)
{
context.Database.Connection.Open();
}
UsersTests result = context.Set <UsersTests>().Where(tests =>
tests.UserId == user.Id).OrderByDescending(tests => tests.BeginningTime).FirstOrDefault();
return(new DalUsersTest()
{
BeginningTime = result.BeginningTime,
EndingTime = result.EndingTime,
Id = result.id,
MarkForTest = result.MarkForTest,
RightAnswersCount = result.RightAnswersCount,
TestId = result.TestId,
UserId = result.UserId
});
}
public void StartTest(DalUser user, DalTest test)
{
if (IsUserTested(user))
{
return;
}
Users ormuser = context.Set <Users>().FirstOrDefault(users => users.id == user.Id);
Tests ormtest = context.Set <Tests>().FirstOrDefault(tests => tests.id == test.Id);
UsersTests startingTest = new UsersTests()
{
TestId = ormtest.id,
BeginningTime = DateTime.Now,
EndingTime = null,
MarkForTest = null,
RightAnswersCount = null,
UserId = ormuser.id
};
context.Set <UsersTests>().Add(startingTest);
}
/// <summary>
/// UnitTests
/// Runs the unit tests for the managed Users class.
/// </summary>
/// <returns>return a boolean value indicating success</returns>
private static bool UnitTests()
{
try
{
UsersTests userTests = new UsersTests();
Console.WriteLine("");
Console.WriteLine("----First Test : Populate test users");
userTests.PopulateUsers();
Console.WriteLine("----Successful");
Console.WriteLine("");
Console.WriteLine("----Second Test : Return grouped first and last names");
List <UserGroupedNameInfo> groupedNames = userTests.TestGroupedFirstAndLastNames();
groupedNames.ForEach(group =>
{
Console.WriteLine(string.Format("{0},{1}", group.Name, group.Count));
});
Console.WriteLine("----Successful");
Console.WriteLine("");
Console.WriteLine("----Third Test");
List <string> addresses = userTests.TestDistinctAddressList();
addresses.ForEach(address =>
{
Console.WriteLine(string.Format("{0}", address));
});
Console.WriteLine("----Successful");
return(true);
}
catch (Exception)
{
Console.WriteLine(string.Format("An exception occured : ", ex.Message));
return(false);
}
}
