public virtual ActionResult Search(string array, string term = "", string search = "", string order = "")
{
int[] arrayResult = Array.ConvertAll(array.Split(','), x => int.Parse(x)).ToArray();
StatusSearch serachResult = (StatusSearch)Enum.Parse(typeof(StatusSearch), search);
StatusOrder orderResult = (StatusOrder)Enum.Parse(typeof(StatusOrder), order);
return(View());
}
public FrmSearchHn(IvfControl ic, StatusConnection statusconn, StatusSearch statussearch, StatusSearchTable statussearchtable)
{
InitializeComponent();
this.ic = ic;
this.statusconn = statusconn;
this.statussearch = statussearch;
this.statussearchtable = statussearchtable;
initConfig();
}
private bool IsEditMode = false; //ForEditMode
public Assignment()
{
InitializeComponent();
TeacherSearch.ForeColor = Color.Gray;
TeacherSearch.Text = "Search Teacher's Name";
TeacherSearch.Select(TeacherSearch.TextLength, 0);
StudentSearch.ForeColor = Color.Gray;
StudentSearch.Text = "Search Student's Name";
StudentSearch.Select(StudentSearch.TextLength, 0);
StatusSearch.ForeColor = Color.Gray;
StatusSearch.Text = "Search Status's Name";
StatusSearch.Select(StatusSearch.Text.Length, 0); //ForDataSearch
}
public virtual ActionResult GetDataTable(string arrayCategory, string arrayCompany, string search = "", string order = "", string term = "", int count = 20, int page = 0)
{
int[] arrayResultCategory = (!string.IsNullOrEmpty(arrayCategory)) ? Array.ConvertAll(arrayCategory.Split(','), x => int.Parse(x)).ToArray() : null;
int[] arrayResultCompany = (!string.IsNullOrEmpty(arrayCompany)) ? Array.ConvertAll(arrayCompany.Split(','), x => int.Parse(x)).ToArray() : null;
var resultCategory = _categoryService.CheckCollectionId_(arrayResultCategory);
if (resultCategory)
{
var resultCompany = _companyService.CheckCollectionId_(arrayResultCompany);
if (resultCompany)
{
StatusSearch serachResult = (StatusSearch)Enum.Parse(typeof(StatusSearch), search);
StatusOrder orderResult = (StatusOrder)Enum.Parse(typeof(StatusOrder), order);
//مقدار دهی
ViewBag.arrayCategory = arrayCategory;
ViewBag.search = search;
ViewBag.order = order;
ViewBag.term = term;
ViewBag.count = count;
ViewBag.page = page;
ViewBag.arrayCompany = arrayCompany;
var totalRecord = _productService.CountProductSerach_(term.ToSafeHtml(), arrayResultCategory, arrayResultCompany);
ViewBag.totalRecords = totalRecord;
ViewBag.currentPage = page + 1;
var list = _productService.GetdataTableProduct_(arrayResultCategory, arrayResultCompany, term.ToSafeHtml(), count, page, serachResult, orderResult);
if (list.Count() > 0)
{
return(PartialView(viewName: "_DataTableCategory", model: list));
}
else
{
return(PartialView(MVC.Shared.Views._Alert));
}
}
else
{
return(PartialView(MVC.Shared.Views._Alert));
}
}
else
{
return(PartialView(MVC.Shared.Views._Alert));
}
}
public Task <IEnumerable <Status> > GetAsync(StatusSearch option, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT *
FROM StatusMaster
WHERE CompanyId = @CompanyId
AND StatusType = @StatusType";
if (option.Codes?.Any() ?? false)
{
query += @"
AND Code IN (SELECT Code FROM @Codes) ";
}
query += @"
ORDER BY DisplayOrder ASC";
return(dbHelper.GetItemsAsync <Status>(query, option, token));
}
private StatusSearch SearchPlayer()
{
if (!_player1.isPlayer && !_player2.isPlayer)
{
statusSearch = StatusSearch.Nothing;
}
else if (_player1.isPlayer && !_player2.isPlayer ||
(!_player1.isPlayer && _player2.isPlayer))
{
statusSearch = StatusSearch.One;
}
else if ((_player1.isPlayer && _player2.isPlayer) &&
((_player1.isPlayerBehind && !_player2.isPlayerBehind) ||
(!_player1.isPlayerBehind && _player2.isPlayerBehind)))
{
statusSearch = StatusSearch.OneWithoutSecond;
}
else
{
statusSearch = StatusSearch.Two;
}
Debug.Log(statusSearch);
return(statusSearch);
}
public async Task <IEnumerable <Status> > GetItems(StatusSearch option, CancellationToken token) => (await statusProcessor.GetAsync(option, token)).ToArray();
private void StatusSearch_Enter(object sender, EventArgs e)
{
StatusSearch.ResetText();
StatusSearch.ForeColor = Color.Black;
}
public async Task <IEnumerable <Status> > GetAsync(StatusSearch option, CancellationToken token = default(CancellationToken)) => await statusQueryProcessor.GetAsync(option, token);
public List <ProductShowViewModel> GetdataTableProduct_(int[] array, int[] arrayCompany, string term, int count, int page,
StatusSearch search = StatusSearch.MoreVisited,
StatusOrder order = StatusOrder.Ascending)
{
var lstProduct = _dbSet.Where(x => array.Contains(x.Category.Id))
.Where(x => arrayCompany.Contains(x.Company.Id))
.Where(x => x.Name.Contains(term)).AsQueryable();
if (order == StatusOrder.Ascending)
{
switch (search)
{
case StatusSearch.MoreVisited:
lstProduct = lstProduct.OrderByDescending(x => x.VisitNumber).AsQueryable();
break;
case StatusSearch.New:
lstProduct = lstProduct.OrderByDescending(x => x.Date).AsQueryable();
break;
case StatusSearch.Offer:
lstProduct = lstProduct.OrderBy(x => x.Recomend == (int)StatusRecomend.SpecialRecomend).AsQueryable();
break;
case StatusSearch.Price:
lstProduct = lstProduct.OrderByDescending(x => x.Price).AsQueryable();
break;
}
}
else
{
switch (search)
{
case StatusSearch.MoreVisited:
lstProduct = lstProduct.OrderBy(x => x.VisitNumber).AsQueryable();
break;
case StatusSearch.New:
lstProduct = lstProduct.OrderBy(x => x.Id).AsQueryable();
break;
case StatusSearch.Offer:
lstProduct = lstProduct.OrderByDescending(x => x.Recomend == (int)StatusRecomend.SpecialRecomend).AsQueryable();
break;
case StatusSearch.Price:
lstProduct = lstProduct.OrderBy(x => x.Price).AsQueryable();
break;
}
}
return(lstProduct.Select(x => new ProductShowViewModel
{
Id = x.Id,
Name = x.Name,
Price = x.Price,
PrimaryImage = x.PrimryImage,
Explain = (x.Explain.Length > 380 ? x.Explain.Substring(0, 380) : x.Explain)
}).Skip(count * page).Take(count).ToList());
}
