protected void btnEdit_Click(object sender, EventArgs e) { int newcID = Convert.ToInt32(ddCINew.SelectedItem.Value); int newfID = Convert.ToInt32(ddFidNew.SelectedItem.Value); int id = Convert.ToInt32(txtIDed.Text); var db = new Model1(); var clFurUpdatequerry = from cf in db.tblClientFurnitures where cf.id == id select cf; if (!clFurUpdatequerry.Any()) { lblError.Text = "ID does not exsist"; } else { tblClientFurniture cfur = clFurUpdatequerry.First(); cfur.clientId = newcID; cfur.furnitureId = newfID; db.SaveChanges(); // execute the query on the table ClFur.DataBind(); // to refresh table } }
protected void btnEdit_Click(object sender, EventArgs e) // this wount work if there are more than one client renting form same clint { int newcID = Convert.ToInt32(ddCINew.Text); int newfID = Convert.ToInt32(ddFidNew.Text); int cID = Convert.ToInt32(ddCIDEd.Text); int fID = Convert.ToInt32(ddFIDEd.Text); var db = new DataClasses1DataContext(); var clFurUpdatequerry = from cf in db.tblClientFurnitures where cf.clientId == cID && cf.furnitureId == fID select cf; if (!clFurUpdatequerry.Any()) { lblError.Text = "Combo does not exsist"; } else { foreach (var cfur in clFurUpdatequerry) { cfur.clientId = newcID; cfur.furnitureId = newfID; } db.SubmitChanges(); // execute the query on the table ClFur.DataBind(); // to refresh table } }
protected void btnRegister_Click(object sender, EventArgs e) { int clientID = Convert.ToInt32(ddCName.SelectedValue); int furnID = Convert.ToInt32(ddFName.SelectedValue); var db = new Model1(); tblClientFurniture cf = new tblClientFurniture(); cf.clientId = clientID; cf.furnitureId = furnID; cf.date = DateTime.Now; db.tblClientFurnitures.Add(cf); // basically the query and where it souuld execute db.SaveChanges(); // execute the query on the table ClFur.DataBind(); // to refresh table }
protected void btnRegister_Click(object sender, EventArgs e) { int clientID = Convert.ToInt32(ddCName.SelectedItem); int furnID = Convert.ToInt32(ddFName.SelectedItem); var db = new DataClasses1DataContext(); tblClientFurniture cf = new tblClientFurniture(); cf.clientId = clientID; cf.furnitureId = furnID; cf.date = DateTime.Now; db.tblClientFurnitures.InsertOnSubmit(cf); // basically the query and where it souuld execute db.SubmitChanges(); // execute the query on the table ClFur.DataBind(); // to refresh table }
protected void btnDelete_Click(object sender, EventArgs e) { int Cid = Convert.ToInt32(txtCId.Text); int fID = Convert.ToInt32(txtfId.Text); var db = new DataClasses1DataContext(); var deleteClFur = from clfur in db.tblClientFurnitures where clfur.clientId == Cid && clfur.furnitureId == fID select clfur; if (deleteClFur.Any()) { db.tblClientFurnitures.DeleteOnSubmit(deleteClFur.First()); db.SubmitChanges(); ClFur.DataBind(); } else { lblError.Text = "furnituresystem not deleted"; } }
protected void btnDelete_Click(object sender, EventArgs e) { int id = Convert.ToInt32(txtid.Text); var db = new Model1(); // var deleteClFur = from clfur in db.tblClientFurnitures where clfur.i == id select clfur; var deleteClFur = from clfur in db.tblClientFurnitures where clfur.id == id select clfur; if (deleteClFur.Any()) { db.tblClientFurnitures.Remove(deleteClFur.First()); db.SaveChanges(); ClFur.DataBind(); } else { lblError.Text = "Record not deleted"; } }