protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Garagens garagem = new Garagens();
lblConsDataRetirada.Text = Session["consDataRetirada"].ToString();
lblConsDataEntrega.Text = Session["consDataEntrega"].ToString();
lblConsGaragemRetirada.Text = garagem.GetNomeGaragem(Convert.ToInt32(Session["ConsGaragemRetirada"]));
lblConsGaragemEntrega.Text = garagem.GetNomeGaragem(Convert.ToInt32(Session["ConsGaragemEntrega"]));
SqlConnection sqlConnection1 = new SqlConnection("Data Source=ROCKENBACH-NOTE\\SQLEXPRESS;Initial Catalog=ZipCar;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
cmd.CommandText = "select c.* from carro c inner join carro_has_garagem cg on c.idCarro = cg.idCarro " +
" where cg.idGaragem = " + Session["ConsGaragemRetirada"].ToString() +
" and not exists (select 1 from cliente_aluga_carro ac where c.idCarro = ac.idCarro and ac.dataHoraDevolvido is null)";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
reader = cmd.ExecuteReader();
gridCarros.DataSource = reader;
gridCarros.DataBind();
}
}
