public void ThenTheRowsOfTheCartPriceShouldBe(Table expected) { List <string> rows = _website.tshirtPage.GetCartPriceRows(); List <string> expectedRows = TableMethods.TableToList(expected); Assert.That(rows[0], Is.EqualTo(expectedRows[0])); Assert.That(rows[1], Is.EqualTo(expectedRows[1])); Assert.That(rows[2], Is.EqualTo(expectedRows[2])); }
private void button2_Click(object sender, EventArgs e) { string selectStatement = "Select Nume,DataStart,DataStop,Frecventa,Ziua " + "from Planificari p ,Localitati l " + "where p.IDLocalitate = l.IDLocalitate"; using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand(selectStatement, con)) { DateTime datastart = dateTimePicker1.Value; DateTime datastop = dateTimePicker2.Value; int ziuastart = datastart.Day; int ziuastop = datastop.Day; command.Parameters.AddWithValue("datastart", datastart.ToString()); command.Parameters.AddWithValue("datastop", datastop.ToString()); command.CommandType = CommandType.Text; using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command)) { using (DataTable table = new DataTable()) { dataAdapter.Fill(table); DataTable newTable = TableMethods.Fill(table, datastart, datastop); newTable.DefaultView.Sort = "DataStart ASC"; newTable.Columns["Nume"].ColumnName = "Localitate"; dataGridView2.DataSource = newTable; //dataGridView2.Sort(dataGridView2.Columns["DataStart"], ListSortDirection.Ascending); DataTable itinerariu = new DataTable(); itinerariu.Columns.Add("Localitate", typeof(string)); itinerariu.Columns.Add("Data", typeof(DateTime)); dataGridView3.DataSource = FillVizualizareItinerariu.Fill(newTable, itinerariu); dataGridView3.Columns["Image"].Visible = false; tabControl1.SelectedTab = tabControl1.TabPages[1]; } } } } }