// GET: Customer
public ActionResult Index(CustomerSearchModel customerSearchModel)
{
var result = db.Customers.AsQueryable();
if (customerSearchModel != null)
{
if (!string.IsNullOrEmpty(customerSearchModel.CustomerID))
{
result = result.Where(x => x.CustomerID.Contains(customerSearchModel.CustomerID));
}
else if (!string.IsNullOrEmpty(customerSearchModel.ContactName))
{
result = result.Where(x => x.ContactName.Contains(customerSearchModel.ContactName));
}
else if (!string.IsNullOrEmpty(customerSearchModel.City))
{
result = result.Where(x => x.City.Contains(customerSearchModel.City));
}
else if (!string.IsNullOrEmpty(customerSearchModel.Country))
{
result = result.Where(x => x.Country.Contains(customerSearchModel.Country));
}
else
{
result.ToList();
}
}
return(View(result));
}
public async Task GetBySearchCriteriaAsyncShouldWorkCorrectlyWithPersonalNumber()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()).Options;
var dbContext = new ApplicationDbContext(options);
var customerRepo = new EfDeletableEntityRepository <Customer>(dbContext);
var service = new CustomerService(customerRepo);
var id = await service.CreateAsync <CustomerModel>(new CustomerModel
{
FirstName = "ivan",
LastName = "ivanov",
MiddleName = "ivanov",
PersonalNumber = "1234567890",
});
var model = new CustomerSearchModel
{
PersonalNumber = "1234567890",
};
var customers = await service.GetBySearchCriteriaAsync <CustomerModel, CustomerSearchModel>(model);
Assert.Single(customers);
Assert.Collection(
customers,
x => Assert.Equal("1234567890", x.PersonalNumber));
}
public IActionResult TicketCustomerSearch(CustomerSearchModel customerSearchModel)
{
var query = from c in _db.Users
select c;
if (customerSearchModel.LastName != null && customerSearchModel.LastName != "")
{
query = query.Where(c => c.LastName.Contains(customerSearchModel.LastName));
}
if (customerSearchModel.AdvantageNumber != null)
{
query = query.Where(c => c.AdvantageNumber == (customerSearchModel.AdvantageNumber));
}
query = query.Where(c => c.AdvantageNumber != null);
List <AppUser> SelectedUsers = query.ToList();
try
{
ViewBag.TicketID = customerSearchModel.TicketID;
}
catch
{
ViewBag.TicketID = -1;
}
return(View("TicketUsersList", SelectedUsers));
}
protected CustomerSearchModel AddNotes(CustomerSearchModel customer, IEnumerable <NoteSearchModel> notes)
{
customer.Notes = notes
.Where(n => n.CustomerId == customer.Id)
.ToArray();
return(customer);
}
public ActionResult SearchResult(CustomerSearchModel customers)
{
/* Call the DAL and pass the values as a model back to the View */
var customerList = customerDAO.SearchForCustomers(customers.Name, customers.SortType);
return(View(customerList));
}
public IQueryable <Customer> GetCustomers(CustomerSearchModel customerSearchModel)
{
var result = db.Customers.AsQueryable();
if (customerSearchModel != null)
{
if (!string.IsNullOrEmpty(customerSearchModel.CustomerID))
{
result = result.Where(x => x.CustomerID.Contains(customerSearchModel.CustomerID));
}
if (!string.IsNullOrEmpty(customerSearchModel.ContactName))
{
result = result.Where(x => x.ContactName.Contains(customerSearchModel.ContactName));
}
if (!string.IsNullOrEmpty(customerSearchModel.City))
{
result = result.Where(x => x.City.Contains(customerSearchModel.City));
}
if (!string.IsNullOrEmpty(customerSearchModel.Country))
{
result = result.Where(x => x.Country.Contains(customerSearchModel.Country));
}
}
return(result);
}
/// <summary>
/// 高级查询按钮点击时调用此方法
/// </summary>
protected async Task ShowSearchDialog()
{
if (CustomerSearchModel != null && CustomerSearchTemplate != null)
{
await DialogService.ShowSearchDialog(CreateCustomerModelDialog());
}
else
{
await DialogService.ShowSearchDialog(CreateModelDialog());
}
SearchDialogOption <TItem> CreateModelDialog() => new()
{
Class = "modal-dialog-table",
IsScrolling = ScrollingDialogContent,
Title = SearchModalTitle,
Model = SearchModel,
DialogBodyTemplate = SearchTemplate,
OnResetSearchClick = ResetSearchClick,
OnSearchClick = SearchClick,
RowType = SearchDialogRowType,
ItemsPerRow = SearchDialogItemsPerRow,
LabelAlign = SearchDialogLabelAlign,
Size = SearchDialogSize,
Items = Columns.Where(i => i.Searchable),
IsDraggable = SearchDialogIsDraggable,
ShowMaximizeButton = SearchDialogShowMaximizeButton,
ShowUnsetGroupItemsOnTop = ShowUnsetGroupItemsOnTop
};
SearchDialogOption <ITableSearchModel> CreateCustomerModelDialog() => new()
{
IsScrolling = ScrollingDialogContent,
Title = SearchModalTitle,
Model = CustomerSearchModel,
DialogBodyTemplate = CustomerSearchTemplate,
OnResetSearchClick = ResetSearchClick,
OnSearchClick = SearchClick,
RowType = SearchDialogRowType,
ItemsPerRow = SearchDialogItemsPerRow,
Size = SearchDialogSize,
LabelAlign = SearchDialogLabelAlign
};
}
/// <summary>
/// 获得 <see cref="CustomerSearchModel"/> 中过滤条件 <see cref="SearchTemplate"/> 模板中的条件无法获得
/// </summary>
/// <returns></returns>
protected IEnumerable <IFilterAction> GetCustomerSearchs()
{
var searchs = new List <IFilterAction>();
// 处理自定义 SearchModel 条件
if (CustomerSearchModel != null)
{
searchs.AddRange(CustomerSearchModel.GetSearchs());
}
return(searchs);
}
/// <summary>
/// Prepare customer search model
/// </summary>
/// <param name="searchModel">Customer search model</param>
/// <returns>Customer search model</returns>
public virtual CustomerSearchModel PrepareCustomerSearchModel(CustomerSearchModel searchModel)
{
if (searchModel == null)
{
throw new ArgumentNullException(nameof(searchModel));
}
searchModel.UsernamesEnabled = _customerSettings.UsernamesEnabled;
searchModel.AvatarEnabled = _customerSettings.AllowCustomersToUploadAvatars;
searchModel.DateOfBirthEnabled = _customerSettings.DateOfBirthEnabled;
searchModel.CompanyEnabled = _customerSettings.CompanyEnabled;
searchModel.PhoneEnabled = _customerSettings.PhoneEnabled;
searchModel.ZipPostalCodeEnabled = _customerSettings.ZipPostalCodeEnabled;
//search registered customers by default
var registeredRole = _customerService.GetCustomerRoleBySystemName(NopCustomerDefaults.RegisteredRoleName);
if (registeredRole != null)
{
searchModel.SelectedCustomerRoleIds.Add(registeredRole.Id);
}
//prepare available customer roles
_aclSupportedModelFactory.PrepareModelCustomerRoles(searchModel);
//prepare page parameters
searchModel.SetGridPageSize();
return(searchModel);
}
public ActionResult ListSeller(CustomerSearchModel model)
{
FillViewBag();
ViewBag.Customers = CustomerDomain.ListCustomers(model.Name, model.GenderId, model.CityId, model.RegionId, model.LastPurchaseStart, model.LastPuchaseEnd, model.ClassificationId, int.Parse(User.Identity.Name)).Select(c => (CustomerListModel)c);
return(View("List"));
}
public IPagedList<MSDS_Customer> Search(CustomerSearchModel searchModel)
{
var query = _context.MSDS_Customer.Where(x => (string.IsNullOrEmpty(searchModel.KeyWord)
|| x.Name.ToLower().Contains(searchModel.KeyWord.ToLower()))).OrderByDescending(x => x.CreateBy);
var count = query.Count();
var result = query.Skip((searchModel.PageIndex - 1) * searchModel.PageSize).Take(searchModel.PageSize).ToList();
return new PagedList<MSDS_Customer>(result, searchModel.PageIndex, searchModel.PageSize, count);
}
private IQueryable <CustomerDto> GetCustomer(CustomerSearchModel searchModel = null)
{
IQueryable <CustomerDto> list = null;
if (searchModel.IsNull())
{
list = _customerService.GetAll();
}
else
{
var predicate = PredicateBuilder.True <CustomerDto>();
var hasOtherFilter = false;
if (!searchModel.CustomerCode.IsNull())
{
hasOtherFilter = true;
predicate = predicate.And(c => c.CustomerCode.Contains(searchModel.CustomerCode));
}
if (!searchModel.FirstName.IsNull())
{
hasOtherFilter = true;
predicate = predicate.And(c => c.FirstName.Contains(searchModel.FirstName));
}
if (!searchModel.LastName.IsNull())
{
hasOtherFilter = true;
predicate = predicate.And(c => c.LastName.Contains(searchModel.LastName));
}
if (!searchModel.Address.IsNull())
{
hasOtherFilter = true;
predicate = predicate.And(c => c.Address.Contains(searchModel.Address));
}
if (!searchModel.isActive.IsNull())
{
hasOtherFilter = true;
if (searchModel.isActive == "true")
{
predicate = predicate.And(a => a.IsActive);
}
else
{
predicate = predicate.And(a => !a.IsActive);
}
}
list = _customerService.GetAll().AsExpandable().Where(predicate);
}
return(list);
}
private void SearchOrders(CustomerSearchViewModel model)
{
CustomerSearchModel searchModel = new CustomerSearchModel {
PageIndex = model.PageIndex,
PageSize = model.PageSize,
KeyWord = model.Keyword
};
model.ViewList = _customerService.Search(searchModel);
}
public IActionResult TicketCustomerSearch(Int32 TicketID)
{
Ticket t = _db.Tickets.Find(TicketID);
CustomerSearchModel csm = new CustomerSearchModel
{
ExistingCustomer = true,
TicketID = t.TicketID
};
return(View(csm));
}
public List <CustomerModel> Search(CustomerSearchModel searchModel)
{
foreach (var func in _search)
{
var list = func(searchModel, _customerService);
if (list != null)
{
return(list);
}
}
return(_customerService.GetCustomers());
}
public CustomerSearchModel Post(CustomerSearchModel model)
{
IQueryable <CustomerInfo> searchResults;
searchResults = CustomerInfo.GetBySearchFields(model); // Find matches based on all fields
if (searchResults.Any() == true)
{
model.Results.FillRange(searchResults.ToList());
}
return(model);
}
public CustomerSearchModel Post(CustomerSearchModel model)
{
IQueryable <CustomerInfo> searchResults;
searchResults = CustomerInfo.GetByAny(model).Take(25);
if (searchResults.Any() == true)
{
model.Results.FillRange(searchResults.ToList());
}
return(model);
}
public ActionResult LoadAllData(DTParameters param, CustomerSearchModel model)
{
var SearchValue = Request.Form.GetValues("search[value]")[0];
var parameters = param.GetSearchParameters();
parameters.SearchText = SearchValue;
var listResult = _customerService.GetAll(parameters, model);
var result = GetListResult <CustomerListModel>(param, listResult);
return(Json(result));
}
public ActionResult GetCustomersByTagType(CustomerSearchModel searchModel)
{
if (!ModelState.IsValid)
{
return(PartialView("~/Views/Home/Partials/_Customers.cshtml", new CustomersModel()));
}
var model = new CustomersModel
{
Customers = _customerService.GetByAny(searchModel.Tags, searchModel.GetKeywords())
};
return(PartialView("~/Views/Home/Partials/_Customers.cshtml", model));
}
public void Model_CustomerSearch_GetBySearchFields()
{
var searchChar = "i";
var searchModel = new CustomerSearchModel()
{
FirstName = searchChar, LastName = searchChar
};
var results = CustomerInfo.GetByAny(searchModel);
Assert.IsTrue(results.Count() > 0);
searchModel.Results.FillRange(results);
Assert.IsTrue(searchModel.FirstName == searchChar && searchModel.LastName == searchChar);
Assert.IsTrue(searchModel.Results.Count() > 0);
}
public CustomerSearchModel CustomerSearch
(string CustomerSearchVal, string SearchParam, int PageNumber, int RowCount)
{
CustomerSearchModel oReturn = new CustomerSearchModel();
int oTotalRows;
oReturn.RelatedCustomer = DocumentManagement.Customer.Controller.Customer.CustomerSearch
(SearchParam, PageNumber, RowCount, out oTotalRows);
oReturn.TotalRows = oTotalRows;
return(oReturn);
}
public void Model_CustomerSearch_GetBySearchFields()
{
var searchChar = "i";
var searchModel = new CustomerSearchModel()
{
FirstName = searchChar, LastName = searchChar
};
var reader = new EntityReader <CustomerInfo>();
var results = reader.GetByWhere(x => x.Key == searchModel.Key || x.FirstName.Contains(searchModel.FirstName) || x.LastName.Contains(searchModel.LastName) || x.BirthDate == searchModel.BirthDate);
Assert.IsTrue(results.Count() > 0);
searchModel.Results.FillRange(results);
Assert.IsTrue(searchModel.FirstName == searchChar && searchModel.LastName == searchChar);
Assert.IsTrue(searchModel.Results.Count() > 0);
}
public IActionResult Post([FromBody] CustomerModel data)
{
var model = new CustomerSearchModel();
var reader = new EntityReader <CustomerInfo>();
var searchResults = reader.GetByWhere(x => x.Key == data.Key || x.FirstName.Contains(data.FirstName) || x.LastName.Contains(data.LastName) || x.BirthDate == data.BirthDate);
var form = Request.ReadFormAsync();
model.Fill(data);
if (searchResults.Any())
{
model.Results.FillRange(searchResults);
}
return(Ok(model));
}
public async Task Customer_Cloud_CustomerSearchGet()
{
CustomerSearchModel returnData = new CustomerSearchModel();
HttpRequestGet <CustomerSearchModel> request;
string urlRoot = new ConfigurationManagerFull().AppSettingValue("MyWebService");
string urlFull = TypeExtension.DefaultString;
// Find customer by first name. -1 for ID does not exist, and empty string Last Name doesnt exist
urlFull = String.Format("{0}/{1}/{2}?firstName={3}&lastName={4}", urlRoot, "CustomerSearch", -1, "i", "");
request = new HttpRequestGet <CustomerSearchModel>(urlFull);
returnData = await request.SendAsync();
Assert.IsTrue(returnData.Results.Count > 0, "Customer did not get.");
Assert.IsTrue(returnData.FirstName != TypeExtension.DefaultString, "Customer did not get.");
}
public async Task <IActionResult> Search(CustomerSearchModel model, CancellationToken cancellationToken)
{
if (!model.Search.HasAnyParameters())
{
return(View(model));
}
var results = await mediator.Send(model.Search, cancellationToken);
return(View(new CustomerSearchModel
{
Search = model.Search,
Results = results,
SearchPerformed = true,
}));
}
public ActionResult List(CustomerSearchModel customerSearchModel)
{
int pageIndex = customerSearchModel.Page ?? 1;
var data = _customerService.GetCustomerDetailAll().Where(x =>
(string.IsNullOrEmpty(customerSearchModel.CustomerName) || x.Name.ToLower().Trim()
.Contains(customerSearchModel.CustomerName.Trim().ToLower()))).ToList();
var customerDetail = _mapper.Map <List <CustomerDetailModel> >(data);
customerSearchModel.CustomerDetailModelList = customerDetail.OrderByDescending(x => x.Id).ToPagedList(pageIndex, 10);
if (Request.IsAjaxRequest())
{
return(PartialView("_customerList", customerSearchModel));
}
return(View(customerSearchModel));
}
public CustomerSearchModel Get(string id = "-1", string firstName = "", string lastName = "")
{
CustomerSearchModel model = new CustomerSearchModel()
{
ID = id.TryParseInt32(), FirstName = firstName, LastName = lastName
};
IQueryable <CustomerInfo> searchResults;
searchResults = CustomerInfo.GetByAny(model).Take(25);
if (searchResults.Any() == true)
{
model.Results.FillRange(searchResults);
}
return(model);
}
public void Model_CustomerSearch_Serialization()
{
var searchChar = "i";
var originalObject = new CustomerSearchModel()
{
FirstName = searchChar, LastName = searchChar
};
var resultObject = new CustomerSearchModel();
var resultString = Defaults.String;
var serializer = new JsonSerializer <CustomerSearchModel>();
resultString = serializer.Serialize(originalObject);
Assert.IsTrue(resultString != Defaults.String);
resultObject = serializer.Deserialize(resultString);
Assert.IsTrue(resultObject.FirstName == searchChar);
Assert.IsTrue(resultObject.LastName == searchChar);
}
public CustomerSearchModel Get(string id, string firstName, string lastName)
{
Int32 idStrong = id.TryParseInt32();
CustomerSearchModel model = new CustomerSearchModel()
{
ID = idStrong, FirstName = firstName, LastName = lastName
};
IQueryable <CustomerInfo> searchResults;
searchResults = CustomerInfo.GetBySearchFields(model); // Find matches based on all fields
if (searchResults.Any() == true)
{
model.Results.FillRange(searchResults);
}
return(model);
}
public IActionResult CustomerSearch(CustomerSearchModel customerSearchModel)
{
var query = from c in _db.Users
select c;
if (customerSearchModel.LastName != null && customerSearchModel.LastName != "")
{
query = query.Where(c => c.LastName.Contains(customerSearchModel.LastName));
}
if (customerSearchModel.AdvantageNumber != null && customerSearchModel.AdvantageNumber != null)
{
query = query.Where(c => c.AdvantageNumber == (customerSearchModel.AdvantageNumber));
}
List <AppUser> SelectedUsers = query.Include(c => c.UserID).ToList();
return(View(SelectedUsers));
}
public IActionResult Get(string key = "-1", string firstName = "", string lastName = "")
{
var model = new CustomerSearchModel()
{
Id = key.TryParseInt32(), Key = key.TryParseGuid(), FirstName = firstName, LastName = lastName
};
var reader = new EntityReader <CustomerInfo>();
var searchResults = reader.GetByWhere(x => x.Key == model.Key || x.FirstName.Contains(model.FirstName) || x.LastName.Contains(model.LastName) || x.BirthDate == model.BirthDate);
if (searchResults.Any())
{
model.Results.FillRange(searchResults);
}
return(Ok(model));
}
