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