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