public int Count(string search, out int totalrecord)
{
using (var entities = new news_crawlEntities1())
{
totalrecord = entities.session_smcc.Count();
return(entities.session_smcc
.Where(p => search == null ||
p.session.ToLower().Contains(search)).Count());
}
}
public String add(session_smcc config)
{
try
{
using (var entities = new news_crawlEntities1())
{
entities.session_smcc.Add(config);
entities.SaveChanges();
return("Thêm Domain thành công");
}
}
catch (Exception)
{
return("Thêm Domain thất bại");
}
}
public bool delete(int id)
{
try
{
using (var entities = new news_crawlEntities1())
{
var config = entities.session_smcc.Find(id);
if (config != null)
{
entities.session_smcc.Remove(config);
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
}
public Boolean edit(session_smcc session)
{
try
{
using (var entities = new news_crawlEntities1())
{
session_smcc sessiontmp = entities.session_smcc.Find(session.Id);
if (sessiontmp != null && session != null)
{
sessiontmp.session = session.session;
entities.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
}
public List <session_smcc> GetResult(DTOrder sort, int start, int length, string search)
{
using (var entities = new news_crawlEntities1())
{
search = search.ToLower();
var configs = from c in entities.session_smcc
where
(c.Id.ToString().Contains(search) ||
c.session.ToString().Contains(search))
select c;
if (sort.Column == 0 && sort.Dir == DTOrderDir.ASC)
{
return(configs.OrderBy(s => s.Id).Skip(start).Take(length).ToList());
}
else if (sort.Column == 0 && sort.Dir == DTOrderDir.DESC)
{
return(configs.OrderByDescending(s => s.Id).Skip(start).Take(length).ToList());
}
else if (sort.Column == 1 && sort.Dir == DTOrderDir.ASC)
{
return(configs.OrderBy(s => s.session).Skip(start).Take(length).ToList());
}
else if (sort.Column == 1 && sort.Dir == DTOrderDir.DESC)
{
return(configs.OrderByDescending(s => s.session).Skip(start).Take(length).ToList());
}
else if (sort.Column == 2 && sort.Dir == DTOrderDir.ASC)
{
return(configs.OrderBy(s => s.status).Skip(start).Take(length).ToList());
}
else
{
return(configs.OrderByDescending(s => s.status).Skip(start).Take(length).ToList());
}
}
}
