public void Delete(ProjectDataCriteria criteria)
{
var data = MockDb.Projects
.Where(row => row.ProjectId == criteria.ProjectId)
.Single();
MockDb.Projects.Remove(data);
}
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);
}
