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(); } }
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(); } }
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; } }
internal static void DeleteProject(ProjectCriteria criteria) { Csla.DataPortal.Delete <Project>(criteria); }
internal static Project FetchProject(ProjectCriteria criteria) { return(Csla.DataPortal.Fetch <Project>(criteria)); }
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); }
internal static ProjectInfoList FetchProjectInfoList(ProjectCriteria criteria) { return Csla.DataPortal.Fetch<ProjectInfoList>(criteria); }
public static ProjectInfoList ProjectFetchInfoList(ProjectCriteria criteria) { return ProjectInfoList.FetchProjectInfoList(criteria); }
internal static void DeleteProject(ProjectCriteria criteria) { Csla.DataPortal.Delete<Project>(criteria); }
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; } }