public int UpdateRow(DbTransaction pTran, RequestSearch RequestSearch, bool CreateTransaction) { int intRow = 0; DbTransaction objTran = pTran; Exception exception = null; try { if (pTran == null && CreateTransaction == true) { objTran = RequestSearchData.CreateTransaction(); } intRow = RequestSearchData.UpdateRow(objTran, RequestSearch); if (pTran == null && objTran != null && CreateTransaction == true) { RequestSearchData.CommitTransaction(objTran, true); objTran = null; } } catch (Exception EX) { exception = EX; if (pTran == null && objTran != null && CreateTransaction == true) { RequestSearchData.RollbackTransaction(objTran, true); objTran = null; } } finally { } return(intRow); }
private static void DoPlaylist(RequestSearch requestSearch, Socket asker) { string userUID = MyServer.Clients.GetUser(asker).UID; var playlists = UsersInfos.GetPlaylists(userUID).Where(p => Search.Find(requestSearch.Name, p.Name)); MyServer.SendObject(new RequestAnswer(playlists.Cast <IElement>().ToList(), ElementType.Playlist), asker); }
public static void Do(RequestSearch requestSearch, Socket asker) { if (MyServer.Clients.GetUser(asker).UID != null) { MyServer.Log.Info("Sending to the client :"); switch (requestSearch.Requested) { case ElementType.Author: DoAuthor(requestSearch, asker); break; case ElementType.Album: DoAlbum(requestSearch, asker); break; case ElementType.Music: DoMusic(requestSearch, asker); break; case ElementType.Playlist: DoPlaylist(requestSearch, asker); break; } } }
public List <Data.Model.Request> Get(RequestSearch request) { var list = _context.Requests.Include(r => r.User).ThenInclude(r => r.CarModel).Where(r => r.RequestStatusID == 1 && request.carserviceID == r.CarServiceID).OrderBy(r => r.DateOfRequest).ToList(); var modelList = new List <Data.Model.Request>(); foreach (var x in list) { var model = new Data.Model.Request() { RequestID = x.RequestID, DateOfRequest = x.DateOfRequest, Date = x.DateOfRequest.Day + "." + x.DateOfRequest.Month + "." + x.DateOfRequest.Year, UserID = x.UserID, UserNameLastName = x.User.FirstName + " " + x.User.LastName, UserCar = x.User.CarModel.CarModelName, CarServiceID = x.CarServiceID, StatusID = x.RequestStatusID, }; var ServicesList = _context.requestServices.Include(s => s.Service).Where(s => s.RequestID == x.RequestID).ToList(); model.ListOfRequestedServices = new List <string>(); foreach (var s in ServicesList) { model.ListOfRequestedServices.Add(s.Service.ServiceName); } modelList.Add(model); } return(modelList); }
void OnRequestSearch() { this._parent._fieldName = this.SearchCondition; this._parent._searchValue = this.SearchValue; //EventHandler handler = this.RequestSearch; //if (handler != null) // handler(this, EventArgs.Empty); RequestSearch?.Invoke(this, EventArgs.Empty); }
private static void DoAuthor(RequestSearch requestSearch, Socket asker) { var result = Indexation.GetAuthors(x => Search.Find(requestSearch.Name, x.Name)); foreach (var a in result) { MyServer.Log.Info($" {a.Name}"); } (new RequestAnswer(result.Cast <IElement>().ToList(), ElementType.Author, requestSearch.Name)).Send(asker); }
public int DeleteRow(DbTransaction pTran, RequestSearch RequestSearch) { int intRows = 0; DbParameter[] Parameters = new DbParameter[1]; Parameters[0] = _getIdParameter(RequestSearch.Id, ParameterDirection.Input); intRows = ExecuteNonQuery(pTran, "[Transactions].[DeleteRequestSearch]", Parameters); return(intRows); }
/// <summary>Serch user or chat.</summary> /// <param name="q">User or chat name</param> /// <param name="limit">Max result count</param> /// <param name="cancellationToken">A cancellation token</param> /// <returns></returns> public async Task <IFound> SearchUserAsync(string q, int limit = 10, CancellationToken cancellationToken = default(CancellationToken)) { AuthApiService.EnsureUserAuthorized(); var r = new RequestSearch { Q = q, Limit = limit }; return(await SenderService.SendRequestAsync(r, cancellationToken).ConfigureAwait(false)); }
public async Task <ActionResult> VolunteerRequestIndex(RequestSearch specifiedRequest) { var volunteersRequest = await _requestSvc.GetRequestForUserAsync(_webSecurity.CurrentUserId); var openRequests = await _requestSvc.GetOpenRequestsAsync(); return(View("VolunteerRequestAssignment", new VolunteerRequestIndexViewModel() { RequestAssignedToVolunteer = volunteersRequest, OpenRequests = openRequests })); }
/// <summary>Serch user or chat. API: contacts.search#11f812d8 q:string limit:int = contacts.Found;</summary> /// <param name="q">User or chat name</param> /// <param name="limit">Max result count</param> /// <returns></returns> public async Task <IFound> SearchUserAsync(string q, int limit) { EnsureUserAuthorized(); var r = new RequestSearch { Q = q, Limit = limit }; return(await SenderService.SendRequestAsync(r).ConfigureAwait(false)); }
/// <inheritdoc /> public async Task <IFound> SearchUserAsync(string query, int limit = 10, CancellationToken cancellationToken = default(CancellationToken)) { ClientSettings.EnsureUserAuthorized(); var r = new RequestSearch { Q = query, Limit = limit }; return(await RequestSender.SendRequestAsync(r, cancellationToken).ConfigureAwait(false)); }
private static void DoMusic(RequestSearch requestSearch, Socket asker) { var result = Indexation.GetAllMusics() .Where(m => Search.Find(requestSearch.Name, m.Title)); foreach (var m in result) { MyServer.Log.Info(" " + m.Title); } requestSearch.SenderUID = MyServer.Clients.GetUser(asker).UID; ServerCom.GlobalSend(requestSearch); MyServer.SendObject(new RequestAnswer(result.Cast <IElement>().ToList(), ElementType.Music), asker); }
private static void DoMusic(RequestSearch requestSearch, Socket asker) { var result = Indexation.GetAllMusics() .Where(m => Search.Find(requestSearch.Name, m.Title)).OrderBy(x => Search.FindStrength(requestSearch.Name, x.Title)).OrderByDescending(x => x.Rating); foreach (var m in result) { MyServer.Log.Info(" " + m.Title); } requestSearch.SenderUID = MyServer.Clients.GetUser(asker).UID; //ServerCom.GlobalSend(requestSearch); (new RequestAnswer(result.Cast <IElement>().ToList(), ElementType.Music, requestSearch.Name)).Send(asker); }
public async Task <SearchEngineResult> SearchOnGoGoDuck(string textQuery) { var result = new SearchEngineResult { SearchEngineValues = new List <SearchEngineValueReturned>() }; var textQueryParams = textQuery.Split(" "); foreach (var textParam in textQueryParams) { if (string.IsNullOrWhiteSpace(textParam)) { continue; } var valueReturned = RequestSearch.DataFromGogoDuck(textParam); result.SearchEngineValues.Add(valueReturned); } return(await Task.FromResult(result)); }
public async Task <ActionResult> Filter(RequestSearch specifiedRequest, string sortField, string sortOrder) { IQueryable <Request> requests = db.Requests.Include(r => r.Creator).Include(r => r.Assignee); IEnumerable <Request> filteredRequests = await _requestSvc.FilterRequestsAsync(specifiedRequest, requests); IOrderedEnumerable <Request> sortedRequests = _requestSvc.SortRequests(sortField, sortOrder, filteredRequests); ViewBag.SortOrderParam = String.IsNullOrEmpty(sortOrder) ? "desc" : sortOrder; ViewBag.SortFieldParam = String.IsNullOrEmpty(sortOrder) ? "EndDate" : sortField; ViewBag.SpecifiedRequest = specifiedRequest; return(View("Index", new AdminRequestIndexViewModel() { Requests = sortedRequests, RequestSearch = specifiedRequest })); }
public async Task <IEnumerable <Request> > FilterRequestsAsync(RequestSearch specifiedRequest, IQueryable <Request> requests) { if (specifiedRequest.Description != null) { requests = requests.Where(x => x.Description.Contains(specifiedRequest.Description)); } if (specifiedRequest.Location != null) { requests = requests.Where(x => x.Location.Contains(specifiedRequest.Location)); } if (specifiedRequest.NullableCreatedDate != null) { requests = requests.Where(x => x.CreatedDate == specifiedRequest.NullableCreatedDate); } if (specifiedRequest.NullableEndDate != null) { requests = requests.Where(x => x.EndDate == specifiedRequest.NullableEndDate); } if (specifiedRequest.RequestStatus != RequestStatus.All) { switch (specifiedRequest.RequestStatus) { case RequestStatus.Unassigned: requests = requests.Where(x => x.Completed == false && !x.AssigneeId.HasValue); break; case RequestStatus.Assigned: requests = requests.Where(x => x.Completed == false && x.AssigneeId.HasValue); break; case RequestStatus.Completed: requests = requests.Where(x => x.Completed == true); break; default: throw new ArgumentException("A valid request status was not selected."); } } return(await requests.ToListAsync()); }
public int InsertRow(DbTransaction pTran, RequestSearch RequestSearch) { int intRows = 0; DbParameter[] Parameters = new DbParameter[24]; Parameters[0] = _getIdParameter(RequestSearch.Id, ParameterDirection.Output); Parameters[1] = _getrequestNumberParameter(RequestSearch.requestNumber, ParameterDirection.Input); Parameters[2] = _gettotalQuantityParameter(RequestSearch.totalQuantity, ParameterDirection.Input); Parameters[3] = _getPDDFromParameter(RequestSearch.PDDFrom, ParameterDirection.Input); Parameters[4] = _getPDDToParameter(RequestSearch.PDDTo, ParameterDirection.Input); Parameters[5] = _getcustomerIDParameter(RequestSearch.customerID, ParameterDirection.Input); Parameters[6] = _getcreationDateFromParameter(RequestSearch.creationDateFrom, ParameterDirection.Input); Parameters[7] = _getcreationDateToParameter(RequestSearch.creationDateTo, ParameterDirection.Input); Parameters[8] = _getcreationUserIDParameter(RequestSearch.creationUserID, ParameterDirection.Input); Parameters[9] = _getapprovalDateFromParameter(RequestSearch.approvalDateFrom, ParameterDirection.Input); Parameters[10] = _getapprovalDateToParameter(RequestSearch.approvalDateTo, ParameterDirection.Input); Parameters[11] = _getapprovalUserIDParameter(RequestSearch.approvalUserID, ParameterDirection.Input); Parameters[12] = _getreceiveDateFromParameter(RequestSearch.receiveDateFrom, ParameterDirection.Input); Parameters[13] = _getreceiveDateToParameter(RequestSearch.receiveDateTo, ParameterDirection.Input); Parameters[14] = _getreceiveUserIDParameter(RequestSearch.receiveUserID, ParameterDirection.Input); Parameters[15] = _getrejectionDateFromParameter(RequestSearch.rejectionDateFrom, ParameterDirection.Input); Parameters[16] = _getrejectionDateToParameter(RequestSearch.rejectionDateTo, ParameterDirection.Input); Parameters[17] = _getrejectionUserIDParameter(RequestSearch.rejectionUserID, ParameterDirection.Input); Parameters[18] = _getrejectionReasonIDParameter(RequestSearch.rejectionReasonID, ParameterDirection.Input); Parameters[19] = _getrequestTypeIDParameter(RequestSearch.requestTypeID, ParameterDirection.Input); Parameters[20] = _getrequestStatusIDParameter(RequestSearch.requestStatusID, ParameterDirection.Input); Parameters[21] = _getrequestCalssIDParameter(RequestSearch.requestCalssID, ParameterDirection.Input); Parameters[22] = _getrequestPriorityIDParameter(RequestSearch.requestPriorityID, ParameterDirection.Input); Parameters[23] = _getcardTypeIDParameter(RequestSearch.cardTypeID, ParameterDirection.Input); intRows = ExecuteNonQuery(pTran, "[Transactions].[InsertRequestSearch]", Parameters); if (Parameters[0].Value != DBNull.Value) { RequestSearch.Id = (System.Int32)Parameters[0].Value; } return(intRows); }
public int InsertRow(RequestSearch RequestSearch) { DbTransaction Tran = null; return(InsertRow(Tran, RequestSearch)); }
public RequestSearchList SelectRows(DbTransaction pTran, System.Int32?Id, System.String requestNumber, System.DateTime?creationDateFrom, System.DateTime?creationDateTo, System.DateTime?approvalDateFrom, System.DateTime?approvalDateTo, System.DateTime?receiveDateFrom, System.DateTime?receiveDateTo, System.DateTime?rejectionDateFrom, System.DateTime?rejectionDateTo) { RequestSearchList RequestSearchList = new RequestSearchList(); Exception exception = null; DbParameter[] Parameters = new DbParameter[10]; Parameters[0] = _getIdParameter(Id, ParameterDirection.Input); Parameters[1] = _getrequestNumberParameter(requestNumber, ParameterDirection.Input); Parameters[2] = _getcreationDateFromParameter(creationDateFrom, ParameterDirection.Input); Parameters[3] = _getcreationDateToParameter(creationDateTo, ParameterDirection.Input); Parameters[4] = _getapprovalDateFromParameter(approvalDateFrom, ParameterDirection.Input); Parameters[5] = _getapprovalDateToParameter(approvalDateTo, ParameterDirection.Input); Parameters[6] = _getreceiveDateFromParameter(receiveDateFrom, ParameterDirection.Input); Parameters[7] = _getreceiveDateToParameter(receiveDateTo, ParameterDirection.Input); Parameters[8] = _getrejectionDateFromParameter(rejectionDateFrom, ParameterDirection.Input); Parameters[9] = _getrejectionDateToParameter(rejectionDateTo, ParameterDirection.Input); DbDataReader Dr = ExecuteReader(pTran, "[Transactions].[SelectRequestSearch]", Parameters); try { if (Dr != null) { while (Dr.Read()) { RequestSearch RequestSearch = new RequestSearch(); if (Dr["Id"] != DBNull.Value) { RequestSearch.Id = (System.Int32)Dr["Id"]; } if (Dr["requestNumber"] != DBNull.Value) { RequestSearch.requestNumber = (System.String)Dr["requestNumber"]; } if (Dr["totalQuantity"] != DBNull.Value) { RequestSearch.totalQuantity = (System.Int32?)Dr["totalQuantity"]; } if (Dr["PDDFrom"] != DBNull.Value) { RequestSearch.PDDFrom = (System.DateTime?)Dr["PDDFrom"]; } if (Dr["PDDTo"] != DBNull.Value) { RequestSearch.PDDTo = (System.DateTime?)Dr["PDDTo"]; } if (Dr["customerID"] != DBNull.Value) { RequestSearch.customerID = (System.Int32?)Dr["customerID"]; } if (Dr["creationDateFrom"] != DBNull.Value) { RequestSearch.creationDateFrom = (System.DateTime?)Dr["creationDateFrom"]; } if (Dr["creationDateTo"] != DBNull.Value) { RequestSearch.creationDateTo = (System.DateTime?)Dr["creationDateTo"]; } if (Dr["creationUserID"] != DBNull.Value) { RequestSearch.creationUserID = (System.Int32?)Dr["creationUserID"]; } if (Dr["approvalDateFrom"] != DBNull.Value) { RequestSearch.approvalDateFrom = (System.DateTime?)Dr["approvalDateFrom"]; } if (Dr["approvalDateTo"] != DBNull.Value) { RequestSearch.approvalDateTo = (System.DateTime?)Dr["approvalDateTo"]; } if (Dr["approvalUserID"] != DBNull.Value) { RequestSearch.approvalUserID = (System.Int32?)Dr["approvalUserID"]; } if (Dr["receiveDateFrom"] != DBNull.Value) { RequestSearch.receiveDateFrom = (System.DateTime?)Dr["receiveDateFrom"]; } if (Dr["receiveDateTo"] != DBNull.Value) { RequestSearch.receiveDateTo = (System.DateTime?)Dr["receiveDateTo"]; } if (Dr["receiveUserID"] != DBNull.Value) { RequestSearch.receiveUserID = (System.Int32?)Dr["receiveUserID"]; } if (Dr["rejectionDateFrom"] != DBNull.Value) { RequestSearch.rejectionDateFrom = (System.DateTime?)Dr["rejectionDateFrom"]; } if (Dr["rejectionDateTo"] != DBNull.Value) { RequestSearch.rejectionDateTo = (System.DateTime?)Dr["rejectionDateTo"]; } if (Dr["rejectionUserID"] != DBNull.Value) { RequestSearch.rejectionUserID = (System.Int32?)Dr["rejectionUserID"]; } if (Dr["rejectionReasonID"] != DBNull.Value) { RequestSearch.rejectionReasonID = (System.Int32?)Dr["rejectionReasonID"]; } if (Dr["requestTypeID"] != DBNull.Value) { RequestSearch.requestTypeID = (System.Int32?)Dr["requestTypeID"]; } if (Dr["requestStatusID"] != DBNull.Value) { RequestSearch.requestStatusID = (System.Int32?)Dr["requestStatusID"]; } if (Dr["requestCalssID"] != DBNull.Value) { RequestSearch.requestCalssID = (System.Int32?)Dr["requestCalssID"]; } if (Dr["requestPriorityID"] != DBNull.Value) { RequestSearch.requestPriorityID = (System.Int32?)Dr["requestPriorityID"]; } if (Dr["cardTypeID"] != DBNull.Value) { RequestSearch.cardTypeID = (System.Int32?)Dr["cardTypeID"]; } RequestSearchList.FillRow(RequestSearch); RequestSearch = null; } } } catch (Exception Ex) { exception = Ex; } finally { if (Dr != null) { if (Dr.IsClosed == false) { Dr.Close(); } Dr = null; } } return(RequestSearchList); }
public RequestList SelectRequestDynamicSearch(RequestSearch requestSearch) { DbTransaction Tran = null; return(SelectRequestDynamicSearch(Tran, requestSearch)); }
public int DeleteRow(RequestSearch RequestSearch) { DbTransaction Tran = null; return(DeleteRow(Tran, RequestSearch, false)); }
public int InsertRow(DbTransaction pTran, RequestSearch RequestSearch) { return(InsertRow(pTran, RequestSearch, false)); }
public async Task <ResponseList <ClassViewModel> > GetAll(RequestSearch <ClassSearch> request) { var result = await this.classRepository.GetAllAsync(request.Page, request.PageSize, request.Search.GetFilter(), request.Search.GetOrderBy(), null); return(base.CreateResultListModel <Class, ClassViewModel>(result)); }
public ActionResult Search(RequestSearch requestSearch) { var result = _stringMatchService.Search(requestSearch.SearchValue, requestSearch.PageIndex, requestSearch.PageSize); return(PartialView("PagingStringMatch", result)); }
public async Task <IActionResult> GetAll([FromBody] RequestSearch <CustomerSearch> request) { var result = await this.customerService.GetAll(request); return(base.Result(result)); }
public async Task <ResponseList <CustomerViewModel> > GetAll(RequestSearch <CustomerSearch> request) { var result = await this.customerRepository.GetAllAsync(request.Page, request.PageSize, request.Search.GetFilter(), request.Search.GetOrderBy(), request.Search.GetIncludes()); return(base.CreateResultListModel <Customer, CustomerViewModel>(result)); }
public int UpdateRow(DbTransaction pTran, RequestSearch RequestSearch) { return(UpdateRow(pTran, RequestSearch, false)); }
public List <Data.Model.Request> Get([FromQuery] RequestSearch request) { return(_service.Get(request)); }
public int UpdateRow(RequestSearch RequestSearch) { DbTransaction Tran = null; return(UpdateRow(Tran, RequestSearch)); }
public static void processOneWay() { ServicePointManager.Expect100Continue = false; ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls | SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12; HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://dc.vietnamairlines.com/v3.6/ssw/products/air/search?jipcc=VNDX"); request.Method = "POST"; request.KeepAlive = false; request.Timeout = System.Threading.Timeout.Infinite; request.Accept = "application/json"; request.UserAgent = "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36"; request.CookieContainer = getCookie(); request.ContentType = "application/json"; request.Headers.Add("Authorization", Properties.Settings.Default.vnAirToken); RequestSearch bodyForm = new RequestSearch(); bodyForm.cabinClass = "Economy"; bodyForm.itineraryParts = new List <ItineraryPart>(); bodyForm.itineraryParts.Add(new ItineraryPart() { from = new ItineraryPartLocation() { code = "SGN", useNearbyLocations = false }, to = new ItineraryPartLocation() { code = "HAN", useNearbyLocations = false }, when = new ItineraryPartWhen() { date = "2019-01-30" } }); bodyForm.passengers = new VNAir.Passenger() { ADT = 1, CHD = 1, INF = 1 }; bodyForm.pointOfSale = "VN"; bodyForm.searchType = "BRANDED"; byte[] data = Encoding.ASCII.GetBytes(JsonConvert.SerializeObject(bodyForm)); using (var stream = request.GetRequestStream()) { stream.Write(data, 0, data.Length); } HttpWebResponse response = null; Label warning = (Label)parentForm.Controls.Find("lbVNAirWarning", true)[0]; try { response = (HttpWebResponse)request.GetResponse(); } catch (WebException ex) { using (WebResponse responseEx = ex.Response) { HttpWebResponse httpResponse = (HttpWebResponse)response; using (Stream dataEx = responseEx.GetResponseStream()) using (var reader = new StreamReader(dataEx)) { string text = reader.ReadToEnd(); } } warning.Invoke((MethodInvoker) delegate { warning.Text = "!"; warning.ForeColor = System.Drawing.Color.Red; }); return; } warning.Invoke((MethodInvoker) delegate { warning.Text = ""; }); if (response != null && response.StatusCode == HttpStatusCode.OK) { Stream stream = response.GetResponseStream(); StreamReader reader = null; if (response.CharacterSet == null || response.CharacterSet == "") { reader = new StreamReader(stream); } else { reader = new StreamReader(stream, Encoding.GetEncoding(response.CharacterSet)); } try { ResponseVNAir result = JsonConvert.DeserializeObject <ResponseVNAir>(reader.ReadToEnd()); } catch (Exception ex) { } reader.Close(); stream.Close(); } response.Close(); }