private void frmBankKotaUpdate_FormClosed(object sender, FormClosedEventArgs e) { if (this.DialogResult == DialogResult.OK) { if (this.Caller is frmBankKotaBrowse) { frmBankKotaBrowse frmCaller = (frmBankKotaBrowse)this.Caller; frmCaller.RefreshData(); frmCaller.FindRow("RowID", RowID.ToString()); } } }
private void cmdSave_Click(object sender, EventArgs e) { if (dataSudahAda()) { KotakPesan.Warning("Data Sudah Ada di database"); txtNama.Focus(); return; } if (string.IsNullOrEmpty(txtNama.Text)) { KotakPesan.Warning("Anda belum mengisi data Nama"); txtNama.Focus(); return; } if (string.IsNullOrEmpty(txtLokasi.Text)) { KotakPesan.Warning("Anda belum mengisi data Lokasi"); txtLokasi.Focus(); return; } try { switch (formMode) { case enumFormMode.NEW: using (Database db = new Database(GlobalVar.DBFinance)) { db.Open(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("[usp_BankKota_INSERT]")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, txtNama.Text)); db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, txtLokasi.Text)); db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.Bit, cbaktif.Checked)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); KotakPesan.Information("Insert Berhasil"); } break; case enumFormMode.UPDATE: using (Database db = new Database(GlobalVar.DBFinance)) { db.Open(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("[usp_BankKota_UPDATE]")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, txtNama.Text)); db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, txtLokasi.Text)); db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.Bit, cbaktif.Checked)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); KotakPesan.Information("Update Berhasil"); } break; } this.DialogResult = DialogResult.OK; frmBankKotaBrowse frmcaller = (frmBankKotaBrowse)this.Caller; frmcaller.RefreshData(); this.Close(); frmcaller.Show(); } catch (Exception ex) { Error.LogError(ex); } }