private void SaveTabir(string WordName, string TabirUrl)
{
ReqUtils Reqs = new ReqUtils();
TabirUrl = TabirUrl.Replace("\" target=\"_blank", "");
string Result = Reqs.GetHTML(TabirUrl, System.Text.Encoding.UTF8);
string _pattern = @" class=""contentpaneopen_text"">\s*(.*?)</div>";
Regex r = new Regex(_pattern, RegexOptions.IgnoreCase | RegexOptions.Singleline);
Match m = r.Match(Result);
if (m.Success)
{
string Meaning = m.Groups[1].Captures[0].ToString();
Meaning = Reqs.RemoveTags(Meaning);
TabirDataContext dc = new TabirDataContext();
Parsetv91._1.Code.DAL.Tabir NewRecord = new Code.DAL.Tabir();
dc.Tabirs.InsertOnSubmit(NewRecord);
NewRecord.WordName = WordName;
NewRecord.Meaning = Meaning;
NewRecord.ID = MainCounter.ToString();
MainCounter++;
dc.SubmitChanges();
}
}
private void DeleteTabir(int Code)
{
TabirDataContext dc = new TabirDataContext();
Parsetv91._1.Code.DAL.Tabir CurRecord = dc.Tabirs.Single(p => p.Code.Equals(Code));
dc.Tabirs.DeleteOnSubmit(CurRecord);
dc.SubmitChanges();
}
protected void btnCorrectYa_Click(object sender, EventArgs e)
{
int Counter = 0;
TabirDataContext dc = new TabirDataContext();
var Result = dc.Tabirs;
foreach (var item in Result)
{
string CurWordName = item.WordName;
CurWordName = Tools.PersianTextCorrection(CurWordName);
item.WordName = CurWordName;
Counter++;
}
dc.SubmitChanges();
lblMessage.Text = Counter + " words corrected";
}
protected void btnRemoveDuplicates_Click(object sender, EventArgs e)
{
int Counter = 0;
TabirDataContext dc = new TabirDataContext();
var Result = dc.Tabirs.OrderBy(p => p.WordName);
foreach (var item in Result)
{
string CurWordName = item.WordName;
if (GetTabirCount(CurWordName) > 1)
{
//DeleteTabir(item.Code);
dc.Tabirs.DeleteOnSubmit(item);
}
Counter++;
}
dc.SubmitChanges();
lblMessage.Text = Counter + " words corrected";
}
private int GetTabirCount(string CurWordName)
{
TabirDataContext dc = new TabirDataContext();
return(dc.Tabirs.Where(p => p.WordName.Equals(CurWordName)).Count());
}
