Ejemplo n.º 1
0
        public static List<ToDoView> GetToDoPage(int pageDim, out int totalPages, ref List<KeyValuePair<LambdaExpression, OrderType>> order, int page = 1,
            System.Linq.Expressions.Expression<Func<ToDoView, bool>> filter=null)
        {
            List<ToDoView> result;
            if (order == null)
            {
                order = new List<KeyValuePair<LambdaExpression, OrderType>>();

            }
            if (order.Count == 0)//paging require ordering! Therefore we always need to add a default oredering
            {
                Expression<Func<ToDoView, DateTime>> defaultOrder = m => m.DueDate;

                order.Add(new KeyValuePair<LambdaExpression, OrderType>(defaultOrder, OrderType.Descending));
            }
            using (SiteDbEntities context = new SiteDbEntities())
            {
                int rowCount;
                if (filter == null) rowCount = context.ToDo.Count();
                else rowCount = (from x in context.ToDo select new ToDoView(){Name = x.Name, Description = x.Description, DueDate = x.DueDate, id = x.id}).Where(filter).Count();
                if (rowCount == 0)
                {
                    totalPages=0;
                    return new List<ToDoView>();
                }
                totalPages = rowCount / pageDim;
                if (rowCount % pageDim > 0) totalPages++;
                if (page > totalPages) page = totalPages;
                if (page < 1) page = 1;
                int toSkip = (page-1) * pageDim;

                if (filter == null)
                {
                    result = context.ToDo.Select(item =>
                        new ToDoView() { Name = item.Name, Description = item.Description, DueDate = item.DueDate, id = item.id }).ApplyOrder(order)
                        .Skip(toSkip).Take(pageDim).ToList();
                }
                else
                {
                    result = context.ToDo.Select(item =>
                        new ToDoView() { Name = item.Name, Description = item.Description, DueDate = item.DueDate, id = item.id }).Where(filter).ApplyOrder(order)
                        .Skip(toSkip).Take(pageDim).ToList();
                }

            }
            return result;
        }
Ejemplo n.º 2
0
        public static int[] UpdatePage(List<ToDoView> itemsI, List<ToDoView> itemsM, List<int> toDelete)
        {
            if (itemsM == null && itemsI == null && toDelete == null) return new int[0];
            List<ToDo> inserted = new List<ToDo>();
            using (SiteDbEntities context = new SiteDbEntities())
            {
                bool aChange = false;
                if (itemsI != null)
                {
                    foreach (ToDoView item in itemsI)
                    {
                        ToDo curr = new ToDo() { Name = item.Name, Description = item.Description, DueDate = item.DueDate };
                        aChange = true;
                        context.ToDo.AddObject(curr);
                        inserted.Add(curr);
                    }
                }
                if (itemsM != null)
                {
                    foreach (ToDoView item in itemsM)
                    {
                        ToDo curr = new ToDo() { Name = item.Name, Description = item.Description, DueDate = item.DueDate, id = item.id.Value };
                        context.ToDo.Attach(curr);
                        context.ObjectStateManager.ChangeObjectState(curr, System.Data.EntityState.Modified);
                        aChange = true;
                    }
                }
                if (toDelete != null)
                {
                    foreach (int key in toDelete)
                    {
                        ToDo curr = new ToDo() { id = key };
                        context.ToDo.Attach(curr);
                        context.ObjectStateManager.ChangeObjectState(curr, System.Data.EntityState.Deleted);
                        aChange = true;
                    }
                }
                if (aChange)
                {
                    try
                    {
                        context.SaveChanges();

                    }
                    catch
                    {
                    }
                    return inserted.Select(m => m.id).ToArray();
                }
                else return new int[0];
            }
        }
Ejemplo n.º 3
0
 public static IQueryable<ToDoView> GetToDoQueryable()
 {
     SiteDbEntities context = new SiteDbEntities();
     return context.ToDo.Include("SubTasks").Select(item =>
                 new ToDoView()
                 {
                     Name = item.Name,
                     Description = item.Description,
                     DueDate = item.DueDate,
                     id = item.id,
                     Tasks = item.SubTasks.Select(x => new SubTasksView { Name = x.Name, WorkingDays = x.WorkingDays, Key = x.code, FatherId = x.idTask })
                 });
 }
Ejemplo n.º 4
0
        public static int[] UpdatePageTasks(List<SubTasksView> itemsI, List<SubTasksView> itemsM, List<int> toDelete)
        {
            if (itemsM == null && itemsI == null && toDelete == null) return new int[0];
            List<SubTasks> inserted = new List<SubTasks>();
            using (SiteDbEntities context = new SiteDbEntities())
            {
                bool aChange = false;
                if (itemsI != null)
                {
                    foreach (SubTasksView item in itemsI)
                    {
                        SubTasks curr = new SubTasks() { Name = item.Name, idTask = item.FatherId.Value, WorkingDays = item.WorkingDays };
                        aChange = true;
                        context.SubTasks.AddObject(curr);
                        inserted.Add(curr);
                    }
                }
                if (itemsM != null)
                {
                    foreach (SubTasksView item in itemsM)
                    {
                        SubTasks curr = new SubTasks() { Name = item.Name, code = item.Key.Value, idTask=item.FatherId.Value, WorkingDays=item.WorkingDays};
                        context.SubTasks.Attach(curr);
                        context.ObjectStateManager.ChangeObjectState(curr, System.Data.EntityState.Modified);
                        aChange = true;
                    }
                }
                if (toDelete != null)
                {
                    foreach (int key in toDelete)
                    {
                        SubTasks curr = new SubTasks() { code = key };
                        context.SubTasks.Attach(curr);
                        context.ObjectStateManager.ChangeObjectState(curr, System.Data.EntityState.Deleted);
                        aChange = true;
                    }
                }
                if (aChange)
                {
                    try
                    {
                        context.SaveChanges();

                    }
                    catch
                    {
                    }
                    return inserted.Select(m => m.code).ToArray();
                }
                else return new int[0];
            }
        }
Ejemplo n.º 5
0
 public static IQueryable<ToDoView> GetToDoQueryable()
 {
     SiteDbEntities context = new SiteDbEntities();
     return context.ToDo.Select(item =>
                 new ToDoView() { Name = item.Name, Description = item.Description, DueDate = item.DueDate, id = item.id });
 }