Exemplo n.º 1
0
        //
        // GET: /Logs/
        public ActionResult Index()
        {
            OSMLogsContext context = new OSMLogsContext();

            DeleteYesterday(context);

            return(View(context.LogsItem.ToList()));
        }
Exemplo n.º 2
0
        public void DeleteYesterday(OSMLogsContext context)
        {
            DateTime       dtNow = DateTime.Now.AddDays(-1);
            List <OSMLogs> items = (from c in context.LogsItem
                                    where c.When < dtNow
                                    select c).ToList();

            for (int i = 0; i < items.Count; i++)
            {
                context.Entry(items[i]).State = System.Data.EntityState.Deleted;
            }

            context.SaveChanges();
        }