private void cmbIdTrain_SelectedIndexChanged(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(cmbIdTrain.Text))
{
tbl_Train train = db.tbl_Trains.FirstOrDefault(i => i.id_train == int.Parse(cmbIdTrain.Text));
tbTrainname.Text = train.train_name;
}
}
private void action(String actioning)
{
train = actioning == "insert" ? new tbl_Train() : train = db.tbl_Trains.FirstOrDefault(i => i.id_train == int.Parse(tbIdTrain.Text));
train.id_train = int.Parse(tbIdTrain.Text);
train.train_name = tbTrainname.Text;
train.train_seat = (int)nudTotalSeat.Value;
if (actioning == "insert")
{
train.id_train = int.Parse(tbIdTrain.Text);
db.tbl_Trains.InsertOnSubmit(train);
}
db.SubmitChanges();
}
private void setTextbox()
{
if (!String.IsNullOrEmpty(tbIdTrain.Text))
{
train = db.tbl_Trains.FirstOrDefault(i => i.id_train == int.Parse(tbIdTrain.Text));
if (train != null)
{
tbTrainname.Text = train.train_name;
nudTotalSeat.Value = train.train_seat;
btnAdd.Text = "UPDATE";
}
else
{
va.clear("tbIdTrain");
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;
}
train = db.tbl_Trains.FirstOrDefault(i => i.id_train == int.Parse(tbIdTrain.Text));
if (train != 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());
}
}
