public static OrganizationInfoList OrganizationFetchInfoList(OrganizationDataCriteria criteria)
{
// this will ensure that users can only view organizations that they are assigned to
criteria.UserId =
((IBusinessIdentity)Csla.ApplicationContext.User.Identity).UserId;
return(OrganizationInfoList.FetchOrganizationInfoList(criteria));
}
public void Delete(OrganizationDataCriteria criteria)
{
var data = MockDb.Organizations
.Where(row => row.OrganizationId == criteria.OrganizationId)
.Single();
MockDb.Organizations.Remove(data);
}
public static OrganizationInfoList OrganizationFetchInfoList(OrganizationDataCriteria criteria)
{
// this will ensure that users can only view organizations that they are assigned to
criteria.UserId =
((IBusinessIdentity)Csla.ApplicationContext.User.Identity).UserId;
return OrganizationInfoList.FetchOrganizationInfoList(criteria);
}
public void Delete(OrganizationDataCriteria criteria)
{
var data = MockDb.Organizations
.Where(row => row.OrganizationId == criteria.OrganizationId)
.Single();
MockDb.Organizations.Remove(data);
}
private void DataPortal_Delete(OrganizationDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IOrganizationDataFactory>();
dalFactory.Delete(criteria);
}
}
public OrganizationData[] FetchLookupInfoList(OrganizationDataCriteria criteria)
{
var query = MockDb.Organizations
.AsQueryable();
var data = query.AsQueryable();
return(data.ToArray());
}
public OrganizationData[] FetchLookupInfoList(OrganizationDataCriteria criteria)
{
var query = MockDb.Organizations
.AsQueryable();
var data = query.AsQueryable();
return data.ToArray();
}
public OrganizationData Fetch(OrganizationDataCriteria criteria)
{
var data = MockDb.Organizations
.Where(row => row.OrganizationId == criteria.OrganizationId)
.Single();
data = this.Fetch(data);
return(data);
}
public OrganizationData Fetch(OrganizationDataCriteria criteria)
{
var data = MockDb.Organizations
.Where(row => row.OrganizationId == criteria.OrganizationId)
.Single();
data = this.Fetch(data);
return data;
}
public void Delete(OrganizationDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var organization = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Organizations.DeleteObject(organization);
ctx.ObjectContext.SaveChanges();
}
}
public void Delete(OrganizationDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var organization = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Organizations.DeleteObject(organization);
ctx.ObjectContext.SaveChanges();
}
}
public OrganizationData Fetch(OrganizationDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var organization = this.Fetch(ctx, criteria)
.Single();
var organizationData = new OrganizationData();
this.Fetch(organization, organizationData);
return(organizationData);
}
}
public OrganizationData Fetch(OrganizationDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var organization = this.Fetch(ctx, criteria)
.Single();
var organizationData = new OrganizationData();
this.Fetch(organization, organizationData);
return organizationData;
}
}
public OrganizationData[] FetchInfoList(OrganizationDataCriteria criteria)
{
var query = MockDb.Organizations
.AsQueryable();
var organizations = query.AsQueryable();
var data = new List <OrganizationData>();
foreach (var organization in organizations)
{
data.Add(this.Fetch(organization));
}
return(data.ToArray());
}
public OrganizationData[] FetchInfoList(OrganizationDataCriteria criteria)
{
var query = MockDb.Organizations
.AsQueryable();
var organizations = query.AsQueryable();
var data = new List<OrganizationData>();
foreach (var organization in organizations)
{
data.Add(this.Fetch(organization));
}
return data.ToArray();
}
private void DataPortal_Fetch(OrganizationDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IOrganizationDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
private void DataPortal_Fetch(OrganizationDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IOrganizationDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild<OrganizationInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
private void DataPortal_Fetch(OrganizationDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IOrganizationDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild <OrganizationInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
public OrganizationData[] FetchLookupInfoList(OrganizationDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var organizations = this.Fetch(ctx, criteria)
.AsEnumerable();
var organizationDataList = new List <OrganizationData>();
foreach (var organization in organizations)
{
var organizationData = new OrganizationData();
this.Fetch(organization, organizationData);
organizationDataList.Add(organizationData);
}
return(organizationDataList.ToArray());
}
}
public OrganizationData[] FetchLookupInfoList(OrganizationDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var organizations = this.Fetch(ctx, criteria)
.AsEnumerable();
var organizationDataList = new List<OrganizationData>();
foreach (var organization in organizations)
{
var organizationData = new OrganizationData();
this.Fetch(organization, organizationData);
organizationDataList.Add(organizationData);
}
return organizationDataList.ToArray();
}
}
internal static OrganizationInfoList FetchOrganizationInfoList(OrganizationDataCriteria criteria)
{
return Csla.DataPortal.Fetch<OrganizationInfoList>(criteria);
}
internal static void DeleteOrganization(OrganizationDataCriteria criteria)
{
Csla.DataPortal.Delete <Organization>(criteria);
}
internal static Organization FetchOrganization(OrganizationDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <Organization>(criteria));
}
private IQueryable <Organization> Fetch(
Csla.Data.ObjectContextManager <ApplicationEntities> ctx,
OrganizationDataCriteria criteria)
{
IQueryable <Organization> query = ctx.ObjectContext.Organizations
.Include("CreatedByUser")
.Include("ModifiedByUser");
if (criteria.OrganizationId != null)
{
query = query.Where(row => row.OrganizationId == criteria.OrganizationId);
}
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.OrganizationUserMembers.Where(pum => pum.UserId == criteria.UserId),
p => p.OrganizationId,
pum => pum.OrganizationId,
(p, cssm) => 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 OrganizationInfoList FetchOrganizationInfoList(OrganizationDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <OrganizationInfoList>(criteria));
}
internal static void DeleteOrganization(OrganizationDataCriteria criteria)
{
Csla.DataPortal.Delete<Organization>(criteria);
}
internal static Organization FetchOrganization(OrganizationDataCriteria criteria)
{
return Csla.DataPortal.Fetch<Organization>(criteria);
}
private IQueryable<Organization> Fetch(
Csla.Data.ObjectContextManager<ApplicationEntities> ctx,
OrganizationDataCriteria criteria)
{
IQueryable<Organization> query = ctx.ObjectContext.Organizations
.Include("CreatedByUser")
.Include("ModifiedByUser");
if (criteria.OrganizationId != null)
{
query = query.Where(row => row.OrganizationId == criteria.OrganizationId);
}
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.OrganizationUserMembers.Where(pum => pum.UserId == criteria.UserId),
p => p.OrganizationId,
pum => pum.OrganizationId,
(p, cssm) => 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;
}
private void DataPortal_Fetch(OrganizationDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IOrganizationDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
private void DataPortal_Delete(OrganizationDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IOrganizationDataFactory>();
dalFactory.Delete(criteria);
}
}
