public void Delete(StatusDataCriteria criteria)
{
var data = MockDb.Statuses
.Where(row => row.StatusId == criteria.StatusId)
.Single();
MockDb.Statuses.Remove(data);
}
public void Delete(StatusDataCriteria criteria)
{
var data = MockDb.Statuses
.Where(row => row.StatusId == criteria.StatusId)
.Single();
MockDb.Statuses.Remove(data);
}
private void DataPortal_Delete(StatusDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IStatusDataFactory>();
dalFactory.Delete(criteria);
}
}
public StatusData Fetch(StatusDataCriteria criteria)
{
var data = MockDb.Statuses
.Where(row => row.StatusId == criteria.StatusId)
.Single();
data = this.Fetch(data);
return(data);
}
public StatusData Fetch(StatusDataCriteria criteria)
{
var data = MockDb.Statuses
.Where(row => row.StatusId == criteria.StatusId)
.Single();
data = this.Fetch(data);
return data;
}
public void Delete(StatusDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var status = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Statuses.DeleteObject(status);
ctx.ObjectContext.SaveChanges();
}
}
public void Delete(StatusDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var status = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Statuses.DeleteObject(status);
ctx.ObjectContext.SaveChanges();
}
}
public StatusData Fetch(StatusDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var status = this.Fetch(ctx, criteria)
.Single();
var statusData = new StatusData();
this.Fetch(status, statusData);
return(statusData);
}
}
public StatusData Fetch(StatusDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var status = this.Fetch(ctx, criteria)
.Single();
var statusData = new StatusData();
this.Fetch(status, statusData);
return statusData;
}
}
private void DataPortal_Fetch(StatusDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IStatusDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
private void DataPortal_Fetch(StatusDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IStatusDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild <StatusInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
private void DataPortal_Fetch(StatusDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IStatusDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild<StatusInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
public StatusData[] FetchInfoList(StatusDataCriteria criteria)
{
var query = MockDb.Statuses
.AsQueryable();
if (criteria.Name != null)
{
query = query.Where(row => row.Name == criteria.Name);
}
var statuses = query.AsQueryable();
var data = new List <StatusData>();
foreach (var status in statuses)
{
data.Add(this.Fetch(status));
}
return(data.ToArray());
}
public StatusData[] FetchInfoList(StatusDataCriteria criteria)
{
var query = MockDb.Statuses
.AsQueryable();
if (criteria.Name != null)
{
query = query.Where(row => row.Name == criteria.Name);
}
var statuses = query.AsQueryable();
var data = new List<StatusData>();
foreach (var status in statuses)
{
data.Add(this.Fetch(status));
}
return data.ToArray();
}
public StatusData[] FetchLookupInfoList(StatusDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var statuss = this.Fetch(ctx, criteria)
.AsEnumerable();
var statusDataList = new List <StatusData>();
foreach (var status in statuss)
{
var statusData = new StatusData();
this.Fetch(status, statusData);
statusDataList.Add(statusData);
}
return(statusDataList.ToArray());
}
}
public StatusData[] FetchLookupInfoList(StatusDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var statuss = this.Fetch(ctx, criteria)
.AsEnumerable();
var statusDataList = new List<StatusData>();
foreach (var status in statuss)
{
var statusData = new StatusData();
this.Fetch(status, statusData);
statusDataList.Add(statusData);
}
return statusDataList.ToArray();
}
}
internal static Status FetchStatus(StatusDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <Status>(criteria));
}
private void DataPortal_Fetch(StatusDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IStatusDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
private void DataPortal_Delete(StatusDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IStatusDataFactory>();
dalFactory.Delete(criteria);
}
}
private IQueryable <Status> Fetch(
Csla.Data.ObjectContextManager <ApplicationEntities> ctx,
StatusDataCriteria criteria)
{
IQueryable <Status> query = ctx.ObjectContext.Statuses
.Include("Project")
.Include("CreatedByUser")
.Include("ModifiedByUser");
if (criteria.StatusId != null)
{
query = query.Where(row => row.StatusId == criteria.StatusId);
}
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.IsCompleted != null)
{
query = query.Where(row => row.IsCompleted == criteria.IsCompleted);
}
if (criteria.IsStarted != null)
{
query = query.Where(row => row.IsStarted == criteria.IsStarted);
}
if (criteria.Name != null)
{
query = query.Where(row => row.Name == criteria.Name);
}
if (criteria.Ordinal != null)
{
query = query.Where(row => row.Ordinal == criteria.Ordinal);
}
if (criteria.ProjectId != null)
{
query = query.Where(row => row.ProjectId == criteria.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);
}
public static StatusInfoList StatusFetchInfoList(StatusDataCriteria criteria)
{
return StatusInfoList.FetchStatusInfoList(criteria);
}
internal static Status FetchStatus(StatusDataCriteria criteria)
{
return Csla.DataPortal.Fetch<Status>(criteria);
}
internal static void DeleteStatus(StatusDataCriteria criteria)
{
Csla.DataPortal.Delete<Status>(criteria);
}
internal static StatusInfoList FetchStatusInfoList(StatusDataCriteria criteria)
{
return Csla.DataPortal.Fetch<StatusInfoList>(criteria);
}
public static StatusInfoList StatusFetchInfoList(StatusDataCriteria criteria)
{
return(StatusInfoList.FetchStatusInfoList(criteria));
}
internal static void DeleteStatus(StatusDataCriteria criteria)
{
Csla.DataPortal.Delete <Status>(criteria);
}
internal static StatusInfoList FetchStatusInfoList(StatusDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <StatusInfoList>(criteria));
}
private IQueryable<Status> Fetch(
Csla.Data.ObjectContextManager<ApplicationEntities> ctx,
StatusDataCriteria criteria)
{
IQueryable<Status> query = ctx.ObjectContext.Statuses
.Include("Project")
.Include("CreatedByUser")
.Include("ModifiedByUser");
if (criteria.StatusId != null)
{
query = query.Where(row => row.StatusId == criteria.StatusId);
}
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.IsCompleted != null)
{
query = query.Where(row => row.IsCompleted == criteria.IsCompleted);
}
if (criteria.IsStarted != null)
{
query = query.Where(row => row.IsStarted == criteria.IsStarted);
}
if (criteria.Name != null)
{
query = query.Where(row => row.Name == criteria.Name);
}
if (criteria.Ordinal != null)
{
query = query.Where(row => row.Ordinal == criteria.Ordinal);
}
if (criteria.ProjectId != null)
{
query = query.Where(row => row.ProjectId == criteria.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;
}
