public UserData[] FetchInfoList(UserDataCriteria criteria)
{
var query = MockDb.Users
.AsQueryable();
if (criteria.Email != null)
{
query = query.Where(row => row.Email == criteria.Email);
}
if (criteria.Name != null)
{
query = query.Where(row => row.Name == criteria.Name);
}
if (criteria.Token != null)
{
query = query.Where(row => row.Token == criteria.Token);
}
var users = query.AsQueryable();
var data = new List<UserData>();
foreach (var user in users)
{
data.Add(this.Fetch(user));
}
return data.ToArray();
}
public void Delete(UserDataCriteria criteria)
{
var data = MockDb.Users
.Where(row => row.UserId == criteria.UserId)
.Single();
MockDb.Users.Remove(data);
}
public UserData Fetch(UserDataCriteria criteria)
{
var data = MockDb.Users
.Where(row => row.UserId == criteria.UserId)
.Single();
data = this.Fetch(data);
return data;
}
public void Delete(UserDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var user = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Users.DeleteObject(user);
ctx.ObjectContext.SaveChanges();
}
}
public void Delete(UserDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var user = this.Fetch(ctx, criteria)
.Single();
ctx.ObjectContext.Users.DeleteObject(user);
ctx.ObjectContext.SaveChanges();
}
}
public UserData Fetch(UserDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var user = this.Fetch(ctx, criteria)
.Single();
var userData = new UserData();
this.Fetch(user, userData);
return(userData);
}
}
public UserData Fetch(UserDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var user = this.Fetch(ctx, criteria)
.Single();
var userData = new UserData();
this.Fetch(user, userData);
return userData;
}
}
private void DataPortal_Fetch(UserDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IUserDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
private void DataPortal_Fetch(UserDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IUserDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild<UserInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
private void DataPortal_Fetch(UserDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider <IUserDataFactory>();
var data = dalFactory.FetchInfoList(criteria);
this.RaiseListChangedEvents = false;
this.IsReadOnly = false;
this.AddRange(data.Select(row => Csla.DataPortal.FetchChild <UserInfo>(row)));
this.IsReadOnly = true;
this.RaiseListChangedEvents = true;
}
}
public UserData[] FetchLookupInfoList(UserDataCriteria criteria)
{
var query = MockDb.Users
.AsQueryable();
if (criteria.Name != null)
{
query = query.Where(row => row.Name == criteria.Name);
}
if (criteria.Email != null)
{
query = query.Where(row => row.Email == criteria.Email);
}
var data = query.AsQueryable();
return(data.ToArray());
}
public UserData[] FetchLookupInfoList(UserDataCriteria criteria)
{
var query = MockDb.Users
.AsQueryable();
if (criteria.Name != null)
{
query = query.Where(row => row.Name == criteria.Name);
}
if (criteria.Email != null)
{
query = query.Where(row => row.Email == criteria.Email);
}
var data = query.AsQueryable();
return data.ToArray();
}
public UserData[] FetchLookupInfoList(UserDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager<ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var users = this.Fetch(ctx, criteria)
.AsEnumerable();
var userDataList = new List<UserData>();
foreach (var user in users)
{
var userData = new UserData();
this.Fetch(user, userData);
userDataList.Add(userData);
}
return userDataList.ToArray();
}
}
public UserData[] FetchLookupInfoList(UserDataCriteria criteria)
{
using (var ctx = Csla.Data.ObjectContextManager <ApplicationEntities>
.GetManager(Database.ApplicationConnection, false))
{
var users = this.Fetch(ctx, criteria)
.AsEnumerable();
var userDataList = new List <UserData>();
foreach (var user in users)
{
var userData = new UserData();
this.Fetch(user, userData);
userDataList.Add(userData);
}
return(userDataList.ToArray());
}
}
public static UserInfoList UserFetchInfoList(UserDataCriteria criteria)
{
return(UserInfoList.FetchUserInfoList(criteria));
}
public static UserInfoList UserFetchInfoList(UserDataCriteria criteria)
{
return UserInfoList.FetchUserInfoList(criteria);
}
private IQueryable <User> Fetch(
Csla.Data.ObjectContextManager <ApplicationEntities> ctx,
UserDataCriteria criteria)
{
IQueryable <User> query = ctx.ObjectContext.Users;
if (criteria.UserId != null)
{
query = query.Where(row => row.UserId == criteria.UserId);
}
if (criteria.Name != null)
{
query = query.Where(row => row.Name == criteria.Name);
}
if (criteria.Email != null)
{
query = query.Where(row => row.Email == criteria.Email);
}
if (criteria.Password != null)
{
query = query.Where(row => row.Password == criteria.Password);
}
if (criteria.Salt != null)
{
query = query.Where(row => row.Salt == criteria.Salt);
}
if (criteria.Token != null)
{
query = query.Where(row => row.Token == criteria.Token);
}
if (criteria.IsActive != null)
{
query = query.Where(row => row.IsActive == criteria.IsActive);
}
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.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.ProjectId != null)
{
query = query.Join(
ctx.ObjectContext.ProjectUserMembers.Where(pum => criteria.ProjectId.Contains(pum.ProjectId)),
u => u.UserId,
pum => pum.UserId,
(u, pum) => u).Distinct();
}
if (criteria.Text != null)
{
query = query.Where(row => row.Name.Contains(criteria.Text) ||
row.Email.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 IQueryable<User> Fetch(
Csla.Data.ObjectContextManager<ApplicationEntities> ctx,
UserDataCriteria criteria)
{
IQueryable<User> query = ctx.ObjectContext.Users;
if (criteria.UserId != null)
{
query = query.Where(row => row.UserId == criteria.UserId);
}
if (criteria.Name != null)
{
query = query.Where(row => row.Name == criteria.Name);
}
if (criteria.Email != null)
{
query = query.Where(row => row.Email == criteria.Email);
}
if (criteria.Password != null)
{
query = query.Where(row => row.Password == criteria.Password);
}
if (criteria.Salt != null)
{
query = query.Where(row => row.Salt == criteria.Salt);
}
if (criteria.Token != null)
{
query = query.Where(row => row.Token == criteria.Token);
}
if (criteria.IsActive != null)
{
query = query.Where(row => row.IsActive == criteria.IsActive);
}
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.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.ProjectId != null)
{
query = query.Join(
ctx.ObjectContext.ProjectUserMembers.Where(pum => criteria.ProjectId.Contains(pum.ProjectId)),
u => u.UserId,
pum => pum.UserId,
(u, pum) => u).Distinct();
}
if (criteria.Text != null)
{
query = query.Where(row => row.Name.Contains(criteria.Text)
|| row.Email.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 UserInfoList FetchUserInfoList(UserDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <UserInfoList>(criteria));
}
private void DataPortal_Fetch(UserDataCriteria criteria)
{
using (var dalManager = DataFactoryManager.GetManager())
{
var dalFactory = dalManager.GetProvider<IUserDataFactory>();
var data = dalFactory.Fetch(criteria);
using (this.BypassPropertyChecks)
{
this.Fetch(data);
}
// this.ChildPropertyName = Csla.DataPortal.FetchChild<ChildPropertType>(data);
}
}
internal static UserInfoList FetchUserInfoList(UserDataCriteria criteria)
{
return Csla.DataPortal.Fetch<UserInfoList>(criteria);
}
internal static User FetchUser(UserDataCriteria criteria)
{
return(Csla.DataPortal.Fetch <User>(criteria));
}
internal static User FetchUser(UserDataCriteria criteria)
{
return Csla.DataPortal.Fetch<User>(criteria);
}
