private void ADD()
{
if (ValidateInsert())
{
if (MessageBox.Show("Hitung " + Data.ToString() + " sudah diinput lebih dari satu. Simpan data?", "Simpan Data", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
this.Close();
return;
}
}
try
{
string _kodeBarang = lookupStock1.BarangID;
DataTable dtopn = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_Opname_List"));
db.Commands[0].Parameters.Add(new Parameter("@BarangID", SqlDbType.VarChar, _kodeBarang));
dtopn = db.Commands[0].ExecuteDataTable();
}
if (dtopn.Rows.Count > 0)
{
_HeaderID = new Guid(dtopn.Rows[0]["RowID"].ToString());
}
usp = "usp_OpnameDetail" + Data.ToString() + "_INSERT";
this.Cursor = Cursors.WaitCursor;
_RowID = Guid.NewGuid();
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand(usp));
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("@NoForm", SqlDbType.VarChar, txtNoForm.Text));
db.Commands[0].Parameters.Add(new Parameter("@TglOpname", SqlDbType.DateTime, TglOpname.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@Baik", SqlDbType.Int, txtBaik.GetIntValue));
db.Commands[0].Parameters.Add(new Parameter("@Cacat", SqlDbType.Int, txtCacat.GetIntValue));
db.Commands[0].Parameters.Add(new Parameter("@Rusak", SqlDbType.Int, txtRusak.GetIntValue));
db.Commands[0].Parameters.Add(new Parameter("@Pengguna", SqlDbType.VarChar, txtPenghitung.Text));
db.Commands[0].Parameters.Add(new Parameter("@KodeGudang", SqlDbType.VarChar, GlobalVar.Gudang));
db.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, 0));
db.Commands[0].Parameters.Add(new Parameter("@Flag", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
this.DialogResult = DialogResult.OK;
Persediaan.frmStokOpname frmcall = (Persediaan.frmStokOpname) this.Caller;
frmcall.FindHeader("RowID", _HeaderID.ToString());
if (Data.ToString() == "1")
{
}
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
