public async Task <IActionResult> GetTransfer([FromQuery] QueryViewModel q) { var data = JsonConvert.SerializeObject(q); ResultModel result = new ResultModel(); string targetUri = _config["api"] + "/Transfer"; targetUri += q.GenerateQueryString(); result = await _callApi.CallAPI(null, new Uri(targetUri), "GET"); //result = await CallAPI(null, new Uri(targetUri), "GET"); if (result.IsSuccess == true && result.Data != null) { q.TransferRecords = JsonConvert.DeserializeObject <List <TransferRecord> >(result.Data.ToString()); } if (result.Message == "Unauthorized or token exppired.") { return(RedirectToAction("Login", "User")); } if (TempData["IsSuccess"] == null) { TempData["IsSuccess"] = result.IsSuccess; TempData["msg"] = result.Message; } return(View(q)); }
public IActionResult Query_Details(string Id) { Querie querie = _context.queries.FirstOrDefault(qry => qry.Id == Id); QueryViewModel queryViewModel = new QueryViewModel(); if (querie != null) { queryViewModel.Title = querie.title; queryViewModel.UploadTime = querie.Query_Time; queryViewModel.Description = System.IO.File.ReadAllText(querie.textfilepath); IEnumerable <PhotoModel> photoModels = _context.photoModels.Where(ph => ph.querieId == Id); if (photoModels == null) { ViewBag.Error = "error"; } else { List <string> urls = new List <string>(); List <string> names = new List <string>(); foreach (var photo in photoModels) { urls.Add(photo.URL); names.Add(photo.Name); } queryViewModel.URLS = urls; queryViewModel.Names = names; } return(View(queryViewModel)); } ViewBag.Error = "error"; return(View()); }
public async Task <IActionResult> Filters(QueryViewModel query = null, int?stringId = null) { FilterResultsViewModel filterResults = null; if (query == null) { query = new QueryViewModel(); } else if (query.IsEmpty) { // let's redirect to root if we get just '/filters' return(RedirectToAction(nameof(Index))); } else { filterResults = await GetFilterResultsViewModelFor(query); if (filterResults == null) { return(BadRequest()); } } var viewModel = new IndexViewModel { StringCounts = await _stringsService.GetStringCounts(), StringsQuery = query, FilterResults = filterResults, UserCanSeeIgnoredAndPushStatus = User.GetClaim <UserType>(ClaimType.UserType) >= UserType.TrustedUser, StringId = stringId, }; return(View("~/Views/Home/Index.cshtml", viewModel)); }
public ActionResult Query(string credNo) { QueryViewModel query = new QueryViewModel() { CredNo = credNo }; var db = ConnHelper.CreateDb(); if (!db.Order_Info.Any(s => s.CredNo == credNo)) { ModelState.AddModelError("error", "该身份证不存在!"); return(View(query)); } var list = db.Order_Info.Where(s => s.State == 1 && s.CredNo == credNo).OrderByDescending(s => s.AddTime).ToList(); foreach (var item in list) { var happy_card = db.HappyCard_Class.Single(s => s.State == 1 && s.ClassID == item.ClassID); query.Orders.Add(new OrderInfoViewModel() { AddTime = item.AddTime, ClassId = item.ClassID, ClassName = happy_card.ClassName, DiscountPrice = Convert.ToDecimal(happy_card.DiscountPrice), MunPrice = item.MunPrice, Rtong = item.Rtong, IsLingPiao = item.IsLingPiao }); } return(View(query)); }
/// <summary> /// Perform a query. /// </summary> /// <param name="q"></param> /// <returns></returns> public ActionResult Search(QueryViewModel q) { if (q == null || !ModelState.IsValid || string.IsNullOrWhiteSpace(q.Text)) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return Json("Invalid request", JsonRequestBehavior.AllowGet); } var sw = Stopwatch.StartNew(); var matches = MvcApplication.WordFinder.Matches(q.Text, 2); sw.Stop(); double millis = 1000.0 * sw.ElapsedTicks / Stopwatch.Frequency; int nodes = MvcApplication.WordFinder.Nodes; var results = new ResultsViewModel(q.Text, matches, millis, nodes); Log.Info(CultureInfo.InvariantCulture, "Query '{0}',{1},{2:F2}", q.Text, nodes, millis); // save query using (var session = MvcApplication.DocumentStore.OpenSession()) { session.Store(new Query { Type = QueryType.Word, Text = q.Text, Nodes = nodes, ElapsedMilliseconds = millis }); session.SaveChanges(); } return Json(results, JsonRequestBehavior.AllowGet); }
public ActionResult Query() { QueryViewModel model = new QueryViewModel(); //var surveys = db.Surveys.Include(s => s.Category); return(View(model)); }
public ActionResult DoQuery(QueryViewModel model) { try { QueryWeatherRequest request = new QueryWeatherRequest(); //request.GPSLocationInfo = gpsLocationInfo; request.WCCode = model.WCCode; request.QueryDateTime = DateTime.Now; QueryWeatherResponse response = QueryServices.GetWeatherInfo(request); response.CurrentDay.QueryDate = request.QueryDateTime.ToString("yyyy/MM/dd"); response.CurrentDay.AreaCode = model.AreaCode; response.CurrentDay.AreaName = CityAndAreaConfig.Instance.getAreaNameByAreaCode(model.AreaCode); response.CurrentDay.WCCode = model.WCCode; response.CurrentDay.CountryName = CityAndAreaConfig.Instance.getWCCountryNameByWCCode(model.WCCode); ViewBag.CurrentDay = response.CurrentDay; ViewBag.OtherDays = response.OthreDays; } catch (System.Exception ex) { return(View("Error")); } return(View("Result")); //return RedirectToAction("Result"); }
public ActionResult ReplyQueryDialog(int queryId) { Query query = queryRepository.GetByKey(queryId); var model = new QueryViewModel { QueryId = queryId }; if (query != null) { model.QueryAuthor = String.Format("{0} {1}", GetAnswerAuthorRole(query.QueryAuthor.Role), query.QueryAuthor.LastName); model.QueryAuthorImage = query.QueryAuthor.Photo; model.QueryText = query.QueryText; model.Question = query.Question.Caption; model.IsClosed = !string.IsNullOrEmpty(query.AnswerText); model.Answer = query.AnswerText; if (query.AnswerAuthor != null) { model.AnswerAuthor = String.Format("{0} {1}", GetAnswerAuthorRole(query.AnswerAuthor.Role), query.AnswerAuthor.LastName); model.AnswerAuthorImage = query.AnswerAuthor.Photo; } model.FormCaption = query.Question.Form.Caption; model.VisitCaption = query.Question.Form.Visit.Caption; model.PatientCaption = query.Question.Form.Visit.Patient.Caption; model.PatientNumber = query.Question.Form.Visit.Patient.PatientNumber; } return(PartialView("_ReplyQueryDialog", model)); }
private IEnumerable <IRecord> GetRecordsToProcess(bool selectedOnly) { IEnumerable <IRecord> recordsToUpdate = null; var fieldsToGet = new List <string>(); fieldsToGet.Add(RecordService.GetPrimaryKey(QueryViewModel.RecordType)); var primaryField = RecordService.GetPrimaryField(QueryViewModel.RecordType); if (!string.IsNullOrWhiteSpace(primaryField)) { fieldsToGet.Add(primaryField); } if (selectedOnly) { var ids = QueryViewModel.DynamicGridViewModel.SelectedRows.Select(r => r.Record.Id).ToArray(); recordsToUpdate = RecordService.RetrieveAllOrClauses(QueryViewModel.RecordType, ids.Select(i => new Condition(RecordService.GetPrimaryKey(QueryViewModel.RecordType), ConditionType.Equal, i)), fieldsToGet); } else { var query = QueryViewModel.GenerateQuery(); query.Fields = fieldsToGet; query.Top = -1; recordsToUpdate = RecordService.RetreiveAll(query); } return(recordsToUpdate); }
public ActionResult Save([Bind(Include = "Queries,SavedQueries,Query,Description,Csv")] QueryViewModel qvm) { SavedQuery savQuery = new SavedQuery(); // Check for valid Query. Must be SELECT Command, and only has a one semicolon at the end of the query string Query = qvm.Query; if (Query.Length >= 6 && Query.Substring(0, 6) == "SELECT" && Query.Substring(0, Query.Length - 1) != ";" && Query.Substring(Query.Length - 1, 1) == ";") { savQuery.Query = Query; savQuery.Description = qvm.Description; savQuery.CreationDate = DateTime.Today; db.SavedQueries.Add(savQuery); try { db.SaveChanges(); TempData["SuccessOHMsg"] = "Saved Query " + savQuery.SavedQueryID + " added"; } catch { TempData["DangerOHMsg"] = "Problem saving query in the database. Please remember to enter a description before saving."; return(RedirectToAction("Index", qvm)); } } else { TempData["DangerOHMsg"] = "There was a problem with the format of the query"; return(RedirectToAction("Index", qvm)); } return(Run(qvm)); }
public IActionResult Query_Details(string Id) { Querie querie = _context.queries.FirstOrDefault(qry => qry.Id == Id); QueryViewModel queryViewModel = new QueryViewModel(); if (querie != null) { queryViewModel.Id = querie.Id; queryViewModel.Title = querie.title; queryViewModel.UploadTime = querie.Query_Time; queryViewModel.Description = System.IO.File.ReadAllText(querie.textfilepath); IEnumerable <PhotoModel> photoModels = _context.photoModels.Where(ph => ph.querieId == Id); if (photoModels == null) { ViewBag.Error = "error"; } else { List <string> urls = new List <string>(); List <string> names = new List <string>(); foreach (var photo in photoModels) { urls.Add(photo.URL); names.Add(photo.Name); } queryViewModel.URLS = urls; queryViewModel.Names = names; } Employee employee = _context.employees.FirstOrDefault(emp => emp.Id == HttpContext.Session.GetString("uid")); if (employee.post == "main") { if (querie.status == "Inp" || querie.status == "Comp") { ViewBag.show = "none"; } else { ViewBag.show = "all"; } } else { if (querie.status == "Comp") { ViewBag.show = "none"; } else if (querie.status == "Inp") { ViewBag.show = "Complete"; } else if (querie.status == "Acc") { ViewBag.show = "proceed Request"; } } return(View(queryViewModel)); } ViewBag.Error = "error"; return(View()); }
byte[] IQueryExportService.Export(QueryViewModel queryModel) { byte[] fileByteContent = null; using (XLWorkbook workbook = new XLWorkbook()) { IXLWorksheet worksheet = workbook.Worksheets.Add(queryModel.CreatedQuery.QueryText); int currentRow = 1; worksheet.Cell(currentRow, 1).Value = "Name"; worksheet.Cell(currentRow, 2).Value = "Audience Size"; worksheet.Cell(currentRow, 3).Value = "Category"; foreach (Interest interest in queryModel.FoundInterests) { currentRow++; worksheet.Cell(currentRow, 1).Value = interest.Name; worksheet.Cell(currentRow, 2).Value = interest.AudienceSize; worksheet.Cell(currentRow, 3).Value = interest.Category; } using (MemoryStream stream = new MemoryStream()) { workbook.SaveAs(stream); fileByteContent = stream.ToArray(); } } return(fileByteContent); }
public ActionResult Run([Bind(Include = "Queries,SavedQueries,Query,Description,Csv")] QueryViewModel qvm) { if (qvm.Query == null) { TempData["DangerOHMsg"] = "There was a problem running the query"; return(RedirectToAction("Index")); } if (qvm.Query.Length >= 6 && qvm.Query.Substring(0, 6) == "SELECT" && qvm.Query.Substring(0, qvm.Query.Length - 1) != ";" && qvm.Query.Substring(qvm.Query.Length - 1, 1) == ";") { try { IEnumerable <QueryDTOViewModel> data = db.Database.SqlQuery <QueryDTOViewModel>(qvm.Query); qvm.Queries = data.ToList(); qvm.SavedQueries = db.SavedQueries.ToList(); TempData["SuccessOHMsg"] = "The Query was successfully ran"; return(View("Index", qvm)); } catch { TempData["DangerOHMsg"] = "There was a problem running the query"; return(RedirectToAction("Index", qvm)); } } TempData["DangerOHMsg"] = "There was a problem with the format of the query"; return(RedirectToAction("Index", qvm)); }
/// <summary> /// Ejecuta la consulta /// </summary> private async Task ExecuteQueryAsync() { // Obtiene la consulta QueryViewModel.Query = GetQueryRequested(); // y la ejecuta await QueryViewModel.ExecuteQueryAsync(); }
public ActionResult Index() { QueryViewModel que = new QueryViewModel(); // ViewModel ViewBag.Descriptor_ID = new SelectList(db.Descriptors, "ID", "Descriptor_content"); ViewBag.Type_ID = new SelectList(db.Relation_types, "ID", "Type_name"); return View(que); }
public void Load(RecordEntryViewModelBase recordForm, string subGridReference) { recordForm.DoOnMainThread(() => { try { var mainFormInContext = recordForm; if (recordForm is GridRowViewModel) { mainFormInContext = recordForm.ParentForm; } var closeFunction = new CustomGridFunction("RETURN", "Return", () => mainFormInContext.ClearChildForm()); var targetType = GetTargetType(recordForm, subGridReference); var selectedFunction = new CustomGridFunction("ADDSELECTED", "Add Selected", (g) => AddSelectedItems(g, recordForm, subGridReference) , visibleFunction: (g) => g.SelectedRows.Any()); var childForm = new QueryViewModel(new[] { targetType }, GetQueryLookupService(recordForm, subGridReference), recordForm.ApplicationController, allowQuery: AllowQuery, loadInitially: !AllowQuery, closeFunction: closeFunction, customFunctions: new[] { selectedFunction }); childForm.TypeAhead = TypeAhead; mainFormInContext.LoadChildForm(childForm); } catch (Exception ex) { recordForm.ApplicationController.ThrowException(ex); } finally { recordForm.LoadingViewModel.IsLoading = false; } }); }
public ActionResult Query(QueryViewModel queryViewModel) { //testing query functionality Query query = new Query(); query.InitializeValues(queryViewModel.Stamp, queryViewModel.Reference, this.merchantId, queryViewModel.Amount, this.merchantSecretKey); //send Query to Checkout Finland try { ViewBag.QueryResponse = CheckoutClient.postQueryData(query.FormData()); } catch (WebException ex) { //exception handling for testing ViewBag.PaymentResponseMessage = "error: " + ex.ToString(); return(View("PaymentResponseError")); } //get status value XDocument xmlDoc = XDocument.Parse(ViewBag.QueryResponse); XElement statusNode = (XElement)xmlDoc.FirstNode; string statusValue = statusNode.Value; ViewBag.QueryResponseMessage = PaymentUtils.GetPaymentResponseStatusMessage(statusValue); return(View()); }
public ActionResult PaymentResponse( String VERSION, String STAMP, String REFERENCE, String PAYMENT, String STATUS, String ALGORITHM, String MAC) { PaymentResponse paymentResponse = new PaymentResponse(); paymentResponse.SetValues(merchantSecretKey, Request.Params); //if response valid (ok data) if (paymentResponse.IsValid()) { ViewBag.PaymentResponseMessage = PaymentUtils.GetPaymentResponseStatusMessage(paymentResponse.Status); } else //invalid response (corrupt data) { ViewBag.PaymentResponseMessage = "response invalid"; return(View("PaymentResponseError")); } //set form values ready for payment status query QueryViewModel queryViewModel = new QueryViewModel(); queryViewModel.Stamp = paymentResponse.Stamp; queryViewModel.Reference = paymentResponse.Reference; //Get Amount from Session, because it's not available //from PaymentResponse (for testing). queryViewModel.Amount = (string)Session["Amount"]; return(View(queryViewModel)); }
public async Task <IActionResult> OnGetAsync(Guid?id) { if (!id.HasValue) { TempData.WithError("No query selected"); return(RedirectToPage("Index")); } var query = await _repository.GetSingleAsync <Query>(id.Value); if (query == null) { TempData.WithError("Query does not exists"); return(RedirectToPage("Index")); } Query = new QueryViewModel { Id = query.Id, Name = query.Name, QueryId = query.QueryId }; return(Page()); }
protected IEnumerable <IRecord> GetRecordsToProcess(bool selectedOnly) { IEnumerable <IRecord> recordsToUpdate = null; QueryViewModel.DynamicGridViewModel.LoadingViewModel.IsLoading = true; QueryViewModel.DynamicGridViewModel.LoadingViewModel.LoadingMessage = "Loading Dialog"; try { var fieldsToGet = new List <string>(); fieldsToGet.Add(RecordService.GetPrimaryKey(QueryViewModel.RecordType)); var primaryField = RecordService.GetPrimaryField(QueryViewModel.RecordType); if (!string.IsNullOrWhiteSpace(primaryField)) { fieldsToGet.Add(primaryField); } if (selectedOnly) { var ids = QueryViewModel.DynamicGridViewModel.SelectedRows.Select(r => r.Record.Id).ToArray(); recordsToUpdate = RecordService.RetrieveAllOrClauses(QueryViewModel.RecordType, ids.Select(i => new Condition(RecordService.GetPrimaryKey(QueryViewModel.RecordType), ConditionType.Equal, i)), fieldsToGet); } else { var getRecordsResults = QueryViewModel.GetGridRecords(true, fields: fieldsToGet); recordsToUpdate = getRecordsResults.Records; } } finally { QueryViewModel.DynamicGridViewModel.LoadingViewModel.IsLoading = false; } return(recordsToUpdate); }
public ActionResult DefinitionSearch(QueryViewModel que) { DEQueries dq = new DEQueries(); object result = dq.GetDefinitions(que.BegDate, que.EndDate, que.RelationTypeID, que.Descriptor_ID); ViewBag.Descriptor_ID = new SelectList(db.Descriptors, "ID", "Descriptor_content", que.Descriptor_ID); ViewBag.Type_ID = new SelectList(db.Relation_types, "ID", "Type_name", que.RelationTypeID); return PartialView("_DisplayDescriptorsPartial", result); }
public async Task <IActionResult> Query(QueryViewModel model) { var response = await _searchIndexClient.Documents.SearchAsync <Animal>(model.Term); model.Animals = response.Results.Select(x => x.Document).ToArray(); return(View(model)); }
public QueryControl(MainWindow mainWindow) { InitializeComponent(); // DataContext = null; DataContext = new QueryViewModel(mainWindow, this); PublicData.ServerConfig.EpcS = new List <string>(); PublicData.ServerConfig.UEpcS = new List <string>(); }
public DataSourceResponse <QueryViewModel> ReadQueries(DataSourceRequest request, IIdentity identity) { var currentUserId = identity.GetUserId(); var roles = this.userService.GetRoles(); var shipments = this.DbContext.Shipments.Where(s => s.UserId == currentUserId).ToList(); IDictionary <string, QueryViewModel> total = new Dictionary <string, QueryViewModel>(); foreach (var shipment in shipments) { string key = shipment.Date.ToString("yyyyMM"); QueryViewModel viewModel; if (total.ContainsKey(key)) { viewModel = total[key]; } else { viewModel = new QueryViewModel { Year = shipment.Date.Year, Month = shipment.Date.Month, Performance = 0 }; total.Add(key, viewModel); } // 計算 var currentRole = roles[shipment.UserRoleId]; var discount = currentRole.GetDiscount(); if (shipment.CustomerId.HasValue) { var customerRole = roles[shipment.CustomerRoleId]; double customerDiscount = customerRole.GetDiscount(); discount -= customerDiscount; } var shipmentDetails = this.DbContext.ShipmentDetails.Where(d => d.ShipmentId == shipment.ShipmentId).ToList(); foreach (var shipmentDetail in shipmentDetails) { viewModel.Performance += shipmentDetail.SubtotalAmount; } viewModel.Bonus = Convert.ToInt32(Math.Round(viewModel.Performance * discount, 0, MidpointRounding.AwayFromZero)); } var response = new DataSourceResponse <QueryViewModel> { TotalRowCount = total.Count }; if (request.ServerPaging != null) { int skip = Math.Max(request.ServerPaging.PageSize * (request.ServerPaging.Page - 1), val2: 0); response.DataCollection = total.Values.OrderBy(v => new { v.Year, v.Month }).Skip(skip).Take(request.ServerPaging.PageSize).ToList(); } return(response); }
protected override void LoadDialogExtention() { try { //this bit messy because may take a while to load the record types //so spawn on async thread, then back to the main thread for th ui objects LoadingViewModel.LoadingMessage = "Loading Types"; var recordTypesForBrowsing = Task.Run <IEnumerable <string> >(() => RecordService.GetAllRecordTypes() .Where(r => RecordService.GetRecordTypeMetadata(r).Searchable) .Union(AdditionalExplicitTypes) .ToArray()).Result; DoOnMainThread(() => { try { var customFunctionList = new List <CustomGridFunction>() { new CustomGridFunction("BULKUPDATE", "Bulk Update", new [] { new CustomGridFunction("BULKUPDATESELECTED", "Selected Only", (g) => { TriggerBulkUpdate(true); }, (g) => g.SelectedRows.Any()), new CustomGridFunction("BULKUPDATEALL", "All Results", (g) => { TriggerBulkUpdate(false); }, (g) => g.GridRecords != null && g.GridRecords.Any()), }), new CustomGridFunction("DELETE", "Bulk Delete", new [] { new CustomGridFunction("BULKDELETESELECTED", "Selected Only", (g) => { TriggerBulkDelete(true); }, (g) => g.SelectedRows.Any()), new CustomGridFunction("BULKDELETEALL", "All Results", (g) => { TriggerBulkDelete(false); }, (g) => g.GridRecords != null && g.GridRecords.Any()), }) }; QueryViewModel = new QueryViewModel(recordTypesForBrowsing, RecordService, ApplicationController, allowQuery: true, customFunctions: customFunctionList); Controller.LoadToUi(QueryViewModel); } catch (Exception ex) { ApplicationController.ThrowException(ex); } }); } catch (Exception ex) { ApplicationController.ThrowException(ex); } }
//public ActionResult WorkerActivate(Guid activate_id) //{ // //Personel aktivasyonu sağlanır // return View(); //} public ActionResult CustomerQuery() { if (CurrentSession.Product == null) { var model = new QueryViewModel(); return(View()); } return(RedirectToAction("ShowInfo")); }
// returns the entire mockup database prior to user input public ActionResult CustomQuery() { ViewBag.Message = "Custom Query"; var queryModel = new QueryViewModel(); queryModel = Backend.Instance.GetQuery(); return(View(queryModel)); }
// GET: Query public ActionResult Index([Bind(Include = "Queries,SavedQueries,Query,Description,Csv")] QueryViewModel qvm) { if (qvm.SavedQueries == null) { qvm = new QueryViewModel(); qvm.SavedQueries = db.SavedQueries.ToList(); } return(View(qvm)); }
public async Task <QueryViewModel> GetQuery(int idQuery) { var result = new QueryViewModel(); var result1 = await _queryManagerRepository.GetQuery(idQuery); result = Traslate(result1); return(result); }
private QueryViewModel Traslate(NewDammiQuery query) { var result = new QueryViewModel() { Descrizione = query.Testo, IdQuery = query.IdQuery.ToString() }; return(result); }
public ActionResult SetAuthCode(QueryViewModel viewModel) { viewModel.AuthCode = viewModel.AuthCode.GetEfficientString(); if (viewModel.AuthCode == null) { viewModel.AuthCode = $"{DateTime.Now.Ticks % 100000000:00000000}"; } AppSettings.Default.AuthorizationCode = viewModel.AuthCode; return(Content(new { result = true, viewModel.AuthCode }.JsonStringify(), "application/json")); }
public ActionResult Edit(int taskId) { var user = userService.GetUserProfile(User.Identity.Name); if (user == null) throw new InvalidCredentialException("User has no permission for this operation"); var thread = service.GetSupplierQueryThreads(taskId, user.SupplierId).Select(QueryConverter.Convert); var model = new QueryViewModel() { QueryThread = thread, TaskId = taskId }; return PartialView("_QueryThreadPartial", model); }
public ActionResult EditSupplier(int taskId, string suppId) { var thread = service.GetSupplierQueryThreads(taskId, suppId).Select(QueryConverter.Convert); var model = new QueryViewModel() { QueryThread = thread, TaskId = taskId }; return PartialView("_QueryListPartial", model); }