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 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
}
