public void ExportarCSV(object sender, EventArgs e)
{
Response.ClearContent();
Response.AppendHeader("content-disposition",
"attachment; filename = " + TabelaTitulo.Text.Replace(" ", string.Empty) + ".xls");
Response.ContentType = "application/excel";
Response.ContentEncoding = Encoding.Unicode;
Response.BinaryWrite(Encoding.Unicode.GetPreamble());
StringWriter sw = new StringWriter();
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(sw);
TabelaPrincipal.HeaderRow.Style.Add("background-color", "#FFFFFF");
TabelaPrincipal.FooterRow.Visible = false;
foreach (TableCell tableCell in TabelaPrincipal.HeaderRow.Cells)
{
tableCell.Style["background-color"] = "#333333";
tableCell.Style["color"] = "#FFFFFF";
}
foreach (GridViewRow gridViewRow in TabelaPrincipal.Rows)
{
gridViewRow.BackColor = System.Drawing.Color.White;
gridViewRow.Cells[5].Visible = false;
foreach (TableCell gridViewRowTableCell in gridViewRow.Cells)
{
gridViewRowTableCell.Style["background-color"] = "#f2f2f2";
}
}
TabelaPrincipal.HeaderRow.Cells[5].Visible = false;
TabelaTitulo.RenderControl(htmlTextWriter);
TabelaPrincipal.RenderControl(htmlTextWriter);
Response.Write(sw.ToString());
Response.End();
}
public void CarregarModelo(string tipo)
{
//NovaFichaID();
DataTable dt = new DataTable();
DataRow row;
using (SqlConnection con = new SqlConnection(sqlConexao))
{
NovaFichaID();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT [LinhaID], [Titulo], [Encontro], [ND], [Experiencia], [Descricao], " +
"[Probabilidade], [Tipo], [Dado] " +
"FROM [SolidTables] WHERE [SolidTablesID] = '" + tipo + "'", con);
da.Fill(dt);
con.Close();
}
if (dt.Rows.Count > 0)
{
TabelaPrincipal.DataSource = dt;
TabelaPrincipal.DataBind();
row = dt.Rows[0];
dado = row[8].ToString();
novaTabela = false;
TabelaEsconder.Style["visibility"] = "visible";
PreencherHeader(row[7].ToString(), row[8].ToString());
if (String.IsNullOrEmpty(row[2].ToString()) && String.IsNullOrEmpty(EditarTitulo.Text))
{
TabelaTitulo.Text = "Sem Título";
EditarTitulo.Text = "Sem Título";
}
else
{
if (String.IsNullOrEmpty(row[2].ToString()) && !String.IsNullOrEmpty(EditarTitulo.Text))
{
TabelaTitulo.Text = EditarTitulo.Text;
TabelaOpcoesDD.Text = row[7].ToString();
DadoDD.Text = row[8].ToString();
}
else
{
TabelaTitulo.Text = row[2].ToString();
EditarTitulo.Text = row[2].ToString();
TabelaOpcoesDD.Text = row[7].ToString();
DadoDD.Text = row[8].ToString();
}
}
}
foreach (DataRow row1 in dt.Rows)
{
using (SqlConnection con = new SqlConnection(sqlConexao))
{
con.Open();
string query = "INSERT INTO SolidTables ([SolidTablesID], [SolidTablesUser], [Titulo], [Encontro], [ND]" +
", [Experiencia], [Descricao], [Probabilidade], [Tipo], [Dado])" +
"VALUES (@Titulo, @Encontro, @ND, @Experiencia, @Descricao, @Probabilidade, @Tipo, @Dado)";
//" WHERE [SolidTablesUser]=@SolidTablesUser AND [SolidTablesID]=@SolidTablesID";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@Titulo", row1[1]);
cmd.Parameters.AddWithValue("@Encontro", row1[2]);
cmd.Parameters.AddWithValue("@ND", row1[3]);
cmd.Parameters.AddWithValue("@Experiencia", row1[4]);
cmd.Parameters.AddWithValue("@Descricao", row1[5]);
cmd.Parameters.AddWithValue("@Probabilidade", row1[6]);
cmd.Parameters.AddWithValue("@Tipo", row1[7]);
cmd.Parameters.AddWithValue("@Dado", row1[8]);
//cmd.Parameters.AddWithValue("@SolidTablesUser", usuarioID);
//cmd.Parameters.AddWithValue("@SolidTablesID", fichaID);
cmd.ExecuteNonQuery();
con.Close();
// PreencherGridView();
}
}
tipo = string.Empty;
Response.Redirect("~/Tabela?fichaID=" + fichaID);
}
public void PreencherGridView()
{
try
{
DataTable dt = new DataTable();
DataRow row;
using (SqlConnection con = new SqlConnection(sqlConexao))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM SolidTables WHERE [SolidTablesUser]='"
+ usuarioID + "' AND [SolidTablesID]='" + fichaID + "'", con);
da.Fill(dt);
con.Close();
}
if (dt.Rows.Count > 0)
{
TabelaPrincipal.DataSource = dt;
TabelaPrincipal.DataBind();
row = dt.Rows[0];
dado = row[10].ToString();
novaTabela = false;
TabelaEsconder.Style["visibility"] = "visible";
PreencherHeader(row[9].ToString(), row[10].ToString());
if (String.IsNullOrEmpty(row[3].ToString()) && String.IsNullOrEmpty(EditarTitulo.Text))
{
TabelaTitulo.Text = "Sem Título";
EditarTitulo.Text = "Sem Título";
}
else
{
if (String.IsNullOrEmpty(row[3].ToString()) && !String.IsNullOrEmpty(EditarTitulo.Text))
{
TabelaTitulo.Text = EditarTitulo.Text;
TabelaOpcoesDD.Text = row[9].ToString();
DadoDD.Text = row[10].ToString();
}
else
{
TabelaTitulo.Text = row[3].ToString();
EditarTitulo.Text = row[3].ToString();
TabelaOpcoesDD.Text = row[9].ToString();
DadoDD.Text = row[10].ToString();
}
}
}
else
{
dt.Rows.Add(dt.NewRow());
TabelaPrincipal.DataSource = dt;
TabelaPrincipal.DataBind();
TabelaPrincipal.Rows[0].Cells.Clear();
TabelaPrincipal.Rows[0].Cells.Add(new TableCell());
TabelaPrincipal.Rows[0].Cells[0].ColumnSpan = dt.Columns.Count; // Célula do tamanho da linha
TabelaPrincipal.Rows[0].Cells[0].Text = "Adicione uma Linha Para Salvar a Tabela";
TabelaPrincipal.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
dado = DadoDD.Text;
novaTabela = true;
// TabelaTitulo.Text = "Sem Título";
// EditarTitulo.Text = "Sem Título";
TabelaEsconder.Style["visibility"] = "hidden";
PreencherHeader(TabelaOpcoesDD.Text, DadoDD.Text);
}
ChecarTabela();
}
catch (Exception e)
{
lblSucesso.Text = "";
lblFalha.Text = e.ToString();
}
}
