public void RepositoryUpdate()
{
//arrange
var connection = DbConnectionFactory.CreateTransient();
var stubDB = new GroceryStoreContext(connection);
var userRepo = new EfGenericRepository <User>(stubDB);
var user = new User
{
FirstName = "Pesho",
LastName = "Pesho",
Username = "******",
Password = "******",
PhoneNumber = "Pesho"
};
userRepo.Add(user);
stubDB.SaveChanges();
//act
user.Password = "******";
userRepo.Update(user);
string actual = userRepo.GetById(1).Password;
//assert
Assert.AreEqual("newPassword", actual);
}
public void RepositoryGetById()
{
//arrange
var connection = DbConnectionFactory.CreateTransient();
var stubDB = new GroceryStoreContext(connection);
var userRepo = new EfGenericRepository <User>(stubDB);
var userToAdd = new User
{
FirstName = "Pesho",
LastName = "Pesho",
Username = "******",
Password = "******",
PhoneNumber = "Pesho"
};
userRepo.Add(userToAdd);
stubDB.SaveChanges();
//act
var actual = userRepo.GetById(1);
//assert
Assert.AreEqual(userToAdd.Username, actual.Username);
}
// Seed database through GroceryStoreAPI project's Startup class
// TODO: Find a better way to seed database
public static void SeedDatabase()
{
using (StreamReader r = new StreamReader("database.json"))
{
string json = r.ReadToEnd();
var jsonData = JsonConvert.DeserializeObject <RootObject>(json);
using (var dataContext = new GroceryStoreContext())
{
foreach (Customer customer in jsonData.customers)
{
dataContext.Customers.Add(customer);
}
foreach (Order order in jsonData.orders)
{
dataContext.Orders.Add(order);
}
foreach (Product product in jsonData.products)
{
dataContext.Products.Add(product);
}
dataContext.SaveChanges();
}
}
}
public static void UpdateProduct(Product product)
{
using (var dataContext = new GroceryStoreContext())
{
dataContext.Products.Update(product);
dataContext.SaveChanges();
}
}
public static void UpdateCustomer(Customer customer)
{
using (var dataContext = new GroceryStoreContext())
{
dataContext.Customers.Update(customer);
dataContext.SaveChanges();
}
}
public static List <Customer> GetCustomers()
{
using (var dataContext = new GroceryStoreContext())
{
return(dataContext.Customers
.OrderBy(c => c.name)
.ToList());
}
}
public static List <Order> GetOrdersByDate(string orderDate)
{
using (var dataContext = new GroceryStoreContext())
{
return(dataContext.Orders
.Where(o => o.orderDate != null && o.orderDate == DateTime.ParseExact(orderDate, "d", CultureInfo.InvariantCulture))
.ToList());
}
}
public static Customer GetCustomerById(int id)
{
using (var dataContext = new GroceryStoreContext())
{
return(dataContext.Customers
.Where(c => c.id == id)
.FirstOrDefault());
}
}
public static List <Product> GetProducts()
{
using (var dataContext = new GroceryStoreContext())
{
return(dataContext.Products
.OrderBy(p => p.description)
.ToList());
}
}
public static int AddProduct(Product product)
{
using (var dataContext = new GroceryStoreContext())
{
dataContext.Products.Add(product);
dataContext.SaveChanges();
return(product.id);
}
}
public static Product GetProductById(int id)
{
using (var dataContext = new GroceryStoreContext())
{
return(dataContext.Products
.Where(p => p.id == id)
.FirstOrDefault());
}
}
public static List <Order> GetOrders()
{
using (var dataContext = new GroceryStoreContext())
{
return(dataContext.Orders
.OrderByDescending(o => o.orderDate)
.ToList());
}
}
public static Order GetOrderById(int id)
{
using (var dataContext = new GroceryStoreContext())
{
return(dataContext.Orders
.Where(o => o.id == id)
.FirstOrDefault());
}
}
public static int AddCustomer(string customerName)
{
var customer = new Customer();
customer.name = customerName;
using (var dataContext = new GroceryStoreContext())
{
dataContext.Customers.Add(customer);
dataContext.SaveChanges();
return(customer.id);
}
}
public static List <Order> GetOrdersByCustomer(string customerName)
{
using (var dataContext = new GroceryStoreContext())
{
return((from o in dataContext.Orders
join c in dataContext.Customers on o.customerId equals c.id
where c.name.Contains(customerName)
select o)
.OrderByDescending(o => o.orderDate)
.ToList());
}
}
public void RepositoryAll()
{
//arrange
var connection = DbConnectionFactory.CreateTransient();
var stubDB = new GroceryStoreContext(connection);
var userRepo = new EfGenericRepository <User>(stubDB);
var userToAdd = new User
{
FirstName = "Pesho",
LastName = "Pesho",
Username = "******",
Password = "******",
PhoneNumber = "Pesho"
};
var userToAdd1 = new User
{
FirstName = "Pesho1",
LastName = "Pesho1",
Username = "******",
Password = "******",
PhoneNumber = "Pesho1"
};
var userToAdd2 = new User
{
FirstName = "Pesho2",
LastName = "Pesho2",
Username = "******",
Password = "******",
PhoneNumber = "Pesho2"
};
stubDB.Users.Add(userToAdd);
stubDB.Users.Add(userToAdd1);
stubDB.Users.Add(userToAdd2);
stubDB.SaveChanges();
//act
var allUsers = userRepo.All;
//assert
Assert.AreEqual(3, allUsers.Count());
Assert.IsInstanceOfType(allUsers, typeof(IQueryable));
}
public MainWindow()
{
InitializeComponent();
this.context = new GroceryStoreContext();
// From StartUp:
Database.SetInitializer(new MigrateDatabaseToLatestVersion <GroceryStoreContext, Configuration>());
AutomapperConfiguration.Initialize();
var builder = new ContainerBuilder();
builder.RegisterAssemblyModules(Assembly.GetExecutingAssembly());
this.container = builder.Build();
// Read products from JSON
if (this.context.Products.Count() == 0)
{
ReadJsonFile("C:/Users/Jivka/Desktop/products.json");
}
FillCategories();
}
public void RepositoryAddEntity()
{
//arrange
var connection = DbConnectionFactory.CreateTransient();
var stubDB = new GroceryStoreContext(connection);
var userRepo = new EfGenericRepository <User>(stubDB);
var userToAdd = new User
{
FirstName = "Pesho",
LastName = "Pesho",
Username = "******",
Password = "******",
PhoneNumber = "Pesho"
};
//act
userRepo.Add(userToAdd);
stubDB.SaveChanges();
//assert
Assert.AreEqual(1, stubDB.Users.Count());
}
public void RepositoryAddCollection()
{
//arrange
var connection = DbConnectionFactory.CreateTransient();
var stubDB = new GroceryStoreContext(connection);
var userRepo = new EfGenericRepository <User>(stubDB);
var user1 = new User
{
FirstName = "Pesho",
LastName = "Peshev",
Username = "******",
Password = "******",
PhoneNumber = "12345678"
};
var user2 = new User
{
FirstName = "Gosho",
LastName = "Goshev",
Username = "******",
Password = "******",
PhoneNumber = "09876543"
};
var collection = new List <User>()
{
user1, user2
};
//act
userRepo.Add(collection);
stubDB.SaveChanges();
//assert
Assert.AreEqual(2, stubDB.Users.Count());
}
public void RepositoryAdd()
{
// Arrange
var connection = DbConnectionFactory.CreateTransient();
var mockDB = new GroceryStoreContext(connection);
var userRepo = new EfGenericRepository <User>(mockDB);
var addressRepo = new EfGenericRepository <Address>(mockDB);
var user = new User {
Username = "******", Password = "******", PhoneNumber = "1234567890"
};
var addressToAdd = new Address {
AddressText = "Pesho", UserId = 1
};
// Act
userRepo.Add(user);
//addressRepo.Add(addressToAdd);
// Assert
Assert.AreEqual(1, mockDB.Users.Count());
//Assert.AreEqual(1, mockDB.Addresses.Count());
}
public GroceriesController(GroceryStoreContext context)
{
_context = context;
}
public HomeController(GroceryStoreContext context)
{
_context = context;
}
public CustomerRepository(GroceryStoreContext ctx)
{
_ctx = ctx;
}
