public IActionResult Load(long?ID, long?ReportGroupID, long?LanguageID) { GetReport operation = new GetReport(); operation.ID = ID; operation.ReportGroupID = ReportGroupID; if (LanguageID.HasValue) { operation.LangID = LanguageID; } else { operation.LangID = 1; } var result = operation.QueryAsync().Result; if (result is ValidationsOutput) { return(Ok(new ApiResult <List <ValidationItem> >() { Data = ((ValidationsOutput)result).Errors })); } else { return(Ok((List <Report>)result)); } }
public List <Reports> Report(string type = "year", string year = "2016", string month = "1", string day = "1") { GetReport getrep = new GetReport(); RangeDate range = getrep.getRange(); char[] split_char = new char[] { '/' }; List <Reports> reports; if (type == "year") { reports = getrep.getMonthInfo(year); } else if (type == "month") { reports = getrep.getWeekInfo(year, month); } else //(type == "day") { reports = getrep.getDayInfo(year, month); } return(reports); }
public static async Task <GetReportResult> FindReport(this ServerApiClient client, int incidentId, string partOfErrorMessage, Func <GetReportResult, bool> filter = null) { var reportListItem = await client.GetReportListItem(incidentId, partOfErrorMessage); if (reportListItem == null) { throw new InvalidOperationException("Failed to find our uploaded report"); } GetReportResult result = null; await Repeat(async() => { var query3 = new GetReport(reportListItem.Id); result = await client.QueryAsync(query3); if (result == null) { return(false); } if (filter != null && filter(result)) { return(true); } return(result.ContextCollections.Any()); }); if (result != null) { Console.WriteLine($"Got report {result.CreatedAtUtc:yyyyMMdd hh:mm:ss.fff}"); } return(result); }
public List <DetailReport> Detail(string year = "2016", string month = "1", string day = "1") { List <DetailReport> dreports; GetReport getrep = new GetReport(); dreports = getrep.getDayDetailInfo(year, month, day); return(dreports); }
public async Task <ActionResult> Download() { var message = new GetReport(); var response = await _endpointInstance.Request <ResponseGetReport>(message).ConfigureAwait(false); var fileBytes = System.IO.File.ReadAllBytes(response.Path); return(File(fileBytes, "application/vnd.ms-excel", $"{Path.GetFileName(response.Path)}")); }
public IActionResult LoadRelated(long?ID, long?ProductID, long?ProductDetailID, long?langId) { GetProductReports operation = new GetProductReports(); GetReport operation2 = new GetReport(); operation.ID = ID; operation.ProductId = ProductID; operation.ProductDetailId = ProductDetailID; if (langId.HasValue) { operation.LangID = langId; operation2.LangID = langId; } else { operation.LangID = 1; operation2.LangID = 1; } var result = operation.QueryAsync().Result; var result2 = (List <Report>)operation2.QueryAsync().Result; List <ProductReport> RelatedReports = new List <ProductReport>(); List <Report> UnRelatedReports = new List <Report>(); var productReports = (List <ProductReport>)result; if (productReports.Count > 0) { RelatedReports = productReports.Where(p => result2.Any(s => s.ID == p.ReportId)).ToList(); UnRelatedReports = result2.Where(s => productReports.Any(p => p.ReportId != s.ID)).ToList(); UnRelatedReports = UnRelatedReports.Where(un => !RelatedReports.Exists(re => un.ID == re.ReportId)).ToList(); } else { UnRelatedReports = result2; } if (result is ValidationsOutput) { return(Ok(new ApiResult <List <ValidationItem> >() { Data = ((ValidationsOutput)result).Errors })); } else { return(Ok(new { UnRelatedReports, RelatedReports })); } }
public string ReceiveReport(GetReport gr) { MedicalReport mr = new MedicalReport(); mr.person = _context.people.Where(b => b.UID == gr.uid).FirstOrDefault(); mr.Report = gr.Report; mr.Approved = true; _context.Add(mr); _context.SaveChanges(); return(""); }
public void ProcessRequest(HttpContext context) { System.Web.Script.Serialization.JavaScriptSerializer ser = new System.Web.Script.Serialization.JavaScriptSerializer(); zues z2 = new zues(); var ppp = (context.Request["vid3"]); GetNewData dd3 = ser.Deserialize <GetNewData>(ppp); // var pp3 = (context.Request["vid2"]).ToString(); int pp2 = Convert.ToInt32(dd3.pageno); // string pp3 = words[1]; string pp3 = dd3.criteria; string pp4 = dd3.valueentered; string pp5 = dd3.valueentered2; string pp6 = dd3.valueentered3; // string pp3 = ""; // System.Collections.Generic.List<XObjs.Office_view> kk = z2.getNew_MarkInfoRSX222b("8", "Certified", 1, 1); GetReport dd = new GetReport(); if (dd3.datastatus == "Accepted") { dd = z2.getNew_MarkInfoRSX222bbx5(dd3.status, dd3.datastatus, pp2, 100, pp3, pp4, pp5, pp6); } else { dd = z2.getNew_MarkInfoRSX222bbx4(dd3.status, dd3.datastatus, pp2, 100, pp3, pp4); } // dd = z2.getNew_MarkInfoRSX222bbx4("8", "Certified", pp2, 100, pp3, pp4); // System.Collections.Generic.List<XObjs.Office_view> kk = z2.getNew_MarkInfoRSX9("8", "Certified", 1, 1); ser.MaxJsonLength = Int32.MaxValue; context.Response.ContentType = "application/json"; // int lt_mi_n = z2.getCriRegisteredMarkInfoRSCnt("8", "Certified"); //dd.data = kk; //dd.count = lt_mi_n; // context.Response.Write(ser.Serialize(kk)); context.Response.Write(ser.Serialize(dd)); }
private void btnImprimir_Click(object sender, EventArgs e) { String vWhere = String.Format("where cliente.dt_registro between '1900-01-01 00:00:00' and '{0}'", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); String orderby = " "; if (!txtcdCliente.Text.Equals(String.Empty)) { vWhere += " and cliente.cd_cliente = " + Convert.ToInt32(txtcdCliente.Text); } if (cbOrdenacao.SelectedIndex == 0) { orderby += " cliente.cd_cliente asc, "; } if (cbOrdenacao.SelectedIndex == 1) { orderby += " cliente.cd_cliente desc, "; } if (cbOrdenacao.SelectedIndex == 2) { orderby += " cliente.ds_nome asc, "; } if (cbOrdenacao.SelectedIndex == 3) { orderby += " cliente.ds_nome desc, "; } Report report = GetReport.loadReport("RelClienteContato.frx"); String vSql = "select " + " cliente.cd_cliente as cliente_cd_cliente, " + " clientecontato.cd_contato as clientecontato_cd_contato, " + " cliente.ds_nome as cliente_ds_nome, " + " cliente.nr_telefone as cliente_nr_telefone, " + " cliente.nr_celular as cliente_nr_celular, " + " cliente.nr_celular2 as cliente_nr_celular2, " + " cliente.ds_email as cliente_ds_email, " + " clientecontato.ds_contato as clientecontato_ds_contato, " + " clientecontato.nr_telefone as clientecontato_nr_telefone, " + " clientecontato.nr_celular as clientecontato_nr_celular, " + " clientecontato.nr_celular2 as clientecontato_nr_celular2, " + " clientecontato.ds_email as clientecontato_ds_email " + " from cliente " + " left join clientecontato on clientecontato.cd_cliente = cliente.cd_cliente " + vWhere + " order by " + orderby + "clientecontato.cd_contato "; GetReport.buildReport("tabClienteContato", vSql, report); GetReport.abreVisualizador(report); }
private void btnImprimir_Click(object sender, EventArgs e) { if (!txtcdCliente.Text.Equals(String.Empty)) { Report report = GetReport.loadReport("CadClienteContato.frx"); String vSqlCliente = String.Format("select cliente.cd_cliente, cliente.ds_nome, cliente.ds_email, cliente.nr_telefone, cliente.nr_celular, cliente.nr_celular2 " + " from cliente where cd_cliente = {0}", txtcdCliente.Text); String vSqlContato = String.Format("select clientecontato.cd_cliente, clientecontato.cd_contato, clientecontato.ds_contato, " + " clientecontato.nr_telefone, clientecontato.nr_celular, clientecontato.nr_celular2, clientecontato.ds_email " + " from clientecontato where cd_cliente = {0}", txtcdCliente.Text); GetReport.buildReport("tabcadcliente", vSqlCliente, report); GetReport.buildReport("tabcadclientecontato", vSqlContato, report); GetReport.abreVisualizador(report); } else { Alert.atencao("É necessário buscar o cliente desejado, para realizar a impressão do relatório individual."); } }
public async Task <Result <ReportModel> > Handle(GetReport request, CancellationToken cancellationToken) { try { var report = await _context.Reports.FirstOrDefaultAsync(r => r.ReportId == request.ReportId, cancellationToken); if (report == null) { return(Result.Failure <ReportModel>($"Could not find user with id = {request.ReportId}")); } var reportModel = _mapper.Map <ReportModel>(report); return(Result.Ok(reportModel)); } catch (System.Exception e) { _logger.LogError($"Unable to load report {request.ReportId}", e); return(Result.Failure <ReportModel>($"Unable to load report {request.ReportId}")); } }
private void btnImprimirRelatorio_Click(object sender, EventArgs e) { try { String vWhere = ""; Report report = GetReport.loadReport("RelCadAcessoCliente.frx"); String vSql = ""; if (!txtcdUsuarioRelatorio.Text.Equals(String.Empty)) { vWhere += String.Format(" and acessoprograma.cd_usuario = '{0}' ", txtcdUsuarioRelatorio.Text); } if (!txtcdModuloRelatorio.Text.Equals(String.Empty)) { vWhere += String.Format(" and modulo.cd_modulo = '{0}' ", txtcdModuloRelatorio.Text); } if (!txtcdProgramaRelatorio.Text.Equals(String.Empty)) { vWhere += String.Format(" and programa.cd_programa = '{0}' ", txtcdProgramaRelatorio.Text); } vSql = "select " + " acessoprograma.cd_usuario, usuario.nm_usuario, modulo.cd_modulo, modulo.ds_modulo, "+ " programa.cd_programa, programa.ds_programa"+ " from modulo " + " inner join programa on programa.cd_modulo = modulo.cd_modulo " + " inner join acessoprograma on acessoprograma.cd_modulo = programa.cd_modulo " + " and acessoprograma.cd_programa = programa.cd_programa "+ " inner join usuario on usuario.cd_usuario = acessoprograma.cd_usuario " + " where acessoprograma.cd_programa = programa.cd_programa " + vWhere + " order by acessoprograma.cd_usuario, modulo.cd_modulo, programa.cd_programa"; GetReport.buildReport("tabacesso", vSql, report); GetReport.abreVisualizador(report); } catch (Exception erro) { Alert.erro("Erro ao gerar Relatório " + erro.Message); } }
public ActionResult Report(string type = "year", string thisyear = "2016", string month = "1", string day = "1") { GetReport getrep = new GetReport(); RangeDate range = getrep.getRange(); char[] split_char = new char[] { '/' }; string[] param = range.enddate.Split(split_char); ViewBag.Year = thisyear; ViewBag.Month = month; ViewBag.Day = day; ViewBag.type = type; List <Reports> reports; if (type == "year") { reports = getrep.getMonthInfo(thisyear); } else if (type == "month") { reports = getrep.getWeekInfo(thisyear, month); } else if (type == "day") { reports = getrep.getDayInfo(thisyear, month); } else { List <DetailReport> dreports; dreports = getrep.getDayDetailInfo(thisyear, month, day); return(View("Detail", dreports)); } return(View(reports)); }
public IActionResult LoadReports(long?groupID, long?reportID, long?LanguageID) { GetGroupRelation operation = new GetGroupRelation(); GetReport getRelatedReport = new GetReport(); operation.GroupID = groupID; GetReport getUnRelatedReport = new GetReport(); if (LanguageID.HasValue) { operation.LangID = LanguageID; getRelatedReport.LangID = LanguageID; getUnRelatedReport.LangID = LanguageID; } else { operation.LangID = 1; getUnRelatedReport.LangID = 1; getRelatedReport.LangID = 1; } var Reports = (List <Report>)getRelatedReport.QueryAsync().Result; var result = operation.QueryAsync().Result; var reports = (List <GroupRelation>)result; List <Report> returnedRelatedReports = new List <Report>(); List <Report> returnedUnRelatedReports = new List <Report>(); var groups = (List <GroupRelation>)result; if (groups.Count > 0) { foreach (var item in Reports) { foreach (var group in groups) { if (group.RefrenceID == item.ID) { bool alreadyExist = returnedRelatedReports.Contains(item); bool alreadyExistInSecondList = returnedUnRelatedReports.Contains(item); if (!alreadyExist && !alreadyExistInSecondList) { item.ReportRelationID = group.ID.Value; returnedRelatedReports.Add(item); } else { item.ReportRelationID = group.ID.Value; returnedRelatedReports.Add(item); returnedUnRelatedReports.Remove(item); } } else { bool alreadyExist = returnedUnRelatedReports.Contains(item); bool alreadyExistInFirstList = returnedRelatedReports.Contains(item); if (!alreadyExist && !alreadyExistInFirstList) { item.ReportRelationID = group.ID.Value; returnedUnRelatedReports.Add(item); } } } } } else { returnedUnRelatedReports = Reports; } if (result is ValidationsOutput) { return(Ok(new ApiResult <List <ValidationItem> >() { Data = ((ValidationsOutput)result).Errors })); } else { return(Ok(new { RelatedReports = returnedRelatedReports, UnRelatedReports = returnedUnRelatedReports })); } }