public static String getTableRegion2()
{
int contador = 0;
RegionDao regDao = new RegionDao();
//Populating a DataTable from database.
DataTable dt = regDao.getTableRegion();
//Building an HTML string.
StringBuilder html2 = new StringBuilder();
//Table start.
html2.Append("<table class='table table-bordered'");
//Building the Header row.
html2.Append("<tr>");
html2.Append("<th>");
html2.Append("Id Región");
html2.Append("</th>");
html2.Append("</tr>");
//Table end.
html2.Append("</table>");
//Append the HTML string to Placeholder.
//PlaceHolder1.Controls.Add(new Literal { Text = html.ToString() });
//PlaceHolderPrueba.Controls.Add(new Literal { Text = html2.ToString() });
return html2.ToString();
}
protected void btnGuardarReg_Click(object sender, EventArgs e)
{
int orderId = Convert.ToInt32(lbl_IdRegionN.Text);
RegionDao regDao = new RegionDao();
if (regDao.updateRegion(orderId, vigencia) == "Ok")
{
Alerta.Text = "Datos Modificados en forma Correcta";
Response.Redirect("MantenedorRegion");
}
else
{
Alerta.Text = regDao.updateRegion(orderId, vigencia);
}
}
protected void btnGuardarRegion_Click(object sender, EventArgs e)
{
Alerta.Enabled = true;
String strManRegionDescripcion = txtManRegion.Text;
String strManRegionNomCorto = txtManRegionNombreCorto.Text;
RegionDao regDao = new RegionDao();
if (regDao.insertRegion(strManRegionDescripcion, strManRegionNomCorto) == "Ok")
{
Alerta.Text = "Se ha guardado correctamente";
}
else
{
Alerta.Text = "No Se ha guardado correctamente";
}
}
private void LoadEditData(int orderId)
{
lblIdRegion.Text = Convert.ToString(orderId);
RegionDao regDao = new RegionDao();
DataSet ds = new DataSet();
da = regDao.getRegionId(orderId);
DataTable dt = new DataTable();
dt = regDao.getTableRegionId();
foreach (DataRow row in dt.Rows)
{
lbl_IdRegionN.Text = row[0].ToString();
txt_DescripcionRegion.Text = row[1].ToString();
txt_NombreCortoRegion.Text = row[2].ToString();
txt_VigenciaRegion.Text = row[3].ToString();
}
}
void getTableRegion()
{
RegionDao regDao = new RegionDao();
DataSet ds = new DataSet();
da = regDao.getRegion();
da.Fill(ds);
this.GV_regiones.DataSource = ds;
this.GV_regiones.DataBind();
}
void getTableRegion()
{
int contador = 0;
RegionDao regDao = new RegionDao();
//Populating a DataTable from database.
DataTable dt = regDao.getTableRegion();
//Building an HTML string.
StringBuilder html = new StringBuilder();
//Table start.
html.Append("<table class='table table-bordered'");
//Building the Header row.
html.Append("<tr>");
html.Append("<th>");
html.Append("Id Región");
html.Append("</th>");
html.Append("<th>");
html.Append("Nombre De Región");
html.Append("</th>");
html.Append("<th>");
html.Append("Nombre Corto de Región");
html.Append("</th>");
html.Append("<th>");
html.Append("Modificar");
html.Append("</th>");
html.Append("<th>");
html.Append("Eliminar");
html.Append("</th>");
html.Append("</tr>");
//Building the Data rows.
foreach (DataRow row in dt.Rows)
{
contador++;
html.Append("<tr class='table-title'>");
DataColumn dc = new DataColumn();
foreach (DataColumn column in dt.Columns)
{
html.Append("<td>");
html.Append("<div>"+row[column.ColumnName]+"</div>");
html.Append("</td>");
}
html.Append("<td><a href='#' id='btnModificar" + contador + "' onClick='getDate(" + row[0] + ")'>Modificar<a></td>");
html.Append("<td><a href='#' id='btnEliminar"+contador+"' onClick='getDate()'>Eliminar<a></td>");
html.Append("</tr>");
}
//Table end.
html.Append("</table>");
//Append the HTML string to Placeholder.
PlaceHolder1.Controls.Add(new Literal { Text = html.ToString() });
//PlaceHolderPrueba.Controls.Add(new Literal { Text = html.ToString() });
}
