public static string HE(string s) { return System.Web.HttpUtility.HtmlEncode(s); } public static string HD(string s) { return System.Web.HttpUtility.HtmlDecode(s); } public static string ReplaceBlankToIllegalCharInFileName(string Statusname) { string FileName = Statusname; string[] chars = System.Configuration.ConfigurationManager.AppSettings.Get("FileNameReplaceChar").Split(','); foreach (string illchar in chars) { FileName = FileName.Replace(illchar,""); } if (string.IsNullOrEmpty(FileName)) FileName = ""; return FileName; } Action in controller to insert data : public ActionResult CreateGetData(GetDataMasterModel GetData, int? DataID) { if (DataID == null) { try { if (db.Getdata.Where(p => p.URL == GetData.URL && p.CategoryId == GetData.CategoryId && p.XNode == GetData.XNode).Count() > 0) { ViewBag.msg = "Record already exist"; } else { string Url = GetData.URL; HtmlWeb web = new HtmlWeb(); HtmlDocument doc = web.Load(Url); var scoreNodes = doc.DocumentNode.SelectNodes(GetData.XNode); foreach (var scoreNode in scoreNodes) { string Statusname = scoreNode.InnerText.ToString(); if (!string.IsNullOrEmpty(Statusname)) { string Encoding = HE(Statusname); StatusMasterModel objStatusMaster = new StatusMasterModel(); objStatusMaster.CategoryId = GetData.CategoryId; objStatusMaster.StatusName = ReplaceBlankToIllegalCharInFileName(Encoding); objStatusMaster.IsActive = true; objStatusMaster.IsDeleted = true; objStatusMaster.CreatedBy = 1; objStatusMaster.UpdatedBy = 1; objStatusMaster.CreatedDate = DateTime.Now; objStatusMaster.UpdatedDate = DateTime.Now; Response.Charset = "utf-8"; db.Status.Add(objStatusMaster); db.SaveChanges(); } // Response.Write(scoreNode.InnerText.ToString() + "<br>"); } GetData.CreatedBy = 1; Dataser.AddGetdata(GetData); ViewBag.msg = "Insert Successfull"; ModelState.Clear(); return RedirectToAction("GetDataList"); } } catch (Exception ex) { ViewBag.msg = ex.ToString(); } return RedirectToAction("CreateGetData"); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)