private void setTextbox() { ro = db.tbl_Routes.FirstOrDefault(x => x.id_route == int.Parse(tbIdroute.Text)); if (ro != null) { tbIdroute.Text = ro.id_route.ToString(); var depart = (from d in db.tbl_Places where d.id_place == ro.departure_place select d).First(); tbAirportdeparture.Text = depart.name_place; departid = depart.id_place; var arriv = (from d in db.tbl_Places where d.id_place == ro.arrival_place select d).First(); tbAirportarrival.Text = arriv.name_place; arrivid = arriv.id_place; btnAdd.Text = "UPDATE"; } else { va.clear("tbIdroute", 0); btnAdd.Text = "ADD"; } }
private void btnAdd_Click(object sender, EventArgs e) { String message = ""; if (va.doValidation() == false) { return; } ro = db.tbl_Routes.FirstOrDefault(x => x.id_route == int.Parse(tbIdroute.Text)); if (ro != null) { aksi("update"); message = "Update"; } else { aksi("insert"); message = "Insert"; } MessageBox.Show(message + " data success!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); loadGrid(); va.clear("tbIdroute", 0); }
public void action() { route = new tbl_Route { id_departure = int.Parse(cmbIdDepart.Text), id_arrival = int.Parse(cmbIdArrival.Text) }; db.tbl_Routes.InsertOnSubmit(route); db.SubmitChanges(); }
private void aksi(String aksinya) { ro = aksinya == "insert" ? new tbl_Route() : db.tbl_Routes.FirstOrDefault(x => x.id_route == int.Parse(tbIdroute.Text)); ro.departure_place = departid; ro.arrival_place = arrivid; if (aksinya == "insert") { ro.id_route = int.Parse(tbIdroute.Text); db.tbl_Routes.InsertOnSubmit(ro); } db.SubmitChanges(); }