public int HacerGiro(Giro giro) { string StrConn = ConfigurationManager.ConnectionStrings["BDLocal"].ToString(); int id = 0; using (SqlConnection conn = new SqlConnection(StrConn)) { conn.Open(); SqlCommand comm = conn.CreateCommand(); comm.CommandText = "giro"; comm.CommandType = System.Data.CommandType.StoredProcedure; comm.Parameters.Add(new SqlParameter("@monto", giro.Monto)); comm.Parameters.Add(new SqlParameter("@id_cuenta", giro.Id_Cuenta)); comm.Parameters.Add(new SqlParameter("@monto_max", giro.MontoMax)); id = Convert.ToInt32(comm.ExecuteScalar()); } return(id); }
private void frmLookupVoucherGiroTitipUpdate_Load(object sender, EventArgs e) { gridDetail.AutoGenerateColumns = false; try { DataTable dtVoucherGiroTtp = new DataTable(); using (Database db = new Database(GlobalVar.DBFinance)) { dtVoucherGiroTtp = Giro.ListLookupVoucherGiroTitip(db); } dtVoucherGiroTtp.DefaultView.Sort = "CHBG,Nomor"; gridDetail.DataSource = dtVoucherGiroTtp.DefaultView; gridDetail.Focus(); } catch (Exception ex) { Error.LogError(ex); } }
private void DetailRefresh() { Guid RowIDHeader = (Guid)gridHeader.SelectedCells[0].OwningRow.Cells["hdrRowID"].Value; try { dtDetail = new DataTable(); using (Database db = new Database(GlobalVar.DBName)) { dtDetail = Giro.ListByVoucherID(db, RowIDHeader); } if (dtHeader.Rows.Count > 0) { dtDetail.DefaultView.Sort = "GiroRecID"; gridDetail.DataSource = dtDetail.DefaultView.ToTable(); //gridDetail.Focus(); } } catch (Exception ex) { Error.LogError(ex); } }
public bool Insert(Giro giro) { //métodos //insert System.Data.IDbConnection objConexao; System.Data.IDbCommand objCommand; string sql = "INSERT INTO giro(gir_codigo, gir_produto, gir_estoqueMaximo, gir_estoqueMinimo, gir_estoqueMedio, gir_vendas, gir_EstoqueAtual) VALUES (?codigo, ?produto, ?estoqueMaximo, ?estoqueMinimo, ?estoqueMedio, ?vendas, ?estoqueAtual)"; objConexao = Mapped.Connection(); objCommand = Mapped.Command(sql, objConexao); objCommand.Parameters.Add(Mapped.Parameter("?codigo", giro.Codigo)); objCommand.Parameters.Add(Mapped.Parameter("?produto", giro.Produto)); objCommand.Parameters.Add(Mapped.Parameter("?estoqueMaximo", giro.EstoqueMaximo)); objCommand.Parameters.Add(Mapped.Parameter("?estoqueMinimo", giro.EstoqueMinimo)); objCommand.Parameters.Add(Mapped.Parameter("?estoqueMedio", giro.EstoqueMedio)); objCommand.Parameters.Add(Mapped.Parameter("?vendas", giro.Vendas)); objCommand.Parameters.Add(Mapped.Parameter("?estoqueAtual", giro.EstoqueAtual)); objCommand.ExecuteNonQuery(); objConexao.Close(); objCommand.Dispose(); objConexao.Dispose(); return(true); }
private void addIndenDetail( Database db ) { DataTable dtCekRelasi = new DataTable(); db.Commands.Clear(); db.Commands.Add(db.CreateCommand("usp_IndenDetail_INSERT")); 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("@RecordID", SqlDbType.VarChar, RecordID)); db.Commands[0].Parameters.Add(new Parameter("@HRecordID", SqlDbType.VarChar, HRecordID)); db.Commands[0].Parameters.Add(new Parameter("@TglTrf", SqlDbType.DateTime, tglRK)); db.Commands[0].Parameters.Add(new Parameter("@BankID", SqlDbType.VarChar, bankID)); db.Commands[0].Parameters.Add(new Parameter("@NamaBank", SqlDbType.VarChar, NamaBank)); db.Commands[0].Parameters.Add(new Parameter("@Lokasi", SqlDbType.VarChar, Lokasi)); db.Commands[0].Parameters.Add(new Parameter("@CHBG", SqlDbType.VarChar, cara)); db.Commands[0].Parameters.Add(new Parameter("@Nomor", SqlDbType.VarChar, noBGC)); db.Commands[0].Parameters.Add(new Parameter("@TglGiro", SqlDbType.DateTime, tglGiro)); db.Commands[0].Parameters.Add(new Parameter("@TglJt", SqlDbType.DateTime, tglJTempo)); db.Commands[0].Parameters.Add(new Parameter("@Ket", SqlDbType.VarChar, ket)); db.Commands[0].Parameters.Add(new Parameter("@NoAcc", SqlDbType.VarChar, noAcc)); db.Commands[0].Parameters.Add(new Parameter("@RpCash", SqlDbType.Money, RpCash)); db.Commands[0].Parameters.Add(new Parameter("@RpGiro", SqlDbType.Money, RpGiro)); db.Commands[0].Parameters.Add(new Parameter("@RpTrf", SqlDbType.Money, RpTrn)); db.Commands[0].Parameters.Add(new Parameter("@RpCrd", SqlDbType.Money, RpCrd)); db.Commands[0].Parameters.Add(new Parameter("@RpDbt", SqlDbType.Money, RpDbt)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID)); if (RowIDOrderPenjualan != Guid.Empty) { db.Commands[0].Parameters.Add(new Parameter("@RowIDOrderPenjualan", SqlDbType.UniqueIdentifier, RowIDOrderPenjualan)); } db.Commands[0].ExecuteNonQuery(); if (cara == "") { string _noPerk; _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString(); dtCekRelasi = Inden.CekRelasiInden("Bukti", "SrcID", HeaderID.ToString(), "", "").Copy(); Guid _RowID = new Guid(); if (dtCekRelasi.Rows.Count == 0) { _RowID = HeaderID; string noBKM = Numerator.BookNumerator("BKM"); BKM.AddHeader(db, _RowID, HeaderID, BKM.GetRecordIDBukti(HRecordID, "IND"), noBKM, "K", "IND", tglInden, namaCollector, "", noAcc, SecurityManager.UserName, ""); } else { _RowID = (Guid)dtCekRelasi.Rows[0][0]; } BKM.AddDetail(db, RowID, _RowID, RecordID, BKM.GetRecordIDBukti(HRecordID, "IND"), "", "", "", noAcc, _noPerk, "PENERIMAAN BELUM IDENTIFIKASI (" + noBukti + ")", RpCash); } else if (cara == "T") { string recordIDTB = HRecordID + "I"; string noBBK = ""; string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString(); Guid _RowID = new Guid(); dtCekRelasi = Inden.CekRelasiInden("TransferBank", "SrcID", HeaderID.ToString(), "", "").Copy(); if (dtCekRelasi.Rows.Count == 0) { _RowID = HeaderID; noBBK = Numerator.BookNumerator("BBM"); TransferBank.addHeader(db, _RowID, HeaderID, recordIDTB, tglInden, noBBK, "M", "", "IND. No " + noBukti, "", "", SecurityManager.UserName, ""); } else { _RowID = (Guid)dtCekRelasi.Rows[0][0]; noBBK = dtCekRelasi.Rows[0][1].ToString(); } TransferBank.addDetail(db, RowID, _RowID, RecordID, recordIDTB, collectorID, namaCollector, NamaBank, Lokasi, noAcc, (DateTime)tglRK, RpTrn, "", "", "", "", bankID, _noPerk, ""); Bank.AddBankDetail(db, RowID, Guid.Empty, noBBK, noAcc, rowIDBankTujuan, "", tglInden, "BBM", "TRANSFER DARI : " + namaCollector + " (BANK TRANSFER)", "IDR", RpTrn, "0", DateTime.Today, (DateTime)tglRK, "", "", "", "", _noPerk, bankID, RecordID); } else if (cara == "G" || cara == "C" || cara == "S") { string recordIDVJ = ""; Guid _VJRowID = new Guid(); string noVoucher = Numerator.BookNumerator("VPG"); string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString(); dtCekRelasi = new DataTable(); dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "PG", "").Copy(); if (dtCekRelasi.Rows.Count == 0) { recordIDVJ = HRecordID + "I"; _VJRowID = Guid.NewGuid(); VoucherJournal.AddHeader(db, _VJRowID, HeaderID, recordIDVJ, "PG", tglInden, noVoucher, "PENERIMAAN GIRO IND. NO " + noBukti, "", "", "", "", "", "", "", 0, true); } else { recordIDVJ = dtCekRelasi.Rows[0][1].ToString(); _VJRowID = (Guid)dtCekRelasi.Rows[0][0]; } //VoucherJournal.AddDetail(db, RowID, _VJRowID, RecordID, recordIDVJ, "", "", "", noBGC, _noPerk, namaCollector, // Convert.ToDouble(RpGiro), 0, true); Giro.Add(db, RowID, _VJRowID, Guid.Empty, Guid.Empty, recordIDVJ, "", "", RecordID, "", NamaBank, Lokasi, cara, noBGC, (DateTime)tglGiro, (DateTime)tglJTempo, Convert.ToDouble(RpGiro), "", SqlDateTime.Null, "", "", "", "", "", "", _noPerk, SqlDateTime.Null, true, noAcc, ""); } else if (cara == "R") { string recordIDVPG = "", noVoucherPG = "", noVoucherTT = ""; string recordIDVTT = ""; Guid _VJRowIDPG = new Guid(); Guid _VJRowIDTT = new Guid(); string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString(); //VOUCHER PENERIMAAN CRD dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "CRD", "").Copy(); if (dtCekRelasi.Rows.Count == 0) { recordIDVPG = HRecordID + "R"; _VJRowIDPG = Guid.NewGuid(); noVoucherPG = Numerator.BookNumerator("VPG"); VoucherJournal.AddHeader(db, _VJRowIDPG, HeaderID, recordIDVPG, "CC", tglInden, noVoucherPG, "PENERIMAAN CREDIT CARD IND. NO " + noBukti, "", "", "", "", "", "", "", 0, true); } else { recordIDVPG = dtCekRelasi.Rows[0][1].ToString(); _VJRowIDPG = (Guid)dtCekRelasi.Rows[0][0]; } //VoucherJournal.AddDetail(db, RowID, _VJRowID, RecordID, recordIDVJ, "", "", "", noBGC, _noPerk, namaCollector, // Convert.ToDouble(RpGiro), 0, true); //VOUCHER TITIP CRD dtCekRelasi = new DataTable(); dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "TT", bankID).Copy(); if (dtCekRelasi.Rows.Count == 0) { recordIDVTT = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial).TrimEnd() + "R"; _VJRowIDTT = Guid.NewGuid(); noVoucherTT = Numerator.BookNumerator("VTG"); VoucherJournal.AddHeader(db, _VJRowIDTT, HeaderID, recordIDVTT, "TT", tglInden, noVoucherTT, "OTOMATIS TITIP DR CRD", "", "", "", "", "", bankID, namaBanki, 0, true); } else { recordIDVTT = dtCekRelasi.Rows[0][1].ToString(); _VJRowIDTT = (Guid)dtCekRelasi.Rows[0][0]; } //INSERT TABLE GIRO Giro.Add(db, RowID, _VJRowIDPG, Guid.Empty, _VJRowIDTT, recordIDVPG, "", recordIDVTT, RecordID, "", NamaBank, Lokasi, cara, noBGC, (DateTime)tglGiro, (DateTime)tglJTempo, Convert.ToDouble(RpCrd), "", (DateTime)SqlDateTime.Null, "", "", "", "", bankID, namaBanki, _noPerk, tglInden, true, noAcc, ""); } else if (cara == "D") { string recordIDVPG = "", noVoucherPG = "", noVoucherTT = ""; string recordIDVTT = ""; Guid _VJRowIDPG = new Guid(); Guid _VJRowIDTT = new Guid(); string _noPerk = Perkiraan.GetPerkiraanKoneksiDetail("IND").Rows[0]["NoPerkiraan"].ToString(); //VOUCHER PENERIMAAN CRD dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "DBT", "").Copy(); if (dtCekRelasi.Rows.Count == 0) { recordIDVPG = HRecordID + "D"; _VJRowIDPG = Guid.NewGuid(); noVoucherPG = Numerator.BookNumerator("VPG"); VoucherJournal.AddHeader(db, _VJRowIDPG, HeaderID, recordIDVPG, "DB", tglInden, noVoucherPG, "PENERIMAAN DEBIT CARD IND. NO " + noBukti, "", "", "", "", "", "", "", 0, true); } else { recordIDVPG = dtCekRelasi.Rows[0][1].ToString(); _VJRowIDPG = (Guid)dtCekRelasi.Rows[0][0]; } //VoucherJournal.AddDetail(db, RowID, _VJRowID, RecordID, recordIDVJ, "", "", "", noBGC, _noPerk, namaCollector, // Convert.ToDouble(RpGiro), 0, true); //VOUCHER TITIP CRD dtCekRelasi = new DataTable(); dtCekRelasi = Inden.CekRelasiInden("VoucherJournal", "RefRowID", HeaderID.ToString(), "TT", bankID).Copy(); if (dtCekRelasi.Rows.Count == 0) { recordIDVTT = Tools.CreateFingerPrint(GlobalVar.PerusahaanID, SecurityManager.UserInitial).TrimEnd() + "D"; _VJRowIDTT = Guid.NewGuid(); noVoucherTT = Numerator.BookNumerator("VTG"); VoucherJournal.AddHeader(db, _VJRowIDTT, HeaderID, recordIDVTT, "TT", tglInden, noVoucherTT, "OTOMATIS TITIP DR DBT", "", "", "", "", "", bankID, namaBanki, 0, true); } else { recordIDVTT = dtCekRelasi.Rows[0][1].ToString(); _VJRowIDTT = (Guid)dtCekRelasi.Rows[0][0]; } //INSERT TABLE GIRO Giro.Add(db, RowID, _VJRowIDPG, Guid.Empty, _VJRowIDTT, recordIDVPG, "", recordIDVTT, RecordID, "", NamaBank, Lokasi, cara, noBGC, (DateTime)tglGiro, (DateTime)tglJTempo, Convert.ToDouble(RpDbt), "", (DateTime)SqlDateTime.Null, "", "", "", "", bankID, namaBanki, _noPerk, tglInden, true, noAcc, ""); } }
public int giro([FromBody] Giro giro) { GestorOperaciones gOperaciones = new GestorOperaciones(); return(gOperaciones.giro(giro)); }
public List<Giro> CargaGiro() { List<Giro> giros = new List<Giro>(); sqlDataAdapter.SelectCommand = new SqlCommand("ConsultaGiro", sqlConnection); sqlDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; sqlDataAdapter.Fill(ds, "ConsultaGiro"); foreach (DataRow dr in ds.Tables["ConsultaGiro"].Rows) { Giro tmp = new Giro(); tmp.Id = Convert.ToString(dr["Id_Giro"]); tmp.Nombre = Convert.ToString(dr["Giro"]); giros.Add(tmp); } return giros; }