private void CloseForm()
{
if (this.DialogResult == DialogResult.OK)
{
if (this.Caller is frmMasterStokBengkelBrowse)
{
frmMasterStokBengkelBrowse frmCaller = (frmMasterStokBengkelBrowse)this.Caller;
frmCaller.RefreshRowDataStok(txtBarangID.Text);
frmCaller.FindRow("id_brg", txtBarangID.Text);
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtBarangID.Text))
{
MessageBox.Show("Barang ID belum diisi");
txtBarangID.Focus();
return;
}
if (string.IsNullOrEmpty(txtNamaStok.Text))
{
MessageBox.Show("Nama stok belum diisi");
txtNamaStok.Focus();
return;
}
int lenIdbrg = 0;
lenIdbrg = txtBarangID.Text.ToString().Trim().Length;
if (lenIdbrg < 12)
{
MessageBox.Show("Kode Barang kurang dari 12 character");
return;
}
else if (lenIdbrg > 12)
{
MessageBox.Show("Kode Barang lebih dari 12 character");
return;
}
string barangIDSubString = txtBarangID.Text.Substring(0, 3).ToUpper();
try
{
int _prediksiLamaKirim = 0;
int _hariRataRata = 0;
switch (formMode)
{
case enumFormMode.New:
try
{
using (Database db = new Database())
{
DataTable dtc = new DataTable();
db.Commands.Add(db.CreateCommand("usp_StokBengkelCekIdbrg_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@id_brg", SqlDbType.VarChar, txtBarangID.Text));
dtc = db.Commands[0].ExecuteDataTable();
if (dtc.Rows.Count > 0)
{
MessageBox.Show("Kode Barang sudah ada");
return;
}
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_StokBengkel_INSERT"));
_rowID = Guid.NewGuid();
string RecID_ = GlobalVar.PerusahaanID + String.Format("{0:yyyyMMddHHmmss}", GlobalVar.DateTimeOfServer) + SecurityManager.UserInitial + " ";
//string RecID_ = GlobalVar.PerusahaanID + String.Format("{0:yyyyMMddHHmmssff}", GlobalVar.DateTimeOfServer) + SecurityManager.UserInitial + " ";
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@recordID", SqlDbType.VarChar, RecID_));
db.Commands[0].Parameters.Add(new Parameter("@id_brg", SqlDbType.VarChar, txtBarangID.Text.ToUpper()));
db.Commands[0].Parameters.Add(new Parameter("@namaStok", SqlDbType.VarChar, txtNamaStok.Text));
db.Commands[0].Parameters.Add(new Parameter("@satJual", SqlDbType.VarChar, txtSatJual.Text));
db.Commands[0].Parameters.Add(new Parameter("@statusPasif", SqlDbType.Bit, !chkStatusAktif.Checked));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
break;
case enumFormMode.Update:
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_StokBengkel_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@barangID", SqlDbType.VarChar, txtBarangID.Text));
db.Commands[0].Parameters.Add(new Parameter("@namaStok", SqlDbType.VarChar, txtNamaStok.Text));
db.Commands[0].Parameters.Add(new Parameter("@satJual", SqlDbType.VarChar, txtSatJual.Text));
db.Commands[0].Parameters.Add(new Parameter("@statusPasif", SqlDbType.Bit, !chkStatusAktif.Checked));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
break;
}
this.DialogResult = DialogResult.OK;
if (this.Caller is frmMasterStokBengkelBrowse)
{
frmMasterStokBengkelBrowse frmCaller = (frmMasterStokBengkelBrowse)this.Caller;
frmCaller.RefreshRowDataStok(txtBarangID.Text);
frmCaller.FindRow("id_brg", txtBarangID.Text);
}
this.Close();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
