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()); } } }