private void printCarne(int nSid)
{
lblMsg.Text = "";
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
Session["sid"] = "";
Tributario_bll tributario_Class = new Tributario_bll("GTIconnection");
List <Boletoguia> ListaBoleto = tributario_Class.Lista_Boleto_Guia(nSid);
int _codigo = Convert.ToInt32(ListaBoleto[0].Codreduzido);
if (ListaBoleto.Count > 0)
{
tributario_Class.Insert_Carne_Web(_codigo, 2020);
DataSet Ds = gtiCore.ToDataSet(ListaBoleto);
ReportDataSource rdsAct = new ReportDataSource("dsBoletoGuia", Ds.Tables[0]);
ReportViewer viewer = new ReportViewer();
viewer.LocalReport.Refresh();
viewer.LocalReport.ReportPath = "Report/Carne_ISS_TLL.rdlc";
viewer.LocalReport.DataSources.Add(rdsAct); // Add datasource here
Empresa_bll empresa_Class = new Empresa_bll("GTIconnection");
EmpresaStruct _empresa = empresa_Class.Retorna_Empresa(_codigo);
decimal _valor_aliquota = empresa_Class.Aliquota_Taxa_Licenca(_codigo);
List <ReportParameter> parameters = new List <ReportParameter>();
parameters.Add(new ReportParameter("DATADOC", Convert.ToDateTime(ListaBoleto[0].Datadoc).ToString("dd/MM/yyyy")));
parameters.Add(new ReportParameter("NOME", ListaBoleto[0].Nome));
parameters.Add(new ReportParameter("ENDERECO", ListaBoleto[0].Endereco + " " + ListaBoleto[0].Complemento));
parameters.Add(new ReportParameter("BAIRRO", ListaBoleto[0].Bairro));
parameters.Add(new ReportParameter("CIDADE", ListaBoleto[0].Cidade + "/" + ListaBoleto[0].Uf));
parameters.Add(new ReportParameter("CODIGO", _codigo.ToString()));
parameters.Add(new ReportParameter("IE", _empresa.Inscricao_estadual == ""? " ": _empresa.Inscricao_estadual));
parameters.Add(new ReportParameter("DOC", ListaBoleto[0].Cpf));
parameters.Add(new ReportParameter("ATIVIDADE", _empresa.Atividade_extenso));
parameters.Add(new ReportParameter("ISS", Convert.ToDecimal(ListaBoleto[0].Valor_ISS).ToString("#0.00")));
parameters.Add(new ReportParameter("TAXA", Convert.ToDecimal(ListaBoleto[0].Valor_Taxa).ToString("#0.00")));
parameters.Add(new ReportParameter("AREA", Convert.ToDecimal(_empresa.Area).ToString("#0.00")));
parameters.Add(new ReportParameter("ALIQUOTA", _valor_aliquota.ToString("#0.00")));
viewer.LocalReport.SetParameters(parameters);
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
tributario_Class.Excluir_Carne(nSid);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename= guia_pmj" + "." + extension);
Response.OutputStream.Write(bytes, 0, bytes.Length);
Response.Flush();
Response.End();
}
else
{
lblMsg.Text = "A guia já foi impressa!";
}
}
private void printCarne(int nSid)
{
lblMsg.Text = "";
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
Session["sid"] = "";
Tributario_bll tributario_Class = new Tributario_bll("GTIconnection");
List <Boletoguia> ListaBoleto = tributario_Class.Lista_Boleto_Guia(nSid);
if (ListaBoleto.Count > 0)
{
tributario_Class.Insert_Carne_Web(Convert.ToInt32(ListaBoleto[0].Codreduzido), 2019);
DataSet Ds = gtiCore.ToDataSet(ListaBoleto);
ReportDataSource rdsAct = new ReportDataSource("dsBoletoGuia", Ds.Tables[0]);
ReportViewer viewer = new ReportViewer();
viewer.LocalReport.Refresh();
viewer.LocalReport.ReportPath = "Report/Carne_PARCELAMENTO.rdlc";
viewer.LocalReport.DataSources.Add(rdsAct);
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
tributario_Class.Excluir_Carne(nSid);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename= guia_pmj" + "." + extension);
Response.OutputStream.Write(bytes, 0, bytes.Length);
Response.Flush();
Response.End();
}
else
{
lblMsg.Text = "A guia já foi impressa!";
}
}
private void printCarne(int nSid)
{
lblMsg.Text = "";
Warning[] warnings;
string[] streamIds;
string mimeType = string.Empty;
string encoding = string.Empty;
string extension = string.Empty;
Session["sid"] = "";
Tributario_bll tributario_Class = new Tributario_bll("GTIconnection");
List <Boletoguia> ListaBoleto = tributario_Class.Lista_Boleto_Guia(nSid);
if (ListaBoleto.Count > 0)
{
tributario_Class.Insert_Carne_Web(Convert.ToInt32(ListaBoleto[0].Codreduzido), 2020);
DataSet Ds = gtiCore.ToDataSet(ListaBoleto);
ReportDataSource rdsAct = new ReportDataSource("dsBoletoGuia", Ds.Tables[0]);
ReportViewer viewer = new ReportViewer();
viewer.LocalReport.Refresh();
viewer.LocalReport.ReportPath = "Report/Carne_IPTU.rdlc";
viewer.LocalReport.DataSources.Add(rdsAct); // Add datasource here
Laseriptu RegIPTU = tributario_Class.Carrega_Dados_IPTU(Convert.ToInt32(ListaBoleto[0].Codreduzido), 2020);
List <ReportParameter> parameters = new List <ReportParameter>();
parameters.Add(new ReportParameter("QUADRA", "Quadra: " + ListaBoleto[0].Quadra + " Lote: " + ListaBoleto[0].Lote));
parameters.Add(new ReportParameter("DATADOC", Convert.ToDateTime(ListaBoleto[0].Datadoc).ToString("dd/MM/yyyy")));
parameters.Add(new ReportParameter("NOME", ListaBoleto[0].Nome));
parameters.Add(new ReportParameter("ENDERECO", ListaBoleto[0].Endereco + " " + ListaBoleto[0].Complemento));
parameters.Add(new ReportParameter("BAIRRO", ListaBoleto[0].Bairro));
parameters.Add(new ReportParameter("CIDADE", ListaBoleto[0].Cidade + "/" + ListaBoleto[0].Uf));
parameters.Add(new ReportParameter("QUADRAO", ListaBoleto[0].Quadra));
parameters.Add(new ReportParameter("LOTEO", ListaBoleto[0].Lote));
parameters.Add(new ReportParameter("CODIGO", ListaBoleto[0].Codreduzido));
parameters.Add(new ReportParameter("INSC", ListaBoleto[0].Inscricao_cadastral));
parameters.Add(new ReportParameter("FRACAO", Convert.ToDecimal(RegIPTU.Fracaoideal).ToString("#0.00")));
parameters.Add(new ReportParameter("NATUREZA", RegIPTU.Natureza));
parameters.Add(new ReportParameter("TESTADA", Convert.ToDecimal(RegIPTU.Testadaprinc).ToString("#0.00")));
parameters.Add(new ReportParameter("AREAT", Convert.ToDecimal(RegIPTU.Areaterreno).ToString("#0.00")));
parameters.Add(new ReportParameter("AREAC", Convert.ToDecimal(RegIPTU.Areaconstrucao).ToString("#0.00")));
parameters.Add(new ReportParameter("VVT", Convert.ToDecimal(RegIPTU.Vvt).ToString("#0.00")));
parameters.Add(new ReportParameter("VVC", Convert.ToDecimal(RegIPTU.Vvc).ToString("#0.00")));
parameters.Add(new ReportParameter("VVI", Convert.ToDecimal(RegIPTU.Vvi).ToString("#0.00")));
parameters.Add(new ReportParameter("IPTU", Convert.ToDecimal(RegIPTU.Impostopredial).ToString("#0.00")));
parameters.Add(new ReportParameter("ITU", Convert.ToDecimal(RegIPTU.Impostoterritorial).ToString("#0.00")));
if (RegIPTU.Natureza == "predial")
{
parameters.Add(new ReportParameter("TOTALPARC", Convert.ToDecimal(RegIPTU.Impostopredial).ToString("#0.00")));
}
else
{
parameters.Add(new ReportParameter("TOTALPARC", Convert.ToDecimal(RegIPTU.Impostoterritorial).ToString("#0.00")));
}
parameters.Add(new ReportParameter("UNICA1", Convert.ToDecimal(RegIPTU.Valortotalunica).ToString("#0.00")));
parameters.Add(new ReportParameter("UNICA2", Convert.ToDecimal(RegIPTU.Valortotalunica2).ToString("#0.00")));
parameters.Add(new ReportParameter("UNICA3", Convert.ToDecimal(RegIPTU.Valortotalunica3).ToString("#0.00")));
viewer.LocalReport.SetParameters(parameters);
byte[] bytes = viewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamIds, out warnings);
tributario_Class.Excluir_Carne(nSid);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename= guia_pmj" + "." + extension);
Response.OutputStream.Write(bytes, 0, bytes.Length);
Response.Flush();
Response.End();
}
else
{
lblMsg.Text = "A guia já foi impressa!";
}
}