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