public MainWindow()
{
InitializeComponent();
using (NumbersContext dbOne = new NumbersContext())
{
dbOne.Database.ExecuteSqlCommand("TRUNCATE TABLE [SortNumbers]");
dbOne.Database.ExecuteSqlCommand("TRUNCATE TABLE [Numbers]");
}
}
private void RandomOneTable_Click(object sender, RoutedEventArgs e)
{
Random rnd = new Random();
using (NumbersContext dbOne = new NumbersContext())
{
for (int i = 0; i < 10; i++)
{
Number number = new Number();
number.Number_Rand = rnd.Next(1, 11);
dbOne.Numbers.Add(number);
}
dbOne.SaveChanges();
dbOne.Numbers.Load();
DataGridOne.ItemsSource = dbOne.Numbers.Local.ToBindingList();
}
}
private void SortTwoTable_Click(object sender, RoutedEventArgs e)
{
using (NumbersContext dbOne = new NumbersContext())
{
dbOne.SortTable.Load();
var sort_tab = dbOne.Numbers.OrderBy(c => c.Number_Rand);
Console.WriteLine(dbOne.Numbers.Count());
for (int i = 0; i < 10; i++)
{
SortNumber sort = new SortNumber();
Console.WriteLine(i);
sort.Number_Sort = sort_tab.Select(c => c.Number_Rand).AsEnumerable().ElementAtOrDefault(i);
dbOne.SortTable.Add(sort);
}
dbOne.SaveChanges();
dbOne.SortTable.Load();
DataGridTwo.ItemsSource = dbOne.SortTable.Local.ToBindingList();
}
}
public IndexModel(ILogger <IndexModel> logger, NumbersContext context)
{
_logger = logger;
_context = context;
}
public ListnumbersModel(NumbersContext context)
{
_context = context;
}
public Ostatnio_SzukaneModel(NumbersContext context)
{
_context = context;
}
