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));
}
