private void frmStafPenjualanUpdate_FormClosed(object sender, FormClosedEventArgs e) { if (this.DialogResult == DialogResult.OK) { if (this.Caller is frmStafPenjualanBrowser) { frmStafPenjualanBrowser frmCaller = (frmStafPenjualanBrowser)this.Caller; frmCaller.RefreshData(); frmCaller.FindRow("RowID", _rowID.ToString()); } } }
private void cmdSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtNama.Text)) { MessageBox.Show("Nama belum diisi"); txtNama.Focus(); return; } try { switch (formMode) { case enumFormMode.New: try { using (Database db = new Database()) { db.Open(); _rowID = Guid.NewGuid(); DataTable dtMessage = new DataTable(); db.Commands.Add(db.CreateCommand("usp_StaffPenjualan_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@nama", SqlDbType.VarChar, txtNama.Text)); db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].Parameters.Add(new Parameter("@unitKerja", SqlDbType.VarChar, CbUnitKerja.SelectedValue)); db.Commands[0].Parameters.Add(new Parameter("@keterangan", SqlDbType.VarChar, TxtKeterangan.Text)); db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.Bit, RBAktif.Checked)); dtMessage = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); if (dtMessage.Rows.Count > 0) { if (dtMessage.Rows[0]["pesan"].ToString() == "Insert Berhasil") { this.DialogResult = DialogResult.OK; frmStafPenjualanBrowser frmCaller = (frmStafPenjualanBrowser)this.Caller; frmCaller.RefreshData(); this.Close(); frmCaller.Show(); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show(dtMessage.Rows[0]["pesan"].ToString()); return; } //if (dt.Rows[0]["pesan"].ToString() == "Data Sudah Ada") //{ // txtKode.Text = string.Empty; // txtKode.Focus(); // return; //} } } } catch (Exception ex) { Error.LogError(ex); } break; case enumFormMode.Update: try { using (Database db = new Database()) { if (Tools.cekDuplikasiDataOnDatabase("StaffPenjualan", "Nama", txtNama.Text, "kode", TxtKode.Text)) { MessageBox.Show("Staf Adm dan Ops Dengan Nama " + txtNama.Text + " Sudah Ada !!"); txtNama.Focus(); return; } db.Open(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_StaffPenjualan_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("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].Parameters.Add(new Parameter("@unitKerja", SqlDbType.VarChar, CbUnitKerja.SelectedValue)); db.Commands[0].Parameters.Add(new Parameter("@keterangan", SqlDbType.VarChar, TxtKeterangan.Text)); db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.Bit, RBAktif.Checked)); db.Commands[0].ExecuteNonQuery(); db.Close(); db.Dispose(); this.DialogResult = DialogResult.OK; frmStafPenjualanBrowser frmCaller = (frmStafPenjualanBrowser)this.Caller; frmCaller.RefreshData(); this.Close(); frmCaller.Show(); } } catch (Exception ex) { Error.LogError(ex); } break; } } catch (Exception ex) { Error.LogError(ex); } }