private void frmPeminjamanDetailUpdate_FormClosed(object sender, FormClosedEventArgs e)
{
if (this.DialogResult == DialogResult.OK)
{
if (this.Caller is frmPeminjaman)
{
ArusStock.frmPeminjaman frmCaller = (ArusStock.frmPeminjaman) this.Caller;
frmCaller.RefreshDetail();
frmCaller.FindDetail("RowIDD", _rowID.ToString());
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (lookupStock.BarangID == "")
{
lookupStock.Focus();
return;
}
if (Convert.ToInt32(txtQtyPinjam.Text) <= 0 || txtQtyPinjam.Text == "")
{
txtQtyPinjam.Focus();
return;
}
switch (formMode)
{
case enumFormMode.New:
try
{
this.Cursor = Cursors.WaitCursor;
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_PeminjamanDetail_INSERT"));
_rowID = Guid.NewGuid();
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@HeaderID", SqlDbType.UniqueIdentifier, _headerID));
db.Commands[0].Parameters.Add(new Parameter("@TransactionID", SqlDbType.VarChar, _TransactionID));
db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, Tools.CreateFingerPrint()));
db.Commands[0].Parameters.Add(new Parameter("@KodeBarang", SqlDbType.VarChar, lookupStock.BarangID));
db.Commands[0].Parameters.Add(new Parameter("@QtyMemo", SqlDbType.Int, txtQtyPinjam.Text));
db.Commands[0].Parameters.Add(new Parameter("@QtyKeluarGudang", SqlDbType.Int, 0));
db.Commands[0].Parameters.Add(new Parameter("@Catatan", SqlDbType.VarChar, txtCatatan.Text));
db.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, 0));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
if (dt.Rows.Count > 0)
{
MessageBox.Show("Kode barang: " + lookupStock.BarangID + " tidak bisa diinput dua kali");
lookupStock.Focus();
return;
}
this.DialogResult = DialogResult.OK;
if (this.Caller is frmPeminjaman)
{
ArusStock.frmPeminjaman frmCaller = (ArusStock.frmPeminjaman) this.Caller;
frmCaller.RefreshDetail();
frmCaller.FindDetail("RowIDD", _rowID.ToString());
}
lookupStock.NamaStock = "";
lookupStock.BarangID = "";
txtQtyPinjam.Text = "";
txtSatuan.Text = "";
txtCatatan.Text = "";
lookupStock.Focus();
//this.DialogResult = DialogResult.OK;
//this.Close();
}
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
break;
case enumFormMode.Update:
try
{
this.Cursor = Cursors.WaitCursor;
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_PeminjamanDetail_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, _headerID));
db.Commands[0].Parameters.Add(new Parameter("@QtyKeluarGudang", SqlDbType.Int, _qtyKeluarGudang));
db.Commands[0].Parameters.Add(new Parameter("@QtyMemo", SqlDbType.Int, txtQtyPinjam.Text));
db.Commands[0].Parameters.Add(new Parameter("@KodeBarang", SqlDbType.VarChar, lookupStock.BarangID));
db.Commands[0].Parameters.Add(new Parameter("@Catatan", SqlDbType.VarChar, txtCatatan.Text));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
if (dt.Rows.Count > 0)
{
MessageBox.Show("Kode barang: " + lookupStock.BarangID + " tidak bisa diinput dua kali");
lookupStock.Focus();
return;
}
this.DialogResult = DialogResult.OK;
cmdClose.PerformClick();
}
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
break;
}
}
