public async Task <IActionResult> GetClientList(ClientSearchViewModel model)
{
_logger.LogInformation(GetLogDetails() + " - model:{@Model}", args: new object[] { model });
var result = await _clientService.GetClientListViewModelAsync(model);
return(Json(result.Model));
}
protected override void OnActivate()
{
base.OnActivate();
#region Инициализация поисковых комбобоксов
this.ObtainerCombo = new EmployeeSearchViewModel(Model, "Приёмщик",
Builders <Employee> .Filter.Eq(nameof(Employee.Profession), EmployeeProfession.Advisor));
this.CorpObtainerCombo = new ClientSearchViewModel(Model, "Приёмщик (корпоративный)",
Builders <Client> .Filter.Eq(nameof(Client.IsCorporative), true));
this.InCourierCombo = new EmployeeSearchViewModel(Model, "Курьер, забирающий заказ",
Builders <Employee> .Filter.Eq(nameof(Employee.Profession), EmployeeProfession.Courier));
this.WasherCombo = new EmployeeSearchViewModel(Model, "Прачечник",
Builders <Employee> .Filter.Eq(nameof(Employee.Profession), EmployeeProfession.Washer));
this.OutCourierCombo = new EmployeeSearchViewModel(Model, "Курьер, вовзращающий заказ",
Builders <Employee> .Filter.Eq(nameof(Employee.Profession), EmployeeProfession.Courier));
this.CorpDistributerCombo = new ClientSearchViewModel(Model, "Приёмщик (корпоративный), принимающий заказ",
Builders <Client> .Filter.Eq(nameof(Client.IsCorporative), true));
this.DistributerCombo = new EmployeeSearchViewModel(Model, "Приёмщик, выдающий заказ",
Builders <Employee> .Filter.Eq(nameof(Employee.Profession), EmployeeProfession.Advisor));
this.ObtainerCombo.EntityChanged += obtainer => this.EntityRepository.SetObtainer(this.Entity, obtainer);
this.CorpObtainerCombo.EntityChanged +=
corpObtainer => this.EntityRepository.SetObtainer(this.Entity, corpObtainer);
this.InCourierCombo.EntityChanged += inCourier => this.EntityRepository.SetInCourier(this.Entity, inCourier);
this.WasherCombo.EntityChanged += washer => this.EntityRepository.SetWasher(this.Entity, washer);
this.OutCourierCombo.EntityChanged += outCourier => this.EntityRepository.SetOutCourier(this.Entity, outCourier);
this.CorpDistributerCombo.EntityChanged += corpDistributer =>
this.EntityRepository.SetDistributer(this.Entity, corpDistributer);
this.DistributerCombo.EntityChanged +=
distributer => this.EntityRepository.SetDistributer(this.Entity, distributer);
#endregion
}
// GET: Client
public ActionResult Index(ClientSearchViewModel viewModel)
{
IQueryable <Client> query = null;
if (ModelState.IsValid)
{
query = SearchClientsByCriteria(viewModel);
}
var result = from c in query
select new ClientViewModel
{
ClientId = c.Id,
ClientName = c.Name,
CreatedDate = c.CreatedDate,
ModifiedDate = c.ModifiedDate,
AccountList = c.Accounts.Select(a => new AccountViewModel
{
Id = a.Id,
AccountNumber = a.AccountNumber,
Title = a.Title,
Balance = a.Balance,
CurrencyId = a.CurrencyId
}).ToList()
};
viewModel.ClientList = result.ToPagedList(viewModel.page ?? 1, viewModel.pageSize ?? 10);
return(View(viewModel));
}
public ActionResult Profile()
{
ClientSearchViewModel clientSearch = new ClientSearchViewModel();
using (var db = new PCMConnection())
{
clientSearch.Clients = db.ClientMasters.Where(c => c.Active == true).ToList();
}
return(View("ClientList", clientSearch));
}
public IActionResult Search(ClientSearchViewModel model)
{
if (model.SearchBy == "FirstName")
{
model.Clients =
context.Clients.Where(u => u.FirstName == model.Value)
.ToList()
.OrderBy(u => u.FirstName)
.ThenBy(u => u.LastName)
.Select(u => new ClientViewModel()
{
Id = u.Id,
FirstName = u.FirstName,
LastName = u.LastName,
IsAdult = u.IsAdult
})
.ToList();
}
else if (model.SearchBy == "LastName")
{
model.Clients =
context.Clients.Where(u => u.LastName == model.Value)
.ToList()
.OrderBy(u => u.FirstName)
.ThenBy(u => u.LastName)
.Select(u => new ClientViewModel()
{
Id = u.Id,
FirstName = u.FirstName,
LastName = u.LastName,
IsAdult = u.IsAdult
})
.ToList();
}
else
{
model.Clients = context.Clients
.OrderBy(u => u.FirstName)
.ThenBy(u => u.LastName)
.Select(u => new ClientViewModel()
{
Id = u.Id,
FirstName = u.FirstName,
LastName = u.LastName,
IsAdult = u.IsAdult
})
.ToList();
}
return(View(model));
}
private IQueryable <Client> SearchClientsByCriteria(ClientSearchViewModel viewModel)
{
var query = from c in db.Clients
select c;
if (!string.IsNullOrEmpty(viewModel.ClientName))
{
query = from c in query
where c.Name.ToLower().Contains(viewModel.ClientName.ToLower())
select c;
}
query = ApplySortOrder(viewModel, query);
return(query);
}
public ActionResult Profile(ClientSearchViewModel searchName)
{
ClientSearchViewModel clientSearch = new ClientSearchViewModel();
using (var db = new PCMConnection())
{
if (searchName.NameSearch == null)
{
clientSearch.Clients = db.ClientMasters.Where(c => c.Active == true).ToList();
}
else
{
clientSearch.Clients = db.ClientMasters.Where(c => c.Name.Contains(searchName.NameSearch)).ToList();
}
}
return(View("ClientList", clientSearch));
}
// GET: Clients
public ActionResult Index(ClientSearchViewModel search)
{
IEnumerable <Client> searched = data;
if (search != null)
{
if (!string.IsNullOrEmpty(search.Name))
{
searched = data.Where(p => p.Name.Contains(search.Name));
}
if (!string.IsNullOrEmpty(search.Phone))
{
searched = searched.Where(p => p.Phone.Contains(search.Phone));
}
}
return(View(searched));
}
public async Task <ICollection <ClientListViewModel> > ListClientsAsync(ClientSearchViewModel model)
{
return(await _context.Client
.Where(e => (!model.StartDate.HasValue || e.Date >= model.StartDate) &&
(!model.EndDate.HasValue || e.Date <= model.EndDate) &&
(string.IsNullOrEmpty(model.FirstName) || e.FirstName.Contains(model.FirstName)) &&
(string.IsNullOrEmpty(model.LastName) || e.LastName.Contains(model.LastName)))
.Select(e => new ClientListViewModel
{
ClientId = e.ClientId,
FirstName = e.FirstName,
LastName = e.LastName,
ReferenceNumber = e.ReferenceNumber,
Date = e.Date
})
.OrderByDescending(vm => vm.CreatedUtc)
.ToListAsync());
}
public ActionResult Index(string sort = "", string sortdir = "", string searchText = "")
{
ViewBag.ddlSearchUnit = GetItemsUnit(string.Empty);
ViewBag.ddlSearchLedger = GetItemsLedger(string.Empty);
ClientSearchViewModel model;
if (string.IsNullOrEmpty(sort) && string.IsNullOrEmpty(sortdir) && string.IsNullOrEmpty(searchText))
{
ViewBag.ShowAdvancedSearch = "hideAdvancedSearch"; //standard
model = new ClientSearchViewModel();
}
else
{
model = DoSort(sort, sortdir);
}
return(View(model));
}
// GET: Client
public async Task <IActionResult> Index(string firstName, string searchString)
{
IQueryable <string> fnQuery = from m in _context.Clients
orderby m.FirstName
select m.FirstName;
var clients = from m in _context.Clients
select m;
if (!String.IsNullOrEmpty(searchString))
{
clients = clients.Where(s => s.LastName.Contains(searchString));
}
if (!string.IsNullOrEmpty(firstName))
{
clients = clients.Where(x => x.FirstName == firstName);
}
var FnlnVM = new ClientSearchViewModel
{
FirstNames = new SelectList(await fnQuery.Distinct().ToListAsync()),
Clients = await clients.ToListAsync()
};
return(View(FnlnVM));
}
public async Task <(bool Success, string Error, ICollection <ClientListViewModel> Model)> GetClientListViewModelAsync(ClientSearchViewModel model)
{
var success = false;
string error = string.Empty;
ICollection <ClientListViewModel> retModel = new List <ClientListViewModel>();
try
{
retModel = await _clientRepository.ListClientsAsync(model);
success = true;
}
catch (Exception ex)
{
error = "Somethong went wrong while processing your request.";
_logger.LogError("ClientService.GetClientListViewModelAsync - exception:{@Ex}", args: new object[] { ex });
}
return(Success : success, Error : error, Model : retModel);
}
public void Cleanup()
{
this._mockRepository = null;
this._clientSearchViewModel = null;
GC.Collect();
}
//
// GET: /ClientEntry/
public ActionResult Index(string sortOrder, string CurrentSort, int?page)
{
int pageSize = 10;
int pageIndex = 1;
pageIndex = page.HasValue ? Convert.ToInt32(page) : 1;
IPagedList <SET_CLIENT_INFO> client_info = null;
ClientSearchViewModel clientModel = null;
var clients = db.SET_CLIENT_INFO.AsQueryable();
if (Request.QueryString.HasKeys() && !page.HasValue)
{
clientModel = new ClientSearchViewModel();
if (!string.IsNullOrEmpty(Request.QueryString["Search_Name"]))
{
clientModel.Search_Name = Request.QueryString["Search_Name"];
clients = clients.Where(u => u.CLIENT_NAME.ToLower()
.Contains(clientModel.Search_Name.ToLower()));
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Mobile"]))
{
clientModel.Search_Mobile = Request.QueryString["Search_Mobile"];
clients = clients.Where(u => u.CLIENT_MOBILE.ToLower()
.Contains(clientModel.Search_Mobile.ToLower()));
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Division"]))
{
clientModel.Search_Division = decimal.Parse(Request.QueryString["Search_Division"]);
clients = clients.Where(u => u.DIVISION_NO == clientModel.Search_Division);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Zilla"]))
{
clientModel.Search_Zilla = decimal.Parse(Request.QueryString["Search_Zilla"]);
clients = clients.Where(u => u.ZILLA_NO == clientModel.Search_Zilla);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Thana"]))
{
clientModel.Search_Thana = decimal.Parse(Request.QueryString["Search_Thana"]);
clients = clients.Where(u => u.THANA_NO == clientModel.Search_Thana);
}
if (!string.IsNullOrEmpty(Request.QueryString["Search_Active"]) &&
Request.QueryString["Search_Active"] != "null")
{
clientModel.Search_Active = bool.Parse(Request.QueryString["Search_Active"]);
decimal active = clientModel.Search_Active == true ? 1 : 0;
clients = clients.Where(u => u.IS_ACTIVE == active);
}
Session["Client_Search_Model"] = clientModel;
}
if (!Request.QueryString.HasKeys() && !page.HasValue)
{
Session["Client_Search_Model"] = null;
}
if (Session["Client_Search_Model"] != null)
{
clientModel = (ClientSearchViewModel)Session["Client_Search_Model"];
if (!string.IsNullOrEmpty(clientModel.Search_Name))
{
clients = clients.Where(u => u.CLIENT_NAME.ToLower()
.Contains(clientModel.Search_Name.ToLower()));
}
if (!string.IsNullOrEmpty(clientModel.Search_Mobile))
{
clients = clients.Where(u => u.CLIENT_MOBILE.ToLower()
.Contains(clientModel.Search_Mobile.ToLower()));
}
if (clientModel.Search_Division.HasValue)
{
clients = clients.Where(u => u.DIVISION_NO == clientModel.Search_Division);
}
if (clientModel.Search_Zilla.HasValue)
{
clients = clients.Where(u => u.ZILLA_NO == clientModel.Search_Zilla);
}
if (clientModel.Search_Thana.HasValue)
{
clients = clients.Where(u => u.THANA_NO == clientModel.Search_Thana);
}
if (clientModel.Search_Active.HasValue)
{
decimal active = clientModel.Search_Active == true ? 1 : 0;
clients = clients.Where(u => u.IS_ACTIVE == active);
}
}
client_info = clients.OrderBy(m => m.CLIENT_NAME)
.ToPagedList(pageIndex, pageSize);
ViewBag.Search_Client_Model = (ClientSearchViewModel)Session["Client_Search_Model"];
if (clientModel != null && clientModel.Search_Division.HasValue)
{
ViewBag.Search_Division = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME",
clientModel.Search_Division);
}
else
{
ViewBag.Search_Division = new SelectList(db.SET_DIVISION, "DIVISION_NO", "DIVISION_NAME");
}
if (clientModel != null && clientModel.Search_Zilla.HasValue)
{
ViewBag.Search_Zilla = new SelectList(db.SET_ZILLA, "ZILLA_NO", "ZILLA_NAME",
clientModel.Search_Zilla);
}
else
{
if (clientModel != null && clientModel.Search_Division.HasValue)
{
ViewBag.Search_Zilla = new SelectList(db.SET_ZILLA
.Where(z => z.DIVISION_NO == clientModel.Search_Division), "ZILLA_NO", "ZILLA_NAME");
}
else
{
ViewBag.Search_Zilla = new SelectList(db.SET_ZILLA.Where(z => z.ZILLA_NO < 0));
}
}
if (clientModel != null && clientModel.Search_Thana.HasValue)
{
ViewBag.Search_Thana = new SelectList(db.SET_THANA, "THANA_NO", "THANA_NAME",
clientModel.Search_Thana);
}
else
{
if (clientModel != null && clientModel.Search_Zilla.HasValue)
{
ViewBag.Search_Thana = new SelectList(db.SET_THANA
.Where(t => t.ZILLA_NO == clientModel.Search_Zilla), "THANA_NO", "THANA_NAME");
}
else
{
ViewBag.Search_Thana = new SelectList(db.SET_THANA.Where(t => t.THANA_NO < 0));
}
}
/*
* var set_client_info = db.SET_CLIENT_INFO.Include("SET_DIVISION")
* .Include("SET_ZILLA").Include("SET_THANA");*/
return(View(client_info));
}
public void Init()
{
this._mockRepository = new Mock <IRepository>();
this._mockDialogService = new Mock <IDialogService>();
this._clientSearchViewModel = new ClientSearchViewModel(this._mockRepository.Object, this._mockDialogService.Object);
}
public ClientSearch(ModelContainer context)
{
InitializeComponent();
DataContext = ViewModel = new ClientSearchViewModel(this, context);
}
private IQueryable <Client> ApplySortOrder(ClientSearchViewModel viewModel, IQueryable <Client> query)
{
#region Apply sort order
switch (viewModel.SortParameter)
{
case "NameSortParameter":
query = query.OrderBy(q => q.Name);
viewModel.NameSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
case "NameSortParameter_desc":
query = query.OrderByDescending(q => q.Name);
viewModel.NameSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
case "AccountsSortParameter":
query = query.OrderBy(q => q.Accounts.Count());
viewModel.AccountsSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
case "AccountsSortParameter_desc":
query = query.OrderByDescending(q => q.Accounts.Count());
viewModel.AccountsSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
case "AccountTotalSortParameter":
query = query.OrderBy(q => q.Accounts.Sum(a => a.Balance));
viewModel.AccountTotalSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
case "AccountTotalSortParameter_desc":
query = query.OrderByDescending(q => q.Accounts.Sum(a => a.Balance));
viewModel.AccountTotalSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
case "CreatedDateSortParameter":
query = query.OrderBy(q => q.CreatedDate);
viewModel.CreatedDateSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
case "CreatedDateSortParameter_desc":
query = query.OrderByDescending(q => q.CreatedDate);
viewModel.CreatedDateSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
case "ModifiedDateSortParameter":
query = query.OrderBy(q => q.CreatedDate);
viewModel.CreatedDateSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
case "ModifiedDateSortParameter_desc":
query = query.OrderByDescending(q => q.CreatedDate);
viewModel.CreatedDateSortParameter = MVCStringHelper.ConvertSortDirection(viewModel.SortParameter);
break;
default:
query = query.OrderBy(q => q.Name);
break;
}
#endregion
return(query);
}
public ActionResult Index(FormCollection form)
{
ViewBag.ddlSearchUnit = GetItemsUnit(string.Empty);
ViewBag.ddlSearchLedger = GetItemsLedger(string.Empty);
var searchText = form["txtSearchText"].Trim();
var model = new ClientSearchViewModel
{
SearchText = searchText,
SearchUnit = form["ddlSearchUnit"],
SortField = form["SortField"],
SortDirection = form["SortDirection"]
};
ViewBag.ShowAdvancedSearch = form["hidIsAdvanced"].Trim();
form["hidIsAdvanced"] = ViewBag.ShowAdvancedSearch;
ViewBag.txtSearchText = searchText;
var searchUnit = form["ddlSearchUnit"];
var searchLedger = form["ddlSearchLedger"];
var searchName = form["txtSearchText"];
var searchClientCode = form["txtSearchClientCode"];
var searchAddress = form["txtSearchAddress"];
var searchUnderWriterPolicyNo = form["txtSearchUnderWriterPolicyNo"];
var searchMemoNo = form["txtSearchMemoNo"];
var searchInvoiceNo = form["txtSearchInvoiceNo"];
var searchDepositBsb = form["txtSearchDepositBSB"];
var searchDepositAccount = form["txtSearchDepositAccount"];
var clientFromAdvancedSearch = Searcher.AdvancedSearchProc(searchUnit,
searchLedger,
searchName,
searchAddress,
searchUnderWriterPolicyNo,
searchMemoNo,
searchInvoiceNo,
searchDepositBsb,
searchDepositAccount,
searchClientCode);
model.SearchResults = clientFromAdvancedSearch;
var cache = new DefaultCacheProvider();
if (Request.LogonUserIdentity != null)
{
var cacheKey = Request.LogonUserIdentity.Name;
cache.Set(cacheKey, model, 30);
}
//reset fields for reshowing
ViewBag.ddlSearchUnit = GetItemsUnit(searchUnit);
ViewBag.ddlSearchLedger = GetItemsLedger(searchLedger);
ViewBag.txtSearchName = searchName;
ViewBag.txtSearchAddress = searchAddress;
ViewBag.txtSearchUnderWriterPolicyNo = searchUnderWriterPolicyNo;
ViewBag.txtSearchMemoNo = searchMemoNo;
ViewBag.txtSearchInvoiceNo = searchInvoiceNo;
ViewBag.txtSearchDepositBSB = searchDepositBsb;
ViewBag.txtSearchDepositAccount = searchDepositAccount;
ViewBag.txtSearchClientCode = searchClientCode;
return(View(model));
}
private ClientSearchViewModel DoSort(string sort, string sortdir)
{
ClientSearchViewModel model;
var cache = new DefaultCacheProvider();
var cacheKey = Request.LogonUserIdentity.Name;
var cachedModel = cache.Get(cacheKey);
if (cachedModel == null)
{
model = new ClientSearchViewModel();
}
else
{
model = (ClientSearchViewModel)cachedModel;
sortdir = string.IsNullOrEmpty(sortdir) ? "asc" : sortdir;
sort = string.IsNullOrEmpty(sort) ? "name" : sort;
if (string.Equals(model.SortField, sort, StringComparison.CurrentCultureIgnoreCase))
{
model.SortDirection = string.Equals(sortdir.ToLowerInvariant(), "asc") ? "desc" : "asc";
}
model.SortField = sort;
switch (sort.ToLowerInvariant())
{
case "unit":
{
model.SearchResults = string.Equals(model.SortDirection, "asc")
? model.SearchResults.OrderBy(x => x.Unit)
: model.SearchResults.OrderByDescending(x => x.Unit);
break;
}
case "ledger code":
{
model.SearchResults = string.Equals(model.SortDirection, "asc")
? model.SearchResults.OrderBy(x => x.LedgerCode)
: model.SearchResults.OrderByDescending(x => x.LedgerCode);
break;
}
case "name":
{
model.SearchResults = string.Equals(model.SortDirection, "asc")
? model.SearchResults.OrderBy(x => x.Name)
: model.SearchResults.OrderByDescending(x => x.Name);
break;
}
case "client code":
{
model.SearchResults = string.Equals(model.SortDirection, "asc")
? model.SearchResults.OrderBy(x => x.ClientCode)
: model.SearchResults.OrderByDescending(x => x.ClientCode);
break;
}
case "account executive":
{
model.SearchResults = string.Equals(model.SortDirection, "asc")
? model.SearchResults.OrderBy(x => x.AccountExecutive)
: model.SearchResults.OrderByDescending(x => x.AccountExecutive);
break;
}
}
}
return(model);
}
