public ESearch GetByID(string id) { using var context = new SMySQLContext(); ESearch e = context.Searches.SingleOrDefault(x => x.Id == id); return(e); }
public async Task <ActionResult <List <EProduct> > > Search([FromBody] ESearch eSearch) { eSearch.CreationDateUTC = DateTime.UtcNow; var result = await searchService.Search(eSearch); return(Ok(result)); }
public async Task <IEnumerable <ETransaction> > Search(ESearch search) { var transactions = (from t in _context.Transaction select new ETransaction { Amount = t.Amount, IsFraud = t.IsFraud, NameDest = t.NameDest, NameOrig = t.NameOrig, IdTransaction = t.IdTransaction, Type = (ETransactionType)Enum.Parse(typeof(ETransactionType), t.Type), TransactionDate = t.TransactionDate }); if (!string.IsNullOrEmpty(search.NameDest)) { transactions = transactions.Where(x => x.NameDest == search.NameDest); } if (search.IsFraud) { transactions = transactions.Where(x => x.IsFraud == search.IsFraud); } if (search.TransactionDate != null) { transactions = transactions.Where(x => x.TransactionDate.Date == search.TransactionDate.Value.Date); } return(await transactions.ToListAsync()); }
//=====================================================GETS ABOVE===================================================== #region AddAsync public async Task <string> AddAsync(ESearch eSearch) { eSearch.CreationDateUTC = DateTime.UtcNow; eSearch.Id = Guid.NewGuid().ToString(); using var context = new SMySQLContext(); var e = await context.Searches.AddAsync(eSearch); await context.SaveChangesAsync(); return(e.Entity.Id); }
public IActionResult Search(ESearch search) { var transactions = _transactionService.Search(search); ETransactionSearch transactionSearch = new ETransactionSearch { Transactions = transactions.Result, Search = new ESearch() { TransactionDate = DateTime.Now } }; return(View("Index", transactionSearch)); }
public async Task <IActionResult> SearchTransactions([FromBody] ESearch search) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { var transactions = await _transactionService.Search(search); return(Ok(transactions)); } catch (Exception ex) { return(Ok(new EResponse() { Code = "2", Desc = ex.GetDetail() })); } }
public async Task <List <EProduct> > Search(ESearch eSearch) { ClientDefines.Loading = true; HttpRequestMessage req = new HttpRequestMessage(HttpMethod.Post, $"api/v1/SSearch/Search"); req.Headers.Add("Authorization", $"bearer {ClientDefines.Token}"); req.Content = new StringContent(JsonConvert.SerializeObject(eSearch), Encoding.UTF8, "application/json"); var response = await httpClient.SendAsync(req); ClientDefines.Loading = false; if (response.StatusCode == System.Net.HttpStatusCode.Unauthorized) { throw new UnauthorizedAccessException(); } response.EnsureSuccessStatusCode(); string responseBody = await response.Content.ReadAsStringAsync(); List <EProduct> result = JsonConvert.DeserializeObject <List <EProduct> >(responseBody); return(result); }
public async Task <List <EProduct> > Search(ESearch eSearch) { List <EProduct> list = new List <EProduct>(); //using var context = new SMySQLContext(); //await AddAsync(eSearch); string pattern = @"(\w+)(\s+)?(\w+)?"; RegexOptions regexOptions = RegexOptions.IgnoreCase | RegexOptions.Singleline | RegexOptions.CultureInvariant; Regex rx = new Regex(pattern, regexOptions); MatchCollection matches = rx.Matches(eSearch.Text); if (matches.Count == 0) { return(list); } GroupCollection groups = matches[0].Groups;//palavra+espaco+palavra if (groups.Count < 2) { return(list); } string firstWord = groups[1].Value; double amount = GetAmount(firstWord); if (amount < 0) { return(list); } var resultList = GetProductInSearch(groups); foreach (EProduct eProduct in resultList) { eProduct.Amount = amount; eProduct.TotalPrice = ((decimal)eProduct.Amount) * eProduct.UnitPrice; } return(resultList); }