public static DataTable GetCroaziere(string connectionString)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
string cmdText = "Select * from Croaziere;";
using (SqlCommand cmd = new SqlCommand(cmdText, con))
{
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
DataTable table = new DataTable();
adapter.Fill(table);
table.Columns.Add("Circuit");
foreach (DataRow row in table.Rows)
{
List <int> porturi = row["Lista_porturi"].ToString().Split(',').Select(x => Int32.Parse(x)).ToList();
string circuit = SqlDataAcces.GetCircuitByArray(porturi);
row["Circuit"] = circuit;
}
return(table);
}
}
}
}
