public void Deleting_Object_But_Dont_Delete_Address_Records_If_There_Is_One_More_Person_Using_It()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
var user = unitOfWork.Users.Create(GetUser());
unitOfWork.Users.Create(ThirdUser());
unitOfWork.Users.Delete(t => t.ID == user.ID);
Assert.IsNotNull(context.AddressTable.First());
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void Test_Deleting_A_Service_Offer()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
ServiceOffer service = unitOfWork.Offers.Create(GetServiceOffer());
var result = unitOfWork.Offers.Delete(t => t.ID == service.ID);
Assert.IsTrue(result);
}
catch
{
Assert.Fail();
}
finally
{
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.SubmitChanges();
context.Users.DeleteAllOnSubmit(context.Users);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.SubmitChanges();
}
}
}
public void Filtr_Database_Of_Users()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
unitOfWork.Users.Create(ForthUser());
unitOfWork.Users.Create(ThirdUser());
IQueryable <Users> filtredList = unitOfWork.Users.List(u => u.AddressTable.City == "Aalborg");
Assert.AreEqual(3, filtredList.ToArray().Count());
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void Edition_Of_User_Is_Saved()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
Users u = unitOfWork.Users.Create(GetUser());
Users toUpdate = ToUpdate();
toUpdate.ID = u.ID;
toUpdate.LastUpdate = u.LastUpdate;
bool edited = unitOfWork.Users.Update(toUpdate);
Assert.IsTrue(edited);
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void TestCreationOfOffer()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
var result = unitOfWork.Offers.Create(GetServiceOffer());
Assert.IsNotNull(result);
}
catch
{
Assert.Fail();
}
finally
{
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.SubmitChanges();
context.Users.DeleteAllOnSubmit(context.Users);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.SubmitChanges();
}
}
}
public void Get_Specific_User_With_All_Information()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
Users found = unitOfWork.Users.Get(t => t.AspNetUsers.PhoneNumber == "12345670");
Assert.AreEqual("*****@*****.**", found.AspNetUsers.Email);
Assert.AreEqual("Male", found.Gender.Gender1);
Assert.AreEqual("Username12", found.AspNetUsers.UserName);
Assert.AreEqual("Nordjylland", found.AddressTable.Region);
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void Deleting_Object_From_Database()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
var x = unitOfWork.Users.Create(GetUser());
bool result = unitOfWork.Users.Delete(t => t.ID == x.ID);
Assert.IsTrue(result);
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void Adding_Two_Same_Object_Throws_Exception()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
unitOfWork.Users.Create(GetAnotherUser());
}
catch (DuplicateKeyException)
{
int numberOfUsers = context.Users.Count();
int numberOfAddresses = context.AddressTable.Count();
int numberOfAspNetUsers = context.AspNetUsers.Count();
Assert.AreEqual(1, numberOfUsers);
Assert.AreEqual(1, numberOfAddresses);
Assert.AreEqual(1, numberOfAspNetUsers);
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.ServiceOffer.DeleteAllOnSubmit(secondContext.ServiceOffer);
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void Adding_Two_Same_Adds_First_Of_Them()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
var result = unitOfWork.Users.Create(GetUser());
Assert.IsNotNull(result);
unitOfWork.Users.Create(GetUser());
}
catch (DuplicateKeyException)
{
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.ServiceOffer.DeleteAllOnSubmit(secondContext.ServiceOffer);
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void Test_Create_Offer_With_Not_Existing_SubOffer_Throws_Exception_And_Do_Not_Add()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
var result = unitOfWork.Offers.Create(GetInvalidServiceOffer());
}
catch (Exception)
{
Assert.IsTrue(true);
Assert.AreEqual(0, context.GetTable <ServiceOffer>().Count());
}
finally
{
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.SubmitChanges();
context.Users.DeleteAllOnSubmit(context.Users);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.SubmitChanges();
}
}
}
public void Creates_One_Address_Record_If_Two_Users_Share_The_Same_Address()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
unitOfWork.Users.Create(ThirdUser());
int numberOfAddressRecords = context.AddressTable.Count();
Assert.AreEqual(1, numberOfAddressRecords);
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void Test_Getting_Specific_Service_Offer()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
ServiceOffer created = unitOfWork.Offers.Create(GetServiceOffer());
ServiceOffer result = unitOfWork.Offers.Get(t => t.ID == created.ID);
Assert.AreEqual("Cleaning", created.SubCategory.Name.ToString());
Assert.AreEqual(created.SubCategory, result.SubCategory);
}
catch
{
Assert.Fail();
}
finally
{
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.SubmitChanges();
context.Users.DeleteAllOnSubmit(context.Users);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.SubmitChanges();
}
}
}
public void Test_Getting_All_Service_Offers()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
unitOfWork.Offers.Create(GetServiceOffer());
unitOfWork.Offers.Create(GetSecondServiceOffer());
unitOfWork.Offers.Create(GetThirdServiceOffer());
var list = unitOfWork.Offers.GetAll();
Assert.AreEqual(3, list.Count());
}
catch
{
Assert.Fail();
}
finally
{
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.SubmitChanges();
context.Users.DeleteAllOnSubmit(context.Users);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.SubmitChanges();
}
}
}
public void Test_Fitering_Using_Rate_By_Hour()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
unitOfWork.Users.Create(SecondUser());
unitOfWork.Offers.Create(GetServiceOffer());
unitOfWork.Offers.Create(GetSecondServiceOffer());
unitOfWork.Offers.Create(GetThirdServiceOffer());
unitOfWork.Offers.Create(GetForthServiceOffer());
var list = unitOfWork.Offers.List(t => t.RatePerHour < 40);
Assert.AreEqual(3, list.Count());
}
catch
{
Assert.Fail();
}
finally
{
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.SubmitChanges();
context.Users.DeleteAllOnSubmit(context.Users);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.SubmitChanges();
}
}
}
public void Edition_Of_Users_Description_Returns_User_Is_Successed()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
Users u = unitOfWork.Users.Create(GetUser());
Users toUpdate = ToUpdate();
toUpdate.ID = u.ID;
toUpdate.LastUpdate = u.LastUpdate;
var result = unitOfWork.Users.AddDescription(toUpdate);
Assert.IsNotNull(result);
Assert.AreEqual("Description", result.Description);
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void Get_All_Users_From_Database()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
unitOfWork.Users.Create(GetUser());
unitOfWork.Users.Create(ThirdUser());
IQueryable <Users> listOfAvailableUsers = unitOfWork.Users.GetAll();
Assert.AreEqual(2, listOfAvailableUsers.ToArray().Count());
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.SubmitChanges();
}
}
public void Get_Available_Hours_From_For_Existing_Service_Which_Has_Already_Booked_Hours()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
//Creating users
var user = unitOfWork.Users.Create(GetUser());
//Creating service
var service = unitOfWork.Offers.Create(GetServiceOffer());
var workingDatesRequireAddingServiceID = GetWorkingDates();
var workingDatesRequireAddingServiceID2 = GetWorkingDatesSecond();
//Assign ID of service offer to woring dates
workingDatesRequireAddingServiceID.ServiceOffer_ID = service.ID;
workingDatesRequireAddingServiceID2.ServiceOffer_ID = service.ID;
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID2);
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID);
var shoppingcartRequireAddingIDs = GetShoppingCart();
//Assing ID of service offer to shopping cart
shoppingcartRequireAddingIDs.Service_ID = service.ID;
//Assing ID of user to shopping cart
shoppingcartRequireAddingIDs.User_ID = user.Logging_ID;
//Add shopping cart to a database.
unitOfWork.Orders.AddToCart(shoppingcartRequireAddingIDs);
unitOfWork.Orders.CreateOrder(user.Logging_ID);
var list = unitOfWork.Orders.GetHoursFrom(service.ID, new DateTime(2018, 12, 10));
Assert.AreEqual(7, list.Count);
}
catch
{
Assert.Fail();
}
finally
{
context.Users.DeleteAllOnSubmit(context.Users);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.Saleline.DeleteAllOnSubmit(context.Saleline);
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.ShoppingCart.DeleteAllOnSubmit(context.ShoppingCart);
context.OrderTable.DeleteAllOnSubmit(context.OrderTable);
context.WorkingDates.DeleteAllOnSubmit(context.WorkingDates);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.BookedDates.DeleteAllOnSubmit(context.BookedDates);
context.SubmitChanges();
}
}
}
public void Cancel_Of_Paid_Order_Returns_False()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
//Creating users
var user = unitOfWork.Users.Create(GetUser());
//Creating service
var service = unitOfWork.Offers.Create(GetServiceOffer());
var workingDatesRequireAddingServiceID = GetWorkingDates();
var workingDatesRequireAddingServiceID2 = GetWorkingDatesSecond();
//Assign ID of service offer to woring dates
workingDatesRequireAddingServiceID.ServiceOffer_ID = service.ID;
workingDatesRequireAddingServiceID2.ServiceOffer_ID = service.ID;
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID2);
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID);
var shoppingcartRequireAddingIDs = GetShoppingCart();
//Assing ID of service offer to shopping cart
shoppingcartRequireAddingIDs.Service_ID = service.ID;
//Assing ID of user to shopping cart
shoppingcartRequireAddingIDs.User_ID = user.Logging_ID;
//Add shopping cart to a database.
unitOfWork.Orders.AddToCart(shoppingcartRequireAddingIDs);
var result = unitOfWork.Orders.CreateOrder(user.Logging_ID);
var paid = unitOfWork.Orders.PayForOrder(result);
Order o = new Order
{
ID = paid.ID,
};
Assert.IsFalse(unitOfWork.Orders.CancelOrder(o));
}
catch
{
Assert.Fail();
}
finally
{
context.Users.DeleteAllOnSubmit(context.Users);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.Saleline.DeleteAllOnSubmit(context.Saleline);
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.ShoppingCart.DeleteAllOnSubmit(context.ShoppingCart);
context.OrderTable.DeleteAllOnSubmit(context.OrderTable);
context.WorkingDates.DeleteAllOnSubmit(context.WorkingDates);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.BookedDates.DeleteAllOnSubmit(context.BookedDates);
context.SubmitChanges();
}
}
}
public void Creation_Of_Two_Orders_With_Same_OrderService_Returns_Exception()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
//Creating users
var user = unitOfWork.Users.Create(GetUser());
//Creating service
var service = unitOfWork.Offers.Create(GetServiceOffer());
var workingDatesRequireAddingServiceID = GetWorkingDates();
var workingDatesRequireAddingServiceID2 = GetWorkingDatesSecond();
//Assign ID of service offer to woring dates
workingDatesRequireAddingServiceID.ServiceOffer_ID = service.ID;
workingDatesRequireAddingServiceID2.ServiceOffer_ID = service.ID;
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID2);
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID);
var shoppingcartRequireAddingIDs = GetShoppingCart();
//Assing ID of service offer to shopping cart
shoppingcartRequireAddingIDs.Service_ID = service.ID;
//Assing ID of user to shopping cart
shoppingcartRequireAddingIDs.User_ID = user.Logging_ID;
//Add shopping cart to a database.
unitOfWork.Orders.AddToCart(shoppingcartRequireAddingIDs);
unitOfWork.Orders.CreateOrder(user.Logging_ID);
unitOfWork.Orders.CreateOrder(user.Logging_ID);
Assert.Fail();
}
catch (BookedTimeException)
{
Assert.IsTrue(true);
}
finally
{
context.Users.DeleteAllOnSubmit(context.Users);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.Saleline.DeleteAllOnSubmit(context.Saleline);
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.ShoppingCart.DeleteAllOnSubmit(context.ShoppingCart);
context.OrderTable.DeleteAllOnSubmit(context.OrderTable);
context.WorkingDates.DeleteAllOnSubmit(context.WorkingDates);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.BookedDates.DeleteAllOnSubmit(context.BookedDates);
context.SubmitChanges();
}
}
}
public void Paying_For_Order_Set_Its_Status_As_Completed()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
//Creating users
var user = unitOfWork.Users.Create(GetUser());
//Creating service
var service = unitOfWork.Offers.Create(GetServiceOffer());
var workingDatesRequireAddingServiceID = GetWorkingDates();
var workingDatesRequireAddingServiceID2 = GetWorkingDatesSecond();
//Assign ID of service offer to woring dates
workingDatesRequireAddingServiceID.ServiceOffer_ID = service.ID;
workingDatesRequireAddingServiceID2.ServiceOffer_ID = service.ID;
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID2);
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID);
var shoppingcartRequireAddingIDs = GetShoppingCart();
//Assing ID of service offer to shopping cart
shoppingcartRequireAddingIDs.Service_ID = service.ID;
//Assing ID of user to shopping cart
shoppingcartRequireAddingIDs.User_ID = user.Logging_ID;
//Add shopping cart to a database.
unitOfWork.Orders.AddToCart(shoppingcartRequireAddingIDs);
var result = unitOfWork.Orders.CreateOrder(user.Logging_ID);
var paid = unitOfWork.Orders.PayForOrder(result);
Assert.AreEqual("Completed", paid.OrderStatus.Order_status.ToString());
}
catch
{
Assert.Fail();
}
finally
{
context.Users.DeleteAllOnSubmit(context.Users);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.Saleline.DeleteAllOnSubmit(context.Saleline);
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.ShoppingCart.DeleteAllOnSubmit(context.ShoppingCart);
context.OrderTable.DeleteAllOnSubmit(context.OrderTable);
context.WorkingDates.DeleteAllOnSubmit(context.WorkingDates);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.BookedDates.DeleteAllOnSubmit(context.BookedDates);
context.SubmitChanges();
}
}
}
public void Delete_Item_From_Shopping_Cart_Works()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
//Creating users
var user = unitOfWork.Users.Create(GetUser());
//Creating service
var service = unitOfWork.Offers.Create(GetServiceOffer());
var workingDatesRequireAddingServiceID = GetWorkingDates();
//Assign ID of service offer to woring dates
workingDatesRequireAddingServiceID.ServiceOffer_ID = service.ID;
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID);
var shoppingcartRequireAddingIDs = GetShoppingCart();
//Assing ID of service offer to shopping cart
shoppingcartRequireAddingIDs.Service_ID = service.ID;
//Assing ID of user to shopping cart
shoppingcartRequireAddingIDs.User_ID = user.Logging_ID;
//Add shopping cart to a database.
var shoppingcartAdded = unitOfWork.Orders.AddToCart(shoppingcartRequireAddingIDs);
unitOfWork.Orders.DeleteFromCart(shoppingcartRequireAddingIDs);
Assert.AreEqual(0, unitOfWork.Orders.GetShoppingCart(user.Logging_ID).Count);
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.Saleline.DeleteAllOnSubmit(secondContext.Saleline);
secondContext.ServiceOffer.DeleteAllOnSubmit(secondContext.ServiceOffer);
secondContext.ShoppingCart.DeleteAllOnSubmit(secondContext.ShoppingCart);
secondContext.OrderTable.DeleteAllOnSubmit(secondContext.OrderTable);
secondContext.WorkingDates.DeleteAllOnSubmit(secondContext.WorkingDates);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.BookedDates.DeleteAllOnSubmit(secondContext.BookedDates);
secondContext.SubmitChanges();
}
}
public void Add_Working_Date_That_Clashes_Existing_One_Fails()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
//Creating users
var user = unitOfWork.Users.Create(GetUser());
//Creating service
var service = unitOfWork.Offers.Create(GetServiceOffer());
var workingDatesRequireAddingServiceID = GetWorkingDates();
var workingDatesRequireAddingServiceID2 = GetWorkingDatesThatClashes();
//Assign ID of service offer to working dates
workingDatesRequireAddingServiceID.ServiceOffer_ID = service.ID;
workingDatesRequireAddingServiceID2.ServiceOffer_ID = service.ID;
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID);
var contextC = new DbTestDataContext();
using (var unitOfWork2 = new UnitOfWork(contextC))
{
var isAdded = unitOfWork2.Offers.AddWorkingDates(workingDatesRequireAddingServiceID2);
Assert.IsFalse(isAdded);
}
}
catch
{
Assert.Fail();
}
}
var secondContext = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(secondContext))
{
secondContext.Users.DeleteAllOnSubmit(secondContext.Users);
secondContext.AddressTable.DeleteAllOnSubmit(secondContext.AddressTable);
secondContext.Saleline.DeleteAllOnSubmit(secondContext.Saleline);
secondContext.ServiceOffer.DeleteAllOnSubmit(secondContext.ServiceOffer);
secondContext.ShoppingCart.DeleteAllOnSubmit(secondContext.ShoppingCart);
secondContext.OrderTable.DeleteAllOnSubmit(secondContext.OrderTable);
secondContext.WorkingDates.DeleteAllOnSubmit(secondContext.WorkingDates);
secondContext.AspNetUsers.DeleteAllOnSubmit(secondContext.AspNetUsers);
secondContext.BookedDates.DeleteAllOnSubmit(secondContext.BookedDates);
secondContext.SubmitChanges();
}
}
public void Add_TestClassUserObjectPassed()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
var result = unitOfWork.Users.Create(GetUser());
Assert.IsNotNull(result);
Assert.IsNotNull(context.Users.FirstOrDefault());
context.Users.DeleteAllOnSubmit(context.Users);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.SubmitChanges();
}
}
public void Get_Available_Hours_To_For_Existing_Service()
{
var context = new DbTestDataContext();
using (var unitOfWork = new UnitOfWork(context))
{
try
{
//Creating users
var user = unitOfWork.Users.Create(GetUser());
//Creating service
var service = unitOfWork.Offers.Create(GetServiceOffer());
var workingDatesRequireAddingServiceID = GetWorkingDates();
var workingDatesRequireAddingServiceID2 = GetWorkingDatesSecond();
//Assign ID of service offer to woring dates
workingDatesRequireAddingServiceID.ServiceOffer_ID = service.ID;
workingDatesRequireAddingServiceID2.ServiceOffer_ID = service.ID;
//Adds working dates for the offer
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID2);
unitOfWork.Offers.AddWorkingDates(workingDatesRequireAddingServiceID);
var list = unitOfWork.Orders.GetHoursTo(service.ID, new DateTime(2018, 12, 10), new TimeSpan(17, 0, 0));
Assert.AreEqual(3, list.Count);
}
catch
{
Assert.Fail();
}
finally
{
context.Users.DeleteAllOnSubmit(context.Users);
context.AddressTable.DeleteAllOnSubmit(context.AddressTable);
context.Saleline.DeleteAllOnSubmit(context.Saleline);
context.ServiceOffer.DeleteAllOnSubmit(context.ServiceOffer);
context.ShoppingCart.DeleteAllOnSubmit(context.ShoppingCart);
context.OrderTable.DeleteAllOnSubmit(context.OrderTable);
context.WorkingDates.DeleteAllOnSubmit(context.WorkingDates);
context.AspNetUsers.DeleteAllOnSubmit(context.AspNetUsers);
context.BookedDates.DeleteAllOnSubmit(context.BookedDates);
context.SubmitChanges();
}
}
}
