private void MenuItem_Clicked(object sender, EventArgs e)
{
var Search = (sender as MenuItem).CommandParameter as Search;
Service.DeleteSearch(Search.Id);
Searchlist.EndRefresh();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
String a = Request.QueryString["search"];
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SalgDBConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("SELECT * FROM Products WHERE ProductName LIKE'%" + a + "%'OR Description LIKE '%" + a + "%'", con);
if (a != null)
{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
Searchlist.DataSource = dt;
Searchlist.DataBind();
con.Close();
}
}
}
//Retrieve list of all searches by specific user
public List <Searchlist> retrieve_searches_db(string userid)
{
var results = new List <Searchlist>();
var query = "SELECT QueryId, SearchTitle, Date, PeakListFileAddress FROM proteomics.query where UserId='" +
userid + "';";
if (!OpenConnection())
{
return(results);
}
try
{
var cmd = new MySqlCommand(query, _connection);
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var temp = new Searchlist
{
Qid = reader["QueryId"].ToString(),
Title = reader["SearchTitle"].ToString(),
Date = reader["Date"].ToString(),
File = reader["PeakListFileAddress"].ToString()
};
results.Add(temp);
}
}
_connection.Close();
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
return(results);
}
