Ejemplo n.º 1
0
        private void DataPortal_Delete(ProjectCriteria criteria)
        {
            using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
                             .GetManager(Database.ApplicationConnection, false))
            {
                var data = ctx.ObjectContext.Projects
                           .Single(row => row.ProjectId == criteria.ProjectId);

                ctx.ObjectContext.Projects.DeleteObject(data);

                ctx.ObjectContext.SaveChanges();
            }
        }
Ejemplo n.º 2
0
        private void DataPortal_Fetch(ProjectCriteria criteria)
        {
            using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
                             .GetManager(Database.ApplicationConnection, false))
            {
                IQueryable <Data.Project> query = ctx.ObjectContext.Projects;

                if (criteria.ProjectId != null)
                {
                    query = query.Where(row => row.ProjectId == criteria.ProjectId);
                }

                if (criteria.Name != null)
                {
                    query = query.Where(row => row.Name == criteria.Name);
                }

                var data = query.Single();

                this.Fetch(data);

                this.BusinessRules.CheckRules();
            }
        }
Ejemplo n.º 3
0
        private void DataPortal_Fetch(ProjectCriteria criteria)
        {
            using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
                        .GetManager(Database.ApplicationConnection, false))
            {
                this.RaiseListChangedEvents = false;
                this.IsReadOnly = false;

                IQueryable<Data.Project> query = ctx.ObjectContext.Projects;

                if (criteria.ProjectId != null)
                {
                    query = query.Where(row => row.ProjectId == criteria.ProjectId);
                }

                if (criteria.Name != null)
                {
                    if (criteria.Name.EndsWith("*"))
                    {
                        criteria.Name = criteria.Name.Replace("*", "");
                        query = query.Where(row => row.Name == criteria.Name
                            || row.Name.StartsWith(criteria.Name));
                    }
                    else
                    {
                        query = query.Where(row => row.Name == criteria.Name);
                    }
                }

                if (criteria.Description != null)
                {
                    query = query.Where(row => row.Description == criteria.Description);
                }

                if (criteria.IsActive != null)
                {
                    query = query.Where(row => row.IsActive == criteria.IsActive);
                }

                if (criteria.IsArchived != null)
                {
                    query = query.Where(row => row.IsArchived == criteria.IsArchived);
                }

                if (criteria.Notes != null)
                {
                    query = query.Where(row => row.Notes == criteria.Notes);
                }

                if (criteria.ModifiedBy != null)
                {
                    query = query.Where(row => row.ModifiedBy == criteria.ModifiedBy);
                }

                if (criteria.ModifiedDate.DateFrom.Date != DateTime.MinValue.Date)
                {
                    query = query.Where(row => row.ModifiedDate >= criteria.ModifiedDate.DateFrom);
                }

                if (criteria.ModifiedDate.DateTo.Date != DateTime.MaxValue.Date)
                {
                    query = query.Where(row => row.ModifiedDate <= criteria.ModifiedDate.DateTo);
                }

                if (criteria.CreatedBy != null)
                {
                    query = query.Where(row => row.CreatedBy == criteria.CreatedBy);
                }

                if (criteria.CreatedDate.DateFrom.Date != DateTime.MinValue.Date)
                {
                    query = query.Where(row => row.CreatedDate >= criteria.CreatedDate.DateFrom);
                }

                if (criteria.CreatedDate.DateTo.Date != DateTime.MaxValue.Date)
                {
                    query = query.Where(row => row.CreatedDate <= criteria.CreatedDate.DateTo);
                }

                if (criteria.SortBy != null)
                {
                    query = query.OrderBy(string.Format(
                        "{0} {1}",
                        criteria.SortBy,
                        criteria.SortOrder == ListSortDirection.Ascending ? "ASC" : "DESC"));
                }

                if (criteria.MaximumRecords != null)
                {
                    query = query.Take(criteria.MaximumRecords.Value);
                }

                var data = query.AsEnumerable().Select(ProjectInfo.FetchProjectInfo);

                this.AddRange(data);

                this.IsReadOnly = true;
                this.RaiseListChangedEvents = true;
            }
        }
Ejemplo n.º 4
0
 internal static void DeleteProject(ProjectCriteria criteria)
 {
     Csla.DataPortal.Delete <Project>(criteria);
 }
Ejemplo n.º 5
0
 internal static Project FetchProject(ProjectCriteria criteria)
 {
     return(Csla.DataPortal.Fetch <Project>(criteria));
 }
