public List <CdtConceptosCategorias> CdtConceptosCategoriasGetAll() { List <CdtConceptosCategorias> lstCdtConceptosCategorias = new List <CdtConceptosCategorias>(); try { ds = new DataSet(); Conexion oConexion = new Conexion(); OracleConnection cn = oConexion.getConexion(); cn.Open(); string sqlSelect = "select * from Cdt_Conceptos_Categorias order by CCA_CODIGO"; cmd = new OracleCommand(sqlSelect, cn); adapter = new OracleDataAdapter(cmd); cmd.ExecuteNonQuery(); adapter.Fill(ds); DataTable dt = new DataTable(); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; dt.Rows.Count > i; i++) { DataRow dr = dt.Rows[i]; CdtConceptosCategorias NewEnt = new CdtConceptosCategorias(); NewEnt = CargarCdtConceptosCategorias(dr); lstCdtConceptosCategorias.Add(NewEnt); } } return(lstCdtConceptosCategorias); } catch (Exception ex) { throw ex; } }
public bool CdtConceptosCategoriasUpdate(CdtConceptosCategorias oCCa) { try { Conexion oConexion = new Conexion(); OracleConnection cn = oConexion.getConexion(); cn.Open(); ds = new DataSet(); sql = "update Cdt_Conceptos_Categorias SET " + "SCA_NUMERO=" + oCCa.ScaNumero + "," + "CPT_NUMERO=" + oCCa.CptNumero + "," + "CCA_IMPORTE=" + oCCa.CcaImporte + "," + "CCA_TASA=" + oCCa.CcaTasa + "," + "CCA_SCRIPT_IMPORTE='" + oCCa.CcaScriptImporte + "'," + "CCA_SCRIPT_TASA='" + oCCa.CcaScriptTasa + "', " + "CCA_ORDEN_CALCULO=" + oCCa.CcaOrdenCalculo + ", " + "CCA_ORDEN_IMPRESION=" + oCCa.CcaOrdenImpresion + ", " + "CCA_TIPO_TARIFA='" + oCCa.CcaTipoTarifa + "', " + "CCA_TIPO_CALCULO='" + oCCa.CcaTipoCalculo + "'," + "CCA_VALOR_LIMITE=" + oCCa.CcaValorLimite + "," + "MON_CODIGO=" + oCCa.MonCodigo + "WHERE CCA_CODIGO=" + oCCa.CcaCodigo; cmd = new OracleCommand(sql, cn); adapter = new OracleDataAdapter(cmd); response = cmd.ExecuteNonQuery(); cn.Close(); return(response > 0); } catch (Exception ex) { throw ex; } }
public CdtConceptosCategorias CdtConceptosCategoriasGetById(long Id) { try { DataSet ds = new DataSet(); Conexion oConexion = new Conexion(); OracleConnection cn = oConexion.getConexion(); cn.Open(); string sqlSelect = "SELECT * FROM Cdt_Conceptos_Categorias " + "WHERE CCA_CODIGO=" + Id.ToString(); cmd = new OracleCommand(sqlSelect, cn); adapter = new OracleDataAdapter(cmd); cmd.ExecuteNonQuery(); adapter.Fill(ds); DataTable dt; dt = ds.Tables[0]; CdtConceptosCategorias NewEnt = new CdtConceptosCategorias(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt = CargarCdtConceptosCategorias(dr); } return(NewEnt); } catch (Exception ex) { throw ex; } }
private CdtConceptosCategorias CargarCdtConceptosCategorias(DataRow dr) { try { CdtConceptosCategorias oCCa = new CdtConceptosCategorias(); oCCa.CcaCodigo = long.Parse(dr["CCA_NUMERO"].ToString()); oCCa.ScaNumero = long.Parse(dr["SCA_NUMERO"].ToString()); if (dr["CPT_NUMERO"].ToString() != "") { oCCa.CptNumero = long.Parse(dr["CPT_NUMERO"].ToString()); } if (dr["CCA_IMPORTE"].ToString() != "") { oCCa.CcaImporte = float.Parse(dr["CCA_IMPORTE"].ToString()); } if (dr["CCA_TASA"].ToString() != "") { oCCa.CcaTasa = float.Parse(dr["CCA_TASA"].ToString()); } oCCa.CcaScriptImporte = dr["CCA_SCRIPT_IMPORTE"].ToString(); oCCa.CcaScriptTasa = dr["CCA_SCRIPT_TASA"].ToString(); if (dr["CCA_ORDEN_CALCULO"].ToString() != "") { oCCa.CcaOrdenCalculo = short.Parse(dr["CCA_ORDEN_CALCULO"].ToString()); } if (dr["CCA_ORDEN_IMPRESION"].ToString() != "") { oCCa.CcaOrdenImpresion = short.Parse(dr["CCA_ORDEN_IMPRESION"].ToString()); } oCCa.CcaTipoTarifa = dr["CCA_TIPO_TARIFA"].ToString(); oCCa.CcaTipoCalculo = dr["CCA_TIPO_CALCULO"].ToString(); if (dr["CCA_VALOR_LIMITE"].ToString() != "") { oCCa.CcaValorLimite = double.Parse(dr["CCA_VALOR_LIMITE"].ToString()); } if (dr["MON_CODIGO"].ToString() != "") { oCCa.MonCodigo = short.Parse(dr["MON_CODIGO"].ToString()); } return(oCCa); } catch (Exception ex) { throw ex; } }
public long CdtConceptosCategoriasAdd(CdtConceptosCategorias oCCa) { try { Conexion oConexion = new Conexion(); OracleConnection cn = oConexion.getConexion(); cn.Open(); // Clave Secuencia CCA_CODIGO ds = new DataSet(); string query = " DECLARE IDTEMP NUMBER; " + " BEGIN " + " SELECT(PKG_SECUENCIAS.FNC_PROX_SECUENCIA('CCA_CODIGO')) into IDTEMP from dual; " + " insert into Cdt_Conceptos_Categorias( CCA_CODIGO, SCA_NUMERO," + " CPT_NUMERO, CCA_IMPORTE, CCA_TASA," + " CCA_SCRIPT_IMPORTE, CCA_SCRIPT_TASA, " + " CCA_ORDEN_CALCULO, CCA_ORDEN_IMPRESION, " + " CCA_TIPO_TARIFA, CCA_TIPO_CALCULO, " + " CCA_VALOR_LIMITE, MON_CODIGO ) " + "values (IDTEMP, " + oCCa.ScaNumero + ", " + oCCa.CptNumero + ", " + oCCa.CcaImporte + ", " + oCCa.CcaTasa + ", '" + oCCa.CcaScriptImporte + "', '" + oCCa.CcaScriptTasa + "', " + oCCa.CcaOrdenCalculo + "', " + oCCa.CcaOrdenImpresion + ", '" + oCCa.CcaTipoTarifa + "', '" + oCCa.CcaTipoCalculo + "', " + oCCa.CcaValorLimite + ", " + oCCa.MonCodigo + "') " + " RETURNING IDTEMP INTO :id;" + " END;"; cmd = new OracleCommand(query, cn); cmd.Parameters.Add(new OracleParameter { ParameterName = ":id", OracleDbType = OracleDbType.Int64, Direction = ParameterDirection.Output }); adapter = new OracleDataAdapter(cmd); cmd.ExecuteNonQuery(); response = long.Parse(cmd.Parameters[":id"].Value.ToString()); cn.Close(); return(response); } catch (Exception ex) { throw ex; } }
public long CdtConceptosCategoriasAdd(CdtConceptosCategorias oCCa) { CdtConceptosCategoriasImpl oCCaImpl = new CdtConceptosCategoriasImpl(); return(oCCaImpl.CdtConceptosCategoriasAdd(oCCa)); }
public bool CdtConceptosCategoriasUpdate(CdtConceptosCategorias oCCa) { CdtConceptosCategoriasImpl oCCaImpl = new CdtConceptosCategoriasImpl(); return(oCCaImpl.CdtConceptosCategoriasUpdate(oCCa)); }