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