public static StylistProfile StylistProfileDB(string queryString, string guid) { StylistProfile s_sp = new StylistProfile(); using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); try { s_sp = new StylistProfile(reader["GUID"].ToString().Trim(), reader["FirstName"].ToString().Trim(), reader["LastName"].ToString().Trim(), reader["Salon"].ToString().Trim(), (float)reader["Lat"], (float)reader["Long"], reader["City"].ToString().Trim() ); } finally { // Always call Close when done reading. reader.Close(); } } return(s_sp); }
public IActionResult Meme(string GUID) { //List<StylistProfile> l_sp = DBStuff(); //JWscCK43/EO0daxAJTd0Ow== //string queryString = "SELECT * FROM [dbo].[Basic_User_Info]"; StylistProfile l_sp = new StylistProfile(GUID, "f**k me sideways", "yui", "", 0, 0, ""); return(Ok(l_sp)); }