static void Main(string[] args)
{
//DbManager dbManager = new DbManager();
MigrationManager migrationManager = new MigrationManager();
migrationManager.DropTables();
migrationManager.CreateTables();
migrationManager.ImportStartValues();
Menu menu = new Menu();
menu.MainMenu();
//migrationManager.DropTables();
//migrationManager.CreateTables();
//migrationManager.ImportStartValues();
//UserFilter userFilter = new UserFilter() { Email = "adasd", FirstName="asd", HashPassword="******", LastName="asd" };
//var user = mapper.Map<UserFilter, User> (userFilter);
//Console.WriteLine(user);
//dbManager.CommandExecuteNonQuery(@"insert into tblRole (Name) Values ('Admin'), ('Customer');");
//var reader = dbManager.GetDataReader(@"select Id, Name from tblRole;");
//while (reader.Read())
//{
// Console.WriteLine("{0}\t{1}", reader.GetInt32(0),
// reader.GetString(1));
//}
//UsersRepository usersRepo = new UsersRepository();
//User entity = new User { FirstName = "Alll", LastName = "PPP", Email = "*****@*****.**", HashPassword = "******", RoleId = 1 };
//entity = usersRepo.Create(entity);
// Console.WriteLine(usersRepo.Update(entity));
//usersRepo.Delete(new UserFilter() { FirstName = "Alll", Id = 1 });
//var res = usersRepo.Update(entity, new UserFilter() { Id = 2 });
//Console.WriteLine(usersRepo.Get(new UserFilter() { }) );
//IEnumerable<User> users = usersRepo.GetRange(new UserFilter() {Id = 0, RoleId = 0 }, new UserFilter() { Id = 4, RoleId = 2 }, new UserFilter() { Email = "*****@*****.**" });
//IEnumerable<User> users = usersRepo.GetAll();
//foreach (User el in users)
//{
// Console.WriteLine("==================================");
// Console.WriteLine(el);
//}
//Console.WriteLine(entity);
//var _user = usersRepo.Get(0
//Console.WriteLine(_user.FirstName + _user.LastName);
//SuppliersRepository suppliersRepository = new SuppliersRepository();
//Supplier supplier = new Supplier() { Id = 1, Name = "asd" };
//suppliersRepository.Create(supplier);
//ProductsRepository productsRepository = new ProductsRepository();
//Product product = new Product() { Id = 1, Name = "asd", Brand="asd", Price=123, ProducingCountry="asd"};
//productsRepository.Create(product);
//var products = productsRepository.GetAll();
//foreach (Product el in products)
//{
// Console.WriteLine("==================================");
// Console.WriteLine(el);
//}
//Console.Read();
}
