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 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();
}
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);
}
}
