public ActionResult <PageResponse <TransactionDTO> > Transactions([FromQuery] TransactionSearch search) { var userId = AuthMiddleware.GetUserId(User); var transactions = _service.GetTransactions(search, userId); return(Ok(transactions)); }
public IActionResult Transaction([FromQuery] TransactionSearch search) { var id = GetTokenId.getId(User); var transaction = _userService.GetTRansactions(search, id); return(Ok(transaction)); }
public PageResponse <TransactionDTO> GetTransactions(TransactionSearch search, int userId) { var wallet = _unitOfWork.Wallet.Find(w => w.UserId == userId).FirstOrDefault(); search.WalletId = wallet.Id; var transactions = Execute(search); return(transactions); }
public IActionResult GetTransactions(int id, [FromQuery] TransactionSearch search) { try { var result = transactionRepository.GetTransactions(id, search); return(Ok(result)); } catch (Exception ex) { return(HandleException(ex)); } }
public IHttpActionResult GetTrans(TransactionSearch search) { if (search == null) { return(BadRequest()); } if (search.Filter == null) { search.Filter = new TransactionFilter(); } var lst = transactionSvc.GetTransactions(search.Filter.AccountID, search.Filter.Description); search.Pagination.TotalItems = lst.Count; search.Transactions = lst.Skip((search.Pagination.Page - 1) * search.Pagination.ItemsPerPage).Take(search.Pagination.ItemsPerPage).ToList(); return(Ok(search)); }
public PageResponse <TransactionDTO> Execute(TransactionSearch request) { var query = _unitOfWork.Transaction.Find(t => t.WalletID == request.WalletId); if (request.MinAmount.HasValue) { query = query.Where(t => t.Amount >= request.MinAmount); } if (request.MaxAmount.HasValue) { query = query.Where(t => t.Amount <= request.MaxAmount); } if (request.Type != null) { var keyword = request.Type.ToLower(); query = query.Where(t => t.Type.ToLower().Contains(keyword)); } var totalCount = query.Count(); query = query.Skip((request.PageNumber - 1) * request.PerPage).Take(request.PerPage); var pagesCount = (int)Math.Ceiling((double)totalCount / request.PerPage); var response = new PageResponse <TransactionDTO> { CurrentPage = request.PageNumber, TotalCount = totalCount, PageCount = pagesCount, Data = query.Select(t => new TransactionDTO { Amount = t.Amount, Type = t.Type, CreatedAt = t.CreatedtAt }) }; return(response); }
public TransationSearchResult GetTransactions(int accountId, TransactionSearch search) { if (search.Query == null) { search.Query = string.Empty; } int pageSize = 20; var transactions = base.Table <BankTransaction>() .Where(q => q.AccountId == (accountId > 0 ? accountId : q.AccountId) && (q.Description.Contains(search.Query) || q.Tag.Contains(search.Query))) .OrderByDescending(o => o.TransactionDate) .ProjectTo <Transaction>().ToList(); var result = new TransationSearchResult() { ItemsPerPage = pageSize, Page = search.Page, Count = transactions.Count, Data = transactions.Skip((search.Page - 1) * pageSize).Take(pageSize).ToList() }; return(result); }
public List <TransactionDataItem> SearchPastel(string buildingPath, DateTime fromDate, DateTime toDate, string reference, string description, decimal?minimumAmount, decimal?maximumAmount) { return(TransactionSearch.SearchPastel(buildingPath, fromDate, toDate, reference, description, minimumAmount, maximumAmount)); }
public void savedSearchMaxCredible(NetSuiteService service) { TransactionSearchAdvanced TSA = new TransactionSearchAdvanced(); TSA.savedSearchScriptId = TxtSavedSearch1.Text; TransactionSearch TS = new TransactionSearch(); TransactionSearchBasic TSB = new TransactionSearchBasic(); if (Settings.Default.APP_DatesEnabled) { DateTime theSearchStartDate = DTPickerFrom.Value; DateTime theSearchFinishDate = DTPickerTo.Value; SearchDateField theDTSearch = new SearchDateField(); theDTSearch.operatorSpecified = true; theDTSearch.@operator = SearchDateFieldOperator.within; theDTSearch.searchValue2Specified = true; theDTSearch.searchValueSpecified = true; theDTSearch.searchValue = theSearchStartDate; theDTSearch.searchValue2 = theSearchFinishDate; TSB.tranDate = theDTSearch; } TS.basic = TSB; TSA.criteria = TS; AppendTextBoxLine(txtSearchResults, "Performing search ...", true); SearchResult SR = service.search(TSA); if (SR.totalRecords == 0) { AppendTextBoxLine(txtSearchResults, "No records / consignments were returned in the Saved Search : " + TxtSavedSearch1.Text, true); } else { AppendTextBoxLine(txtSearchResults, SR.totalRecords + " records / consignments were returned in the Saved Search : " + TxtSavedSearch1.Text, true); SearchRow[] SSR; SSR = SR.searchRowList; SearchRow[] SSRM; // Build Intermediate List to allow pagination System.Collections.ArrayList theInvoiceList = new System.Collections.ArrayList(); for (int ssr = 0; ssr < SSR.Length; ssr++) theInvoiceList.Add(SSR[ssr]); AppendTextBoxLine(txtSearchResults, "Records downloaded : " + theInvoiceList.Count + " of " + SR.totalRecords.ToString(), true); if (SR.totalRecords > SR.pageSize) { int batchNo = 2; // Keep getting pages until there are no more pages to get while (SR.totalRecords > ((batchNo - 1) * SR.pageSize)) { AppendTextBoxLine(txtSearchResults, "Fetching next batch no. " + batchNo, true); // Invoke searchMore() operation - ensure logged in ... setupNetSuiteObjects(service); // To ensure logged in before next batch SearchResult SRM = service.searchMore(batchNo); if (SRM != null) { // Process response if (SRM.status.isSuccess) { SSRM = SRM.searchRowList; for (int ssrm = 0; ssrm < SSRM.Length; ssrm++) theInvoiceList.Add(SSRM[ssrm]); AppendTextBoxLine(txtSearchResults, "Records downloaded : " + theInvoiceList.Count + " of " + SR.totalRecords.ToString(), true); batchNo++; } else { AppendTextBoxLine(txtSearchResults, getStatusDetails(SRM.status), true); } } } } _SSRECORDS = new SearchRow[theInvoiceList.Count]; IEnumerator iienum = theInvoiceList.GetEnumerator(); for (int iicr = 0; iienum.MoveNext(); iicr++) { _SSRECORDS[iicr] = (SearchRow)iienum.Current; } //Record list assembly complete - create list for MaxCredible upload ProgressNSSearch.Maximum = _SSRECORDS.Length; for (int i = 0; i < _SSRECORDS.Length; i++) { TransactionSearchRow TSR = (TransactionSearchRow)_SSRECORDS[i]; // Declare all the variables for use when writing the file... //DOCNUM string theInternalid = ""; if (TSR.basic.internalId != null) { theInternalid = TSR.basic.internalId[0].searchValue.internalId; } string sDocNum = ""; if (TSR.basic.tranId != null) { sDocNum = TSR.basic.tranId[0].searchValue.ToString(); } //DATE string sDate = ""; if (TSR.basic.tranDate != null) { sDate = TSR.basic.tranDate[0].searchValue.ToString("dd/MM/yyyy"); } AppendTextBoxLine(txtSearchResults, (i+1) + "\t" + theInternalid + "\t" + sDocNum + "\t" + sDate, false); ProgressNSSearch.Value++; } // Set up MaxCredible Data defaults based on records returned _MaxCredibleData.NR_RECORDS = _SSRECORDS.Length.ToString(); _MaxCredibleData.CHUNK_SIZE = TxtChunkSize.Text; GrpMaxCredible.Text = "Step 2 - Upload " + _MaxCredibleData.NR_RECORDS + " Records to MaxCredible"; updateChunkSizes(); } return; }
public static void DeleteItemFullfitment() { string strItem = ""; try { TransactionSearch xactionSearch = new TransactionSearch(); //xactionSearch.basic //SearchMultiSelectField entity = new SearchMultiSelectField(); //entity.@operator = SearchMultiSelectFieldOperator.anyOf; //entity.operatorSpecified = true; //RecordRef custRecordRef = new RecordRef(); //custRecordRef.internalId = strCustomerId; //custRecordRef.type = RecordType.customer; //custRecordRef.typeSpecified = true; //RecordRef[] custRecordRefArray = new RecordRef[1]; //custRecordRefArray[0] = custRecordRef; //entity.searchValue = custRecordRefArray; SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField(); searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf; searchSalesOrderField.operatorSpecified = true; System.String[] soStringArray = new System.String[1]; soStringArray[0] = "_itemFulfillment"; searchSalesOrderField.searchValue = soStringArray; TransactionSearchBasic xactionBasic = new TransactionSearchBasic(); xactionBasic.type = searchSalesOrderField; xactionBasic.dateCreated = new SearchDateField(); xactionBasic.dateCreated.@operator = SearchDateFieldOperator.within; xactionBasic.dateCreated.operatorSpecified = true; xactionBasic.dateCreated.searchValue = new DateTime(2011, 12, 30); xactionBasic.dateCreated.searchValueSpecified = true; xactionBasic.dateCreated.searchValue2 = new DateTime(2011, 12, 31); xactionBasic.dateCreated.searchValue2Specified = true; xactionSearch.basic = xactionBasic; SearchResult objSearchResult = _service.search(xactionSearch); if (objSearchResult.status != null && objSearchResult.status.isSuccess) { if (objSearchResult.recordList != null) { Record[] recordList; for (int i = 1; i <= objSearchResult.totalPages; i++) { recordList = objSearchResult.recordList; for (int j = 0; j < recordList.Length; j++) { if (recordList[j] is ItemFulfillment) { try { ItemFulfillment objOrder = (ItemFulfillment)(recordList[j]); object objCustomReseller = GetValue("custbodytbfcustomerid", objOrder.customFieldList); if (objCustomReseller != null && (objCustomReseller.ToString().Equals("CST100WA") || objCustomReseller.ToString().Equals("1"))) { RecordRef objRef = new RecordRef(); objRef.internalId = ((ItemFulfillment)recordList[j]).internalId; objRef.type = RecordType.itemFulfillment; objRef.typeSpecified = true; WriteResponse writeRes = _service.delete(objRef); if (writeRes.status.isSuccess) { Console.WriteLine("delete: " + objRef.internalId); } else { Console.WriteLine(getStatusDetails(writeRes.status)); } } } catch (Exception objExc) { Console.WriteLine(objExc.ToString()); } } } } } } else { strItem = "error"; } } catch (Exception objExc) { Console.WriteLine(objExc.ToString()); } }
public static string GetOrderId(string strCustomerId, double numAmount) { string strItem = ""; try { TransactionSearch xactionSearch = new TransactionSearch(); SearchMultiSelectField entity = new SearchMultiSelectField(); entity.@operator = SearchMultiSelectFieldOperator.anyOf; entity.operatorSpecified = true; RecordRef custRecordRef = new RecordRef(); custRecordRef.internalId = strCustomerId; custRecordRef.type = RecordType.customer; custRecordRef.typeSpecified = true; RecordRef[] custRecordRefArray = new RecordRef[1]; custRecordRefArray[0] = custRecordRef; entity.searchValue = custRecordRefArray; SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField(); searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf; searchSalesOrderField.operatorSpecified = true; System.String[] soStringArray = new System.String[1]; soStringArray[0] = "_salesOrder"; searchSalesOrderField.searchValue = soStringArray; TransactionSearchBasic xactionBasic = new TransactionSearchBasic(); xactionBasic.type = searchSalesOrderField; xactionBasic.entity = entity; xactionBasic.status = new SearchEnumMultiSelectField(); xactionBasic.status.@operator = SearchEnumMultiSelectFieldOperator.anyOf; xactionBasic.status.operatorSpecified = true; xactionBasic.status.searchValue = new string[] { "_salesOrderPendingApproval" }; xactionBasic.amount = new SearchDoubleField(); xactionBasic.amount.@operator = SearchDoubleFieldOperator.equalTo; xactionBasic.amount.operatorSpecified = true; xactionBasic.amount.searchValue = numAmount; xactionBasic.amount.searchValueSpecified = true; xactionSearch.basic = xactionBasic; SearchResult objSearchResult = _service.search(xactionSearch); if (objSearchResult.recordList != null) { Record[] recordList; for (int i = 1; i <= objSearchResult.totalPages; i++) { recordList = objSearchResult.recordList; for (int j = 0; j < recordList.Length; j++) { if (recordList[j] is SalesOrder) { SalesOrder so = (SalesOrder)(recordList[j]); strItem = so.internalId; return strItem; } } } } } catch (Exception) { } return strItem; }
public static string GetOrderId(string strCustomerId, string strPONumber, string strOrderNumber) { string strItem = ""; try { TransactionSearch xactionSearch = new TransactionSearch(); //SearchMultiSelectField entity = new SearchMultiSelectField(); //entity.@operator = SearchMultiSelectFieldOperator.anyOf; //entity.operatorSpecified = true; //RecordRef custRecordRef = new RecordRef(); //custRecordRef.internalId = strCustomerId; //custRecordRef.type = RecordType.customer; //custRecordRef.typeSpecified = true; //RecordRef[] custRecordRefArray = new RecordRef[1]; //custRecordRefArray[0] = custRecordRef; //entity.searchValue = custRecordRefArray; SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField(); searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf; searchSalesOrderField.operatorSpecified = true; System.String[] soStringArray = new System.String[1]; soStringArray[0] = "_salesOrder"; searchSalesOrderField.searchValue = soStringArray; TransactionSearchBasic xactionBasic = new TransactionSearchBasic(); xactionBasic.type = searchSalesOrderField; //xactionBasic.entity = entity; xactionBasic.otherRefNum = new SearchTextNumberField(); xactionBasic.otherRefNum.@operator = SearchTextNumberFieldOperator.equalTo; xactionBasic.otherRefNum.operatorSpecified = true; xactionBasic.otherRefNum.searchValue = strPONumber; SearchStringCustomField objOrderNumber = new SearchStringCustomField(); objOrderNumber.internalId = "custbodycst_ordernumber"; objOrderNumber.@operator = SearchStringFieldOperator.contains; objOrderNumber.operatorSpecified = true; objOrderNumber.searchValue = strOrderNumber; xactionBasic.customFieldList = new SearchCustomField[] { objOrderNumber }; xactionSearch.basic = xactionBasic; SearchResult objSearchResult = _service.search(xactionSearch); if (objSearchResult.status != null && objSearchResult.status.isSuccess) { if (objSearchResult.recordList != null) { Record[] recordList; for (int i = 1; i <= objSearchResult.totalPages; i++) { recordList = objSearchResult.recordList; for (int j = 0; j < recordList.Length; j++) { if (recordList[j] is SalesOrder) { SalesOrder so = (SalesOrder)(recordList[j]); strItem = so.internalId; return strItem; } } } } } else { strItem = "error"; } } catch (Exception) { } return strItem; }
public static string GetOrderId(string strPONumber, string strReseller) { string strOrderId = ""; try { TransactionSearch xactionSearch = new TransactionSearch(); SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField(); searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf; searchSalesOrderField.operatorSpecified = true; System.String[] soStringArray = new System.String[1]; soStringArray[0] = "_salesOrder"; searchSalesOrderField.searchValue = soStringArray; TransactionSearchBasic xactionBasic = new TransactionSearchBasic(); xactionBasic.type = searchSalesOrderField; xactionBasic.otherRefNum = new SearchTextNumberField(); xactionBasic.otherRefNum.@operator = SearchTextNumberFieldOperator.equalTo; xactionBasic.otherRefNum.operatorSpecified = true; xactionBasic.otherRefNum.searchValue = strPONumber; SearchMultiSelectCustomField objReseller = new SearchMultiSelectCustomField(); objReseller.internalId = "custbodytbfcustomerid"; objReseller.@operator = SearchMultiSelectFieldOperator.anyOf; objReseller.operatorSpecified = true; objReseller.searchValue = new ListOrRecordRef[1]; objReseller.searchValue[0] = new ListOrRecordRef(); objReseller.searchValue[0].internalId = strReseller; xactionBasic.customFieldList = new SearchCustomField[] { objReseller }; xactionSearch.basic = xactionBasic; SearchResult objSearchResult = _service.search(xactionSearch); if (objSearchResult.recordList != null) { Record[] recordList; for (int i = 1; i <= objSearchResult.totalPages; i++) { recordList = objSearchResult.recordList; for (int j = 0; j < recordList.Length; j++) { if (recordList[j] is SalesOrder) { SalesOrder so = (SalesOrder)(recordList[j]); strOrderId = so.internalId; } } } } } catch (Exception) { } return strOrderId; }
public static void DeleteSalesOrder() { string strItem = ""; try { TransactionSearch xactionSearch = new TransactionSearch(); //xactionSearch.basic //SearchMultiSelectField entity = new SearchMultiSelectField(); //entity.@operator = SearchMultiSelectFieldOperator.anyOf; //entity.operatorSpecified = true; //RecordRef custRecordRef = new RecordRef(); //custRecordRef.internalId = strCustomerId; //custRecordRef.type = RecordType.customer; //custRecordRef.typeSpecified = true; //RecordRef[] custRecordRefArray = new RecordRef[1]; //custRecordRefArray[0] = custRecordRef; //entity.searchValue = custRecordRefArray; SearchEnumMultiSelectField searchSalesOrderField = new SearchEnumMultiSelectField(); searchSalesOrderField.@operator = SearchEnumMultiSelectFieldOperator.anyOf; searchSalesOrderField.operatorSpecified = true; System.String[] soStringArray = new System.String[1]; soStringArray[0] = "_salesOrder"; searchSalesOrderField.searchValue = soStringArray; TransactionSearchBasic xactionBasic = new TransactionSearchBasic(); xactionBasic.type = searchSalesOrderField; xactionBasic.customFieldList = new SearchCustomField[1]; SearchStringCustomField objNumber = new SearchStringCustomField(); objNumber.internalId = "custbodycst_ordernumber"; objNumber.@operator = SearchStringFieldOperator.notEmpty; objNumber.operatorSpecified = true; xactionBasic.customFieldList[0] = objNumber; xactionSearch.basic = xactionBasic; SearchResult objSearchResult = _service.search(xactionSearch); if (objSearchResult.status != null && objSearchResult.status.isSuccess) { if (objSearchResult.recordList != null) { Record[] recordList; for (int i = 1; i <= objSearchResult.totalPages; i++) { recordList = objSearchResult.recordList; for (int j = 0; j < recordList.Length; j++) { if (recordList[j] is SalesOrder) { try { SalesOrder objOrder = GetSalesOrder(((SalesOrder)(recordList[j])).internalId); object objCustomReseller = GetValue("custbodytbfcustomerid", objOrder.customFieldList); if (objCustomReseller.ToString().Equals("CST100WA")) { RecordRef objRef = new RecordRef(); objRef.internalId = objOrder.internalId; objRef.type = RecordType.salesOrder; objRef.typeSpecified = true; WriteResponse writeRes = _service.delete(objRef); if (writeRes.status.isSuccess) { Console.WriteLine("delete: " + objOrder.tranId); } else { Console.WriteLine(getStatusDetails(writeRes.status)); } } } catch (Exception objExc) { Console.WriteLine(objExc.ToString()); } } } } } } else { strItem = "error"; } } catch (Exception) { } }
protected TransactionResult ListMovements(GridModel model, TransactionSearch search) { var response = new TransactionResult(); ExecuteReader("r_AssetTransaction_List", delegate(SqlCommand sqlCommand) { if (search != null) { if (!string.IsNullOrEmpty(search.Id)) { sqlCommand.Parameters.AddWithValue("@Id", search.Id); } if (search.Location != 0) { sqlCommand.Parameters.AddWithValue("@location", search.Location); } if (search.Status != 0) { sqlCommand.Parameters.AddWithValue("@status", search.Status); } if (!string.IsNullOrEmpty(search.Name)) { sqlCommand.Parameters.AddWithValue("@name", search.Name); } if (!string.IsNullOrEmpty(search.From)) { sqlCommand.Parameters.AddWithValue("@from", DateTime.Parse(search.From)); } if (!string.IsNullOrEmpty(search.To)) { sqlCommand.Parameters.AddWithValue("@to", DateTime.Parse(search.To).AddHours(23).AddMinutes(59)); } if (!string.IsNullOrEmpty(search.Direction)) { sqlCommand.Parameters.AddWithValue("@Direction", search.Direction); } if (model.iSortCol_0 != 0) { model.iSortCol_0--; } switch (model.SortingDirection) { case SortDirection.Undefiened: sqlCommand.Parameters.AddWithValue("@sortColumn", 4); sqlCommand.Parameters.AddWithValue("@SortDirection", 1); break; case SortDirection.Ascending: sqlCommand.Parameters.AddWithValue("@sortColumn", model.iSortCol_0); sqlCommand.Parameters.AddWithValue("@SortDirection", 0); break; case SortDirection.Descending: sqlCommand.Parameters.AddWithValue("@sortColumn", model.iSortCol_0); sqlCommand.Parameters.AddWithValue("@SortDirection", 1); break; default: break; } } var pageSize = model == null ? 10 : ((model.iDisplayLength == 0) ? 10 : model.iDisplayLength); var PageNumber = model == null ? 1 : ((model.iDisplayStart == 0) ? 1 : model.iDisplayStart) / pageSize + 1; sqlCommand.Parameters.AddWithValue("@pageSize", pageSize); sqlCommand.Parameters.AddWithValue("@PageNumber", PageNumber); }, delegate(SqlDataReader reader) { while (reader.Read()) { response.AssetTransactions.Add(new AssetTransaction { AssetId = reader.GetString(0), AssetName = reader.GetString(1), AssetStatus = reader.GetInt32(2), Location = reader.GetString(3), Date_and_Time = reader.GetDateTime(4), Direction = reader.GetString(5) }); } if (reader.NextResult() && reader.Read()) { response.RowsCount = reader.GetInt32(0); } }); return(response); }
public void itemFulfillmentSearch(string orderNumber) { NetSuiteService service = new NetSuiteService(); service.CookieContainer = new CookieContainer(); NetsuiteUser user = new NetsuiteUser("3451682", "*****@*****.**", "1026", "tridenT168"); Passport passport = user.prepare(user); Status status = service.login(passport).status; TransactionSearchAdvanced tranSearchAdvanced = new TransactionSearchAdvanced(); TransactionSearch tranSearch = new TransactionSearch(); SearchStringField orderID = new SearchStringField(); orderID.@operator = SearchStringFieldOperator.@is; orderID.operatorSpecified = true; orderID.searchValue = orderNumber; TransactionSearchBasic tranSearchBasic = new TransactionSearchBasic(); tranSearchBasic.tranId = orderID; tranSearch.basic = tranSearchBasic; tranSearchAdvanced.criteria = tranSearch; SearchPreferences searchPreferences = new SearchPreferences(); searchPreferences.bodyFieldsOnly = false; service.searchPreferences = searchPreferences; SearchResult transactionResult = service.search(tranSearchAdvanced); if (transactionResult.status.isSuccess != true) throw new Exception("Cannot find Order " + orderNumber + " " + transactionResult.status.statusDetail[0].message); if (transactionResult.recordList.Count() != 1) throw new Exception("More than one order found for item " + orderNumber); this.itemFulfillment = new com.netsuite.webservices.ItemFulfillment(); this.itemFulfillment = ((com.netsuite.webservices.ItemFulfillment)transactionResult.recordList[0]); }