private void SaveInsert() { try { Validasi(); //DateTime tglTerakhir; //using (Database db = new Database()) //{ // db.Commands.Add(db.CreateCommand("usp_fnGetStokOpname")); // db.Commands[0].Parameters.Add(new Parameter("@tgl", SqlDbType.DateTime, DateTime.Now)); // db.Commands[0].Parameters.Add(new Parameter("@kodeBarang", SqlDbType.VarChar, kodeBarang)); // db.Commands[0].Parameters.Add(new Parameter("@kodeGudang", SqlDbType.VarChar, GlobalVar.Gudang)); // tglTerakhir = (DateTime)db.Commands[0].ExecuteScalar(); //} //if (dtTglOpname.DateValue <= tglTerakhir) //{ // MessageBox.Show("Tanggal opname harus lebih besar dari tanggal [" + tglTerakhir.ToString("dd/MM/yyyy") + "] opname terkahir"); // dtTglOpname.Focus(); // return; //} try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_OpnameHistory_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, Guid.NewGuid())); db.Commands[0].Parameters.Add(new Parameter("@RecordID", SqlDbType.VarChar, Tools.CreateFingerPrint())); db.Commands[0].Parameters.Add(new Parameter("@TglOpname", SqlDbType.DateTime, dtTglOpname.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@QtyOpname", SqlDbType.Int, tbQtyOpname.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@KodeBarang", SqlDbType.VarChar, kodeBarang)); db.Commands[0].Parameters.Add(new Parameter("@KodeGudang", SqlDbType.VarChar, GlobalVar.Gudang)); db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, tbPenghitung.Text.Trim() + " - " + tbKeterangan.Text.Trim())); db.Commands[0].Parameters.Add(new Parameter("@Syncflag", SqlDbType.Bit, 0)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); } MessageBox.Show("Insert stok opname harian berhasil"); frmStokOpnameBrowse frmCaller = (frmStokOpnameBrowse)this.Caller; frmCaller.RefreshDataDetail(); this.Close(); } catch (System.Exception ex) { Error.LogError(ex); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void SaveUpdate() { try { Validasi(); if (dtTglOpname.DateValue != DateTime.Today) { MessageBox.Show("Tanggal opname harus hari ini."); dtTglOpname.Focus(); return; } try { this.keterangan = tbPenghitung.Text.Trim() + " - " + tbKeterangan.Text.Trim(); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_OpnameHistory_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, this.rowID)); db.Commands[0].Parameters.Add(new Parameter("@QtyOpname", SqlDbType.Int, tbQtyOpname.GetIntValue)); db.Commands[0].Parameters.Add(new Parameter("@KodeBarang", SqlDbType.VarChar, this.kodeBarang)); db.Commands[0].Parameters.Add(new Parameter("@KodeGudang", SqlDbType.VarChar, GlobalVar.Gudang)); db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, this.keterangan)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].ExecuteNonQuery(); } MessageBox.Show("Update stok opname harian berhasil"); frmStokOpnameBrowse frmCaller = (frmStokOpnameBrowse)this.Caller; frmCaller.RefreshDataDetail(); this.Close(); } catch (System.Exception ex) { Error.LogError(ex); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }