public response validar_credenciales(string user_name, string password) { string query = "select contrasena from Usuarios where correo_electronico = '" + user_name + "'"; MySqlCommand comando = conn.conex.CreateCommand(); comando.CommandText = query; MySqlDataReader reader = comando.ExecuteReader(); Login_model model = null; while (reader.Read()) { model = new Login_model(user_name, reader["contrasena"].ToString()); break; } if (model != null) { return(model.validate(password)); } return(new response(false, "No existe usuario")); }
public Get_Post_List LoginService(Login_model user) { string status = "failed"; Get_Post_List list = new Get_Post_List(); try { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PortalConnectionString"].ToString())) { DataSet ds = new DataSet(); con.Open(); SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@username", user.username); param[1] = new SqlParameter("@password", user.password); param[2] = new SqlParameter("@IsValid", SqlDbType.Int); param[2].Direction = ParameterDirection.Output; ds = SqlHelper.ExecuteDataset(con, CommandType.StoredProcedure, "tmpprclogin", param); int OutParam = 0; if (!String.IsNullOrEmpty(Convert.ToString(param[2].Value))) { OutParam = Convert.ToInt32(param[2].Value); } if (OutParam == 1) { list.message = "valid"; } else if (OutParam == 0) { list.message = "invalid"; } } } catch (Exception ex) { list.message = ex.Message; } return(list); }