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"; }