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
{
}
}
