private void frmCheckerUpdate_FormClosed(object sender, FormClosedEventArgs e) { if (this.DialogResult == DialogResult.OK) { if (this.Caller is frmCheckerBrowse) { frmCheckerBrowse frmCaller = (frmCheckerBrowse)this.Caller; frmCaller.RefreshData(); //frmCaller.FindRow("CheckerID", checkerID); } } }
private void cmdSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtFirstName.Text)) { MessageBox.Show("Nama depan belum diisi"); txtFirstName.Focus(); return; } if (string.IsNullOrEmpty(txtMasuk.Text)) { MessageBox.Show("Tanggal masuk belum diisi"); txtMasuk.Focus(); return; } if (txtKeluar.DateValue < txtMasuk.DateValue) { MessageBox.Show("Tanggal keluar tidak boleh lebih kecil dari tanggal masuk"); txtKeluar.Focus(); return; } try { switch (formMode) { case enumFormMode.New: using (Database db = new Database()) { db.Open(); checkerID = Tools.CreateFingerPrint(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_Checker_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@checkerID", SqlDbType.VarChar, checkerID)); db.Commands[0].Parameters.Add(new Parameter("@FirstName", SqlDbType.VarChar, txtFirstName.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastName", SqlDbType.VarChar, txtLastName.Text)); db.Commands[0].Parameters.Add(new Parameter("@Alamat", SqlDbType.VarChar, txtAlamat.Text)); db.Commands[0].Parameters.Add(new Parameter("@Kota", SqlDbType.VarChar, txtKota.Text)); db.Commands[0].Parameters.Add(new Parameter("@Masuk", SqlDbType.DateTime, txtMasuk.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@Keluar", SqlDbType.DateTime, txtKeluar.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); } break; case enumFormMode.Update: using (Database db = new Database()) { db.Open(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_Checker_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@checkerID", SqlDbType.VarChar, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@FirstName", SqlDbType.VarChar, txtFirstName.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastName", SqlDbType.VarChar, txtLastName.Text)); db.Commands[0].Parameters.Add(new Parameter("@Alamat", SqlDbType.VarChar, txtAlamat.Text)); db.Commands[0].Parameters.Add(new Parameter("@Kota", SqlDbType.VarChar, txtKota.Text)); db.Commands[0].Parameters.Add(new Parameter("@Masuk", SqlDbType.DateTime, txtMasuk.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@Keluar", SqlDbType.DateTime, txtKeluar.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); db.Close(); db.Dispose(); } break; } this.DialogResult = DialogResult.OK; frmCheckerBrowse frmCaller = (frmCheckerBrowse)this.Caller; frmCaller.RefreshData(); this.Close(); frmCaller.Show(); } catch (Exception ex) { Error.LogError(ex); } }