Ejemplo n.º 6
0
        public ActionResult Index(int? isActive, int? isArchived, string sortBy, string sortOrder)
        {
            var model = new ProjectIndexModel();

            model.Tab = "Project";

            model.IsActive = isActive ?? -1;
            model.IsArchived = isArchived ?? 0;

            model.SortBy = sortBy ?? "Name";
            model.SortOrder = sortOrder ?? "ASC";
            model.SortableColumns.Add("Name", "Name");

            var criteria = new ProjectCriteria()
            {
                IsActive = DataHelper.ToBoolean(isActive, true),
                IsArchived = DataHelper.ToBoolean(isArchived, false)
            };

            var projects = ProjectService.ProjectFetchInfoList(criteria)
                .AsQueryable();

            projects = projects.OrderBy(string.Format("{0} {1}", model.SortBy, model.SortOrder));

            model.Projects = projects;

            var notes = NoteService.NoteFetchInfoList(
                SourceType.Project,
                projects.Select(project => project.ProjectId).ToArray());

            model.Notes = notes.AsQueryable();

            return this.View(model);
        }
Ejemplo n.º 7
0
 internal static ProjectInfoList FetchProjectInfoList(ProjectCriteria criteria)
 {
     return Csla.DataPortal.Fetch<ProjectInfoList>(criteria);
 }
Ejemplo n.º 8
0
 public static ProjectInfoList ProjectFetchInfoList(ProjectCriteria criteria)
 {
     return ProjectInfoList.FetchProjectInfoList(criteria);
 }
Ejemplo n.º 9
0
 internal static void DeleteProject(ProjectCriteria criteria)
 {
     Csla.DataPortal.Delete<Project>(criteria);
 }
Ejemplo n.º 10
0
        private void DataPortal_Fetch(ProjectCriteria criteria)
        {
            using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
                             .GetManager(Database.ApplicationConnection, false))
            {
                this.RaiseListChangedEvents = false;
                this.IsReadOnly             = false;

                IQueryable <Data.Project> query = ctx.ObjectContext.Projects;

                if (criteria.ProjectId != null)
                {
                    query = query.Where(row => row.ProjectId == criteria.ProjectId);
                }

                if (criteria.Name != null)
                {
                    if (criteria.Name.EndsWith("*"))
                    {
                        criteria.Name = criteria.Name.Replace("*", "");
                        query         = query.Where(row => row.Name == criteria.Name ||
                                                    row.Name.StartsWith(criteria.Name));
                    }
                    else
                    {
                        query = query.Where(row => row.Name == criteria.Name);
                    }
                }

                if (criteria.Description != null)
                {
                    query = query.Where(row => row.Description == criteria.Description);
                }

                if (criteria.IsActive != null)
                {
                    query = query.Where(row => row.IsActive == criteria.IsActive);
                }

                if (criteria.IsArchived != null)
                {
                    query = query.Where(row => row.IsArchived == criteria.IsArchived);
                }

                if (criteria.Notes != null)
                {
                    query = query.Where(row => row.Notes == criteria.Notes);
                }

                if (criteria.ModifiedBy != null)
                {
                    query = query.Where(row => row.ModifiedBy == criteria.ModifiedBy);
                }

                if (criteria.ModifiedDate.DateFrom.Date != DateTime.MinValue.Date)
                {
                    query = query.Where(row => row.ModifiedDate >= criteria.ModifiedDate.DateFrom);
                }

                if (criteria.ModifiedDate.DateTo.Date != DateTime.MaxValue.Date)
                {
                    query = query.Where(row => row.ModifiedDate <= criteria.ModifiedDate.DateTo);
                }

                if (criteria.CreatedBy != null)
                {
                    query = query.Where(row => row.CreatedBy == criteria.CreatedBy);
                }

                if (criteria.CreatedDate.DateFrom.Date != DateTime.MinValue.Date)
                {
                    query = query.Where(row => row.CreatedDate >= criteria.CreatedDate.DateFrom);
                }

                if (criteria.CreatedDate.DateTo.Date != DateTime.MaxValue.Date)
                {
                    query = query.Where(row => row.CreatedDate <= criteria.CreatedDate.DateTo);
                }

                if (criteria.SortBy != null)
                {
                    query = query.OrderBy(string.Format(
                                              "{0} {1}",
                                              criteria.SortBy,
                                              criteria.SortOrder == ListSortDirection.Ascending ? "ASC" : "DESC"));
                }

                if (criteria.MaximumRecords != null)
                {
                    query = query.Take(criteria.MaximumRecords.Value);
                }

                var data = query.AsEnumerable().Select(ProjectInfo.FetchProjectInfo);

                this.AddRange(data);

                this.IsReadOnly             = true;
                this.RaiseListChangedEvents = true;
            }
        }