/// <summary> /// Validar usuario /// </summary> /// <param name="obclsUsuarios">Objeto usuario</param> /// <returns>Confirmacion</returns> public bool getValidarUsuario(Models.clsUsuarios obclsUsuarios) { try { DataSet dsConsulta = new DataSet(); _SqlConnection = new SqlConnection(stConexion); _SqlConnection.Open(); _SqlCommand = new SqlCommand("spConsultarUsuario", _SqlConnection); _SqlCommand.CommandType = CommandType.StoredProcedure; _SqlCommand.Parameters.Add(new SqlParameter("@cLogin", obclsUsuarios.stLogin)); _SqlCommand.Parameters.Add(new SqlParameter("@cPassword", obclsUsuarios.stPassword)); _SqlCommand.ExecuteNonQuery(); _SqlDataAdapter = new SqlDataAdapter(_SqlCommand); _SqlDataAdapter.Fill(dsConsulta); if (dsConsulta.Tables[0].Rows.Count > 0) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } finally { _SqlConnection.Close(); } }
/// <summary> /// ADministrar registro usuario /// </summary> /// <returns>Mensaje de proceso</returns> public string setUsuario(Models.clsUsuarios ob) { try { _SqlConnection = new SqlConnection(stConexion); _SqlConnection.Open(); _SqlCommand = new SqlCommand("spRegistrarUsuario", _SqlConnection); _SqlCommand.CommandType = CommandType.StoredProcedure; _SqlCommand.Parameters.Add(new SqlParameter("@cNombre", ob.stNombre)); _SqlCommand.Parameters.Add(new SqlParameter("@cApellido", ob.stApellido)); _SqlCommand.Parameters.Add(new SqlParameter("@cCorreo", ob.stUsuario)); _SqlCommand.Parameters.Add(new SqlParameter("@cContraseña", ob.stContraseña)); _SqlCommand.Parameters.Add(new SqlParameter("@cTelefono", ob.inTelefono)); _SqlCommand.Parameters.Add(new SqlParameter("@cTipoUsuario", "1")); _SqlParameter = new SqlParameter(); _SqlParameter.ParameterName = "@cMensaje"; _SqlParameter.Direction = ParameterDirection.Output; _SqlParameter.SqlDbType = SqlDbType.VarChar; _SqlParameter.Size = 50; _SqlCommand.Parameters.Add(_SqlParameter); _SqlCommand.ExecuteNonQuery(); return(_SqlParameter.Value.ToString()); } catch (Exception ex) { throw ex; } finally { _SqlConnection.Close(); } }
/// <summary> /// CREAR CUENTA DE USUARIO /// </summary> /// <param name="obclsUsuarios">OBJETO USUARIO</param> /// <returns>MENSAJE DE BBDD</returns> public string setCrearCuenta(Models.clsUsuarios obclsUsuarios, int inOpcion) { try { DataSet dsConsulta = new DataSet(); _SqlConnection = new SqlConnection(stConexion); _SqlConnection.Open(); _SqlCommand = new SqlCommand("spAdministrarUsuarios", _SqlConnection); _SqlCommand.CommandType = CommandType.StoredProcedure; //PARAMETROS DE ENTRADA _SqlCommand.Parameters.Add(new SqlParameter("@cLogin", obclsUsuarios.stLogin)); _SqlCommand.Parameters.Add(new SqlParameter("@cPassword", obclsUsuarios.stPassword)); _SqlCommand.Parameters.Add(new SqlParameter("@cImagen", obclsUsuarios.stImagen)); _SqlCommand.Parameters.Add(new SqlParameter("@nOpcion", inOpcion)); //PARAMETROS DE SALIDA _SqlParameter = new SqlParameter(); _SqlParameter.ParameterName = "@cMensaje"; _SqlParameter.Direction = ParameterDirection.Output; _SqlParameter.SqlDbType = SqlDbType.VarChar; _SqlParameter.Size = 50; _SqlCommand.Parameters.Add(_SqlParameter); _SqlCommand.ExecuteNonQuery(); return(_SqlParameter.Value.ToString()); } catch (Exception ex) { throw ex; } finally { _SqlConnection.Close(); } }
public DataSet getConsultarPassword(Models.clsUsuarios obclsUsuarios) { try { DataSet dsConsulta = new DataSet(); _SqlConnection = new SqlConnection(stConexion); _SqlConnection.Open(); _SqlCommand = new SqlCommand("spConsultarPassword", _SqlConnection); _SqlCommand.CommandType = CommandType.StoredProcedure; _SqlCommand.Parameters.Add(new SqlParameter("@cCorreo", obclsUsuarios.stCorreo)); _SqlCommand.ExecuteNonQuery(); _SqlDataAdapter = new SqlDataAdapter(_SqlCommand); _SqlDataAdapter.Fill(dsConsulta); return(dsConsulta); } catch (Exception ew) { throw ew; } finally { _SqlConnection.Close(); } }