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, tbKeterangan.Text)); 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].Parameters.Add(new Parameter("@StaffPenghitungID", SqlDbType.UniqueIdentifier, new Guid(comboBoxStaffAdsdanOps1.RowID))); 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, tbKeterangan.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); db.Commands[0].Parameters.Add(new Parameter("@StaffPenghitungID", SqlDbType.UniqueIdentifier, new Guid(comboBoxStaffAdsdanOps1.RowID))); 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); } }