protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bGerado = false;
Dados.StringDeConexao = ConfigurationManager.ConnectionStrings["GTIconnection"].ToString();
DebitoBLL obj = new DebitoBLL();
nValorTaxa = obj.TaxaExpediente(DateTime.Now.Year);
ShowResult(false);
txtVencto.Text = DateTime.Now.ToString("dd/MM/yyyy");
lblMsg2.Text = "";
}
}
private void GeraGuia()
{
decimal tmpNumber = 0;
StringBuilder sFullTrib;
bGerado = true;
List <Debito> lstExtrato = new List <Debito>();
DebitoBLL objDebitoBLL = new DebitoBLL();
Decimal nTaxaExp = objDebitoBLL.TaxaExpediente(DateTime.Now.Year);
Debito reg;
foreach (GridViewRow row in grdMain.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
if ((row.FindControl("chkRow") as CheckBox).Checked)
{
reg = new Debito();
reg.Codigo = Convert.ToInt32(txtCod.Text);
reg.Exercicio = Convert.ToInt32(row.Cells[1].Text);
reg.Lancamento = Convert.ToInt16(row.Cells[2].Text.Substring(0, 3));
reg.Sequencia = Convert.ToInt16(row.Cells[3].Text);
reg.Parcela = Convert.ToInt16(row.Cells[4].Text);
reg.Complemento = Convert.ToInt16(row.Cells[5].Text);
reg.DescLancamento = row.Cells[2].Text.Substring(4, row.Cells[2].Text.ToString().Length - 4);
reg.DtVencimento = Convert.ToDateTime(row.Cells[6].Text);
decimal.TryParse(row.Cells[7].Text, out tmpNumber);
reg.VlTributo = tmpNumber;
decimal.TryParse(row.Cells[8].Text, out tmpNumber);
reg.VlJuros = tmpNumber;
decimal.TryParse(row.Cells[9].Text, out tmpNumber);
reg.VlMulta = tmpNumber;
decimal.TryParse(row.Cells[10].Text, out tmpNumber);
reg.VlCorrecao = tmpNumber;
decimal.TryParse(row.Cells[11].Text, out tmpNumber);
reg.VlTotal = tmpNumber;
sFullTrib = new StringBuilder();
List <Debito> ListaTrib = objDebitoBLL.ListaTributos(reg);
foreach (Debito Trib in ListaTrib)
{
if (sFullTrib.ToString().IndexOf(Trib.CodigoTributo.ToString("000")) == -1)
{
String CodTributo = Trib.CodigoTributo.ToString("000");
String DescTributo = Trib.DescTributo;
sFullTrib.Append(CodTributo + "-" + DescTributo + "/");
}
}
sFullTrib.Remove(sFullTrib.Length - 1, 1);
reg.DescTributo = sFullTrib.ToString();
lstExtrato.Add(reg);
}
}
}
//taxa de expediente
reg = new Debito();
reg.Codigo = Convert.ToInt32(txtCod.Text);
reg.Exercicio = DateTime.Now.Year;
reg.Lancamento = 4;
reg.Sequencia = 0;
reg.Parcela = 1;
reg.Complemento = 0;
reg.DtVencimento = Convert.ToDateTime(txtVencto.Text);
reg.DescTributo = "003-TAXA EXP.DOC.";
reg.DescLancamento = "";
reg.VlTributo = nTaxaExp;
reg.VlJuros = 0;
reg.VlMulta = 0;
reg.VlCorrecao = 0;
reg.VlTotal = nTaxaExp;
lstExtrato.Add(reg);
float nValorGuia = 0;
float.TryParse(TableTotal.Rows[2].Cells[6].Text, out nValorGuia);
Int32 NumDoc = objDebitoBLL.GravaNovoDocumento(nValorGuia);
objDebitoBLL.GravaDAMWeb(NumDoc);
// NumDoc = Convert.ToInt32(txtimgcode.Text);
foreach (Debito Lanc in lstExtrato)
{
objDebitoBLL.GravaParcelaDocumento(Lanc, NumDoc);
}
String sDataDAM = txtVencto.Text;
Int32 nSID = objDebitoBLL.GravaBoletoDAM(lstExtrato, NumDoc, DateTime.ParseExact(sDataDAM, "dd/MM/yyyy", null));
Dados.StringDeConexao = ConfigurationManager.ConnectionStrings["GTIconnection"].ToString();
DebitoBLL obj = new DebitoBLL();
DataTable lista = obj.FillDataTableBoleto(nSID);
ReportDocument crystalReport = new ReportDocument();
crystalReport.Load(Server.MapPath("~/Report/boletodam.rpt"));
crystalReport.SetDataSource(lista);
HttpContext.Current.Response.Buffer = false;
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ClearHeaders();
objDebitoBLL.DeleteSID(nSID);
try {
crystalReport.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, HttpContext.Current.Response, true, "DAM" + nSID.ToString());
} catch {
} finally {
crystalReport.Close();
crystalReport.Dispose();
}
}
