private void cmdSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtdate.Text))
{
KotakPesan.Warning("Anda belum mengisi Tanggal", "Cek Tanggal");
txtdate.Focus();
return;
}
if (txtdate.DateValue < GlobalVar.DateOfServer)
{
KotakPesan.Warning("Tanggal tidak boleh kurang dari datetime server", "Cek Tanggal");
txtdate.Focus();
return;
}
if (txtHargaJual.GetDoubleValue <= 0)
{
KotakPesan.Warning("Harga Jual Harus Lebih besar dari 0", "Cek Harga Jual");
txtHargaJual.Focus();
return;
}
try
{
// using (Database db = new Database(GlobalVar.DBFinance))
using (Database db = new Database())
{
db.Open();
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_JasaHarga_Insert"));
db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID));
db.Commands[0].Parameters.Add(new Parameter("@JasaRowID", SqlDbType.UniqueIdentifier, JasaRowID));
db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, txtdate.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@HargaJual", SqlDbType.Money, txtHargaJual.GetDoubleValue));
db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, txtKeterangan.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)
{
KotakPesan.Warning(string.Format("Jasa Harga Tanggal {0:dd-MM-yyyy} sudah ada. Mohon gunakan Tombol Edit jika ingin merubah.", txtdate.DateValue), "Cek Tanggal");
txtdate.Focus();
return;
}
}
this.DialogResult = DialogResult.OK;
frmJasaBrowse frmcaller = (frmJasaBrowse)this.Caller;
frmcaller.RefreshData();
this.Close();
frmcaller.Show();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
private void frmHPPUpdate_FormClosed(object sender, FormClosedEventArgs e)
{
if (this.DialogResult == DialogResult.OK)
{
if (this.Caller is frmJasaBrowse)
{
frmJasaBrowse frmCaller = (frmJasaBrowse)this.Caller;
frmCaller.RefreshData();
frmCaller.FindRow("TMT", txttglBerlaku.ToString());
}
}
}
private void frmJasaUpdate_FormClosed(object sender, FormClosedEventArgs e)
{
if (this.DialogResult == DialogResult.OK)
{
if (this.Caller is frmJasaBrowse)
{
frmJasaBrowse frmCaller = (frmJasaBrowse)this.Caller;
frmCaller.RefreshData();
frmCaller.FindRow("Kode", txtKode.Text);
}
}
}
private void frmJasaHargaUpdate_FormClosed(object sender, FormClosedEventArgs e)
{
if (this.DialogResult == DialogResult.OK)
{
if (this.Caller is frmJasaBrowse)
{
frmJasaBrowse frmCaller = (frmJasaBrowse)this.Caller;
frmCaller.RefreshDataDetail(JasaRowID);
frmCaller.FindRowDetail("DRowID", RowID.ToString());
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtNama.Text))
{
MessageBox.Show("Anda belum mengisi Nama Nama");
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? 0:1;
db.Commands.Add(db.CreateCommand("usp_Jasa_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("@Nama", SqlDbType.VarChar, txtNama.Text));
db.Commands[0].Parameters.Add(new Parameter("@Status", SqlDbType.VarChar, Status));
db.Commands[0].Parameters.Add(new Parameter("@Catatan", 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("Jasa", "Nama", 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 ? 0 : 1;
db.Commands.Add(db.CreateCommand("usp_Jasa_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("@Nama", SqlDbType.VarChar, txtNama.Text));
db.Commands[0].Parameters.Add(new Parameter("@Kode", SqlDbType.VarChar, txtKode.Text));
db.Commands[0].Parameters.Add(new Parameter("@Status", SqlDbType.VarChar, Status));
db.Commands[0].Parameters.Add(new Parameter("@Catatan", 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;
frmJasaBrowse frmcaller = (frmJasaBrowse)this.Caller;
frmcaller.RefreshData();
this.Close();
frmcaller.Show();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
