How to read data from html file and save in data base

 GetDataModel.cs file As Model

 

public class GetDataModel
{
public int Id { get; set; }
public string Name { get; set; }
public string Res { get; set; }
public string Tel { get; set; }
public string Ch { get; set; }
public string Off { get; set; }
public string Res_Off { get; set; }
public string Email { get; set; }
public string Mobile { get; set; }
public string EnrolmentNoofBarCouncil { get; set; }
public string DHCBAMembershipNo { get; set; }
public string Fax { get; set; }
}

 

 

 // Using this code in action ........................

 

 

GetDataModel model2 = new GetDataModel();
//string path = HttpContext.Server.MapPath("~/HtmlFiles/A1.htm");
// string path = HttpContext.Server.MapPath("~/HtmlFiles/B.htm");
string directoryPath = HttpContext.Server.MapPath("~/HtmlFiles");
string[] fileEntries = Directory.GetFiles(directoryPath);
//get the page
foreach (var fileName in fileEntries)
{
var web = new HtmlWeb();
var document = web.Load(fileName);
var page = document.DocumentNode;
var count = page.QuerySelectorAll("span").Count();
var htmlArray = page.QuerySelectorAll("span").ToArray();
for (int i = 0; i < count; i++)
{
var item = htmlArray[i];
if (item.InnerText!="" && item.FirstChild.Name != "img" && item.FirstChild.Name != "hr")
{


if (item.Attributes["class"].Value != "ft1" && item.Attributes["class"].Value != "ft2" && item.Attributes["class"].Value != "ft3")
{
if (item.Attributes["class"].Value == "ft0" && item.InnerText != " ")
{
int value;

if (int.TryParse(item.InnerText, out value))
{
var id = Convert.ToInt32(item.InnerText);
model2.Id = id;
}
else
{
var Name = item.InnerText;
if (Name != "Name & Address")
model2.Name = Name.Trim();
}
}



if (item.Attributes["class"].Value == "ft4" && item.InnerText != " ")
{
if (item.InnerText == "Res:")
{
string Res = htmlArray[i + 1].InnerHtml.Contains(":") ? htmlArray[i - 1].InnerHtml : htmlArray[i + 1].InnerHtml;
if (!htmlArray[i + 2].InnerHtml.Contains("skype_c2c_print_container notranslate"))
Res = Res + (htmlArray[i + 2].InnerHtml.Contains(":") ? "" : htmlArray[i + 2].InnerHtml);
int value;
if (!int.TryParse(htmlArray[i + 3].InnerText, out value) && !htmlArray[i + 3].InnerHtml.Contains("skype_c2c_print_container notranslate") && !(htmlArray[i + 2].InnerHtml.Contains(":")))
Res = Res + (htmlArray[i + 3].InnerHtml.Contains(":") ? "" : htmlArray[i + 3].InnerHtml);

model2.Res = Res.Trim();
}
if (item.InnerText == "Ch:")
{
string CH = htmlArray[i + 1].InnerHtml.Contains(":") ? htmlArray[i - 1].InnerHtml : htmlArray[i + 1].InnerHtml;
CH = CH + (htmlArray[i + 2].InnerHtml.Contains(":") ? "" : htmlArray[i + 2].InnerHtml);
if (!(htmlArray[i + 2].InnerHtml.Contains(":")))
CH = CH + (htmlArray[i + 3].InnerHtml.Contains(":") ? "" : htmlArray[i + 3].InnerHtml);
model2.Ch = CH.Trim();
}

if (item.InnerText.Trim() == "Res/Off.:")
{
string Res_Off =string.Empty;//htmlArray[i + 1].InnerHtml.Contains(":") ? htmlArray[i - 1].InnerHtml.Contains(":")?"":htmlArray[i - 2].InnerHtml.Contains(":") ? htmlArray[i - 1].InnerHtml :htmlArray[i - 3].InnerHtml.Contains(":")?htmlArray[i - 2].InnerHtml+""+htmlArray[i - 1].InnerHtml:"" : htmlArray[i + 1].InnerHtml;
if (htmlArray[i - 3].Attributes["class"].Value!="ft0")
Res_Off = Res_Off + htmlArray[i - 3].InnerText;
if (htmlArray[i - 2].Attributes["class"].Value != "ft0")
Res_Off =Res_Off+htmlArray[i - 2].InnerText;
if (htmlArray[i - 1].Attributes["class"].Value != "ft0")
Res_Off = Res_Off + htmlArray[i - 1].InnerText;
// Res_Off = Res_Off + (htmlArray[i + 2].InnerHtml.Contains(":") ? "" : htmlArray[i + 2].InnerHtml);
//if (!(htmlArray[i + 2].InnerHtml.Contains(":")))
// Res_Off = Res_Off + (htmlArray[i + 3].InnerHtml.Contains(":") ? "" : htmlArray[i + 3].InnerHtml);
model2.Res_Off = Res_Off.Trim();
}
if (item.InnerText == "Tel:")
{
string Tel = htmlArray[i + 1].InnerHtml.Contains(":") ? htmlArray[i - 1].InnerHtml : htmlArray[i + 1].InnerHtml;

if (Tel.Contains("skype_c2c_print_container notranslate"))
{

string html="";
var vals = Tel.Substring(html.Length+1,12);
model2.Tel = model2.Tel + vals + ",";
}

if (!Tel.Contains("skype_c2c_print_container notranslate") && Tel.Contains(","))
{
string []telArr = Tel.Split(',');
int value;
model2.Tel = model2.Tel+(int.TryParse(telArr[0], out value) ? int.TryParse(telArr[0], out value) ? Tel : "" : "") + ",";
}
else
if (!Tel.Contains("skype_c2c_print_container notranslate") && Tel.Contains("/"))
{
string[] telArr = Tel.Split('/');
int value;
model2.Tel = model2.Tel + (int.TryParse(telArr[0], out value) ? int.TryParse(telArr[0], out value) ? Tel : "" : "") + ",";
}
else
{
int value;
model2.Tel = model2.Tel+(int.TryParse(Tel, out value) ? Tel : "")+",";
}
// model2.Tel =model2.Tel+ Tel+",";
}
if (item.InnerText == "Fax:")
{
model2.Fax = htmlArray[i + 1].InnerText;
}

if (item.InnerText == "Off:")
{
string Off = htmlArray[i + 1].InnerHtml.Contains(":") ? htmlArray[i - 1].InnerHtml : htmlArray[i + 1].InnerHtml;
if (!htmlArray[i + 2].InnerHtml.Contains("skype_c2c_print_container notranslate") && !(htmlArray[i + 1].InnerHtml.Contains(":")))
Off = Off + (htmlArray[i + 2].InnerHtml.Contains(":") ? "" : htmlArray[i + 2].InnerHtml);
if (!htmlArray[i + 3].InnerHtml.Contains("skype_c2c_print_container notranslate") && !(htmlArray[i + 2].InnerHtml.Contains(":")))
Off = Off + (htmlArray[i + 3].InnerHtml.Contains(":") ? "" : htmlArray[i + 3].InnerHtml);

model2.Off = Off.Trim();
}

if (item.InnerText.Contains("E-mail:"))
{
string Email = htmlArray[i].InnerText.Replace("E-mail:","").Trim();
model2.Email = Email;
}
if (item.InnerText.Contains("Mobile:"))
{
string Mobile = htmlArray[i].InnerHtml.Replace("Mobile:","").Trim();
model2.Mobile = Mobile.Trim();
}

if (item.InnerText.Contains("Enrolment No.of Bar Council:"))
{
string EnrolmentNoofBarCouncil = htmlArray[i].InnerText.Replace("Enrolment No.of Bar Council:","").Trim();
model2.EnrolmentNoofBarCouncil = EnrolmentNoofBarCouncil.Trim();
}
if (item.InnerText.Contains("D.H.C.B.A. Membership No.:"))
{
string DHCBAMembershipNo = htmlArray[i].InnerText.Replace("D.H.C.B.A. Membership No.:","").Trim();
model2.DHCBAMembershipNo = DHCBAMembershipNo.Trim();
if (model2.Tel!=null && model2.Tel.Length > 1)
model2.Tel = model2.Tel.Substring(0, model2.Tel.Length - 1).Trim();
if (model2.Tel!=null && model2.Tel!="" && model2.Tel.ToCharArray()[0] == ',')
{
model2.Tel = model2.Tel.Length==1?"": model2.Tel.Substring(1, model2.Tel.Length-1);
}

if (model2.Tel != null && model2.Tel != "" && model2.Tel.ToCharArray()[model2.Tel.Length-1] == ',')
{
model2.Tel = model2.Tel.Length == 1 ? "" : model2.Tel.Substring(0, model2.Tel.Length - 1);
}
ListModel.Add(model2);
model2 = ModelEmpty(model2);

}

}


}
}

}
}

 

