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