public List <PurchaseOrderContract> GetPurchaseOrders(long salesAgentId) { var queryRequest = new QueryRequestModel(_dbId); queryRequest.Select = new List <long>() { 3, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 18 }; queryRequest.Where = $"{{11.EX.{salesAgentId}}}"; queryRequest.GroupBy = new List <QueryRequestGroupBy>() { new QueryRequestGroupBy() { FieldId = 3, Grouping = "equal-values" } }; var result = PostRequest <QueryRequestModel, QueryResponseModel>("/v1/records/query", queryRequest); var purchaseOrders = new List <PurchaseOrderContract>(); if (result.Data != null) { foreach (var data in result.Data) { purchaseOrders.Add(new PurchaseOrderContract(data)); } } return(purchaseOrders); }
public SalesAgentContract GetSalesAgent(long recordId) { var query = new QueryRequestModel(_dbId); query.Select = new List <long>() { 3, 6, 7, 8, 9, 10, 11, 12 }; query.Where = $"{{3.EX.{recordId}}}"; query.GroupBy = new List <QueryRequestGroupBy>() { new QueryRequestGroupBy() { FieldId = 3, Grouping = "equal-values" } }; var result = PostRequest <QueryRequestModel, QueryResponseModel>("/v1/records/query", query); if (result.Data.Any()) { var data = result.Data.First(); return(new SalesAgentContract(data)); } return(null); }
public PurchaseOrderContract GetPurchaseOrder(long recordId, long salesAgentId) { var queryRequest = new QueryRequestModel(_dbId); queryRequest.Select = new List <long>() { 3, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 18 }; queryRequest.Where = $"{{3.EX.{recordId}}}AND{{11.EX.{salesAgentId}}}"; queryRequest.GroupBy = new List <QueryRequestGroupBy>() { new QueryRequestGroupBy() { FieldId = 3, Grouping = "equal-values" } }; var result = PostRequest <QueryRequestModel, QueryResponseModel>("/v1/records/query", queryRequest); if (result.Data != null) { var data = result.Data.First(); return(new PurchaseOrderContract(data)); } return(null); }
public List <CustomerContract> GetCustomers(string query) { var queryRequest = new QueryRequestModel(_dbId); queryRequest.Select = new List <long>() { 3, 6, 7, 8, 9, 10, 11 }; if (!string.IsNullOrEmpty(query)) { queryRequest.Where = $"{{6.CT.'{query}'}}"; } queryRequest.GroupBy = new List <QueryRequestGroupBy>() { new QueryRequestGroupBy() { FieldId = 3, Grouping = "equal-values" } }; var result = PostRequest <QueryRequestModel, QueryResponseModel>("/v1/records/query", queryRequest); var customers = new List <CustomerContract>(); if (result.Data != null) { foreach (var data in result.Data) { customers.Add(new CustomerContract(data)); } } return(customers); }
public CustomerContract GetCustomer(long recordId) { var queryRequest = new QueryRequestModel(_dbId); queryRequest.Select = new List <long>() { 3, 6, 7, 8, 9, 10, 11 }; queryRequest.Where = $"{{3.EX.{recordId}}}"; queryRequest.GroupBy = new List <QueryRequestGroupBy>() { new QueryRequestGroupBy() { FieldId = 3, Grouping = "equal-values" } }; var result = PostRequest <QueryRequestModel, QueryResponseModel>("/v1/records/query", queryRequest); if (result.Data != null) { var data = result.Data.First(); return(new CustomerContract(data)); } return(null); }
public List <AttendanceLogContract> GetAttendanceLogs(long employeeRecordId) { var queryRequest = new QueryRequestModel(_dbId); queryRequest.Select = new List <long>() { 3, 6, 7, 8, 9, 10, 11, 12, 13, 14 }; queryRequest.Where = $"{{11.EX.{employeeRecordId}}}"; queryRequest.GroupBy = new List <QueryRequestGroupBy>() { new QueryRequestGroupBy() { FieldId = 3, Grouping = "equal-values" } }; var result = PostRequest <QueryRequestModel, QueryResponseModel>("/v1/records/query", queryRequest); var logs = new List <AttendanceLogContract>(); if (result.Data != null) { foreach (var data in result.Data) { logs.Add(new AttendanceLogContract(data)); } } return(logs); }
public AttendanceLogContract GetAttendanceLog(long recordId, long employeeRecordId) { var queryRequest = new QueryRequestModel(_dbId); queryRequest.Select = new List <long>() { 3, 6, 7, 8, 9, 10, 11, 12, 13, 14 }; queryRequest.Where = $"{{3.EX.{recordId}}}AND{{11.EX.{employeeRecordId}}}"; queryRequest.GroupBy = new List <QueryRequestGroupBy>() { new QueryRequestGroupBy() { FieldId = 3, Grouping = "equal-values" } }; var result = PostRequest <QueryRequestModel, QueryResponseModel>("/v1/records/query", queryRequest); if (result.Data != null) { var data = result.Data.First(); return(new AttendanceLogContract(data)); } return(null); }
public long?Login(string employeeId, string accessCode) { var query = new QueryRequestModel(_dbId); query.Select = new List <long>() { 3, 6, 7, 8, 9, 10, 11, 12 }; query.Where = $"{{9.EX.'{employeeId}'}}AND{{10.EX.'{accessCode}'}}"; query.GroupBy = new List <QueryRequestGroupBy>() { new QueryRequestGroupBy() { FieldId = 3, Grouping = "equal-values" } }; var result = PostRequest <QueryRequestModel, QueryResponseModel>("/v1/records/query", query); if (result.Data.Any()) { return((long)result.Data.First()["3"].Value); } return(null); }
public Message SaveQuery([FromBody] QueryRequestModel request) { QueryHelper.SaveQueryHelper(request.Name, request.Query, request.GroupId); return(new SuccessMessage { Data = null, MessageText = "Query Saved" }); }
public async Task <IHttpActionResult> Query([FromUri] string[] sort, [FromBody] QueryRequestModel filter) { var queryResult = await appManager.Query(sort, filter); if (queryResult == null) { return(BadRequest("Invalid query")); } if (queryResult.Count == 0) { return(Ok("Your query didn't produce anything")); } return(Ok(queryResult)); }
public async Task <List <ContactResponseModel> > Query(string[] sorts, QueryRequestModel qrm) { var fullName = !string.IsNullOrEmpty(qrm.FullName) ? qrm.FullName : "%"; var companyName = !string.IsNullOrEmpty(qrm.CompanyName) ? qrm.CompanyName : "%"; var position = !string.IsNullOrEmpty(qrm.Position) ? qrm.Position : "%"; var country = !string.IsNullOrEmpty(qrm.Country) ? qrm.Country : "%"; var email = !string.IsNullOrEmpty(qrm.Email) ? qrm.Email : "%"; var queryString = "select * from Contacts " + $"where fullname like '{fullName}' " + $"and companyname like '{companyName}' " + $"and position like '{position}' " + $"and country like '{country}' " + $"and email like '{email}'"; if (sorts != null && sorts.Length != 0) // order by { queryString += " order by "; queryString = sorts.Aggregate(queryString, (current, sort) => current + $"{sort.Replace('_', ' ')},"); queryString = queryString.TrimEnd(','); } var rows = await db.Contacts.SqlQuery(queryString).ToListAsync(); return(rows.Select(x => modelFactory.CreateContactResponseModel(x)).ToList()); }
public ActionResult Execute(QueryRequestModel request) { try { var temp = new User { Username = "******", Email = "*****@*****.**" }; var user = DataContext.Users.FirstOrDefault(x => x.Username == temp.Username); if (user == null) { DataContext.Users.Add(temp); DataContext.SaveChanges(); } var query = new SqlQuery { Sql = request.Query }; IQueryResult result = GetUserDataSource().Execute(query); var model = QueryResultViewModel.Generate(result); //var json = JsonResult(model); //return json; var view = PartialView("_ExecuteResult", model); return(view); } catch (Exception ex) { return(Error(ex)); } }
public List <ProductContract> GetProducts(string query) { var queryRequest = new QueryRequestModel("bqy89m7q2"); queryRequest.Select = new List <long>() { 3, 6, 7, 8, 9, 10, 11 }; if (!string.IsNullOrEmpty(query)) { queryRequest.Where = $"{{6.CT.'{query}'}}OR{{7.CT.'{query}'}}"; } queryRequest.GroupBy = new List <QueryRequestGroupBy>() { new QueryRequestGroupBy() { FieldId = 3, Grouping = "equal-values" } }; var result = PostRequest <QueryRequestModel, QueryResponseModel>("/v1/records/query", queryRequest); var products = new List <ProductContract>(); if (result.Data != null) { foreach (var data in result.Data) { products.Add(new ProductContract(data)); } } return(products); }
public async Task <ActionResult <IEnumerable <GetFleetCustomerDriverList_ViewModel> > > Get(int customerId, [FromQuery] QueryRequestModel queryRequest) { return(Ok(await Mediator.Send(new GetFleetCustomerCardListQuery(customerId, queryRequest)))); }
public async Task <LoadResult> Drivers(DataSourceLoadOptions loadOptions, [FromQuery] QueryRequestModel queryRequestModel) { var response = DataSourceLoader.Load <GetCardShipmentAddressQueryable_Dto>(await Mediator.Send(new GetCardShipmentAddressQueryable_Query(queryRequestModel)), loadOptions); return(response); }
public GetFleetCardQueryable_Query(QueryRequestModel queryRequestModel) { QueryRequestModel = queryRequestModel; }
public GetFleetDriverListQuery(QueryRequestModel queryRequest) { QueryRequest = queryRequest; }
public GetVehicleQueryable_Query(QueryRequestModel queryRequestModel, IMapper mapper) { mapper.Map(queryRequestModel, this); }
public GetSampleQueryable_Query(QueryRequestModel queryRequestModel) { QueryRequestModel = queryRequestModel; }
public GetFleetCardListQuery(QueryRequestModel queryRequest) { QueryRequest = queryRequest; }
public async Task <ActionResult <GetFleetOrgLevelDefinitionList_ViewModel> > GetAll([FromQuery] QueryRequestModel queryRequest) { return(Ok(await Mediator.Send(new GetFleetOrgLevelDefinitionList_Query(queryRequest)))); }
public GetLocationQueryable_Query(QueryRequestModel queryRequestModel) { QueryRequestModel = queryRequestModel; }
public GetOrgLevelDefinitionsQueryable_Query(QueryRequestModel queryRequestModel, IMapper mapper) { mapper.Map(queryRequestModel, this); }
public GetCustomerCardCategoryQueryable_Query(QueryRequestModel queryRequestModel) { QueryRequestModel = queryRequestModel; }
public GetFleetCustomerCardListQuery(int customerId, QueryRequestModel queryRequest) { QueryRequest = queryRequest; CustomerId = customerId; }
public GetFleetOrgLevelDefinitionList_Query(QueryRequestModel queryRequest) { QueryRequest = queryRequest; }
public EntityListQuery(QueryRequestModel queryRequest) { QueryRequest = queryRequest; }
public GetTransactionsQueryable_Query(QueryRequestModel queryRequestModel, IMapper mapper) { mapper.Map(queryRequestModel, this); }
public GetBusinessHoursQueryable_Query(QueryRequestModel queryRequestModel) { QueryRequestModel = queryRequestModel; }
public async Task <LoadResult> Customers(DataSourceLoadOptions loadOptions, [FromQuery] QueryRequestModel queryRequestModel) { var response = DataSourceLoader.Load(await Mediator.Send(new GetCustomerQueryable_Query(queryRequestModel, _mapper)), loadOptions); return(response); }