/// Save data in data base.............................

 

 

 

private GetDataModel ModelEmpty(GetDataModel model)
{
ShowData data = new ShowData();
data.SRNO = model.Id;
if (model.Name != null)
data.Name = model.Name;
if (model.Res != null)
data.Res = model.Res;
if (model.Tel != null)
data.Tel = model.Tel;
if (model.Ch != null)
data.Ch = model.Ch;
if (model.Res_Off != null)
data.Res_Off = model.Res_Off;
if (model.Off != null)
data.Off_Address = model.Off;
if (model.Email != null)
data.Email = model.Email;
if (model.Mobile != null)
data.Mobile = model.Mobile;
if (model.EnrolmentNoofBarCouncil != null)
data.EnrolmentNoofBarCouncil = model.EnrolmentNoofBarCouncil;
if (model.DHCBAMembershipNo != null)
data.DHCBAMembershipNo = model.DHCBAMembershipNo;
if (model.Fax != null)
data.Fax = model.Fax;

db.ShowDatas.Add(data);
db.SaveChanges();
model.Id = 0;
model.Name = "";
model.Mobile = "";
model.Off = "";
model.Res_Off = "";
model.Res = "";
model.Tel = "";
model.Fax = "";
model.Email = "";
model.DHCBAMembershipNo = "";
model.EnrolmentNoofBarCouncil = "";
model.Ch = "";
return model;

}