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);