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