public SexSpider GetSexSpider(int siteId) { using (var db = new SexSpiderDbContext()) { return(db.SexSpider.Where(s => s.SiteId == siteId).FirstOrDefault()); } }
public void AddSiteList(string jsonHtml) { try { var jsonObject = Newtonsoft.Json.JsonConvert.DeserializeObject <IEnumerable <SexSpider> >(jsonHtml); using (var db = new SexSpiderDbContext()) { db.SexSpider.AddRange(jsonObject); db.SaveChanges(); } } catch (Exception ex) { log.Error(ex.Message); } }
public void AddSiteList(string jsonHtml) { try { var jsonObject = Newtonsoft.Json.JsonConvert.DeserializeObject <List <SiteListViewModel> >(jsonHtml); var models = AutoMapper.Mapper.Map <List <SiteListViewModel>, List <SexSpider> >(jsonObject); using (var db = new SexSpiderDbContext()) { db.SexSpider.AddRange(models); db.SaveChanges(); } } catch { } }
public string GetSiteList() { string html = ""; try { using (var db = new SexSpiderDbContext()) { var sexSpiders = db.SexSpider.OrderBy(s => s.SiteRank).ToList(); html = Newtonsoft.Json.JsonConvert.SerializeObject(sexSpiders, serializerSettings); } } catch (Exception ex) { log.Error(ex.Message); } return(html); }
public void RemoveSiteList(string jsonHtml) { try { var jsonObject = Newtonsoft.Json.JsonConvert.DeserializeObject <IEnumerable <SexSpider> >(jsonHtml); using (var db = new SexSpiderDbContext()) { jsonObject.ToList().ForEach(s => { db.SexSpider.Remove(db.SexSpider.Where(a => a.SiteId == s.SiteId).FirstOrDefault()); db.SaveChanges(); }); } } catch (Exception ex) { log.Error(ex.Message); } }
public void RemoveSiteList(string jsonHtml) { try { var jsonObject = Newtonsoft.Json.JsonConvert.DeserializeObject <List <SiteListViewModel> >(jsonHtml); var models = AutoMapper.Mapper.Map <List <SiteListViewModel>, List <SexSpider> >(jsonObject); using (var db = new SexSpiderDbContext()) { models.ForEach(s => { db.SexSpider.Remove(db.SexSpider.Where(a => a.SiteId == s.SiteId).FirstOrDefault()); db.SaveChanges(); }); } } catch { } }
public void UpdateSiteList(string jsonHtml) { try { var jsonObject = Newtonsoft.Json.JsonConvert.DeserializeObject <IEnumerable <SexSpider> >(jsonHtml); using (var db = new SexSpiderDbContext()) { jsonObject.ToList().ForEach(s => { db.SexSpider.Attach(s); DbEntityEntry <SexSpider> entry = db.Entry(s); entry.State = EntityState.Modified; db.SaveChanges(); }); } } catch (Exception ex) { log.Error(ex.Message); } }
public string GetSiteList() { string html = ""; try { using (var db = new SexSpiderDbContext()) { var sexSpiders = db.SexSpider.OrderBy(s => s.SiteRank).ToList(); var models = AutoMapper.Mapper.Map <List <SexSpider>, List <SiteListViewModel> >(sexSpiders); html = Newtonsoft.Json.JsonConvert.SerializeObject(models); } } catch (Exception ex) { log.Error(ex.Message); } return(html); }
public void UpdateSiteList(string jsonHtml) { try { var jsonObject = Newtonsoft.Json.JsonConvert.DeserializeObject <List <SiteListViewModel> >(jsonHtml); var models = AutoMapper.Mapper.Map <List <SiteListViewModel>, List <SexSpider> >(jsonObject); using (var db = new SexSpiderDbContext()) { models.ForEach(s => { db.SexSpider.Attach(s); DbEntityEntry <SexSpider> entry = db.Entry(s); entry.State = EntityState.Modified; db.SaveChanges(); }); } } catch { } }