private void dgvDrugList_SelectionChanged(object sender, EventArgs e)
{
cmdSearch.Enabled = false;
dgvDrugList.Visible = false;
string id = string.Empty;
Int32 WID = 0;
foreach (DataGridViewRow row in dgvDrugList.SelectedRows)
{
id = row.Cells[0].Value.ToString();
WID = Convert.ToInt32(row.Cells[1].Value.ToString());
}
DrugbankdruginteractionQuery dbdiQ = new DrugbankdruginteractionQuery("a");
DrugbankQuery dbQ = new DrugbankQuery("b");
dbdiQ.Select(dbdiQ.DrugbankWid, dbdiQ.Drug, dbdiQ.Description, dbQ.Name.As("Names"));
dbdiQ.InnerJoin(dbQ).On(dbdiQ.Drug == dbQ.WID);
dbdiQ.Where(dbdiQ.DrugbankWid == WID);
dbdiQ.OrderBy(dbQ.Name.Ascending);
DataTable dtDI = dbdiQ.LoadDataTable();
//dtDI.Columns.Add(new DataColumn("Deskripsi", typeof(string)));
//if (dtDI.Rows.Count > 0)
//{
// //foreach (DataRow dr in dtDI.Rows)
// //{
// // Translator t = new Translator();
// // dr["Deskripsi"] = t.Translate(dr["Description"].ToString().Trim(), Language.English, Language.Indonesian);
// //}
// for (int i = 0; i < dtDI.Rows.Count; i++)
// {
// Translator t = new Translator();
// dtDI.Rows[i]["Deskripsi"] = t.Translate(dtDI.Rows[i]["Description"].ToString().Trim(), "English", "Indonesian");
// dtDI.AcceptChanges();
// }
//}
dtDI.Columns.Remove("DrugBank_WID");
dtDI.Columns.Remove("Drug");
//dtDI.Columns.Remove("Description");
dgvDrugInteraction.DataSource = dtDI;
// ===================||====================
//for Drug Information TabPage
DrugbankQuery DBQ = new DrugbankQuery("a");
DBQ.SelectAll().Where(DBQ.WID == WID && DBQ.Id == id);
DataTable dtDB = DBQ.LoadDataTable();
int counter = 0;
if (dtDB.Rows.Count > 0)
{
rtbDrugInfo.Text = string.Empty;
foreach (DataRow drDB in dtDB.Rows)
{
counter++;
foreach (DataColumn dcDB in dtDB.Columns)
{
rtbDrugInfo.Text = rtbDrugInfo.Text + dcDB.ColumnName + " : ";
rtbDrugInfo.Text = rtbDrugInfo.Text + Environment.NewLine;
rtbDrugInfo.Text = rtbDrugInfo.Text + "---------------------";
rtbDrugInfo.Text = rtbDrugInfo.Text + Environment.NewLine;
rtbDrugInfo.Text = rtbDrugInfo.Text + drDB[dcDB].ToString();
rtbDrugInfo.Text = rtbDrugInfo.Text + Environment.NewLine;
rtbDrugInfo.Text = rtbDrugInfo.Text + "_______________________________________________________________________________________________________________________________________";
rtbDrugInfo.Text = rtbDrugInfo.Text + Environment.NewLine;
}
if (counter >= 1)
continue;
}
}
//
cmdSearch.Enabled = true;
dgvDrugList.Visible = true;
}
private void fillDrugGridView(string txtDrug)
{
if (string.IsNullOrEmpty(txtDrug))
{ }
else
{
dgvDrugList.DataSource = null;
DrugbankQuery dbQ = new DrugbankQuery("a");
dbQ.Select(dbQ.Id,dbQ.WID ,dbQ.Name.As("DrugName"));
dbQ.Where(dbQ.Id.Like("%" + txtDrug + "%") || dbQ.Name.Like("%" + txtDrug + "%"));
//DrugbankCollection dbC = new DrugbankCollection();
//dbC.Load(dbQ);
//var item = lvDrugList.Items;
//if (dbC.Count > 0)
//{
// foreach (Drugbank db in dbC)
// {
// item.Add(db.Name);
// }
//}
dgvDrugList.DataSource = dbQ.LoadDataTable();
}
}
