public ActionResult List(
string createdDate,
string date,
string isArchived,
string modifiedDate,
int?projectId,
string projectName,
int?sprintId,
string sprintName,
int?storyId,
int?userId,
string userName)
{
var model = new HourListModel();
var criteria =
new HourDataCriteria
{
CreatedDate = CriteriaHelper.ToDateRangeCriteria(createdDate),
Date = CriteriaHelper.ToDateRangeCriteria(date),
IsArchived = CriteriaHelper.ToBoolean(isArchived),
ModifiedDate = CriteriaHelper.ToDateRangeCriteria(modifiedDate),
ProjectId = CriteriaHelper.ToArray(projectId),
ProjectName = projectName,
SprintId = sprintId,
StoryId = storyId,
UserId = userId,
UserName = userName
};
var hours = HourRepository.HourFetchInfoList(criteria);
model.Hours = hours;
return(this.View(model));
}
public void Delete(HourDataCriteria criteria)
{
var data = MockDb.Hours
.Where(row => row.HourId == criteria.HourId)
.Single();
MockDb.Hours.Remove(data);
}
public void Delete(HourDataCriteria criteria)
{
var data = MockDb.Hours
.Where(row => row.HourId == criteria.HourId)
.Single();
MockDb.Hours.Remove(data);
}
public static HourInfoList HourFetchInfoList(HourDataCriteria criteria)
{
criteria.ProjectId = ProjectRepository.ProjectFetchInfoList()
.Select(row => row.ProjectId)
.ToArray();
return(HourInfoList.FetchHourInfoList(criteria));
}
public HourData[] FetchLookupInfoList(HourDataCriteria criteria)
{
var query = MockDb.Hours
.AsQueryable();
var data = query.AsQueryable();
return data.ToArray();
}
private void DataPortal_Delete(HourDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IHourDataFactory>();
dalFactory.Delete(criteria);
}
}
public HourData[] FetchLookupInfoList(HourDataCriteria criteria)
{
var query = MockDb.Hours
.AsQueryable();
var data = query.AsQueryable();
return(data.ToArray());
}
public HourData Fetch(HourDataCriteria criteria)
{
var data = MockDb.Hours
.Where(row => row.HourId == criteria.HourId)
.Single();
data = this.Fetch(data);
return data;
}
public HourData Fetch(HourDataCriteria criteria)
{
var data = MockDb.Hours
.Where(row => row.HourId == criteria.HourId)
.Single();
data = this.Fetch(data);
return(data);
}
public void Delete(HourDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var hour = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Hours.DeleteObject(hour);
ctx.ObjectContext.SaveChanges();
}
}
public void Delete(HourDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var hour = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Hours.DeleteObject(hour);
ctx.ObjectContext.SaveChanges();
}
}
private void DataPortal_Fetch(HourDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IHourDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
}
}
public HourData Fetch(HourDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var hour = this.Fetch(ctx, criteria)
.Single();
var hourData = new HourData();
this.Fetch(hour, hourData);
return hourData;
}
}
public HourData Fetch(HourDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var hour = this.Fetch(ctx, criteria)
.Single();
var hourData = new HourData();
this.Fetch(hour, hourData);
return(hourData);
}
}
public HourData[] FetchInfoList(HourDataCriteria criteria)
{
var query = MockDb.Hours
.AsQueryable();
var hours = query.AsQueryable();
var data = new List <HourData>();
foreach (var hour in hours)
{
data.Add(this.Fetch(hour));
}
return(data.ToArray());
}
public HourData[] FetchInfoList(HourDataCriteria criteria)
{
var query = MockDb.Hours
.AsQueryable();
var hours = query.AsQueryable();
var data = new List<HourData>();
foreach (var hour in hours)
{
data.Add(this.Fetch(hour));
}
return data.ToArray();
}
private void DataPortal_Fetch(HourDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IHourDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild<HourInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
private void DataPortal_Fetch(HourDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IHourDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild <HourInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
public HourData[] FetchLookupInfoList(HourDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var hours = this.Fetch(ctx, criteria)
.AsEnumerable();
var hourDataList = new List<HourData>();
foreach (var hour in hours)
{
var hourData = new HourData();
this.Fetch(hour, hourData);
hourDataList.Add(hourData);
}
return hourDataList.ToArray();
}
}
public ActionResult Index(int?year, int?userId)
{
var model = new HourIndexModel();
var projects = ProjectRepository.ProjectFetchInfoList();
model.UserId = userId ?? ((IBusinessIdentity)Csla.ApplicationContext.User.Identity).UserId;
var weeks = WeekCollection.GetWeeks(year ?? DateTime.Now.Year);
model.Weeks = weeks;
var criteria =
new HourDataCriteria
{
Date = CriteriaHelper.ToDateRangeCriteria(weeks.StartDate, weeks.EndDate),
UserId = model.UserId
};
var hours = HourRepository.HourFetchInfoList(criteria);
model.Hours = hours;
model.Year = year ?? DateTime.Now.Year;
var years = new List <int>();
for (var currentYear = year ?? DateTime.Now.Year; currentYear <= DateTime.Now.Year; currentYear++)
{
years.Add(currentYear);
}
model.Years = years;
var users = UserRepository.UserFetchInfoList(projects);
model.Users = users;
return(this.View(model));
}
public HourData[] FetchLookupInfoList(HourDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var hours = this.Fetch(ctx, criteria)
.AsEnumerable();
var hourDataList = new List <HourData>();
foreach (var hour in hours)
{
var hourData = new HourData();
this.Fetch(hour, hourData);
hourDataList.Add(hourData);
}
return(hourDataList.ToArray());
}
}
internal static Hour FetchHour(HourDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <Hour>(criteria));
}
public ActionResult Index(int? year, int? userId)
{
var model = new HourIndexModel();
var projects = ProjectRepository.ProjectFetchInfoList();
model.UserId = userId ?? ((IBusinessIdentity)Csla.ApplicationContext.User.Identity).UserId;
var weeks = WeekCollection.GetWeeks(year ?? DateTime.Now.Year);
model.Weeks = weeks;
var criteria =
new HourDataCriteria
{
Date = CriteriaHelper.ToDateRangeCriteria(weeks.StartDate, weeks.EndDate),
UserId = model.UserId
};
var hours = HourRepository.HourFetchInfoList(criteria);
model.Hours = hours;
model.Year = year ?? DateTime.Now.Year;
var years = new List<int>();
for (var currentYear = year ?? DateTime.Now.Year; currentYear <= DateTime.Now.Year; currentYear++)
{
years.Add(currentYear);
}
model.Years = years;
var users = UserRepository.UserFetchInfoList(projects);
model.Users = users;
return this.View(model);
}
public ActionResult List(
string createdDate,
string date,
string isArchived,
string modifiedDate,
int? projectId,
string projectName,
int? sprintId,
string sprintName,
int? storyId,
int? userId,
string userName)
{
var model = new HourListModel();
var criteria =
new HourDataCriteria
{
CreatedDate = CriteriaHelper.ToDateRangeCriteria(createdDate),
Date = CriteriaHelper.ToDateRangeCriteria(date),
IsArchived = CriteriaHelper.ToBoolean(isArchived),
ModifiedDate = CriteriaHelper.ToDateRangeCriteria(modifiedDate),
ProjectId = CriteriaHelper.ToArray(projectId),
ProjectName = projectName,
SprintId = sprintId,
StoryId = storyId,
UserId = userId,
UserName = userName
};
var hours = HourRepository.HourFetchInfoList(criteria);
model.Hours = hours;
return this.View(model);
}
private IQueryable<Hour> Fetch(
Csla.Data.ObjectContextManager<ApplicationEntities> ctx,
HourDataCriteria criteria)
{
IQueryable<Hour> query = ctx.ObjectContext.Hours
.Include("Story")
.Include("Story.Project")
.Include("Story.Sprint")
.Include("User")
.Include("CreatedByUser")
.Include("ModifiedByUser");
if (criteria.HourId != null)
{
query = query.Where(row => row.HourId == criteria.HourId);
}
if (criteria.Date != null
&& criteria.Date.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.Date >= criteria.Date.DateFrom);
}
if (criteria.Date != null
&& (criteria.Date.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.Date <= criteria.Date.DateTo);
}
if (criteria.Duration != null)
{
query = query.Where(row => row.Duration == criteria.Duration);
}
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.ProjectId != null)
{
query = query.Where(row => criteria.ProjectId.Contains(row.Story.ProjectId));
}
if (criteria.ProjectName != null)
{
query = query.Where(row => row.Story.Project.Name == criteria.ProjectName);
}
if (criteria.SprintId != null)
{
query = query.Where(row => row.Story.SprintId == criteria.SprintId);
}
if (criteria.StoryId != null)
{
query = query.Where(row => row.StoryId == criteria.StoryId);
}
if (criteria.UserId != null)
{
query = query.Where(row => row.UserId == criteria.UserId);
}
if (criteria.UserName != null)
{
query = query.Where(row => row.User.Name == criteria.UserName);
}
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 => SqlFunctions.StringConvert((double)row.StoryId).Contains(criteria.Text)
|| row.Notes.Contains(criteria.Text)
|| row.Story.Project.Name.Contains(criteria.Text)
|| row.User.Name.Contains(criteria.Text)
|| row.Story.Status.Name.Contains(criteria.Text)
|| row.Story.Sprint.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(HourDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IHourDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
}
}
private void DataPortal_Delete(HourDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IHourDataFactory>();
dalFactory.Delete(criteria);
}
}
private IQueryable <Hour> Fetch(
Csla.Data.ObjectContextManager <ApplicationEntities> ctx,
HourDataCriteria criteria)
{
IQueryable <Hour> query = ctx.ObjectContext.Hours
.Include("Story")
.Include("Story.Project")
.Include("Story.Sprint")
.Include("User")
.Include("CreatedByUser")
.Include("ModifiedByUser");
if (criteria.HourId != null)
{
query = query.Where(row => row.HourId == criteria.HourId);
}
if (criteria.Date != null &&
criteria.Date.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.Date >= criteria.Date.DateFrom);
}
if (criteria.Date != null &&
(criteria.Date.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.Date <= criteria.Date.DateTo);
}
if (criteria.Duration != null)
{
query = query.Where(row => row.Duration == criteria.Duration);
}
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.ProjectId != null)
{
query = query.Where(row => criteria.ProjectId.Contains(row.Story.ProjectId));
}
if (criteria.ProjectName != null)
{
query = query.Where(row => row.Story.Project.Name == criteria.ProjectName);
}
if (criteria.SprintId != null)
{
query = query.Where(row => row.Story.SprintId == criteria.SprintId);
}
if (criteria.StoryId != null)
{
query = query.Where(row => row.StoryId == criteria.StoryId);
}
if (criteria.UserId != null)
{
query = query.Where(row => row.UserId == criteria.UserId);
}
if (criteria.UserName != null)
{
query = query.Where(row => row.User.Name == criteria.UserName);
}
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 => SqlFunctions.StringConvert((double)row.StoryId).Contains(criteria.Text) ||
row.Notes.Contains(criteria.Text) ||
row.Story.Project.Name.Contains(criteria.Text) ||
row.User.Name.Contains(criteria.Text) ||
row.Story.Status.Name.Contains(criteria.Text) ||
row.Story.Sprint.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 HourInfoList FetchHourInfoList(HourDataCriteria criteria)
{
return Csla.DataPortal.Fetch<HourInfoList>(criteria);
}
internal static HourInfoList FetchHourInfoList(HourDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <HourInfoList>(criteria));
}
internal static void DeleteHour(HourDataCriteria criteria)
{
Csla.DataPortal.Delete <Hour>(criteria);
}
internal static void DeleteHour(HourDataCriteria criteria)
{
Csla.DataPortal.Delete<Hour>(criteria);
}
public static HourInfoList HourFetchInfoList(HourDataCriteria criteria)
{
criteria.ProjectId = ProjectRepository.ProjectFetchInfoList()
.Select(row => row.ProjectId)
.ToArray();
return HourInfoList.FetchHourInfoList(criteria);
}
internal static Hour FetchHour(HourDataCriteria criteria)
{
return Csla.DataPortal.Fetch<Hour>(criteria);
}
