public ActionResult InterogareDoi(List <IntergareCompelxa4> x)
{
List <IntergareCompelxa4> comenzi = new List <IntergareCompelxa4>();
SqlConnection connection = new SqlConnection("data source = DESKTOP-IBNRKP3\\SQLEXPRESS; initial catalog = BD_Project; integrated security = True");
SqlCommand cmd = new SqlCommand(@"
Select c.IdComenzi, c.TimpStart, c.TimpStop from Comenzi c
where c.IdComenzi in (
select cb.IdComenzi from Comenzi_Biciclete cb
inner join Bicicleta b on b.IdBicicleta = cb.IdBicicleta
where b.Pret_h > " + x[0].pret + " group by cb.IdComenzi)", connection);
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
IntergareCompelxa4 interogare = new IntergareCompelxa4();
Comenzi z = new Comenzi();
z.IdComenzi = reader.GetInt32(0);
z.TimpStart = reader.GetDateTime(1);
z.TimpStop = reader.GetDateTime(2);
interogare.coamnda = z;
comenzi.Add(interogare);
}
reader.Close();
return(View(comenzi));
}
public ActionResult InterogareDoi()
{
List <IntergareCompelxa4> y = new List <IntergareCompelxa4>();
IntergareCompelxa4 z = new IntergareCompelxa4();
y.Add(z);
return(View(y));
}
