public void Delete(WeekDataCriteria criteria)
{
var data = MockDb.Weeks
.Where(row => row.WeekId == criteria.WeekId)
.Single();
MockDb.Weeks.Remove(data);
}
public void Delete(WeekDataCriteria criteria)
{
var data = MockDb.Weeks
.Where(row => row.WeekId == criteria.WeekId)
.Single();
MockDb.Weeks.Remove(data);
}
private void DataPortal_Delete(WeekDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IWeekDataFactory>();
dalFactory.Delete(criteria);
}
}
public WeekData Fetch(WeekDataCriteria criteria)
{
var data = MockDb.Weeks
.Where(row => row.WeekId == criteria.WeekId)
.Single();
data = this.Fetch(data);
return data;
}
public WeekData Fetch(WeekDataCriteria criteria)
{
var data = MockDb.Weeks
.Where(row => row.WeekId == criteria.WeekId)
.Single();
data = this.Fetch(data);
return(data);
}
public void Delete(WeekDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var week = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Weeks.DeleteObject(week);
ctx.ObjectContext.SaveChanges();
}
}
public void Delete(WeekDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var week = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Weeks.DeleteObject(week);
ctx.ObjectContext.SaveChanges();
}
}
public WeekData Fetch(WeekDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var week = this.Fetch(ctx, criteria)
.Single();
var weekData = new WeekData();
this.Fetch(week, weekData);
return weekData;
}
}
public WeekData Fetch(WeekDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var week = this.Fetch(ctx, criteria)
.Single();
var weekData = new WeekData();
this.Fetch(week, weekData);
return(weekData);
}
}
public WeekData[] FetchInfoList(WeekDataCriteria criteria)
{
var query = MockDb.Weeks
.AsQueryable();
var weeks = query.AsQueryable();
var data = new List<WeekData>();
foreach (var week in weeks)
{
data.Add(this.Fetch(week));
}
return data.ToArray();
}
private void DataPortal_Fetch(WeekDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IWeekDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
public WeekData[] FetchInfoList(WeekDataCriteria criteria)
{
var query = MockDb.Weeks
.AsQueryable();
var weeks = query.AsQueryable();
var data = new List <WeekData>();
foreach (var week in weeks)
{
data.Add(this.Fetch(week));
}
return(data.ToArray());
}
private void DataPortal_Fetch(WeekDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IWeekDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild<WeekInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
private void DataPortal_Fetch(WeekDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IWeekDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild <WeekInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
public WeekData[] FetchLookupInfoList(WeekDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var weeks = this.Fetch(ctx, criteria)
.AsEnumerable();
var weekDataList = new List<WeekData>();
foreach (var week in weeks)
{
var weekData = new WeekData();
this.Fetch(week, weekData);
weekDataList.Add(weekData);
}
return weekDataList.ToArray();
}
}
public WeekData[] FetchLookupInfoList(WeekDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var weeks = this.Fetch(ctx, criteria)
.AsEnumerable();
var weekDataList = new List <WeekData>();
foreach (var week in weeks)
{
var weekData = new WeekData();
this.Fetch(week, weekData);
weekDataList.Add(weekData);
}
return(weekDataList.ToArray());
}
}
internal static WeekInfoList FetchWeekInfoList(WeekDataCriteria criteria)
{
return Csla.DataPortal.Fetch<WeekInfoList>(criteria);
}
internal static WeekInfoList FetchWeekInfoList(WeekDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <WeekInfoList>(criteria));
}
private IQueryable <Week> Fetch(
Csla.Data.ObjectContextManager <ApplicationEntities> ctx,
WeekDataCriteria criteria)
{
IQueryable <Week> query = ctx.ObjectContext.Weeks;
if (criteria.WeekId != null)
{
query = query.Where(row => row.WeekId == criteria.WeekId);
}
if (criteria.EndDate != null &&
criteria.EndDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.EndDate >= criteria.EndDate.DateFrom);
}
if (criteria.EndDate != null &&
(criteria.EndDate.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.EndDate <= criteria.EndDate.DateTo);
}
if (criteria.Period != null)
{
query = query.Where(row => row.Period == criteria.Period);
}
if (criteria.StartDate != null &&
criteria.StartDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.StartDate >= criteria.StartDate.DateFrom);
}
if (criteria.StartDate != null &&
(criteria.StartDate.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.StartDate <= criteria.StartDate.DateTo);
}
if (criteria.Year != null)
{
query = query.Where(row => row.Year == criteria.Year);
}
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.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_Delete(WeekDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IWeekDataFactory>();
dalFactory.Delete(criteria);
}
}
private IQueryable<Week> Fetch(
Csla.Data.ObjectContextManager<ApplicationEntities> ctx,
WeekDataCriteria criteria)
{
IQueryable<Week> query = ctx.ObjectContext.Weeks;
if (criteria.WeekId != null)
{
query = query.Where(row => row.WeekId == criteria.WeekId);
}
if (criteria.EndDate != null
&& criteria.EndDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.EndDate >= criteria.EndDate.DateFrom);
}
if (criteria.EndDate != null
&& (criteria.EndDate.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.EndDate <= criteria.EndDate.DateTo);
}
if (criteria.Period != null)
{
query = query.Where(row => row.Period == criteria.Period);
}
if (criteria.StartDate != null
&& criteria.StartDate.DateFrom.Date != DateTime.MinValue.Date)
{
query = query.Where(row => row.StartDate >= criteria.StartDate.DateFrom);
}
if (criteria.StartDate != null
&& (criteria.StartDate.DateTo.Date != DateTime.MaxValue.Date))
{
query = query.Where(row => row.StartDate <= criteria.StartDate.DateTo);
}
if (criteria.Year != null)
{
query = query.Where(row => row.Year == criteria.Year);
}
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.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 static WeekInfoList WeekFetchInfoList(WeekDataCriteria criteria)
{
return(WeekInfoList.FetchWeekInfoList(criteria));
}
public static WeekInfoList WeekFetchInfoList(WeekDataCriteria criteria)
{
return WeekInfoList.FetchWeekInfoList(criteria);
}
internal static Week FetchWeek(WeekDataCriteria criteria)
{
return Csla.DataPortal.Fetch<Week>(criteria);
}
internal static void DeleteWeek(WeekDataCriteria criteria)
{
Csla.DataPortal.Delete<Week>(criteria);
}
internal static void DeleteWeek(WeekDataCriteria criteria)
{
Csla.DataPortal.Delete <Week>(criteria);
}
internal static Week FetchWeek(WeekDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <Week>(criteria));
}
private void DataPortal_Fetch(WeekDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IWeekDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
