public ActionResult SearchCustomer(CustomerSearchViewModel csvm)
{
int maxid = db.csvms.Max(x => x.CustomerSearchViewModelID);
CustomerSearchViewModel vm = db.csvms.Find(maxid);
vm.FirstName = csvm.FirstName;
vm.LastName = csvm.LastName;
vm.AdvantageNumber = csvm.AdvantageNumber;
db.SaveChanges();
vm.Customers = db.Users.Where(c => c.EmpType == "Customer" || c.EmpType == null).ToList();
if (vm.FirstName != null)
{
vm.Customers = vm.Customers.Where(c => c.FirstName.Contains(vm.FirstName)).ToList();
db.SaveChanges();
}
if (vm.LastName != null)
{
vm.Customers = vm.Customers.Where(c => c.LastName.Contains(vm.LastName)).ToList();
db.SaveChanges();
}
if (vm.AdvantageNumber != null)
{
vm.Customers = vm.Customers.Where(c => c.AdvantageNumber == vm.AdvantageNumber).ToList();
db.SaveChanges();
}
ViewBag.SeatInfo = "Seat " + vm.Seat.SeatName + " on Flight " + vm.Seat.Flight.FlightNumber.Number.ToString() + " on " + vm.Seat.Flight.DepartDateTime.Date.ToString();
vm.Customers = vm.Customers.OrderBy(d => d.AdvantageNumber).ThenBy(d => d.LastName).ThenBy(d => d.FirstName).ToList();
db.SaveChanges();
//Int32 a = 12;
//Int32 b = 0;
//Int32 r = a / b;
return(View(vm));
}
void vm_ChangeCustomerNotice(object sender, SimpleMvvmToolkit.NotificationEventArgs <Core.Model.Order, Core.Model.Customer> e)
{
bool selected = false;
var vm = new CustomerSearchViewModel();
var win = new CustomerSearchView();
win.Owner = Application.Current.MainWindow;
win.DataContext = vm;
vm.CloseNotice += (ss, ee) =>
{
if (vm.SelectedCustomer != null)
{
selected = true;
e.Completed(vm.SelectedCustomer);
}
win.Close();
};
win.txtSearch.Focus();
win.ShowDialog();
if (!selected)
{
e.Completed(null);
}
}
public JsonResult GetCustomerList(CustomerSearchViewModel SearchViewModel)
{
if (SessionCustomerSearchViewModel != null)
{
if (SearchViewModel != SessionCustomerSearchViewModel)
{
SessionCustomerSearchViewModel = SearchViewModel;
}
else
{
SearchViewModel = SessionCustomerSearchViewModel;
}
}
ResponseViewModel result = new ResponseViewModel();
try
{
//限制只能為公司
var user = _aspNetUsersService.GetUserModelByName(User.Identity.Name);
SearchViewModel.CompanyId = user.CompanyId;
result.Data = _customerService.GetCustomerList(SearchViewModel);
result.IsOk = true;
result.HttpStatusCode = HttpStatusCode.OK;
}
catch (Exception ex)
{
result.IsOk = false;
result.Exception = ex;
result.HttpStatusCode = HttpStatusCode.InternalServerError;
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
public ActionResult Export(CustomerSearchViewModel filter)
{
var result = customerRepo
.Search(filter.Name, filter.CategoryID)
.Include(客 => 客.客戶分類1)
.Select(x =>
new
{
customerName = x.客戶名稱,
taxID = x.統一編號,
phone = x.電話,
fax = x.傳真,
address = x.地址,
email = x.Email,
category = x.客戶分類1.分類名稱
})
.ToList();
var dt = GetDataTable();
result.ForEach(item =>
{
var row = dt.NewRow();
row[0] = item.customerName;
row[1] = item.taxID;
row[2] = item.phone;
row[3] = item.fax;
row[4] = item.address;
row[5] = item.email;
row[6] = item.category;
dt.Rows.Add(row);
});
return(new ExportExcelResult("客戶資料.xlsx", dt));
}
public ActionResult Search(CustomerSearchViewModel filter)
{
var data = customerRepo.Search(filter.Name, filter.CategoryID).Include(x => x.客戶分類1).ToList();
ViewBag.Category = new SelectList(categoryRepo.All(), "Id", "分類名稱");
return(View("Index", data));
}
public IActionResult CustomerSearch(Owner owner)
{
ViewBag.Vaccinations = _context.Vaccination.ToList();
var ownerWithVet = _context.Owner
.Include(o => o.Veterinarian)
.Where(o => o.OwnerId == owner.OwnerId)
.FirstOrDefault();
var pets = _context.Pet
.Include(p => p.PetVaccination)
.ThenInclude(v => v.Vaccination)
.Where(p => p.OwnerId == owner.OwnerId)
.OrderBy(p => p.Name)
.ToList();
var petRes = _context.PetReservation
.Include(p => p.Reservation)
.Include(p => p.Pet)
.Include(p => p.Medication)
.Include(p => p.PetReservationService)
.Where(p => p.Pet.Owner.OwnerId == owner.OwnerId)
.OrderBy(p => p.Reservation.StartDate)
.ToList();
CustomerSearchViewModel result = new CustomerSearchViewModel {
Owner = ownerWithVet, Pets = pets, PetReservations = petRes
};
return(View(result));
}
// GET: BackOffice/Customers
public ActionResult Index(CustomerSearchViewModel model)
{
IEnumerable <Customer> liste = db.Customers.Include(c => c.Civility);
if (!string.IsNullOrWhiteSpace(model.Lastname))
{
liste = liste.Where(x => x.Lastname.ToLower().Contains(model.Lastname));
}
if (!string.IsNullOrWhiteSpace(model.Firstname))
{
liste = liste.Where(x => x.Firstname.ToLower().Contains(model.Firstname));
}
if (!string.IsNullOrWhiteSpace(model.Mail))
{
liste = liste.Where(x => x.Mail.ToLower().Contains(model.Mail));
}
if (model.BirthDateMin != null)
{
liste = liste.Where(x => x.BirthDate >= model.BirthDateMin);
}
if (model.BirthDateMax != null)
{
liste = liste.Where(x => x.BirthDate <= model.BirthDateMax);
}
model.Customers = liste.ToList();
return(View(model));
}
private static void PrepareResults(CustomerSearchResult result, CustomerSearchViewModel model)
{
model.CarMakes = result.GetFilteredFacetValuesFor("purchased_car_make");
model.CarModels = result.GetFilteredFacetValuesFor("purchased_car_model");
model.SalesPeople = result.GetFilteredFacetValuesFor("done_business_with");
model.Customers = result.Results;
}
void vm_ChangeCustomerNotice(object sender, SimpleMvvmToolkit.NotificationEventArgs<Core.Model.Order, Core.Model.Customer> e)
{
bool selected = false;
var vm = new CustomerSearchViewModel();
var win = new CustomerSearchView();
win.Owner = Application.Current.MainWindow;
win.DataContext = vm;
vm.CloseNotice += (ss, ee) =>
{
if (vm.SelectedCustomer != null)
{
selected = true;
e.Completed(vm.SelectedCustomer);
}
win.Close();
};
win.txtSearch.Focus();
win.ShowDialog();
if (!selected)
e.Completed(null);
}
public ActionResult Search([Bind(Include = "SearchText")] CustomerSearchViewModel model) //indicate field and model
{
model.Results = (from c in db.Customers
where c.FirstName.Contains(model.SearchText) || c.LastName.Contains(model.SearchText)
select c).ToList(); //convert LINQ to list since Results accepts list
return(View(model));
}
// GET: Customer
public ActionResult Index()
{
var searchViewModel = new CustomerSearchViewModel();
PrepareCustomerRolesModel(searchViewModel);
return(View(searchViewModel));
}
public ActionResult SearchCustomer(int?id)
{
CustomerSearchViewModel vm = new CustomerSearchViewModel();
vm.Customers = db.Users.Where(c => c.EmpType == "Customer" || c.EmpType == null).ToList();
vm.Customers = vm.Customers.OrderBy(d => d.AdvantageNumber).ThenBy(d => d.LastName).ThenBy(d => d.FirstName).ToList();
return(View(vm));
}
public ActionResult Search([Bind(Include = "SearchText")] CustomerSearchViewModel model)
{
model.Results = (from c in db.Customers
where c.FirstName.Contains(model.SearchText) ||
c.LastName.Contains(model.SearchText)
select c).ToList();
return(View(model));
}
public ActionResult Index(CustomerSearchViewModel model)
{
if (ModelState.IsValid)
{
model.HasSessionCriteria = true;
CustomerSearchData = model;
}
return(View(model));
}
// GET: Customers
public ActionResult Index()
{
CustomerSearchViewModel vmodel = new CustomerSearchViewModel();
vmodel.Allcustomer = new List <CustomerModel>();
vmodel.Customer = new CustomerModel();
return(View(vmodel));
// return View(db.Customers.ToList());
}
public IActionResult SearchCustomerByName(CustomerSearchViewModel values, int page = 1)
{
if (values.SearchValue == null)
{
var model = new CustomerSearchViewModel();
return(View(model));
}
else
{
const int pageSize = 50;
int offSet = pageSize * (page - 1);
var model = new CustomerSearchViewModel();
model.SearchValue = values.SearchValue;
model.NameOrCity = values.NameOrCity;
if (values.NameOrCity == "name")
{
var customerList = _context.Customers.Where(c => c.Givenname.Contains(values.SearchValue) || c.Surname.Contains(values.SearchValue));
model.CustomerList = customerList.ToList();
}
else if (values.NameOrCity == "city")
{
var customerList = _context.Customers.Where(c => c.City.Contains(values.SearchValue));
model.CustomerList = customerList.ToList();
}
else
{
ViewData["Message"] = "Kryssa för ditt sökalternativ";
return(View(model));
}
var total = model.CustomerList.Count();
model.HasMorePages = offSet + pageSize < total;
var firstCustomerList = model.CustomerList.Skip((page - 1) * pageSize).Take(pageSize);
model.CustomerList = firstCustomerList.ToList();
if (model.CustomerList.Count == 0)
{
ViewData["Message"] = "Kunde ej hitta kund";
return(View(model));
}
else
{
if (total % 50 != 0)
{
model.TotalPages = (total / pageSize) + 1;
}
else
{
model.TotalPages = total / pageSize;
}
}
return(View(model));
}
}
public ActionResult Index(int?id)
{
CustomerSearchViewModel vm = new CustomerSearchViewModel();
vm.Customers = db.Users.Where(c => c.EmpType == "Customer" || c.EmpType == null).ToList();
//ViewBag.SeatInfo = "Seat " + vm.Seat.SeatName + " on Flight " + vm.Seat.Flight.FlightNumber.Number.ToString() + " on " + vm.Seat.Flight.DepartDateTime.Date.ToString();
vm.Customers = vm.Customers.OrderBy(d => d.AdvantageNumber).ThenBy(d => d.LastName).ThenBy(d => d.FirstName).ToList();
return(View(vm));
}
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 Index()
{
var customers = _repository.GetAllCustomers();
CustomerSearchViewModel model = new CustomerSearchViewModel();
model.Customers = customers;
return(View(model));
}
public ActionResult SearchResult(string searchTerm, string sortBy)
{
IList <Customer> customers = _customerDAL.SearchForCustomers(searchTerm, sortBy);
CustomerSearchViewModel model = new CustomerSearchViewModel();
model.MatchingCustomers.AddRange(customers);
return(View(model));
}
public CustomerSearchModel Build(CustomerSearchViewModel viewModel)
{
return(new CustomerSearchModel
{
FirstName = viewModel.FirstName,
LastName = viewModel.LastName,
EmailAddress = viewModel.EmailAddress,
PhoneNumber = viewModel.PhoneNumber
});
}
public ActionResult Search(CustomerSearchViewModel objModel)
{
CustomerSearchViewModel vModel = new CustomerSearchViewModel();
vModel.Customer = new CustomerModel();
vModel.Allcustomer = new List <CustomerModel>();
List <CustomerModel> objRes = _ICustomer.AllCustomers(objModel.Customer);
vModel.Allcustomer.AddRange(objRes);
return(PartialView("~/Views/Customers/_CustomerSearch.cshtml", vModel));
}
public PartialViewResult CustomerList(CustomerSearchViewModel searchViewModel, int page)
{
var customers = UserManager.GetAllUsers(page, _pagedSize, searchViewModel.SearchEmail,
searchViewModel.SearchFristName,
searchViewModel.SearchLastName,
searchViewModel.SearchCustomerRoles);
var customersVm = customers.Select(PrepareCustomerViewModelForList);
PagedList <CustomerViewModel> pagedListCustomers = new PagedList <CustomerViewModel>(customersVm, page, _pagedSize, customers.TotalItems);
return(PartialView("_CustomerTablePartial", pagedListCustomers));
}
public void Manage(CustomerSearchViewModel viewModel)
{
var validationResult = _customerSearchValidator.Validate(viewModel);
if (validationResult.IsValid)
{
var model = _customerSearchModelBuilder.Build(viewModel);
var customers = _customerSearchProcessor.Process(model);
viewModel.Customers = _customerTableViewModelBuilder.Build(customers);
}
}
public ActionResult Index()
{
var criteria = PrepareSearchCriteriaWithFacets();
var result = new CustomerSearchResultRepository().Search(criteria);
var model = new CustomerSearchViewModel();
PrepareResults(result, model);
return(View(model));
}
[ValidateAntiForgeryToken] // search funciton
public ActionResult Search([Bind(Include = "SearchText")] CustomerSearchViewModel model)
{
model.Result = (from c in db.Customers where c.FirstName.Contains(model.SearchText) || c.LastName.Contains(model.SearchText) select c).ToList();
List <Movie> fromall = new List <Movie>();
fromall = (from c in db.Movies where c.Title.Contains(model.SearchText) select c).ToList(); // code selects all movies with search text adds them to list "fromall"
foreach (Movie m in fromall)
{
model.Result.AddRange(from c in db.Customers where c.CurrentRentedMovies.Contains(m) select c); // CODE SLEECTS THE CUSTOMERS have rented movies from list m
}
return(View(model));
}
public IActionResult Index(CustomerSearchViewModel model)
{
if (ModelState.IsValid)
{
if (_customerSearch.CustomerSearch(model.Name, model.Phone, model.Email))
{
ModelState.Clear();
ViewBag.Message = "Thanks!";
}
}
return(View());
}
protected virtual void PrepareCustomerRolesModel(CustomerSearchViewModel model)
{
var roles = RoleManager.Roles.ToList();
foreach (var role in roles)
{
model.AvailabelCustomerRoles.Add(new SelectListItem
{
Text = role.Name,
Value = role.Id
});
}
}
public ActionResult Search(CustomerSearchViewModel model)
{
if (!string.IsNullOrEmpty(model.Name))
{
var customers = userService.SearchCustomers(model.Name)
.OrderBy(x => x.DisplayName)
.ToList();
model.Results = customers;
}
return(View(model));
}
public ActionResult SearchCustomer(int?seatid)
{
CustomerSearchViewModel vm = new CustomerSearchViewModel();
vm.Customers = db.Users.Where(c => c.EmpType == "Customer" || c.EmpType == null).ToList();
vm.Seat = db.Seats.Find(seatid);
vm.SeatID = seatid;
ViewBag.SeatInfo = "Seat " + vm.Seat.SeatName + " on Flight " + vm.Seat.Flight.FlightNumber.Number.ToString() + " on " + vm.Seat.Flight.DepartDateTime.Date.ToString();
vm.Customers = vm.Customers.OrderBy(d => d.AdvantageNumber).ThenBy(d => d.LastName).ThenBy(d => d.FirstName).ToList();
db.csvms.Add(vm);
db.SaveChanges();
return(View(vm));
}
// GET: Customer
public ActionResult Index()
{
try
{
var model = new CustomerSearchViewModel();
SearchOrders(model);
return(View(model));
}
catch (Exception ex)
{
ErrorNotification(ex);
return(View());
}
}
