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();
}
