public bool insertdises(dises_Description_tbl obj)
{
try
{
if (!string.IsNullOrEmpty(obj.code_dec))
{
db.dises_Description_tbl.Add(obj);
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
throw;
}
}
private dises_Description_tbl GetData3(string Link, int FK)
{
try
{
Link = "https://icd.codes" + Link;
webBrowser1.Url = new Uri(Link);
WebClient client = new WebClient();
string content = client.DownloadString(Link);
HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument();
doc.LoadHtml(content);
var n2 = doc.DocumentNode.SelectNodes(xpath: "//div[@id='content']/div[@class='well']/div[@class='row']/div[@class='col-md-8']/p");
dises_Description_tbl thirdobj = new dises_Description_tbl();
if (n2 != null)
{
//DataTable dt = new DataTable();
//dt.Columns.Add("Descraption");
//dt.Columns.Add("code_dec");
//dt.Columns.Add("Specialty");
//dt.Columns.Add("MeSH_Codes");
//dt.Columns.Add("ICD9Codes");
//dt.Columns.Add("img");
//HtmlNode Descraption = n2.FirstOrDefault().SelectSingleNode("//p");
HtmlNode Descraption = doc.DocumentNode.SelectNodes(xpath: "//div[@id='content']/div[@class='well']/div[@class='row']/div[@class='col-md-8']/p")[0];
HtmlNode code_dec = doc.DocumentNode.SelectNodes(xpath: "//div[@id='content']/div[@class='well']/h3")[0];
HtmlNode img = doc.DocumentNode.
SelectNodes(xpath: "//div[@id='content']/div[@class='well']/div[@class='row']/div[@class='col-md-4 text-right']/img")[0];
HtmlNodeCollection table = doc.DocumentNode.
SelectNodes(xpath: "//div[@id='content']/div[@class='well']/div[@class='row']/div[@class='col-md-8']/table/tr");
string Specialty = "", MeSH_Codes = "", ICD9Codes = "";
if (table != null)
{
HtmlNodeCollection tr1 = table[0].SelectNodes("//td");
Specialty = tr1 != null && tr1.Count >= 5 ? tr1[1].InnerText : "";
MeSH_Codes = tr1 != null && tr1.Count >= 5 ? tr1[3].InnerText : "";
ICD9Codes = tr1 != null && tr1.Count >= 5 ? tr1[5].InnerText : "";
}
thirdobj = new dises_Description_tbl()
{
Descraption = Descraption == null ? "" : Descraption.InnerText,
code_dec = code_dec == null ? "" : code_dec.InnerText,
Specialty = Specialty,
ICD9Codes = ICD9Codes,
MeSH_Codes = MeSH_Codes,
img = img.Attributes["src"] == null ? "" : img.Attributes["src"].Value.ToString(),
details_fk = FK
};
}
return(thirdobj);
}
catch (Exception ex)
{
throw;
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (webBrowser1.Url != null)
{
using (MedicalDBEntities db = new MedicalDBEntities())
{
List <Chabter1_Tbl> List = GetData();
bool result = new Home().insertChabter(List);
if (result)
{
foreach (var item in List)
{
List <Section_Tbl> obj = GetData(item.link_data, item.ID);
bool result2 = new Home().insertSection(obj);
foreach (var item2 in obj)
{
List <Notes_Tbl> notes1 = GetData6(item2.link_data, item2.ID, 2);
new Home().insertnotse1(notes1);
List <Diseases_Tbl> dises = GetData4(item2.link_data, item2.ID);
bool result3 = new Home().insertDiseases(dises);
if (result3)
{
foreach (var item3 in dises)
{
foreach (var item4 in item3.Diseases_destails_tbl)
{
dises_Description_tbl _dises_Description = GetData3(item4.Link_data, item4.ID);
new Home().insertdises(_dises_Description);
}
}
}
}
List <Notes_Tbl> note = GetData6(item.link_data, item.ID, 1);
new Home().insertnotse(note);
}
}
//foreach (var item4 in item6)
//{
// Notes_Tbl _dises_Description = GetData6();
// new Home().insertnotse();
//}
//List<Section_Tbl> obj = GetData();
//bool list1 = new Home().insertSection(obj);
//for (int i = 0; i < List.Count; i++)
//{
// Chabter1_Tbl obj = new Chabter1_Tbl()
// {
// CodeRange_from = List.Rows[i][0].ToString(),
// CodeRange_To = List.Rows[i][1].ToString(),
// SectionDescription = List.Rows[i][2].ToString(),
// link_data = List.Rows[i][3].ToString()
// };
// int result = new Home().insertChabter(obj);
// if (result > 0)
// {
// DataTable notestbl1 = GetData6(obj.link_data);
// foreach (DataRow detailsitem in notestbl1.Rows)
// {
// // insert chapter notes
// Notes_Tbl notes5 = new Notes_Tbl()
// {
// Notes = detailsitem[0].ToString(),
// Table_FK = result,
// Fk_type = 1
// };
// int notes1 = new Home().insertnotse(notes5);
// }
// DataTable secoundtable = GetData(obj.link_data);
// foreach (DataRow item in secoundtable.Rows)
// {
// Section_Tbl secoundobj = new Section_Tbl()
// {
// Code_from = item[0].ToString(),
// Code_to = item[1].ToString(),
// Name = item[2].ToString(),
// link_data = item[3].ToString(),
// Chabter1_fk = result
// };
// int secondresult = new Home().insertSection(secoundobj);
// DataTable notestbl12 = GetData6(secoundobj.link_data);
// foreach (DataRow detailsitem in notestbl1.Rows)
// {
// // insert chapter notes
// Notes_Tbl notes5 = new Notes_Tbl()
// {
// Notes = detailsitem[1].ToString(),
// Table_FK = secondresult,
// Fk_type = 2
// };
// int notes1 = new Home().insertnotse(notes5);
// }
// DataTable desis = GetData4(item[3].ToString());
// foreach (DataRow desisitem in desis.Rows)
// {
// Diseases_Tbl thirdTable = new Diseases_Tbl()
// {
// Code = desisitem[0].ToString(),
// Name = desisitem[1].ToString(),
// Section_Fk = secondresult
// };
// int thirdResult = new Home().insertDiseases(thirdTable);
// DataTable details = GetData5(desisitem[2].ToString());
// foreach (DataRow detailsitem in details.Rows)
// {
// Diseases_destails_tbl fourthtable = new Diseases_destails_tbl()
// {
// Name = detailsitem[0].ToString(),
// Code = detailsitem[1].ToString(),
// Link_data = detailsitem[2].ToString(),
// Diseases_fk = thirdResult
// };
// int fourthResult = new Home().insertDiseases_destails(fourthtable);
// if (fourthResult > 0)
// {
// dises_Description_tbl thirdobj = GetData3(fourthtable.Link_data);
// thirdobj.details_fk = fourthResult;
// int descrnote = new Home().insertdises(thirdobj);
// DataTable notestbl7 = GetData7(fourthtable.Link_data);
// foreach (DataRow decrip in notestbl1.Rows)
// {
// // insert chapter notes
// Notes_Tbl notes5 = new Notes_Tbl()
// {
// Notes = detailsitem[1].ToString(),
// Table_FK = secondresult,
// Fk_type = 3
// };
// int notes1 = new Home().insertnotse(notes5);
// }
// }
// }
// }
// };
// }
MessageBox.Show("saved", "info", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
//}
}
}
else
{
MessageBox.Show("Please load the web Page first!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
