//________________________________________________________________________________________________________ public static void SavePersona(PersonaDto persona) { PersonaDb.GrabarPersonas(ref persona); }
//________________________________________________________________________________________________________ // SavePersona public static void GrabarPersonas(ref PersonaDto persona) { //#region Insert New Persona //OracleCommand cmd = new OracleCommand(); //try //{ // ------------------------------------------------------------------------------ // Consulta Text // ------------------------------------------------------------------------------ var querystring = "INSERT INTO PERSONA ( psnNombre) VALUES (:psnNombre)"; var cmd = new OracleCommand(querystring); cmd.Connection = GetConn(); cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new OracleParameter(":psnNombre", persona.PsnNombre)); //------------------------------------------------------------------------------ // Consulta StoredProcedure //------------------------------------------------------------------------------ //cmd.Connection = GetConn(); //cmd.CommandType = CommandType.StoredProcedure; //cmd.CommandText = "PKG_PERSONA.InsertPersona"; //cmd.Parameters.Add(CreateParameter("psn_tpdId", Persona.psn_tpdId));//NUMBER //cmd.Parameters.Add(CreateParameter("psnNroDcto", Persona.psnNroDcto));//NUMBER //cmd.Parameters.Add(CreateParameter("psnNombre", Persona.psnNombre, 45));//VARCHAR //cmd.Parameters.Add(CreateParameter("psnApellido", Persona.psnApellido, 45));//VARCHAR //cmd.Parameters.Add(CreateParameter("psnFechaNac", Persona.psnFechaNac, 12));//VARCHAR //cmd.Parameters.Add(CreateParameter("psnTelefono", Persona.psnTelefono, 20));//VARCHAR //cmd.Parameters.Add(CreateParameter("psnSexo", Persona.psnSexo, 1));//VARCHAR //cmd.Parameters.Add(CreateParameter("psn_domId", Persona.psn_domId));//NUMBER // Run the command. cmd.Connection.Open(); cmd.ExecuteNonQuery(); //} //catch(Exception ex) //{ // throw ex; //} //finally //{ // cmd.Connection.Close(); //} //#endregion /* if (Persona.IsNew) { cmd = GetDbSprocCommand("usp_Persona_Insert"); cmd.Parameters.Add(CreateOutputParameter("@psnId", OracleDbType.Int16)); } else { cmd = GetDbSprocCommand("usp_Persona_Update"); cmd.Parameters.Add(CreateParameter("@psnId", Persona.psnId)); } cmd.Parameters.Add(CreateParameter("@psn_tpdId", Persona.psn_tpdId));//NUMBER cmd.Parameters.Add(CreateParameter("@psnNroDcto", Persona.psnNroDcto));//NUMBER cmd.Parameters.Add(CreateParameter("@psnNombre", Persona.psnNombre,45));//VARCHAR cmd.Parameters.Add(CreateParameter("@psnApellido", Persona.psnApellido, 45));//VARCHAR cmd.Parameters.Add(CreateParameter("@psnFechaNac", Persona.psnFechaNac, 12));//VARCHAR cmd.Parameters.Add(CreateParameter("@psnTelefono", Persona.psnTelefono, 20));//VARCHAR cmd.Parameters.Add(CreateParameter("@psn_sexId", Persona.psn_sexId, 1));//VARCHAR cmd.Parameters.Add(CreateParameter("@psn_domId", Persona.psn_domId));//NUMBER // Run the command. cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); * */ }