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];
}
}
}
}
}
