private void frmKategoriReturUpdate_FormClosed(object sender, FormClosedEventArgs e)
{
if (this.DialogResult == DialogResult.OK)
{
if (this.Caller is frmKategoriReturBrowse)
{
frmKategoriReturBrowse frmCaller = (frmKategoriReturBrowse)this.Caller;
frmCaller.RefreshData();
frmCaller.FindRow("RowID", RowID.ToString());
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtRetur.Text))
{
MessageBox.Show("Anda belum mengisi Nama Nama");
txtRetur.Focus();
return;
}
try
{
switch (formMode)
{
case enumFormMode.NEW:
if (Tools.cekDataOnDatabase("Kategori", "Kategori", txtKode.Text))
{
MessageBox.Show("Kategori dengan Kode " + txtKode.Text + " Sudah Ada");
txtKode.Focus();
return;
}
if (Tools.cekDataOnDatabase("Kategori", "Keterangan", txtKeterangan.Text))
{
MessageBox.Show("Kategori dengan Keterangan " + txtKeterangan.Text + " Sudah Ada");
txtKeterangan.Focus();
return;
}
using (Database db = new Database())
{
db.Open();
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("[usp_Kategori_INSERT]"));
db.Commands[0].Parameters.Add(new Parameter("@Kategori", SqlDbType.VarChar, txtKode.Text));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID));
db.Commands[0].Parameters.Add(new Parameter("@Ket", SqlDbType.VarChar, txtRetur.Text));
db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.VarChar, cbaktif.Checked));
db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, txtKeterangan.Text));
db.Commands[0].Parameters.Add(new Parameter("@User", SqlDbType.VarChar, SecurityManager.UserName));
db.Commands[0].ExecuteNonQuery();
db.Close();
db.Dispose();
}
break;
case enumFormMode.UPDATE:
using (Database db = new Database())
{
if (Tools.cekDuplikasiDataOnDatabase("Kategori", "Kategori", txtKode.Text, "RowID", RowID.ToString()))
{
MessageBox.Show("Kategori dengan Kode " + txtKode.Text + " Sudah Ada");
txtKode.Focus();
return;
}
if (Tools.cekDuplikasiDataOnDatabase("Kategori", "Keterangan", txtKeterangan.Text, "RowID", RowID.ToString()))
{
MessageBox.Show("Kategori dengan Keterangan " + txtKeterangan.Text + " Sudah Ada");
txtKeterangan.Focus();
return;
}
db.Open();
DataTable dt = new DataTable();
int Status = cbaktif.Checked == true ? 0 : 1;
db.Commands.Add(db.CreateCommand("[usp_Kategori_UPDATE]"));
db.Commands[0].Parameters.Add(new Parameter("@Kategori", SqlDbType.VarChar, txtKode.Text));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID));
db.Commands[0].Parameters.Add(new Parameter("@Ket", SqlDbType.VarChar, txtRetur.Text));
db.Commands[0].Parameters.Add(new Parameter("@StatusAktif", SqlDbType.VarChar, cbaktif.Checked));
db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, txtKeterangan.Text));
db.Commands[0].Parameters.Add(new Parameter("@User", SqlDbType.VarChar, SecurityManager.UserName));
db.Commands[0].ExecuteNonQuery();
db.Close();
db.Dispose();
}
break;
}
this.DialogResult = DialogResult.OK;
frmKategoriReturBrowse frmcaller = (frmKategoriReturBrowse)this.Caller;
frmcaller.RefreshData();
this.Close();
frmcaller.Show();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
