public ActionResult getAndSaveData(string inputURL) { viecLamEntities db = new viecLamEntities(); if (inputURL == "") { ViewBag.ThongBao = "Bạn cần phải nhập URL để lấy dữ liệu"; } else { try { List <dataRecord> list = new List <dataRecord>(); list = querySelection(inputURL); for (int i = 0; i < list.Count; i++) { infomationWork work = new infomationWork(); work.nameWork = list[i].name.ToString(); work.nameCompany = list[i].nameCompany.ToString(); work.href = list[i].href.ToString(); work.salary = list[i].salary.ToString(); work.country = list[i].country.ToString(); work.date = list[i].date.ToString(); db.infomationWork.Add(work); db.SaveChanges(); } ViewBag.ThongBao = "Thanh Cong"; } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } return(View()); }
public ActionResult showData(String inputSearch) { viecLamEntities db = new viecLamEntities(); if (inputSearch != null) { ViewBag.tuKhoaTimKiem = "Từ Khóa Tìm Kiếm: " + inputSearch; return(View(db.infomationWork.Where(x => x.nameWork.StartsWith(inputSearch)))); } List <infomationWork> list = db.infomationWork.ToList(); return(View(list)); }