public SprintData[] FetchInfoList(SprintDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var sprints = from sprint in this.Fetch(ctx, criteria) select new { Sprint = sprint, Duration = ctx.ObjectContext.GetSprintDuration(sprint.SprintId) ?? 0 }; var sprintDataList = new List<SprintData>(); foreach (var sprint in sprints) { var sprintData = new SprintData(); this.Fetch(sprint.Sprint, sprintData); sprintData.Duration = sprint.Duration; sprintDataList.Add(sprintData); } return sprintDataList.ToArray(); } }
public SprintData[] FetchInfoList(SprintDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var sprints = from sprint in this.Fetch(ctx, criteria) select new { Sprint = sprint, Duration = ctx.ObjectContext.GetSprintDuration(sprint.SprintId) ?? 0 }; var sprintDataList = new List <SprintData>(); foreach (var sprint in sprints) { var sprintData = new SprintData(); this.Fetch(sprint.Sprint, sprintData); sprintData.Duration = sprint.Duration; sprintDataList.Add(sprintData); } return(sprintDataList.ToArray()); } }
public void Delete(SprintDataCriteria criteria) { var data = MockDb.Sprints .Where(row => row.SprintId == criteria.SprintId) .Single(); MockDb.Sprints.Remove(data); }
public SprintData[] FetchLookupInfoList(SprintDataCriteria criteria) { var query = MockDb.Sprints .AsQueryable(); var data = query.AsQueryable(); return(data.ToArray()); }
public SprintData[] FetchLookupInfoList(SprintDataCriteria criteria) { var query = MockDb.Sprints .AsQueryable(); var data = query.AsQueryable(); return data.ToArray(); }
private void DataPortal_Delete(SprintDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider <ISprintDataFactory>(); dalFactory.Delete(criteria); } }
public SprintData Fetch(SprintDataCriteria criteria) { var data = MockDb.Sprints .Where(row => row.SprintId == criteria.SprintId) .Single(); data = this.Fetch(data); return(data); }
public SprintData Fetch(SprintDataCriteria criteria) { var data = MockDb.Sprints .Where(row => row.SprintId == criteria.SprintId) .Single(); data = this.Fetch(data); return data; }
public void Delete(SprintDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var sprint = this.Fetch(ctx, criteria) .Single(); ctx.ObjectContext.Sprints.DeleteObject(sprint); ctx.ObjectContext.SaveChanges(); } }
public void Delete(SprintDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var sprint = this.Fetch(ctx, criteria) .Single(); ctx.ObjectContext.Sprints.DeleteObject(sprint); ctx.ObjectContext.SaveChanges(); } }
public SprintData[] FetchInfoList(SprintDataCriteria criteria) { var query = MockDb.Sprints .AsQueryable(); var sprints = query.AsQueryable(); var data = new List <SprintData>(); foreach (var sprint in sprints) { data.Add(this.Fetch(sprint)); } return(data.ToArray()); }
public SprintData[] FetchInfoList(SprintDataCriteria criteria) { var query = MockDb.Sprints .AsQueryable(); var sprints = query.AsQueryable(); var data = new List<SprintData>(); foreach (var sprint in sprints) { data.Add(this.Fetch(sprint)); } return data.ToArray(); }
private void DataPortal_Fetch(SprintDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider <ISprintDataFactory>(); var data = dalFactory.Fetch(criteria); using (this.BypassPropertyChecks) { this.Fetch(data); } // this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data); } }
public SprintData Fetch(SprintDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var sprint = this.Fetch(ctx, criteria) .Single(); var sprintData = new SprintData(); this.Fetch(sprint, sprintData); sprintData.Duration = ctx.ObjectContext.GetSprintDuration(sprint.SprintId) ?? 0; return(sprintData); } }
private void DataPortal_Fetch(SprintDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider <ISprintDataFactory>(); var data = dalFactory.FetchInfoList(criteria); this.RaiseListChangedEvents = false; this.IsReadOnly = false; this.AddRange(data.Select(row => Csla.DataPortal.FetchChild <SprintInfo>(row))); this.IsReadOnly = true; this.RaiseListChangedEvents = true; } }
private void DataPortal_Fetch(SprintDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider<ISprintDataFactory>(); var data = dalFactory.FetchInfoList(criteria); this.RaiseListChangedEvents = false; this.IsReadOnly = false; this.AddRange(data.Select(row => Csla.DataPortal.FetchChild<SprintInfo>(row))); this.IsReadOnly = true; this.RaiseListChangedEvents = true; } }
public SprintData Fetch(SprintDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var sprint = this.Fetch(ctx, criteria) .Single(); var sprintData = new SprintData(); this.Fetch(sprint, sprintData); sprintData.Duration = ctx.ObjectContext.GetSprintDuration(sprint.SprintId) ?? 0; return sprintData; } }
protected void DataPortal_Create(SprintDataCriteria criteria) { using (this.BypassPropertyChecks) { this.CompletedDate = DateTime.MaxValue.Date; this.IsActive = true; this.EstimatedCompletedDate = DateTime.MaxValue.Date; if (criteria.ProjectId != null) { this.ProjectId = criteria.ProjectId[0]; } this.ModifiedDate = DateTime.Now; this.CreatedDate = DateTime.Now; } this.PropertyHasChanged(ProjectIdProperty); base.DataPortal_Create(); }
public SprintData[] FetchLookupInfoList(SprintDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var sprints = this.Fetch(ctx, criteria) .AsEnumerable(); var sprintDataList = new List <SprintData>(); foreach (var sprint in sprints) { var sprintData = new SprintData(); this.Fetch(sprint, sprintData); sprintDataList.Add(sprintData); } return(sprintDataList.ToArray()); } }
private void DataPortal_Delete(SprintDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider<ISprintDataFactory>(); dalFactory.Delete(criteria); } }
public static SprintInfoList SprintFetchInfoList(SprintDataCriteria criteria) { return SprintInfoList.FetchSprintInfoList(criteria); }
private IQueryable <Sprint> Fetch( Csla.Data.ObjectContextManager <ApplicationEntities> ctx, SprintDataCriteria criteria) { IQueryable <Sprint> query = ctx.ObjectContext.Sprints .Include("Project") .Include("CreatedByUser") .Include("ModifiedByUser"); if (criteria.SprintId != null) { query = query.Where(row => row.SprintId == criteria.SprintId); } if (criteria.CompletedDate != null && criteria.CompletedDate.DateFrom.Date != DateTime.MinValue.Date) { query = query.Where(row => row.CompletedDate >= criteria.CompletedDate.DateFrom); } if (criteria.CompletedDate != null && (criteria.CompletedDate.DateTo.Date != DateTime.MaxValue.Date)) { query = query.Where(row => row.CompletedDate <= criteria.CompletedDate.DateTo); } 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.IsCompleted != null) { query = query.Where(row => row.IsCompleted == criteria.IsCompleted); } if (criteria.Duration != null) { query = query.Where(row => row.Duration == criteria.Duration); } if (criteria.EstimatedCompletedDate != null && criteria.EstimatedCompletedDate.DateFrom.Date != DateTime.MinValue.Date) { query = query.Where(row => row.EstimatedCompletedDate >= criteria.EstimatedCompletedDate.DateFrom); } if (criteria.EstimatedCompletedDate != null && (criteria.EstimatedCompletedDate.DateTo.Date != DateTime.MaxValue.Date)) { query = query.Where(row => row.EstimatedCompletedDate <= criteria.EstimatedCompletedDate.DateTo); } if (criteria.EstimatedDuration != null) { query = query.Where(row => row.EstimatedDuration == criteria.EstimatedDuration); } if (criteria.Name != null) { query = query.Where(row => row.Name == criteria.Name); } if (criteria.ProjectId != null) { query = query.Where(row => criteria.ProjectId.Contains(row.ProjectId)); } 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 void DeleteSprint(SprintDataCriteria criteria) { Csla.DataPortal.Delete<Sprint>(criteria); }
public static SprintInfoList SprintFetchInfoList(SprintDataCriteria criteria) { return(SprintInfoList.FetchSprintInfoList(criteria)); }
internal static SprintInfoList FetchSprintInfoList(SprintDataCriteria criteria) { return Csla.DataPortal.Fetch<SprintInfoList>(criteria); }
internal static SprintInfoList FetchSprintInfoList(SprintDataCriteria criteria) { return(Csla.DataPortal.Fetch <SprintInfoList>(criteria)); }
public SprintData[] FetchLookupInfoList(SprintDataCriteria criteria) { using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities> .GetManager(Database.ApplicationConnection, false)) { var sprints = this.Fetch(ctx, criteria) .AsEnumerable(); var sprintDataList = new List<SprintData>(); foreach (var sprint in sprints) { var sprintData = new SprintData(); this.Fetch(sprint, sprintData); sprintDataList.Add(sprintData); } return sprintDataList.ToArray(); } }
internal static void DeleteSprint(SprintDataCriteria criteria) { Csla.DataPortal.Delete <Sprint>(criteria); }
private IQueryable<Sprint> Fetch( Csla.Data.ObjectContextManager<ApplicationEntities> ctx, SprintDataCriteria criteria) { IQueryable<Sprint> query = ctx.ObjectContext.Sprints .Include("Project") .Include("CreatedByUser") .Include("ModifiedByUser"); if (criteria.SprintId != null) { query = query.Where(row => row.SprintId == criteria.SprintId); } if (criteria.CompletedDate != null && criteria.CompletedDate.DateFrom.Date != DateTime.MinValue.Date) { query = query.Where(row => row.CompletedDate >= criteria.CompletedDate.DateFrom); } if (criteria.CompletedDate != null && (criteria.CompletedDate.DateTo.Date != DateTime.MaxValue.Date)) { query = query.Where(row => row.CompletedDate <= criteria.CompletedDate.DateTo); } 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.IsCompleted != null) { query = query.Where(row => row.IsCompleted == criteria.IsCompleted); } if (criteria.Duration != null) { query = query.Where(row => row.Duration == criteria.Duration); } if (criteria.EstimatedCompletedDate != null && criteria.EstimatedCompletedDate.DateFrom.Date != DateTime.MinValue.Date) { query = query.Where(row => row.EstimatedCompletedDate >= criteria.EstimatedCompletedDate.DateFrom); } if (criteria.EstimatedCompletedDate != null && (criteria.EstimatedCompletedDate.DateTo.Date != DateTime.MaxValue.Date)) { query = query.Where(row => row.EstimatedCompletedDate <= criteria.EstimatedCompletedDate.DateTo); } if (criteria.EstimatedDuration != null) { query = query.Where(row => row.EstimatedDuration == criteria.EstimatedDuration); } if (criteria.Name != null) { query = query.Where(row => row.Name == criteria.Name); } if (criteria.ProjectId != null) { query = query.Where(row => criteria.ProjectId.Contains(row.ProjectId)); } 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; }
private void DataPortal_Fetch(SprintDataCriteria criteria) { using (var dalManager = DataFactoryManager.GetManager()) { var dalFactory = dalManager.GetProvider<ISprintDataFactory>(); var data = dalFactory.Fetch(criteria); using (this.BypassPropertyChecks) { this.Fetch(data); } // this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data); } }