//Returns Search History of specific query ie. search parameters and Results
public searchview retrieve_searchview_db(string qid)
{
searchview result = new searchview();
QuerryParameters qp = new QuerryParameters();
Results r = new Results();
string[] QIDArr = qid.Split('z');
qid = QIDArr[0];
int file_id = Convert.ToInt32(QIDArr[1]);
string query1 = "SELECT * FROM proteomics.query where QueryId='" + qid + "';";
string queryT = "SELECT * FROM proteomics.timings where querry_ID='" + qid + "';";
if (this.OpenConnection() == true)
{
try
{
using (MySqlTransaction trans = connection.BeginTransaction())
{
MySqlCommand cmd = new MySqlCommand(queryT, connection);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
r.times.insilico_time = reader.GetValue(1).ToString();
r.times.ptm_time = reader.GetValue(2).ToString();
r.times.tuner_time = reader.GetValue(3).ToString();
r.times.mw_filter_time = reader.GetValue(4).ToString();
r.times.pst_time = reader.GetValue(5).ToString();
r.times.total_time = reader.GetValue(6).ToString();
r.times.file = reader.GetValue(7).ToString();
}
reader.Close();
cmd = new MySqlCommand(query1, connection);
reader = cmd.ExecuteReader();
if (reader.Read())
{
qp.queryid = reader.GetValue(0).ToString();
qp.userID = reader.GetValue(1).ToString();
qp.title = reader.GetValue(2).ToString();
qp.protDB = reader.GetValue(3).ToString();
qp.outputFormat = Convert.ToInt32(reader.GetValue(4));
qp.insilico_frag_type = reader.GetValue(5).ToString();
qp.filterDB = Convert.ToInt32(reader.GetValue(6));
qp.ptm_tolerance = Convert.ToDouble(reader.GetValue(7));
qp.MWTolUnit = reader.GetValue(8).ToString();
qp.MW_tolerance = Convert.ToDouble(reader.GetValue(9));
qp.hopThreshhold = Convert.ToDouble(reader.GetValue(10));
qp.minimum_est_length = Convert.ToInt32(reader.GetValue(11));
qp.maximum_est_length = Convert.ToInt32(reader.GetValue(12));
// public double pst_tolerance;
qp.GUI_mass = Convert.ToDouble(reader.GetValue(13));
qp.HandleIons = reader.GetValue(14).ToString();
qp.autotune = Convert.ToInt32(reader.GetValue(15));
qp.peakListFile = reader.GetValue(16).ToString().Split('<');
qp.fileType = reader.GetValue(17).ToString();
// public double peptideTol;
//added
qp.hopTolUnit = reader.GetValue(18).ToString();
qp.MW_sweight = Convert.ToDouble(reader.GetValue(19));
qp.PST_sweight = Convert.ToDouble(reader.GetValue(20));
qp.Insilico_sweight = Convert.ToDouble(reader.GetValue(21));
qp.NumberOfOutputs = Convert.ToInt32(reader.GetValue(22));
/////
qp.denovo_allow = Convert.ToInt32(reader.GetValue(23));
qp.ptm_allow = Convert.ToInt32(reader.GetValue(24));
}
reader.Close();
query1 = "SELECT fixed_mod FROM fixed_modifications where QuerryId='" + qid + "';";
cmd = new MySqlCommand(query1, connection);
using (reader = cmd.ExecuteReader())
{
qp.ptm_code_fix = new List <int>();
while (reader.Read())
{
qp.ptm_code_fix.Add(Convert.ToInt32(reader["fixed_mod"]));
}
}
reader.Close();
query1 = "SELECT variable_mod FROM variable_modifications where QuerryId='" + qid + "';";
cmd = new MySqlCommand(query1, connection);
using (reader = cmd.ExecuteReader())
{
qp.ptm_code_var = new List <int>();
while (reader.Read())
{
qp.ptm_code_var.Add(Convert.ToInt32(reader["variable_mod"]));
}
}
reader.Close();
// SELECT * FROM proteomics.results Where Querry_ID = 'fe29e39e-97ee-4f5e-9cab-4d414b5e902a' ORDER BY score DESC LIMIT 3;
string query2 = "SELECT * FROM results where Querry_ID='" + qid + "' AND file_ID = " + file_id + " ORDER BY score DESC LIMIT " + qp.NumberOfOutputs + ";";
cmd = new MySqlCommand(query2, connection);
r.querryID = qid;
r.final_prot = new List <proteins>();
proteins temp_prot = new proteins();
List <string> resid = new List <string>();
using (reader = cmd.ExecuteReader())
{
while (reader.Read())
{
temp_prot = new proteins();
resid.Add(reader.GetValue(0).ToString());
temp_prot.header = reader.GetValue(2).ToString();
temp_prot.sequence = reader.GetValue(3).ToString();
temp_prot.est_score = Convert.ToDouble(reader.GetValue(4));
temp_prot.insilico_score = Convert.ToDouble(reader.GetValue(5));
temp_prot.ptm_score = Convert.ToDouble(reader.GetValue(6));
temp_prot.score = Convert.ToDouble(reader.GetValue(7));
temp_prot.MW_score = Convert.ToDouble(reader.GetValue(8));
temp_prot.MW = Convert.ToDouble(reader.GetValue(9));
r.final_prot.Add(temp_prot);
}
}
reader.Close();
Sites temp_site = new Sites();
string tempaa;
for (int i = 0; i < resid.Count; i++)
{
query2 = "SELECT * FROM ptm_sites where result_id='" + resid[i] + "';";
cmd = new MySqlCommand(query2, connection);
using (reader = cmd.ExecuteReader())
{
while (reader.Read())
{
temp_site = new Sites();
temp_site.i = Convert.ToInt32(reader.GetValue(1));
temp_site.score = Convert.ToInt32(reader.GetValue(2));
temp_site.mod_weight = Convert.ToInt32(reader.GetValue(3));
temp_site.mod_name = reader.GetValue(4).ToString();
temp_site.site = Convert.ToChar(reader.GetValue(5));
tempaa = reader.GetValue(6).ToString();
for (int j = 0; j < tempaa.Length; j++)
{
temp_site.AA.Add(tempaa[j]);
}
r.final_prot[i].ptm_particulars.Add(temp_site);
}
}
}
reader.Close();
///////////
//temp_p.insilico_details.insilico_mass_left = dataPs[3].Split(',').Select(t => double.Parse(t)).ToList<double>();
string xx;
for (int i = 0; i < resid.Count; i++)
{
query2 = "SELECT matched_peak_left FROM insilico_matches_left where result_id='" + resid[i] + "';";
cmd = new MySqlCommand(query2, connection);
using (reader = cmd.ExecuteReader())
{
temp_site = new Sites();
if (reader.Read())
{
xx = reader.GetValue(0).ToString();
r.final_prot[i].insilico_details.peaklist_mass_left = xx.Split(',').Select(t => double.Parse(t)).ToList <double>();
}
}
query2 = "SELECT Ions FROM leftions where ProteinID='" + r.final_prot[i].header + "';";
cmd = new MySqlCommand(query2, connection);
using (reader = cmd.ExecuteReader())
{
temp_site = new Sites();
if (reader.Read())
{
xx = reader.GetValue(0).ToString();
xx = Decompress(xx);
r.final_prot[i].insilico_details.insilico_mass_left = xx.Split(',').Select(t => double.Parse(t)).ToList <double>();
}
}
}
reader.Close();
//////////////////////////////////////////////////////////////
for (int i = 0; i < resid.Count; i++)
{
query2 = "SELECT matchedpeak_right FROM insilico_matches_right where result_id='" + resid[i] + "';";
cmd = new MySqlCommand(query2, connection);
using (reader = cmd.ExecuteReader())
{
temp_site = new Sites();
if (reader.Read())
{
xx = reader.GetValue(0).ToString();
r.final_prot[i].insilico_details.peaklist_mass_right = xx.Split(',').Select(t => double.Parse(t)).ToList <double>();
}
}
query2 = "SELECT Ions FROM rightions where ProteinID='" + r.final_prot[i].header + "';";
cmd = new MySqlCommand(query2, connection);
using (reader = cmd.ExecuteReader())
{
temp_site = new Sites();
if (reader.Read())
{
xx = reader.GetValue(0).ToString();
xx = Decompress(xx);
r.final_prot[i].insilico_details.insilico_mass_right = xx.Split(',').Select(t => double.Parse(t)).ToList <double>();
}
}
}
reader.Close();
//////////////////////////////////////////////////////////////
//for (int i = 0; i < resid.Count; i++)
//{
// query2 = "SELECT * FROM insilico_mass_right where result_id='" + resid[i] + "';";
// cmd = new MySqlCommand(query2, connection);
// using (reader = cmd.ExecuteReader())
// {
// while (reader.Read())
// {
// temp_site = new Sites();
// r.final_prot[i].insilico_details.insilico_mass_right.Add(Convert.ToDouble(reader.GetValue(1)));
// r.final_prot[i].insilico_details.peaklist_mass_right.Add(Convert.ToDouble(reader.GetValue(2)));
// }
// }
//}
//reader.Close();
////////////
result.param = qp;
result.result = r;
trans.Commit();
connection.Close();
}
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Message);
}
}
// result.result.final_prot = result.result.final_prot.OrderByDescending(o => o.score).ToList();
return(result);
}
//string querrry id
public searchview Get_viewsearch(string em)
{
searchview answer = abc.retrieve_searchview(em);
return(answer);
}
protected async void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
try
{
if (string.IsNullOrEmpty(Session["ID"].ToString()))
{
Response.Redirect("~/Account/Login", false);
}
var client = new HttpClient();
var userId = Session["ID"].ToString();
var sessionG = Session["guid"].ToString();
string result;
var uri = "http://localhost:14625//api/users/Get_Session/" + userId + "/" + sessionG;
try
{
var task = client.GetStringAsync(uri);
result = await task;
}
catch (Exception k)
{
result = k.Message;
}
if (result == "F")
{
Response.Redirect("~/Account/Login", false);
}
else
{
var regBtn = (HtmlAnchor)Master.FindControl("reg");
var heyBtn = (HtmlAnchor)Master.FindControl("hello");
regBtn.Style.Add("display", "none");
heyBtn.Style.Remove("display");
heyBtn.InnerHtml = Session["ID"].ToString();
client = new HttpClient();
userId = Session["ID"].ToString();
uri = "http://localhost:14625//api/users/Get_my_searches/" + userId;
var searchlists = new List <searchlist>();
try
{
var task = client.GetStringAsync(uri);
var value = await task;
searchlists = JsonConvert.DeserializeObject <List <searchlist> >(value);
searchlists = searchlists.OrderByDescending(e11 => DateTime.Parse(e11.date)).ToList();
}
catch (Exception k)
{
var result1 = k.Message;
}
var searchRec = (HtmlAnchor)Master.FindControl("A1");
var lgnBtn = (HtmlAnchor)Master.FindControl("lin");
searchRec.Style.Remove("display");
searchRec.InnerHtml = "Searches: " + searchlists.Count;
lgnBtn.InnerHtml = "Logout";
lgnBtn.HRef = "~/Account/Logout";
Result_table.Rows[0].Cells[0].Attributes.Add("style", "text-align:center !important;");
Result_table.Rows[0].Cells[1].Attributes.Add("style", "text-align:center !important;");
Result_table.Rows[0].Cells[2].Attributes.Add("style", "text-align:center !important;");
Result_table.Rows[0].Cells[3].Attributes.Add("style", "text-align:center !important;");
client = new HttpClient();
var qid = !string.IsNullOrEmpty(Request.QueryString["Qid"])
? Request.QueryString["Qid"]
: Guid.Empty.ToString();
uri = "http://localhost:14625//api/users/Get_viewsearch/" + qid;
var qidArr = qid.Split('z');
qid = qidArr[0];
var fileId = Convert.ToInt32(qidArr[1]);
var resultList = new searchview();
try
{
var task = client.GetStringAsync(uri);
var value = await task;
resultList = JsonConvert.DeserializeObject <searchview>(value);
}
catch (Exception k)
{
var result1 = k.Message;
}
Session["Qid"] = qid;
Session[qid] = resultList;
var querryParameters = resultList.param;
P_Search1.Text = querryParameters.title;
P_ProMass1.Text = querryParameters.GUI_mass.ToString();
var xx = resultList.param.peakListFile[fileId].Substring(31 + querryParameters.userID.Length);
P_Data1.Text = xx;
P_PT1.Text = querryParameters.hopThreshhold.ToString();
P_PTU1.Text = "Da";
P_DB1.Text = querryParameters.protDB;
if (querryParameters.insilico_frag_type == "*")
{
P_FRGL.Style.Add(HtmlTextWriterStyle.Color, "gray");
}
else
{
P_FRG1.Text = querryParameters.insilico_frag_type;
}
if (querryParameters.insilico_frag_type == "*")
{
P_SIL.Style.Add(HtmlTextWriterStyle.Color, "gray");
}
else
{
P_SI1.Text = querryParameters.HandleIons;
}
if (querryParameters.autotune == 1)
{
P_AU1.Text = "Yes";
if (querryParameters.filterDB == 1)
{
}
else
{
P_MT1.Text = querryParameters.MW_tolerance.ToString();
P_MTU1.Text = "Da";
}
}
else
{
P_AU1.Text = "No";
}
if (querryParameters.filterDB == 1)
{
P_FDB1.Text = "Yes";
P_MT1.Text = querryParameters.MW_tolerance.ToString();
P_MTU1.Text = "Da"; // qu.MWTolUnit;
}
else
{
P_FDB1.Text = "No";
P_MTL.Style.Add(HtmlTextWriterStyle.Color, "gray");
P_MTUL.Style.Add(HtmlTextWriterStyle.Color, "gray");
}
if (querryParameters.denovo_allow == 1)
{
P_EPT1.Text = "Yes";
if ((querryParameters.maximum_est_length == -1) &&
(querryParameters.minimum_est_length == -1))
{
P_MINL.Style.Add(HtmlTextWriterStyle.Color, "gray");
P_MAXL.Style.Add(HtmlTextWriterStyle.Color, "gray");
}
else
{
P_MIN1.Text = querryParameters.minimum_est_length.ToString();
P_MAX1.Text = querryParameters.maximum_est_length.ToString();
}
}
else
{
P_EPT1.Text = "No";
P_MINL.Style.Add(HtmlTextWriterStyle.Color, "gray");
P_MAXL.Style.Add(HtmlTextWriterStyle.Color, "gray");
}
if (querryParameters.ptm_allow == 1)
{
P_PTM1.Text = "Yes";
P_NOS1.Text =
(querryParameters.ptm_code_fix.Count + querryParameters.ptm_code_var.Count).ToString();
P_PTMT1.Text = querryParameters.ptm_tolerance.ToString();
P_NOSL.Style.Add(HtmlTextWriterStyle.Color, "black");
}
else
{
P_PTM1.Text = "No";
P_NOSL.Style.Add(HtmlTextWriterStyle.Color, "gray");
P_PTMTL.Style.Add(HtmlTextWriterStyle.Color, "gray");
}
P_MWSW1.Text = querryParameters.MW_sweight.ToString();
P_PSTW1.Text = querryParameters.PST_sweight.ToString();
P_INSW1.Text = querryParameters.Insilico_sweight.ToString();
P_NO1.Text = querryParameters.NumberOfOutputs.ToString();
var results = resultList.result;
var tableRow = new TableRow();
Result_table.Rows.Add(tableRow);
if (results.final_prot != null)
{
for (var index = 0;
(index < results.final_prot.Count) && (index < querryParameters.NumberOfOutputs);
index++)
{
tableRow = new TableRow();
Result_table.Rows.Add(tableRow);
var tableCell = new TableCell();
tableRow.Cells.Add(tableCell);
tableCell.Text = (index + 1).ToString();
tableCell.HorizontalAlign = HorizontalAlign.Center;
tableCell = new TableCell();
tableRow.Cells.Add(tableCell);
tableCell.Text = results.final_prot[index].header;
tableCell.HorizontalAlign = HorizontalAlign.Center;
tableCell = new TableCell();
tableRow.Cells.Add(tableCell);
tableCell.Text = results.final_prot[index].score.ToString();
tableCell.HorizontalAlign = HorizontalAlign.Center;
tableCell = new TableCell();
tableRow.Cells.Add(tableCell);
tableCell.Text = results.final_prot[index].ptm_particulars != null
? results.final_prot[index].ptm_particulars.Count.ToString()
: "0";
tableCell.HorizontalAlign = HorizontalAlign.Center;
var htmlAnchor = new HtmlAnchor
{
ClientIDMode = ClientIDMode.Static,
InnerHtml = "[Details]",
HRef = "~/Detailed_Results.aspx?ID=" + index + "z" + fileId,
Target = "_blank"
};
tableCell = new TableCell();
tableCell.Controls.Add(htmlAnchor);
tableCell.HorizontalAlign = HorizontalAlign.Center;
tableRow.Cells.Add(tableCell);
if (index % 2 == 0)
{
tableRow.CssClass = "active";
}
}
}
}
}
catch
{
Response.Redirect("~/Account/Login", false);
}
}
