private void cmbIdArrival_SelectedIndexChanged(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(cmbIdArrival.Text))
{
tbl_Station station = db.tbl_Stations.FirstOrDefault(i => i.id_station == int.Parse(cmbIdArrival.Text));
tbArrival.Text = station.station_name;
tbArrivalLocation.Text = station.station_location;
}
}
private void action(String actioning)
{
stat = actioning == "insert" ? new tbl_Station() : stat = db.tbl_Stations.FirstOrDefault(i => i.id_station == int.Parse(tbIdStation.Text));
stat.id_station = int.Parse(tbIdStation.Text);
stat.station_name = tbStationname.Text;
stat.station_location = tbStationlocation.Text;
if (actioning == "insert")
{
stat.id_station = int.Parse(tbIdStation.Text);
db.tbl_Stations.InsertOnSubmit(stat);
}
db.SubmitChanges();
}
private void setTextBox()
{
if (!String.IsNullOrEmpty(tbIdStation.Text))
{
stat = db.tbl_Stations.FirstOrDefault(i => i.id_station == int.Parse(tbIdStation.Text));
if (stat != null)
{
tbStationname.Text = stat.station_name;
tbStationlocation.Text = stat.station_location;
btnAdd.Text = "UPDATE";
}
else
{
va.clear("tbIdStation");
btnAdd.Text = "ADD";
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
String message = "";
DialogResult fc = MessageBox.Show("Are you sure want to add this data?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (fc == DialogResult.No)
{
return;
}
if (va.doValidation() == false)
{
return;
}
stat = db.tbl_Stations.FirstOrDefault(i => i.id_station == int.Parse(tbIdStation.Text));
if (stat != null)
{
message = "Update";
action("update");
}
else
{
message = "Insert";
action("insert");
}
MessageBox.Show(message + " data success!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
loadGrid();
va.clear("");
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
}
