protected void Page_Load(object sender, EventArgs e)
{
CarsInfoEntities db = new CarsInfoEntities();
var result = from a in db.Brands
select new { a.BrandName };
GridView1.DataSource = result;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
String index = Request.QueryString["index"];
CarsInfoEntities db = new CarsInfoEntities();
Brand br = db.Brands.FirstOrDefault(m => m.BrandName == index);
br.BrandName = txtboxBrand.Text;
db.SaveChanges();
ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Brand Name has been successfully updated')</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
String index = Request.QueryString["index"];
CarsInfoEntities db = new CarsInfoEntities();
Brand br = db.Brands.FirstOrDefault(m => m.BrandName == index);
txtboxBrand.Text = br.BrandName;
}
}
protected void Page_Load(object sender, EventArgs e)
{
CarsInfoEntities db = new CarsInfoEntities();
var result = from t in db.Cars
join x in db.Brands on t.BrandId equals x.BrandId
select new { x.BrandName, t.Model, t.Costs };
GridView1.DataSource = result;
GridView1.DataBind();
}
protected void GridView1_RowEditing1(object sender, GridViewEditEventArgs e)
{
String index = GridView1.DataKeys[e.NewEditIndex].Value.ToString();
CarsInfoEntities db = new CarsInfoEntities();
var data =
(from c in db.Cars
where c.Model == index
select new { c.BrandId }).ToList();
String id = data.ElementAt(0).BrandId.ToString();
Server.Transfer("CarEdit.aspx?index=" + index + "&id=" + id);
}
protected void Button1_Click(object sender, EventArgs e)
{
CarsInfoEntities db = new CarsInfoEntities();
var data =
from c in db.Brands
where c.BrandName == txtSearch.Text
select new { c.BrandName };
GridView1.Visible = false;
GridView2.DataSource = data;
GridView2.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
CarsInfoEntities db = new CarsInfoEntities();
var result = from t in db.Cars
join x in db.Brands on t.BrandId equals x.BrandId
where t.Model == txtModel.Text
select new { x.BrandName, t.Model, t.Costs };
GridView1.Visible = false;
GridView2.DataSource = result;
GridView2.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
String index = Request.QueryString["index"];
String id = Request.QueryString["id"];
CarsInfoEntities db = new CarsInfoEntities();
Car c = db.Cars.FirstOrDefault(m => m.Model == index);
c.Model = txtModel.Text;
c.BrandId = int.Parse(ddlBrand.SelectedValue);
c.Costs = int.Parse(txtCosts.Text);
db.SaveChanges();
ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Car details have been successfully updated')</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
CarsInfoEntities db = new CarsInfoEntities();
String index = Request.QueryString["index"];
String id = Request.QueryString["id"];
ddlBrand.SelectedValue = id;
Car c = db.Cars.FirstOrDefault(m => m.Model == index);
txtModel.Text = c.Model;
txtCosts.Text = Convert.ToString(c.Costs);
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
String s = GridView1.DataKeys[e.RowIndex].Value.ToString();
CarsInfoEntities db = new CarsInfoEntities();
Car c = db.Cars.FirstOrDefault(m => m.Model == s);
db.DeleteObject(c);
db.SaveChanges();
ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Record has been deleted successfully')</script>");
var result = from t in db.Cars
join x in db.Brands on t.BrandId equals x.BrandId
select new { x.BrandName, t.Model, t.Costs };
GridView1.DataSource = result;
GridView1.DataBind();
}
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
String s = GridView2.DataKeys[e.RowIndex].Value.ToString();
CarsInfoEntities db = new CarsInfoEntities();
Brand br = db.Brands.FirstOrDefault(m => m.BrandName == s);
db.DeleteObject(br);
db.SaveChanges();
ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Record has been deleted successfully')</script>");
var data = from a in db.Brands
select new { a.BrandName };
GridView1.Visible = true;
GridView2.Visible = false;
GridView1.DataSource = data;
GridView1.DataBind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
String s = GridView1.DataKeys[e.RowIndex].Value.ToString();
CarsInfoEntities db = new CarsInfoEntities();
Brand br = db.Brands.FirstOrDefault(m => m.BrandName == s);
db.DeleteObject(br);
try
{
db.SaveChanges();
}
catch (Exception)
{
ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Cannot delete record. Foreign key constraint violated.')</script>");
}
ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Record has been deleted successfully')</script>");
var data = from a in db.Brands
select new { a.BrandName };
GridView1.DataSource = data;
GridView1.DataBind();
}
