protected void DropDownListFabio_TextChanged(object sender, EventArgs e)
{
var valor = Convert.ToInt32(DropDownListFabio.SelectedItem.Value);
using (var db = new DefaultConection())
{
//var query = (from brand in db.CarBrands
// join models in db.CarModels
// on brand.CarBrandId equals models.CarBrandId
// where brand.CarBrandId == valor
// select new { Brand = brand, Models = models });
var query = (from regis in db.Regis
join manu in db.MaintenanceTips
on regis.cb equals manu.carbrandId.ToString()
where manu.carbrandId == valor
select new { Manu = manu, Regis = regis });
foreach (var item in query)
{
item.Manu.tip = item.Manu.tip + "\teach\t" + item.Manu.km + "\tkm";
}
GridView1.DataSource = query.ToList();
GridView1.DataBind();
}
}
private void CarregaDropDownlist()
{
using (var db = new DefaultConection())
{
var query = (from b in db.Regis
select b.cb).Distinct();
foreach (var item in query)
{
DropDownListFabio.Items.Add(new ListItem(item));
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//lembrar de tratar os campos e duplicados
//trate todos os erros aqui...
if (!Page.IsValid)
{
LabelError.Visible = true;
return;
}
using (var db = new DefaultConection())
{
Regi rg = new Regi
{
cb = DropDownList1.SelectedValue,
cm = DropDownList2.SelectedValue,
cy = txtCarYear.Text,
m = txtMilage.Text
};
db.Regis.Add(rg);
db.SaveChanges();
LabelSucesso.Visible = true;
LabelSucesso.Text = "Register Inserted";
txtCarYear.Text = "";
txtMilage.Text = "";
DropDownList1.SelectedIndex = 0;
DropDownList2.SelectedIndex = 0;
}
#region Apagar este Parte do Codigo
//string constring = "Data Source=KARANAULAKH\\SQLEXPRESS;Initial Catalog=CARMODELS;Integrated Security=True";
//SqlConnection connect = new SqlConnection(constring);
//SqlCommand command = new SqlCommand("Insert into Regis values(@cb,@cm,@cy,@m)", connect);
//command.Parameters.AddWithValue("@cb", DropDownList1.SelectedItem.Value);
//command.Parameters.AddWithValue("@cm", DropDownList2.SelectedItem.Value);
//command.Parameters.AddWithValue("@cy", txtCarYear.Text);
//command.Parameters.AddWithValue("@m", txtMilage.Text);
//connect.Open();
//command.ExecuteNonQuery();
//Label.Text = "successful";
//DropDownList1.SelectedItem.Value = "";
//DropDownList2.SelectedItem.Value = "";
//txtCarYear.Text = "";
//txtMilage.Text = "";
//connect.Close();
#endregion
}
private void LoadGrids()
{
using (var db = new DefaultConection())
{
var query = (from brand in db.CarBrands
select new { Brand = brand });
GridViewBrands.DataSource = query.ToList();
GridViewBrands.DataBind();
var query1 = (from models in db.CarModels
select new { Model = models });
GridViewModels.DataSource = query1.ToList();
GridViewModels.DataBind();
}
}
private void CarregaDropDownlists()
{
using (var db = new DefaultConection())
{
var query = (from b in db.CarBrands
select b.CarBrandId).Distinct();
foreach (var item in query)
{
DropDownList1.Items.Add(new ListItem(item.ToString()));
}
var query1 = (from c in db.CarModels
select c.CarModelId).Distinct();
foreach (var item in query1)
{
DropDownList2.Items.Add(new ListItem(item.ToString()));
}
}
}
