private void button2_Click(object sender, EventArgs e)
{
ServiceFilteringClient client = new ServiceFilteringClient();
DataTable dt = new DataTable("laptops");
int columnCount = 0;
List <int> columnNumbers = new List <int>();
foreach (DataGridViewColumn dataGridViewColumn in dataGridView1.Columns)
{
if (dataGridViewColumn.Visible)
{
dt.Columns.Add(dataGridViewColumn.Name);
columnNumbers.Add(columnCount);
}
columnCount++;
}
var cell = new object[columnNumbers.Count];
foreach (DataGridViewRow dataGridViewRow in dataGridView1.Rows)
{
int i = 0;
foreach (int a in columnNumbers)
{
cell[i] = dataGridViewRow.Cells[a].Value;
i++;
}
dt.Rows.Add(cell);
}
dataGridView1.Rows.Clear();
DataTable firtredValue = client.filteringBrand(dt, brandChoose);
dataGridView1.Rows.Add();
for (int i = 0; i < firtredValue.Rows.Count; i++)
{
dataGridView1.Rows.Add();
for (int j = 0; j < firtredValue.Columns.Count; j++)
{
dataGridView1.Rows[i].Cells[j].Value = firtredValue.Rows[i][j].ToString();
}
}
laptopCount.Text = "Liczba laptopów: " + firtredValue.Rows.Count;
}
public void LoadDataFromDB()
{
ServiceFilteringClient client = new ServiceFilteringClient();
DataTable dt = client.GetDataFromDataBase();
dataGridView1.Rows.Clear();
laptopCount.Text = "Liczba laptopów: " + dt.Rows.Count;
dataGridView1.Rows.Add();
int k = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
dataGridView1.Rows.Add();
for (int j = 1, s = 0; j < dt.Columns.Count && s < dt.Columns.Count; j++, s++)
{
dataGridView1.Rows[i].Cells[s].Value = dt.Rows[i][j].ToString();
}
}
}
public void AddAspectRation()
{
DataTable dt = new DataTable("laptops");
int columnCount = 0;
List <int> columnNumbers = new List <int>();
foreach (DataGridViewColumn dataGridViewColumn in dataGridView1.Columns)
{
if (dataGridViewColumn.Visible)
{
dt.Columns.Add(dataGridViewColumn.Name);
columnNumbers.Add(columnCount);
}
columnCount++;
}
var cell = new object[columnNumbers.Count];
foreach (DataGridViewRow dataGridViewRow in dataGridView1.Rows)
{
int i = 0;
foreach (int a in columnNumbers)
{
cell[i] = dataGridViewRow.Cells[a].Value;
i++;
}
dt.Rows.Add(cell);
}
ServiceFilteringClient client = new ServiceFilteringClient();
string[] list = client.aspectRatioList(dt);
if (ScreenChooseComboBox.Items.Count == 0)
{
for (int i = 0; i < list.Length; i++)
{
ScreenChooseComboBox.Items.Add(list[i]);
}
}
}
