protected void btnEdit_Click(object sender, EventArgs e)
{
string name = txtNameEd.Text;
int type = Convert.ToInt32(ddTypeEd.SelectedItem.Value);
int id = Convert.ToInt32(txtIDEd.Text);
var db = new Model1();
var furnitureUpdatequerry = from furniture in db.tblFurnitures where furniture.id == id select furniture;
if (!furnitureUpdatequerry.Any())
{
lblError.Text = "Furniture does not exsists";
}
else
{
tblFurniture fur = furnitureUpdatequerry.First();
fur.Name = name;
fur.typeID = type;
db.SaveChanges(); // execute the query on the table
Furniture.DataBind(); // to refresh table
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
string name = txtName.Text;
int type = Convert.ToInt32(ddType.SelectedItem.Value);
var db = new Model1();
tblFurniture fur = new tblFurniture();
fur.Name = name;
fur.typeID = type;
db.tblFurnitures.Add(fur); // basically the query and where it souuld execute
db.SaveChanges(); // execute the query on the table
Furniture.DataBind(); // to refresh table
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txtId.Text);
var db = new Model1();
var deleteFurniture = from furniture in db.tblFurnitures where furniture.id == id select furniture;
if (deleteFurniture.Any())
{
tblFurniture fur = deleteFurniture.First();
db.tblFurnitures.Remove(fur);
db.SaveChanges();
Furniture.DataBind();
}
else
{
lblError.Text = "Furniture not deleted";
}
}
private void detach_tblFurnitures(tblFurniture entity)
{
this.SendPropertyChanging();
entity.tblFurnitureType = null;
}
partial void DeletetblFurniture(tblFurniture instance);
partial void UpdatetblFurniture(tblFurniture instance);
partial void InserttblFurniture(tblFurniture instance);
