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);
}
}
