public static IQueryable<Petshop.Data.Entities.Category> ByCategoryId(this IQueryable<Petshop.Data.Entities.Category> queryable, ContainmentOperator containmentOperator, System.String categoryId)
{
if (categoryId == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("categoryId", "Parameter 'categoryId' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(c => c.CategoryId.Contains(categoryId));
case ContainmentOperator.StartsWith:
return queryable.Where(c => c.CategoryId.StartsWith(categoryId));
case ContainmentOperator.EndsWith:
return queryable.Where(c => c.CategoryId.EndsWith(categoryId));
case ContainmentOperator.NotContains:
return queryable.Where(c => c.CategoryId.Contains(categoryId) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(c => c.CategoryId != categoryId);
default:
return queryable.Where(c => c.CategoryId == categoryId);
}
}
public static IQueryable<PetShop.Core.Data.Inventory> ByItemId(this IQueryable<PetShop.Core.Data.Inventory> queryable, ContainmentOperator containmentOperator, string itemId)
{
if (itemId == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("itemId", "Parameter 'itemId' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(i => i.ItemId.Contains(itemId));
case ContainmentOperator.StartsWith:
return queryable.Where(i => i.ItemId.StartsWith(itemId));
case ContainmentOperator.EndsWith:
return queryable.Where(i => i.ItemId.EndsWith(itemId));
case ContainmentOperator.NotContains:
return queryable.Where(i => i.ItemId.Contains(itemId) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(i => i.ItemId != itemId);
default:
return queryable.Where(i => i.ItemId == itemId);
}
}
public static IQueryable <Abeced.Data.QuizScore> ByIdentification(this IQueryable <Abeced.Data.QuizScore> queryable, ContainmentOperator containmentOperator, System.String identification)
{
if (identification == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("identification", "Parameter 'identification' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(q => q.Identification.Contains(identification)));
case ContainmentOperator.StartsWith:
return(queryable.Where(q => q.Identification.StartsWith(identification)));
case ContainmentOperator.EndsWith:
return(queryable.Where(q => q.Identification.EndsWith(identification)));
case ContainmentOperator.NotContains:
return(queryable.Where(q => q.Identification.Contains(identification) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(q => q.Identification != identification));
default:
return(queryable.Where(q => q.Identification == identification));
}
}
public static IQueryable<Petshop.Data.Entities.Order> ByBillCity(this IQueryable<Petshop.Data.Entities.Order> queryable, ContainmentOperator containmentOperator, System.String billCity)
{
if (billCity == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("billCity", "Parameter 'billCity' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(o => o.BillCity.Contains(billCity));
case ContainmentOperator.StartsWith:
return queryable.Where(o => o.BillCity.StartsWith(billCity));
case ContainmentOperator.EndsWith:
return queryable.Where(o => o.BillCity.EndsWith(billCity));
case ContainmentOperator.NotContains:
return queryable.Where(o => o.BillCity.Contains(billCity) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(o => o.BillCity != billCity);
default:
return queryable.Where(o => o.BillCity == billCity);
}
}
public static IQueryable<PetShop.Core.Data.Supplier> ByPhone(this IQueryable<PetShop.Core.Data.Supplier> queryable, ContainmentOperator containmentOperator, string phone)
{
if (phone == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("phone", "Parameter 'phone' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(s => s.Phone.Contains(phone));
case ContainmentOperator.StartsWith:
return queryable.Where(s => s.Phone.StartsWith(phone));
case ContainmentOperator.EndsWith:
return queryable.Where(s => s.Phone.EndsWith(phone));
case ContainmentOperator.NotContains:
return queryable.Where(s => s.Phone.Contains(phone) == false);
case ContainmentOperator.NotEquals:
return phone == null
? queryable.Where(s => s.Phone != null)
: queryable.Where(s => s.Phone != phone);
default:
return phone == null
? queryable.Where(s => s.Phone == null)
: queryable.Where(s => s.Phone == phone);
}
}
public static IQueryable<PetShop.Core.Data.Supplier> ByStatus(this IQueryable<PetShop.Core.Data.Supplier> queryable, ContainmentOperator containmentOperator, string status)
{
if (status == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("status", "Parameter 'status' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(s => s.Status.Contains(status));
case ContainmentOperator.StartsWith:
return queryable.Where(s => s.Status.StartsWith(status));
case ContainmentOperator.EndsWith:
return queryable.Where(s => s.Status.EndsWith(status));
case ContainmentOperator.NotContains:
return queryable.Where(s => s.Status.Contains(status) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(s => s.Status != status);
default:
return queryable.Where(s => s.Status == status);
}
}
public static IQueryable<Tracker.Core.Data.Task> ByDetails(this IQueryable<Tracker.Core.Data.Task> queryable, ContainmentOperator containmentOperator, string details)
{
if (details == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("details", "Parameter 'details' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(t => t.Details.Contains(details));
case ContainmentOperator.StartsWith:
return queryable.Where(t => t.Details.StartsWith(details));
case ContainmentOperator.EndsWith:
return queryable.Where(t => t.Details.EndsWith(details));
case ContainmentOperator.NotContains:
return queryable.Where(t => t.Details.Contains(details) == false);
case ContainmentOperator.NotEquals:
return details == null
? queryable.Where(t => t.Details != null)
: queryable.Where(t => t.Details != details);
default:
return details == null
? queryable.Where(t => t.Details == null)
: queryable.Where(t => t.Details == details);
}
}
public static IQueryable <SmartSocial.Data.AspNetUserClaims> ByClaimValue(this IQueryable <SmartSocial.Data.AspNetUserClaims> queryable, ContainmentOperator containmentOperator, string claimValue)
{
if (claimValue == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("claimValue", "Parameter 'claimValue' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(a => a.ClaimValue.Contains(claimValue)));
case ContainmentOperator.StartsWith:
return(queryable.Where(a => a.ClaimValue.StartsWith(claimValue)));
case ContainmentOperator.EndsWith:
return(queryable.Where(a => a.ClaimValue.EndsWith(claimValue)));
case ContainmentOperator.NotContains:
return(queryable.Where(a => a.ClaimValue.Contains(claimValue) == false));
case ContainmentOperator.NotEquals:
return(claimValue == null
? queryable.Where(a => a.ClaimValue != null)
: queryable.Where(a => a.ClaimValue != claimValue));
default:
return(claimValue == null
? queryable.Where(a => a.ClaimValue == null)
: queryable.Where(a => a.ClaimValue == claimValue));
}
}
public static IQueryable <Abeced.Data.LookupRevisetime> ByRptDescription(this IQueryable <Abeced.Data.LookupRevisetime> queryable, ContainmentOperator containmentOperator, System.String rptDescription)
{
if (rptDescription == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("rptDescription", "Parameter 'rptDescription' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(l => l.RptDescription.Contains(rptDescription)));
case ContainmentOperator.StartsWith:
return(queryable.Where(l => l.RptDescription.StartsWith(rptDescription)));
case ContainmentOperator.EndsWith:
return(queryable.Where(l => l.RptDescription.EndsWith(rptDescription)));
case ContainmentOperator.NotContains:
return(queryable.Where(l => l.RptDescription.Contains(rptDescription) == false));
case ContainmentOperator.NotEquals:
return(rptDescription == null
? queryable.Where(l => l.RptDescription != null)
: queryable.Where(l => l.RptDescription != rptDescription));
default:
return(rptDescription == null
? queryable.Where(l => l.RptDescription == null)
: queryable.Where(l => l.RptDescription == rptDescription));
}
}
public static IQueryable <Tracker.Core.Data.Role> ByName(this IQueryable <Tracker.Core.Data.Role> queryable, ContainmentOperator containmentOperator, string name)
{
if (name == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("name", "Parameter 'name' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(r => r.Name.Contains(name)));
case ContainmentOperator.StartsWith:
return(queryable.Where(r => r.Name.StartsWith(name)));
case ContainmentOperator.EndsWith:
return(queryable.Where(r => r.Name.EndsWith(name)));
case ContainmentOperator.NotContains:
return(queryable.Where(r => r.Name.Contains(name) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(r => r.Name != name));
default:
return(queryable.Where(r => r.Name == name));
}
}
public static IQueryable <Petshop.Data.Entities.Inventory> ByItemId(this IQueryable <Petshop.Data.Entities.Inventory> queryable, ContainmentOperator containmentOperator, System.String itemId)
{
if (itemId == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("itemId", "Parameter 'itemId' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(i => i.ItemId.Contains(itemId)));
case ContainmentOperator.StartsWith:
return(queryable.Where(i => i.ItemId.StartsWith(itemId)));
case ContainmentOperator.EndsWith:
return(queryable.Where(i => i.ItemId.EndsWith(itemId)));
case ContainmentOperator.NotContains:
return(queryable.Where(i => i.ItemId.Contains(itemId) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(i => i.ItemId != itemId));
default:
return(queryable.Where(i => i.ItemId == itemId));
}
}
public static IQueryable <Petshop.Data.Entities.Supplier> ByPhone(this IQueryable <Petshop.Data.Entities.Supplier> queryable, ContainmentOperator containmentOperator, System.String phone)
{
if (phone == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("phone", "Parameter 'phone' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(s => s.Phone.Contains(phone)));
case ContainmentOperator.StartsWith:
return(queryable.Where(s => s.Phone.StartsWith(phone)));
case ContainmentOperator.EndsWith:
return(queryable.Where(s => s.Phone.EndsWith(phone)));
case ContainmentOperator.NotContains:
return(queryable.Where(s => s.Phone.Contains(phone) == false));
case ContainmentOperator.NotEquals:
return(phone == null
? queryable.Where(s => s.Phone != null)
: queryable.Where(s => s.Phone != phone));
default:
return(phone == null
? queryable.Where(s => s.Phone == null)
: queryable.Where(s => s.Phone == phone));
}
}
public static IQueryable <Petshop.Data.Entities.Supplier> ByAddr2(this IQueryable <Petshop.Data.Entities.Supplier> queryable, ContainmentOperator containmentOperator, System.String addr2)
{
if (addr2 == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("addr2", "Parameter 'addr2' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(s => s.Addr2.Contains(addr2)));
case ContainmentOperator.StartsWith:
return(queryable.Where(s => s.Addr2.StartsWith(addr2)));
case ContainmentOperator.EndsWith:
return(queryable.Where(s => s.Addr2.EndsWith(addr2)));
case ContainmentOperator.NotContains:
return(queryable.Where(s => s.Addr2.Contains(addr2) == false));
case ContainmentOperator.NotEquals:
return(addr2 == null
? queryable.Where(s => s.Addr2 != null)
: queryable.Where(s => s.Addr2 != addr2));
default:
return(addr2 == null
? queryable.Where(s => s.Addr2 == null)
: queryable.Where(s => s.Addr2 == addr2));
}
}
public static IQueryable <Tracker.Core.Data.TaskExtended> ByOs(this IQueryable <Tracker.Core.Data.TaskExtended> queryable, ContainmentOperator containmentOperator, string os)
{
if (os == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("os", "Parameter 'os' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(t => t.Os.Contains(os)));
case ContainmentOperator.StartsWith:
return(queryable.Where(t => t.Os.StartsWith(os)));
case ContainmentOperator.EndsWith:
return(queryable.Where(t => t.Os.EndsWith(os)));
case ContainmentOperator.NotContains:
return(queryable.Where(t => t.Os.Contains(os) == false));
case ContainmentOperator.NotEquals:
return(os == null
? queryable.Where(t => t.Os != null)
: queryable.Where(t => t.Os != os));
default:
return(os == null
? queryable.Where(t => t.Os == null)
: queryable.Where(t => t.Os == os));
}
}
public static IQueryable <Petshop.Data.Entities.Cart> ByType(this IQueryable <Petshop.Data.Entities.Cart> queryable, ContainmentOperator containmentOperator, System.String type)
{
if (type == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("type", "Parameter 'type' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(c => c.Type.Contains(type)));
case ContainmentOperator.StartsWith:
return(queryable.Where(c => c.Type.StartsWith(type)));
case ContainmentOperator.EndsWith:
return(queryable.Where(c => c.Type.EndsWith(type)));
case ContainmentOperator.NotContains:
return(queryable.Where(c => c.Type.Contains(type) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(c => c.Type != type));
default:
return(queryable.Where(c => c.Type == type));
}
}
public static IQueryable <Nsun.Domain.DataContent.UserInfo> ByEmail(this IQueryable <Nsun.Domain.DataContent.UserInfo> queryable, ContainmentOperator containmentOperator, System.String email)
{
if (email == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("email", "Parameter 'email' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(u => u.Email.Contains(email)));
case ContainmentOperator.StartsWith:
return(queryable.Where(u => u.Email.StartsWith(email)));
case ContainmentOperator.EndsWith:
return(queryable.Where(u => u.Email.EndsWith(email)));
case ContainmentOperator.NotContains:
return(queryable.Where(u => u.Email.Contains(email) == false));
case ContainmentOperator.NotEquals:
return(email == null
? queryable.Where(u => u.Email != null)
: queryable.Where(u => u.Email != email));
default:
return(email == null
? queryable.Where(u => u.Email == null)
: queryable.Where(u => u.Email == email));
}
}
public static IQueryable <Abeced.Data.LookupEducLevel> ByEducLevel(this IQueryable <Abeced.Data.LookupEducLevel> queryable, ContainmentOperator containmentOperator, System.String educLevel)
{
if (educLevel == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("educLevel", "Parameter 'educLevel' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(l => l.EducLevel.Contains(educLevel)));
case ContainmentOperator.StartsWith:
return(queryable.Where(l => l.EducLevel.StartsWith(educLevel)));
case ContainmentOperator.EndsWith:
return(queryable.Where(l => l.EducLevel.EndsWith(educLevel)));
case ContainmentOperator.NotContains:
return(queryable.Where(l => l.EducLevel.Contains(educLevel) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(l => l.EducLevel != educLevel));
default:
return(queryable.Where(l => l.EducLevel == educLevel));
}
}
public static IQueryable <Abeced.Data.LookupRevisetime> ByLkuprevisetime(this IQueryable <Abeced.Data.LookupRevisetime> queryable, ContainmentOperator containmentOperator, System.String lkuprevisetime)
{
if (lkuprevisetime == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("lkuprevisetime", "Parameter 'lkuprevisetime' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(l => l.Lkuprevisetime.Contains(lkuprevisetime)));
case ContainmentOperator.StartsWith:
return(queryable.Where(l => l.Lkuprevisetime.StartsWith(lkuprevisetime)));
case ContainmentOperator.EndsWith:
return(queryable.Where(l => l.Lkuprevisetime.EndsWith(lkuprevisetime)));
case ContainmentOperator.NotContains:
return(queryable.Where(l => l.Lkuprevisetime.Contains(lkuprevisetime) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(l => l.Lkuprevisetime != lkuprevisetime));
default:
return(queryable.Where(l => l.Lkuprevisetime == lkuprevisetime));
}
}
public static IQueryable <SmartSocial.Data.ChartComment> ByIdUser(this IQueryable <SmartSocial.Data.ChartComment> queryable, ContainmentOperator containmentOperator, string idUser)
{
if (idUser == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("idUser", "Parameter 'idUser' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(c => c.IdUser.Contains(idUser)));
case ContainmentOperator.StartsWith:
return(queryable.Where(c => c.IdUser.StartsWith(idUser)));
case ContainmentOperator.EndsWith:
return(queryable.Where(c => c.IdUser.EndsWith(idUser)));
case ContainmentOperator.NotContains:
return(queryable.Where(c => c.IdUser.Contains(idUser) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(c => c.IdUser != idUser));
default:
return(queryable.Where(c => c.IdUser == idUser));
}
}
public static IQueryable <Abeced.Data.PasswordReset> ByRequestid(this IQueryable <Abeced.Data.PasswordReset> queryable, ContainmentOperator containmentOperator, System.String requestid)
{
if (requestid == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("requestid", "Parameter 'requestid' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(p => p.Requestid.Contains(requestid)));
case ContainmentOperator.StartsWith:
return(queryable.Where(p => p.Requestid.StartsWith(requestid)));
case ContainmentOperator.EndsWith:
return(queryable.Where(p => p.Requestid.EndsWith(requestid)));
case ContainmentOperator.NotContains:
return(queryable.Where(p => p.Requestid.Contains(requestid) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(p => p.Requestid != requestid));
default:
return(queryable.Where(p => p.Requestid == requestid));
}
}
public static IQueryable<Petshop.Data.Entities.Item> ByImage(this IQueryable<Petshop.Data.Entities.Item> queryable, ContainmentOperator containmentOperator, System.String image)
{
if (image == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("image", "Parameter 'image' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(i => i.Image.Contains(image));
case ContainmentOperator.StartsWith:
return queryable.Where(i => i.Image.StartsWith(image));
case ContainmentOperator.EndsWith:
return queryable.Where(i => i.Image.EndsWith(image));
case ContainmentOperator.NotContains:
return queryable.Where(i => i.Image.Contains(image) == false);
case ContainmentOperator.NotEquals:
return image == null
? queryable.Where(i => i.Image != null)
: queryable.Where(i => i.Image != image);
default:
return image == null
? queryable.Where(i => i.Image == null)
: queryable.Where(i => i.Image == image);
}
}
public static IQueryable <Petshop.Data.Entities.OrderStatus> ByStatus(this IQueryable <Petshop.Data.Entities.OrderStatus> queryable, ContainmentOperator containmentOperator, System.String status)
{
if (status == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("status", "Parameter 'status' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(o => o.Status.Contains(status)));
case ContainmentOperator.StartsWith:
return(queryable.Where(o => o.Status.StartsWith(status)));
case ContainmentOperator.EndsWith:
return(queryable.Where(o => o.Status.EndsWith(status)));
case ContainmentOperator.NotContains:
return(queryable.Where(o => o.Status.Contains(status) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(o => o.Status != status));
default:
return(queryable.Where(o => o.Status == status));
}
}
public static IQueryable<PetShop.Core.Data.Supplier> ByCity(this IQueryable<PetShop.Core.Data.Supplier> queryable, ContainmentOperator containmentOperator, string city)
{
if (city == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("city", "Parameter 'city' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(s => s.City.Contains(city));
case ContainmentOperator.StartsWith:
return queryable.Where(s => s.City.StartsWith(city));
case ContainmentOperator.EndsWith:
return queryable.Where(s => s.City.EndsWith(city));
case ContainmentOperator.NotContains:
return queryable.Where(s => s.City.Contains(city) == false);
case ContainmentOperator.NotEquals:
return city == null
? queryable.Where(s => s.City != null)
: queryable.Where(s => s.City != city);
default:
return city == null
? queryable.Where(s => s.City == null)
: queryable.Where(s => s.City == city);
}
}
public static IQueryable <SmartSocial.Data.SmartReport> ByInsights(this IQueryable <SmartSocial.Data.SmartReport> queryable, ContainmentOperator containmentOperator, string insights)
{
if (insights == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("insights", "Parameter 'insights' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(s => s.Insights.Contains(insights)));
case ContainmentOperator.StartsWith:
return(queryable.Where(s => s.Insights.StartsWith(insights)));
case ContainmentOperator.EndsWith:
return(queryable.Where(s => s.Insights.EndsWith(insights)));
case ContainmentOperator.NotContains:
return(queryable.Where(s => s.Insights.Contains(insights) == false));
case ContainmentOperator.NotEquals:
return(insights == null
? queryable.Where(s => s.Insights != null)
: queryable.Where(s => s.Insights != insights));
default:
return(insights == null
? queryable.Where(s => s.Insights == null)
: queryable.Where(s => s.Insights == insights));
}
}
public static IQueryable<Petshop.Data.Entities.Order> ByLocale(this IQueryable<Petshop.Data.Entities.Order> queryable, ContainmentOperator containmentOperator, System.String locale)
{
if (locale == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("locale", "Parameter 'locale' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(o => o.Locale.Contains(locale));
case ContainmentOperator.StartsWith:
return queryable.Where(o => o.Locale.StartsWith(locale));
case ContainmentOperator.EndsWith:
return queryable.Where(o => o.Locale.EndsWith(locale));
case ContainmentOperator.NotContains:
return queryable.Where(o => o.Locale.Contains(locale) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(o => o.Locale != locale);
default:
return queryable.Where(o => o.Locale == locale);
}
}
public static IQueryable <Abeced.Data.LookupSubcategory> ByTags(this IQueryable <Abeced.Data.LookupSubcategory> queryable, ContainmentOperator containmentOperator, System.String tags)
{
if (tags == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("tags", "Parameter 'tags' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(l => l.Tags.Contains(tags)));
case ContainmentOperator.StartsWith:
return(queryable.Where(l => l.Tags.StartsWith(tags)));
case ContainmentOperator.EndsWith:
return(queryable.Where(l => l.Tags.EndsWith(tags)));
case ContainmentOperator.NotContains:
return(queryable.Where(l => l.Tags.Contains(tags) == false));
case ContainmentOperator.NotEquals:
return(tags == null
? queryable.Where(l => l.Tags != null)
: queryable.Where(l => l.Tags != tags));
default:
return(tags == null
? queryable.Where(l => l.Tags == null)
: queryable.Where(l => l.Tags == tags));
}
}
public static IQueryable<PetShop.Core.Data.Order> ByBillState(this IQueryable<PetShop.Core.Data.Order> queryable, ContainmentOperator containmentOperator, string billState)
{
if (billState == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("billState", "Parameter 'billState' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(o => o.BillState.Contains(billState));
case ContainmentOperator.StartsWith:
return queryable.Where(o => o.BillState.StartsWith(billState));
case ContainmentOperator.EndsWith:
return queryable.Where(o => o.BillState.EndsWith(billState));
case ContainmentOperator.NotContains:
return queryable.Where(o => o.BillState.Contains(billState) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(o => o.BillState != billState);
default:
return queryable.Where(o => o.BillState == billState);
}
}
public static IQueryable <SmartSocial.Data.DataProviderXChartType> ByFileLoadFunctionName(this IQueryable <SmartSocial.Data.DataProviderXChartType> queryable, ContainmentOperator containmentOperator, string fileLoadFunctionName)
{
if (fileLoadFunctionName == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("fileLoadFunctionName", "Parameter 'fileLoadFunctionName' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(d => d.FileLoadFunctionName.Contains(fileLoadFunctionName)));
case ContainmentOperator.StartsWith:
return(queryable.Where(d => d.FileLoadFunctionName.StartsWith(fileLoadFunctionName)));
case ContainmentOperator.EndsWith:
return(queryable.Where(d => d.FileLoadFunctionName.EndsWith(fileLoadFunctionName)));
case ContainmentOperator.NotContains:
return(queryable.Where(d => d.FileLoadFunctionName.Contains(fileLoadFunctionName) == false));
case ContainmentOperator.NotEquals:
return(fileLoadFunctionName == null
? queryable.Where(d => d.FileLoadFunctionName != null)
: queryable.Where(d => d.FileLoadFunctionName != fileLoadFunctionName));
default:
return(fileLoadFunctionName == null
? queryable.Where(d => d.FileLoadFunctionName == null)
: queryable.Where(d => d.FileLoadFunctionName == fileLoadFunctionName));
}
}
public static IQueryable<Tracker.Data.Entities.Audit> ByUsername(this IQueryable<Tracker.Data.Entities.Audit> queryable, ContainmentOperator containmentOperator, System.String username)
{
if (username == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("username", "Parameter 'username' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(a => a.Username.Contains(username));
case ContainmentOperator.StartsWith:
return queryable.Where(a => a.Username.StartsWith(username));
case ContainmentOperator.EndsWith:
return queryable.Where(a => a.Username.EndsWith(username));
case ContainmentOperator.NotContains:
return queryable.Where(a => a.Username.Contains(username) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(a => a.Username != username);
default:
return queryable.Where(a => a.Username == username);
}
}
public static IQueryable <Tracker.Data.Entities.Status> ByDescription(this IQueryable <Tracker.Data.Entities.Status> queryable, ContainmentOperator containmentOperator, System.String description)
{
if (description == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("description", "Parameter 'description' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(s => s.Description.Contains(description)));
case ContainmentOperator.StartsWith:
return(queryable.Where(s => s.Description.StartsWith(description)));
case ContainmentOperator.EndsWith:
return(queryable.Where(s => s.Description.EndsWith(description)));
case ContainmentOperator.NotContains:
return(queryable.Where(s => s.Description.Contains(description) == false));
case ContainmentOperator.NotEquals:
return(description == null
? queryable.Where(s => s.Description != null)
: queryable.Where(s => s.Description != description));
default:
return(description == null
? queryable.Where(s => s.Description == null)
: queryable.Where(s => s.Description == description));
}
}
public static IQueryable <Nsun.Domain.DataContent.UserInfo> ByAddress(this IQueryable <Nsun.Domain.DataContent.UserInfo> queryable, ContainmentOperator containmentOperator, System.String address)
{
if (address == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("address", "Parameter 'address' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(u => u.Address.Contains(address)));
case ContainmentOperator.StartsWith:
return(queryable.Where(u => u.Address.StartsWith(address)));
case ContainmentOperator.EndsWith:
return(queryable.Where(u => u.Address.EndsWith(address)));
case ContainmentOperator.NotContains:
return(queryable.Where(u => u.Address.Contains(address) == false));
case ContainmentOperator.NotEquals:
return(address == null
? queryable.Where(u => u.Address != null)
: queryable.Where(u => u.Address != address));
default:
return(address == null
? queryable.Where(u => u.Address == null)
: queryable.Where(u => u.Address == address));
}
}
public static IQueryable<Tracker.Data.Entities.TaskExtended> ByOs(this IQueryable<Tracker.Data.Entities.TaskExtended> queryable, ContainmentOperator containmentOperator, System.String os)
{
if (os == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("os", "Parameter 'os' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(t => t.Os.Contains(os));
case ContainmentOperator.StartsWith:
return queryable.Where(t => t.Os.StartsWith(os));
case ContainmentOperator.EndsWith:
return queryable.Where(t => t.Os.EndsWith(os));
case ContainmentOperator.NotContains:
return queryable.Where(t => t.Os.Contains(os) == false);
case ContainmentOperator.NotEquals:
return os == null
? queryable.Where(t => t.Os != null)
: queryable.Where(t => t.Os != os);
default:
return os == null
? queryable.Where(t => t.Os == null)
: queryable.Where(t => t.Os == os);
}
}
public static IQueryable <Nsun.Domain.DataContent.UserInfo> ByLoginName(this IQueryable <Nsun.Domain.DataContent.UserInfo> queryable, ContainmentOperator containmentOperator, System.String loginName)
{
if (loginName == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("loginName", "Parameter 'loginName' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(u => u.LoginName.Contains(loginName)));
case ContainmentOperator.StartsWith:
return(queryable.Where(u => u.LoginName.StartsWith(loginName)));
case ContainmentOperator.EndsWith:
return(queryable.Where(u => u.LoginName.EndsWith(loginName)));
case ContainmentOperator.NotContains:
return(queryable.Where(u => u.LoginName.Contains(loginName) == false));
case ContainmentOperator.NotEquals:
return(loginName == null
? queryable.Where(u => u.LoginName != null)
: queryable.Where(u => u.LoginName != loginName));
default:
return(loginName == null
? queryable.Where(u => u.LoginName == null)
: queryable.Where(u => u.LoginName == loginName));
}
}
public static IQueryable <Tracker.Data.Entities.Audit> ByUsername(this IQueryable <Tracker.Data.Entities.Audit> queryable, ContainmentOperator containmentOperator, System.String username)
{
if (username == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("username", "Parameter 'username' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(a => a.Username.Contains(username)));
case ContainmentOperator.StartsWith:
return(queryable.Where(a => a.Username.StartsWith(username)));
case ContainmentOperator.EndsWith:
return(queryable.Where(a => a.Username.EndsWith(username)));
case ContainmentOperator.NotContains:
return(queryable.Where(a => a.Username.Contains(username) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(a => a.Username != username));
default:
return(queryable.Where(a => a.Username == username));
}
}
public static IQueryable <SmartSocial.Data.AspNetUserClaims> ByUserId(this IQueryable <SmartSocial.Data.AspNetUserClaims> queryable, ContainmentOperator containmentOperator, string userId)
{
if (userId == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("userId", "Parameter 'userId' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(a => a.UserId.Contains(userId)));
case ContainmentOperator.StartsWith:
return(queryable.Where(a => a.UserId.StartsWith(userId)));
case ContainmentOperator.EndsWith:
return(queryable.Where(a => a.UserId.EndsWith(userId)));
case ContainmentOperator.NotContains:
return(queryable.Where(a => a.UserId.Contains(userId) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(a => a.UserId != userId));
default:
return(queryable.Where(a => a.UserId == userId));
}
}
public static IQueryable <Tracker.Data.Entities.Audit> ByMyxml(this IQueryable <Tracker.Data.Entities.Audit> queryable, ContainmentOperator containmentOperator, System.String myxml)
{
if (myxml == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("myxml", "Parameter 'myxml' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(a => a.Myxml.Contains(myxml)));
case ContainmentOperator.StartsWith:
return(queryable.Where(a => a.Myxml.StartsWith(myxml)));
case ContainmentOperator.EndsWith:
return(queryable.Where(a => a.Myxml.EndsWith(myxml)));
case ContainmentOperator.NotContains:
return(queryable.Where(a => a.Myxml.Contains(myxml) == false));
case ContainmentOperator.NotEquals:
return(myxml == null
? queryable.Where(a => a.Myxml != null)
: queryable.Where(a => a.Myxml != myxml));
default:
return(myxml == null
? queryable.Where(a => a.Myxml == null)
: queryable.Where(a => a.Myxml == myxml));
}
}
public static IQueryable <Abeced.Data.LookupCategory> ByCatid(this IQueryable <Abeced.Data.LookupCategory> queryable, ContainmentOperator containmentOperator, System.String catid)
{
if (catid == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("catid", "Parameter 'catid' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(l => l.Catid.Contains(catid)));
case ContainmentOperator.StartsWith:
return(queryable.Where(l => l.Catid.StartsWith(catid)));
case ContainmentOperator.EndsWith:
return(queryable.Where(l => l.Catid.EndsWith(catid)));
case ContainmentOperator.NotContains:
return(queryable.Where(l => l.Catid.Contains(catid) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(l => l.Catid != catid));
default:
return(queryable.Where(l => l.Catid == catid));
}
}
public static IQueryable<PetShop.Core.Data.Product> ByDescn(this IQueryable<PetShop.Core.Data.Product> queryable, ContainmentOperator containmentOperator, string descn)
{
if (descn == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("descn", "Parameter 'descn' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(p => p.Descn.Contains(descn));
case ContainmentOperator.StartsWith:
return queryable.Where(p => p.Descn.StartsWith(descn));
case ContainmentOperator.EndsWith:
return queryable.Where(p => p.Descn.EndsWith(descn));
case ContainmentOperator.NotContains:
return queryable.Where(p => p.Descn.Contains(descn) == false);
case ContainmentOperator.NotEquals:
return descn == null
? queryable.Where(p => p.Descn != null)
: queryable.Where(p => p.Descn != descn);
default:
return descn == null
? queryable.Where(p => p.Descn == null)
: queryable.Where(p => p.Descn == descn);
}
}
public static IQueryable <SmartSocial.Data.ChartComment> ByMessage(this IQueryable <SmartSocial.Data.ChartComment> queryable, ContainmentOperator containmentOperator, string message)
{
if (message == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("message", "Parameter 'message' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(c => c.Message.Contains(message)));
case ContainmentOperator.StartsWith:
return(queryable.Where(c => c.Message.StartsWith(message)));
case ContainmentOperator.EndsWith:
return(queryable.Where(c => c.Message.EndsWith(message)));
case ContainmentOperator.NotContains:
return(queryable.Where(c => c.Message.Contains(message) == false));
case ContainmentOperator.NotEquals:
return(message == null
? queryable.Where(c => c.Message != null)
: queryable.Where(c => c.Message != message));
default:
return(message == null
? queryable.Where(c => c.Message == null)
: queryable.Where(c => c.Message == message));
}
}
public static IQueryable<Tracker.Core.Data.User> ByAvatarType(this IQueryable<Tracker.Core.Data.User> queryable, ContainmentOperator containmentOperator, string avatarType)
{
if (avatarType == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("avatarType", "Parameter 'avatarType' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(u => u.AvatarType.Contains(avatarType));
case ContainmentOperator.StartsWith:
return queryable.Where(u => u.AvatarType.StartsWith(avatarType));
case ContainmentOperator.EndsWith:
return queryable.Where(u => u.AvatarType.EndsWith(avatarType));
case ContainmentOperator.NotContains:
return queryable.Where(u => u.AvatarType.Contains(avatarType) == false);
case ContainmentOperator.NotEquals:
return avatarType == null
? queryable.Where(u => u.AvatarType != null)
: queryable.Where(u => u.AvatarType != avatarType);
default:
return avatarType == null
? queryable.Where(u => u.AvatarType == null)
: queryable.Where(u => u.AvatarType == avatarType);
}
}
public static IQueryable<Tracker.Core.Data.Task> ByLastModifiedBy(this IQueryable<Tracker.Core.Data.Task> queryable, ContainmentOperator containmentOperator, string lastModifiedBy)
{
if (lastModifiedBy == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("lastModifiedBy", "Parameter 'lastModifiedBy' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(t => t.LastModifiedBy.Contains(lastModifiedBy));
case ContainmentOperator.StartsWith:
return queryable.Where(t => t.LastModifiedBy.StartsWith(lastModifiedBy));
case ContainmentOperator.EndsWith:
return queryable.Where(t => t.LastModifiedBy.EndsWith(lastModifiedBy));
case ContainmentOperator.NotContains:
return queryable.Where(t => t.LastModifiedBy.Contains(lastModifiedBy) == false);
case ContainmentOperator.NotEquals:
return lastModifiedBy == null
? queryable.Where(t => t.LastModifiedBy != null)
: queryable.Where(t => t.LastModifiedBy != lastModifiedBy);
default:
return lastModifiedBy == null
? queryable.Where(t => t.LastModifiedBy == null)
: queryable.Where(t => t.LastModifiedBy == lastModifiedBy);
}
}
public static IQueryable<Tracker.Core.Data.User> ByEmailAddress(this IQueryable<Tracker.Core.Data.User> queryable, ContainmentOperator containmentOperator, string emailAddress)
{
if (emailAddress == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("emailAddress", "Parameter 'emailAddress' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(u => u.EmailAddress.Contains(emailAddress));
case ContainmentOperator.StartsWith:
return queryable.Where(u => u.EmailAddress.StartsWith(emailAddress));
case ContainmentOperator.EndsWith:
return queryable.Where(u => u.EmailAddress.EndsWith(emailAddress));
case ContainmentOperator.NotContains:
return queryable.Where(u => u.EmailAddress.Contains(emailAddress) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(u => u.EmailAddress != emailAddress);
default:
return queryable.Where(u => u.EmailAddress == emailAddress);
}
}
public static IQueryable<Tracker.Core.Data.Role> ByName(this IQueryable<Tracker.Core.Data.Role> queryable, ContainmentOperator containmentOperator, string name)
{
if (name == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("name", "Parameter 'name' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(r => r.Name.Contains(name));
case ContainmentOperator.StartsWith:
return queryable.Where(r => r.Name.StartsWith(name));
case ContainmentOperator.EndsWith:
return queryable.Where(r => r.Name.EndsWith(name));
case ContainmentOperator.NotContains:
return queryable.Where(r => r.Name.Contains(name) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(r => r.Name != name);
default:
return queryable.Where(r => r.Name == name);
}
}
public static IQueryable<Tracker.Core.Data.User> ByPasswordHash(this IQueryable<Tracker.Core.Data.User> queryable, ContainmentOperator containmentOperator, string passwordHash)
{
if (passwordHash == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("passwordHash", "Parameter 'passwordHash' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(u => u.PasswordHash.Contains(passwordHash));
case ContainmentOperator.StartsWith:
return queryable.Where(u => u.PasswordHash.StartsWith(passwordHash));
case ContainmentOperator.EndsWith:
return queryable.Where(u => u.PasswordHash.EndsWith(passwordHash));
case ContainmentOperator.NotContains:
return queryable.Where(u => u.PasswordHash.Contains(passwordHash) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(u => u.PasswordHash != passwordHash);
default:
return queryable.Where(u => u.PasswordHash == passwordHash);
}
}
public static IQueryable<PetShop.Core.Data.Supplier> ByAddr2(this IQueryable<PetShop.Core.Data.Supplier> queryable, ContainmentOperator containmentOperator, string addr2)
{
if (addr2 == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("addr2", "Parameter 'addr2' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(s => s.Addr2.Contains(addr2));
case ContainmentOperator.StartsWith:
return queryable.Where(s => s.Addr2.StartsWith(addr2));
case ContainmentOperator.EndsWith:
return queryable.Where(s => s.Addr2.EndsWith(addr2));
case ContainmentOperator.NotContains:
return queryable.Where(s => s.Addr2.Contains(addr2) == false);
case ContainmentOperator.NotEquals:
return addr2 == null
? queryable.Where(s => s.Addr2 != null)
: queryable.Where(s => s.Addr2 != addr2);
default:
return addr2 == null
? queryable.Where(s => s.Addr2 == null)
: queryable.Where(s => s.Addr2 == addr2);
}
}
public static IQueryable<Tracker.Core.Data.User> ByComment(this IQueryable<Tracker.Core.Data.User> queryable, ContainmentOperator containmentOperator, string comment)
{
if (comment == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("comment", "Parameter 'comment' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(u => u.Comment.Contains(comment));
case ContainmentOperator.StartsWith:
return queryable.Where(u => u.Comment.StartsWith(comment));
case ContainmentOperator.EndsWith:
return queryable.Where(u => u.Comment.EndsWith(comment));
case ContainmentOperator.NotContains:
return queryable.Where(u => u.Comment.Contains(comment) == false);
case ContainmentOperator.NotEquals:
return comment == null
? queryable.Where(u => u.Comment != null)
: queryable.Where(u => u.Comment != comment);
default:
return comment == null
? queryable.Where(u => u.Comment == null)
: queryable.Where(u => u.Comment == comment);
}
}
public static IQueryable<PetShop.Core.Data.Supplier> ByZip(this IQueryable<PetShop.Core.Data.Supplier> queryable, ContainmentOperator containmentOperator, string zip)
{
if (zip == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("zip", "Parameter 'zip' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(s => s.Zip.Contains(zip));
case ContainmentOperator.StartsWith:
return queryable.Where(s => s.Zip.StartsWith(zip));
case ContainmentOperator.EndsWith:
return queryable.Where(s => s.Zip.EndsWith(zip));
case ContainmentOperator.NotContains:
return queryable.Where(s => s.Zip.Contains(zip) == false);
case ContainmentOperator.NotEquals:
return zip == null
? queryable.Where(s => s.Zip != null)
: queryable.Where(s => s.Zip != zip);
default:
return zip == null
? queryable.Where(s => s.Zip == null)
: queryable.Where(s => s.Zip == zip);
}
}
public static IQueryable<Petshop.Data.Entities.Product> ByName(this IQueryable<Petshop.Data.Entities.Product> queryable, ContainmentOperator containmentOperator, System.String name)
{
if (name == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("name", "Parameter 'name' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(p => p.Name.Contains(name));
case ContainmentOperator.StartsWith:
return queryable.Where(p => p.Name.StartsWith(name));
case ContainmentOperator.EndsWith:
return queryable.Where(p => p.Name.EndsWith(name));
case ContainmentOperator.NotContains:
return queryable.Where(p => p.Name.Contains(name) == false);
case ContainmentOperator.NotEquals:
return name == null
? queryable.Where(p => p.Name != null)
: queryable.Where(p => p.Name != name);
default:
return name == null
? queryable.Where(p => p.Name == null)
: queryable.Where(p => p.Name == name);
}
}
public static IQueryable <SmartSocial.Data.WebpagesRoles> ByRoleName(this IQueryable <SmartSocial.Data.WebpagesRoles> queryable, ContainmentOperator containmentOperator, string roleName)
{
if (roleName == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("roleName", "Parameter 'roleName' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(w => w.RoleName.Contains(roleName)));
case ContainmentOperator.StartsWith:
return(queryable.Where(w => w.RoleName.StartsWith(roleName)));
case ContainmentOperator.EndsWith:
return(queryable.Where(w => w.RoleName.EndsWith(roleName)));
case ContainmentOperator.NotContains:
return(queryable.Where(w => w.RoleName.Contains(roleName) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(w => w.RoleName != roleName));
default:
return(queryable.Where(w => w.RoleName == roleName));
}
}
public static IQueryable<Tracker.Data.Entities.TaskDetail> ByPriority(this IQueryable<Tracker.Data.Entities.TaskDetail> queryable, ContainmentOperator containmentOperator, System.String priority)
{
if (priority == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("priority", "Parameter 'priority' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(t => t.Priority.Contains(priority));
case ContainmentOperator.StartsWith:
return queryable.Where(t => t.Priority.StartsWith(priority));
case ContainmentOperator.EndsWith:
return queryable.Where(t => t.Priority.EndsWith(priority));
case ContainmentOperator.NotContains:
return queryable.Where(t => t.Priority.Contains(priority) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(t => t.Priority != priority);
default:
return queryable.Where(t => t.Priority == priority);
}
}
public static IQueryable<Petshop.Data.Entities.Order> ByShipZip(this IQueryable<Petshop.Data.Entities.Order> queryable, ContainmentOperator containmentOperator, System.String shipZip)
{
if (shipZip == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("shipZip", "Parameter 'shipZip' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(o => o.ShipZip.Contains(shipZip));
case ContainmentOperator.StartsWith:
return queryable.Where(o => o.ShipZip.StartsWith(shipZip));
case ContainmentOperator.EndsWith:
return queryable.Where(o => o.ShipZip.EndsWith(shipZip));
case ContainmentOperator.NotContains:
return queryable.Where(o => o.ShipZip.Contains(shipZip) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(o => o.ShipZip != shipZip);
default:
return queryable.Where(o => o.ShipZip == shipZip);
}
}
public static IQueryable<Tracker.Data.Entities.TaskDetail> ByStatus(this IQueryable<Tracker.Data.Entities.TaskDetail> queryable, ContainmentOperator containmentOperator, System.String status)
{
if (status == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("status", "Parameter 'status' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(t => t.Status.Contains(status));
case ContainmentOperator.StartsWith:
return queryable.Where(t => t.Status.StartsWith(status));
case ContainmentOperator.EndsWith:
return queryable.Where(t => t.Status.EndsWith(status));
case ContainmentOperator.NotContains:
return queryable.Where(t => t.Status.Contains(status) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(t => t.Status != status);
default:
return queryable.Where(t => t.Status == status);
}
}
public static IQueryable<PetShop.Core.Data.Order> ByShipCountry(this IQueryable<PetShop.Core.Data.Order> queryable, ContainmentOperator containmentOperator, string shipCountry)
{
if (shipCountry == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("shipCountry", "Parameter 'shipCountry' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(o => o.ShipCountry.Contains(shipCountry));
case ContainmentOperator.StartsWith:
return queryable.Where(o => o.ShipCountry.StartsWith(shipCountry));
case ContainmentOperator.EndsWith:
return queryable.Where(o => o.ShipCountry.EndsWith(shipCountry));
case ContainmentOperator.NotContains:
return queryable.Where(o => o.ShipCountry.Contains(shipCountry) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(o => o.ShipCountry != shipCountry);
default:
return queryable.Where(o => o.ShipCountry == shipCountry);
}
}
public static IQueryable<Tracker.Data.Entities.TaskDetail> ByCreated(this IQueryable<Tracker.Data.Entities.TaskDetail> queryable, ContainmentOperator containmentOperator, System.String created)
{
if (created == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("created", "Parameter 'created' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(t => t.Created.Contains(created));
case ContainmentOperator.StartsWith:
return queryable.Where(t => t.Created.StartsWith(created));
case ContainmentOperator.EndsWith:
return queryable.Where(t => t.Created.EndsWith(created));
case ContainmentOperator.NotContains:
return queryable.Where(t => t.Created.Contains(created) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(t => t.Created != created);
default:
return queryable.Where(t => t.Created == created);
}
}
public static IQueryable<Petshop.Data.Entities.Cart> ByType(this IQueryable<Petshop.Data.Entities.Cart> queryable, ContainmentOperator containmentOperator, System.String type)
{
if (type == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("type", "Parameter 'type' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(c => c.Type.Contains(type));
case ContainmentOperator.StartsWith:
return queryable.Where(c => c.Type.StartsWith(type));
case ContainmentOperator.EndsWith:
return queryable.Where(c => c.Type.EndsWith(type));
case ContainmentOperator.NotContains:
return queryable.Where(c => c.Type.Contains(type) == false);
case ContainmentOperator.NotEquals:
return queryable.Where(c => c.Type != type);
default:
return queryable.Where(c => c.Type == type);
}
}
public static IQueryable <Nsun.Domain.DataContent.UserInfo> ByPhoneNum(this IQueryable <Nsun.Domain.DataContent.UserInfo> queryable, ContainmentOperator containmentOperator, System.String phoneNum)
{
if (phoneNum == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("phoneNum", "Parameter 'phoneNum' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(u => u.PhoneNum.Contains(phoneNum)));
case ContainmentOperator.StartsWith:
return(queryable.Where(u => u.PhoneNum.StartsWith(phoneNum)));
case ContainmentOperator.EndsWith:
return(queryable.Where(u => u.PhoneNum.EndsWith(phoneNum)));
case ContainmentOperator.NotContains:
return(queryable.Where(u => u.PhoneNum.Contains(phoneNum) == false));
case ContainmentOperator.NotEquals:
return(phoneNum == null
? queryable.Where(u => u.PhoneNum != null)
: queryable.Where(u => u.PhoneNum != phoneNum));
default:
return(phoneNum == null
? queryable.Where(u => u.PhoneNum == null)
: queryable.Where(u => u.PhoneNum == phoneNum));
}
}
public static IQueryable<Tracker.Data.Entities.Priority> ByDescription(this IQueryable<Tracker.Data.Entities.Priority> queryable, ContainmentOperator containmentOperator, System.String description)
{
if (description == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("description", "Parameter 'description' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(p => p.Description.Contains(description));
case ContainmentOperator.StartsWith:
return queryable.Where(p => p.Description.StartsWith(description));
case ContainmentOperator.EndsWith:
return queryable.Where(p => p.Description.EndsWith(description));
case ContainmentOperator.NotContains:
return queryable.Where(p => p.Description.Contains(description) == false);
case ContainmentOperator.NotEquals:
return description == null
? queryable.Where(p => p.Description != null)
: queryable.Where(p => p.Description != description);
default:
return description == null
? queryable.Where(p => p.Description == null)
: queryable.Where(p => p.Description == description);
}
}
public static IQueryable <Nsun.Domain.DataContent.UserInfo> ByUserNo(this IQueryable <Nsun.Domain.DataContent.UserInfo> queryable, ContainmentOperator containmentOperator, System.String userNo)
{
if (userNo == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("userNo", "Parameter 'userNo' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(u => u.UserNo.Contains(userNo)));
case ContainmentOperator.StartsWith:
return(queryable.Where(u => u.UserNo.StartsWith(userNo)));
case ContainmentOperator.EndsWith:
return(queryable.Where(u => u.UserNo.EndsWith(userNo)));
case ContainmentOperator.NotContains:
return(queryable.Where(u => u.UserNo.Contains(userNo) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(u => u.UserNo != userNo));
default:
return(queryable.Where(u => u.UserNo == userNo));
}
}
public static IQueryable<Tracker.Data.Entities.Audit> ByMyxml(this IQueryable<Tracker.Data.Entities.Audit> queryable, ContainmentOperator containmentOperator, System.String myxml)
{
if (myxml == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
throw new ArgumentNullException("myxml", "Parameter 'myxml' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return queryable.Where(a => a.Myxml.Contains(myxml));
case ContainmentOperator.StartsWith:
return queryable.Where(a => a.Myxml.StartsWith(myxml));
case ContainmentOperator.EndsWith:
return queryable.Where(a => a.Myxml.EndsWith(myxml));
case ContainmentOperator.NotContains:
return queryable.Where(a => a.Myxml.Contains(myxml) == false);
case ContainmentOperator.NotEquals:
return myxml == null
? queryable.Where(a => a.Myxml != null)
: queryable.Where(a => a.Myxml != myxml);
default:
return myxml == null
? queryable.Where(a => a.Myxml == null)
: queryable.Where(a => a.Myxml == myxml);
}
}
public static IQueryable <Abeced.Data.AllCard> ByIndCardId(this IQueryable <Abeced.Data.AllCard> queryable, ContainmentOperator containmentOperator, System.String indCardId)
{
if (indCardId == null && containmentOperator != ContainmentOperator.Equals && containmentOperator != ContainmentOperator.NotEquals)
{
throw new ArgumentNullException("indCardId", "Parameter 'indCardId' cannot be null with the specified ContainmentOperator. Parameter 'containmentOperator' must be ContainmentOperator.Equals or ContainmentOperator.NotEquals to support null.");
}
switch (containmentOperator)
{
case ContainmentOperator.Contains:
return(queryable.Where(a => a.IndCardId.Contains(indCardId)));
case ContainmentOperator.StartsWith:
return(queryable.Where(a => a.IndCardId.StartsWith(indCardId)));
case ContainmentOperator.EndsWith:
return(queryable.Where(a => a.IndCardId.EndsWith(indCardId)));
case ContainmentOperator.NotContains:
return(queryable.Where(a => a.IndCardId.Contains(indCardId) == false));
case ContainmentOperator.NotEquals:
return(queryable.Where(a => a.IndCardId != indCardId));
default:
return(queryable.Where(a => a.IndCardId == indCardId));
}
}
