public void Delete(ProjectDataCriteria criteria) { var data = MockDb.Projects .Where(row => row.ProjectId == criteria.ProjectId) .Single(); MockDb.Projects.Remove(data); }
public static ProjectInfoList ProjectFetchInfoList(ProjectDataCriteria criteria) { // this will ensure that users can only view projects that they are assigned to criteria.UserId = ((IBusinessIdentity)Csla.ApplicationContext.User.Identity).UserId; return(ProjectInfoList.FetchProjectInfoList(criteria)); }
public static ProjectInfoList ProjectFetchInfoList(ProjectDataCriteria criteria) { // this will ensure that users can only view projects that they are assigned to criteria.UserId = ((IBusinessIdentity)Csla.ApplicationContext.User.Identity).UserId; return ProjectInfoList.FetchProjectInfoList(criteria); }
public ProjectData[] FetchLookupInfoList(ProjectDataCriteria criteria) { var query = MockDb.Projects .AsQueryable(); var data = query.AsQueryable(); return(data.ToArray()); }
public ProjectData[] FetchLookupInfoList(ProjectDataCriteria criteria) { var query = MockDb.Projects .AsQueryable(); var data = query.AsQueryable(); return data.ToArray(); }
private void DataPortal_Delete(ProjectDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider <IProjectDataFactory>(); dalFactory.Delete(criteria); } }
public ProjectData Fetch(ProjectDataCriteria criteria) { var data = MockDb.Projects .Where(row => row.ProjectId == criteria.ProjectId) .Single(); data = this.Fetch(data); return(data); }
public ProjectData Fetch(ProjectDataCriteria criteria) { var data = MockDb.Projects .Where(row => row.ProjectId == criteria.ProjectId) .Single(); data = this.Fetch(data); return data; }
public void Delete(ProjectDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var project = this.Fetch(ctx, criteria) .Single(); ctx.ObjectContext.Projects.DeleteObject(project); ctx.ObjectContext.SaveChanges(); } }
public void Delete(ProjectDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var project = this.Fetch(ctx, criteria) .Single(); ctx.ObjectContext.Projects.DeleteObject(project); ctx.ObjectContext.SaveChanges(); } }
public ProjectData Fetch(ProjectDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var project = this.Fetch(ctx, criteria) .Single(); var projectData = new ProjectData(); this.Fetch(project, projectData); return projectData; } }
public ProjectData Fetch(ProjectDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var project = this.Fetch(ctx, criteria) .Single(); var projectData = new ProjectData(); this.Fetch(project, projectData); return(projectData); } }
private void DataPortal_Fetch(ProjectDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider <IProjectDataFactory>(); var data = dalFactory.Fetch(criteria); using (this.BypassPropertyChecks) { this.Fetch(data); } // this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data); } }
public ProjectData[] FetchInfoList(ProjectDataCriteria criteria) { var query = MockDb.Projects .AsQueryable(); var projects = query.AsQueryable(); var data = new List <ProjectData>(); foreach (var project in projects) { data.Add(this.Fetch(project)); } return(data.ToArray()); }
public ProjectData[] FetchInfoList(ProjectDataCriteria criteria) { var query = MockDb.Projects .AsQueryable(); var projects = query.AsQueryable(); var data = new List<ProjectData>(); foreach (var project in projects) { data.Add(this.Fetch(project)); } return data.ToArray(); }
private void DataPortal_Fetch(ProjectDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider <IProjectDataFactory>(); var data = dalFactory.FetchInfoList(criteria); this.RaiseListChangedEvents = false; this.IsReadOnly = false; this.AddRange(data.Select(row => Csla.DataPortal.FetchChild <ProjectInfo>(row))); this.IsReadOnly = true; this.RaiseListChangedEvents = true; } }
private void DataPortal_Fetch(ProjectDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider<IProjectDataFactory>(); var data = dalFactory.FetchInfoList(criteria); this.RaiseListChangedEvents = false; this.IsReadOnly = false; this.AddRange(data.Select(row => Csla.DataPortal.FetchChild<ProjectInfo>(row))); this.IsReadOnly = true; this.RaiseListChangedEvents = true; } }
public ProjectData[] FetchLookupInfoList(ProjectDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var projects = this.Fetch(ctx, criteria) .AsEnumerable(); var projectDataList = new List <ProjectData>(); foreach (var project in projects) { var projectData = new ProjectData(); this.Fetch(project, projectData); projectDataList.Add(projectData); } return(projectDataList.ToArray()); } }
public ProjectData[] FetchLookupInfoList(ProjectDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var projects = this.Fetch(ctx, criteria) .AsEnumerable(); var projectDataList = new List<ProjectData>(); foreach (var project in projects) { var projectData = new ProjectData(); this.Fetch(project, projectData); projectDataList.Add(projectData); } return projectDataList.ToArray(); } }
public ActionResult Index( string createdDate, string isActive, string isArchived, string modifiedDate, string projectName) { var model = new ProjectListModel(); var criteria = new ProjectDataCriteria { CreatedDate = CriteriaHelper.ToDateRangeCriteria(createdDate), IsActive = CriteriaHelper.ToBoolean(isActive), IsArchived = CriteriaHelper.ToBoolean(isArchived), Name = projectName, ModifiedDate = CriteriaHelper.ToDateRangeCriteria(modifiedDate) }; var projects = ProjectRepository.ProjectFetchInfoList(criteria); model.Projects = projects; var stories = StoryRepository.StoryFetchInfoList(projects.ToArray(), false); model.Stories = stories; var timelines = TimelineRepository.TimelineFetchInfoList( projects.Select(row => row.ProjectId).Distinct().ToArray(), SourceType.Project); model.Timelines = timelines; var sprints = SprintRepository.SprintFetchInfoList(projects.ToArray(), false); model.Sprints = sprints; model.Actions.Add("Add a project", Url.Action("Create"), "primary"); return(this.View(model)); }
private IQueryable <Project> Fetch( Csla.Data.ObjectContextManager <ApplicationEntities> ctx, ProjectDataCriteria criteria) { IQueryable <Project> query = ctx.ObjectContext.Projects .Include("CreatedByUser") .Include("ModifiedByUser"); if (criteria.ProjectId != null) { query = query.Where(row => row.ProjectId == criteria.ProjectId); } 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.Name != null) { query = query.Where(row => row.Name == criteria.Name); } if (criteria.UserId != null) { query = query.Join( ctx.ObjectContext.ProjectUserMembers.Where(pum => pum.UserId == criteria.UserId), p => p.ProjectId, pum => pum.ProjectId, (p, pum) => p); } if (criteria.CreatedBy != null) { query = query.Where(row => row.CreatedBy == criteria.CreatedBy); } if (criteria.CreatedDate != null && criteria.CreatedDate.DateFrom.Date != DateTime.MinValue.Date) { query = query.Where(row => row.CreatedDate >= criteria.CreatedDate.DateFrom); } if (criteria.CreatedDate != null && criteria.CreatedDate.DateTo.Date != DateTime.MaxValue.Date) { query = query.Where(row => row.CreatedDate <= criteria.CreatedDate.DateTo); } if (criteria.ModifiedBy != null) { query = query.Where(row => row.ModifiedBy == criteria.ModifiedBy); } if (criteria.ModifiedDate != null && criteria.ModifiedDate.DateFrom.Date != DateTime.MinValue.Date) { query = query.Where(row => row.ModifiedDate >= criteria.ModifiedDate.DateFrom); } if (criteria.ModifiedDate != null && criteria.ModifiedDate.DateTo.Date != DateTime.MaxValue.Date) { query = query.Where(row => row.ModifiedDate <= criteria.ModifiedDate.DateTo); } if (criteria.Text != null) { query = query.Where(row => row.Name.Contains(criteria.Text)); } if (criteria.SortBy != null) { query = query.OrderBy(string.Format( "{0} {1}", criteria.SortBy, criteria.SortOrder == ListSortDirection.Ascending ? "ASC" : "DESC")); } if (criteria.SkipRecords != null) { query = query.Skip(criteria.SkipRecords.Value); } if (criteria.MaximumRecords != null) { query = query.Take(criteria.MaximumRecords.Value); } return(query); }
public ActionResult Index( string createdDate, string isActive, string isArchived, string modifiedDate, string projectName) { var model = new ProjectListModel(); var criteria = new ProjectDataCriteria { CreatedDate = CriteriaHelper.ToDateRangeCriteria(createdDate), IsActive = CriteriaHelper.ToBoolean(isActive), IsArchived = CriteriaHelper.ToBoolean(isArchived), Name = projectName, ModifiedDate = CriteriaHelper.ToDateRangeCriteria(modifiedDate) }; var projects = ProjectRepository.ProjectFetchInfoList(criteria); model.Projects = projects; var stories = StoryRepository.StoryFetchInfoList(projects.ToArray(), false); model.Stories = stories; var timelines = TimelineRepository.TimelineFetchInfoList( projects.Select(row => row.ProjectId).Distinct().ToArray(), SourceType.Project); model.Timelines = timelines; var sprints = SprintRepository.SprintFetchInfoList(projects.ToArray(), false); model.Sprints = sprints; model.Actions.Add("Add a project", Url.Action("Create"), "primary"); return this.View(model); }
private void DataPortal_Delete(ProjectDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider<IProjectDataFactory>(); dalFactory.Delete(criteria); } }
private void DataPortal_Fetch(ProjectDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider<IProjectDataFactory>(); var data = dalFactory.Fetch(criteria); using (this.BypassPropertyChecks) { this.Fetch(data); } // this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data); } }
internal static Project FetchProject(ProjectDataCriteria criteria) { return(Csla.DataPortal.Fetch <Project>(criteria)); }
internal static void DeleteProject(ProjectDataCriteria criteria) { Csla.DataPortal.Delete <Project>(criteria); }
private IQueryable<Project> Fetch( Csla.Data.ObjectContextManager<ApplicationEntities> ctx, ProjectDataCriteria criteria) { IQueryable<Project> query = ctx.ObjectContext.Projects .Include("CreatedByUser") .Include("ModifiedByUser"); if (criteria.ProjectId != null) { query = query.Where(row => row.ProjectId == criteria.ProjectId); } 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.Name != null) { query = query.Where(row => row.Name == criteria.Name); } if (criteria.UserId != null) { query = query.Join( ctx.ObjectContext.ProjectUserMembers.Where(pum => pum.UserId == criteria.UserId), p => p.ProjectId, pum => pum.ProjectId, (p, pum) => p); } if (criteria.CreatedBy != null) { query = query.Where(row => row.CreatedBy == criteria.CreatedBy); } if (criteria.CreatedDate != null && criteria.CreatedDate.DateFrom.Date != DateTime.MinValue.Date) { query = query.Where(row => row.CreatedDate >= criteria.CreatedDate.DateFrom); } if (criteria.CreatedDate != null && criteria.CreatedDate.DateTo.Date != DateTime.MaxValue.Date) { query = query.Where(row => row.CreatedDate <= criteria.CreatedDate.DateTo); } if (criteria.ModifiedBy != null) { query = query.Where(row => row.ModifiedBy == criteria.ModifiedBy); } if (criteria.ModifiedDate != null && criteria.ModifiedDate.DateFrom.Date != DateTime.MinValue.Date) { query = query.Where(row => row.ModifiedDate >= criteria.ModifiedDate.DateFrom); } if (criteria.ModifiedDate != null && criteria.ModifiedDate.DateTo.Date != DateTime.MaxValue.Date) { query = query.Where(row => row.ModifiedDate <= criteria.ModifiedDate.DateTo); } if (criteria.Text != null) { query = query.Where(row => row.Name.Contains(criteria.Text)); } if (criteria.SortBy != null) { query = query.OrderBy(string.Format( "{0} {1}", criteria.SortBy, criteria.SortOrder == ListSortDirection.Ascending ? "ASC" : "DESC")); } if (criteria.SkipRecords != null) { query = query.Skip(criteria.SkipRecords.Value); } if (criteria.MaximumRecords != null) { query = query.Take(criteria.MaximumRecords.Value); } return query; }
internal static Project FetchProject(ProjectDataCriteria criteria) { return Csla.DataPortal.Fetch<Project>(criteria); }
internal static void DeleteProject(ProjectDataCriteria criteria) { Csla.DataPortal.Delete<Project>(criteria); }