private void frmJenisBarangUpdate_FormClosed(object sender, FormClosedEventArgs e) { if (this.DialogResult == DialogResult.OK) { if (this.Caller is frmJenisBarangBrowse) { frmJenisBarangBrowse frmCaller = (frmJenisBarangBrowse)this.Caller; frmCaller.RefreshData(); frmCaller.FindRow("Kode", txtKode.Text); } } }
private void cmdSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtNama.Text)) { MessageBox.Show("Anda belum mengisi Jenis"); txtNama.Focus(); return; } try { switch (formMode) { case enumFormMode.NEW: using (Database db = new Database()) { db.Open(); DataTable dt = new DataTable(); int Status = cbaktif.Checked == true? 1:0; db.Commands.Add(db.CreateCommand("usp_JenisBarang_Insert_Update_Delete")); db.Commands[0].Parameters.Add(new Parameter("@do", SqlDbType.Int, 0)); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@Jenis", SqlDbType.VarChar, txtNama.Text)); db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.VarChar, Status)); db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, txtCatatan.Text)); db.Commands[0].Parameters.Add(new Parameter("@Createdby", SqlDbType.VarChar, SecurityManager.UserName)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); if (dt.Rows.Count > 0) { MessageBox.Show(dt.Rows[0]["pesan"].ToString()); if (dt.Rows[0]["pesan"].ToString() == "Data Sudah Ada") { txtKode.Text = string.Empty; txtKode.Focus(); return; } else if (dt.Rows[0]["pesan"].ToString().Substring(dt.Rows[0]["pesan"].ToString().Length - 14) == " Sudah Ada !!!") { txtNama.Text = string.Empty; txtNama.Focus(); return; } } } break; case enumFormMode.UPDATE: using (Database db = new Database()) { if (Tools.cekDuplikasiDataOnDatabase("JenisBarang", "Jenis", txtNama.Text, "Kode", txtKode.Text)) { MessageBox.Show("Jasa Dengan Nama " + txtNama.Text + " Sudah Ada !!"); txtNama.Focus(); return; } db.Open(); DataTable dt = new DataTable(); int Status = cbaktif.Checked == true ? 1 : 0; db.Commands.Add(db.CreateCommand("usp_JenisBarang_Insert_Update_Delete")); db.Commands[0].Parameters.Add(new Parameter("@do", SqlDbType.Int, 1)); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@Jenis", SqlDbType.VarChar, txtNama.Text)); db.Commands[0].Parameters.Add(new Parameter("@Kode", SqlDbType.VarChar, txtKode.Text)); db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.VarChar, Status)); db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, txtCatatan.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); if (dt.Rows.Count > 0) { MessageBox.Show(dt.Rows[0]["pesan"].ToString()); if (dt.Rows[0]["pesan"].ToString() == "Data Sudah Ada") { txtKode.Text = string.Empty; txtKode.Focus(); return; } } } break; } this.DialogResult = DialogResult.OK; frmJenisBarangBrowse frmcaller = (frmJenisBarangBrowse)this.Caller; frmcaller.RefreshData(); this.Close(); frmcaller.Show(); } catch (Exception ex) { Error.LogError(ex); } }