protected void Consultar_Click(object sender, EventArgs e)
{
pent.pentagSQL bd = new pent.pentagSQL();
DataTable dt = new DataTable();
dt = bd.ObtenGraficaComportamientos(TextBox1.Text, TextBox2.Text, DropDownList1.SelectedValue.ToString(), DropDownList2.SelectedValue.ToString(), ConnectionString);
string data = ObtenGrafia(dt);
string datos = ObtenTabla(dt);
BindChart(data);
DibujaTabla(datos);
}
protected void Button2_Click(object sender, EventArgs e)
{
if (NumUsr.Text != "")//actualizar
{
pent.pentagSQL bd = new pent.pentagSQL();
string res = bd.getIDbyuser(User.Text, ConnectionString);
if (res == NumUsr.Text || res == "")
{
bd.updateUsr(User.Text, Cont.Text, Rol.SelectedValue, RadioButtonList1.SelectedValue, NumUsr.Text, ConnectionString);
bd.updateUsrDtl(NameUsr.Text, Email.Text, Comp.Text, AreaFun.SelectedValue, AreaReal.SelectedValue, usrinfo.Text, ConnectionString);
//usrinfo.Text = "";
//NumUsr.Text = "";
//NameUsr.Text = "";
//Email.Text = "";
//Comp.Text = "";
//AreaFun.SelectedValue ="0";
//AreaReal.SelectedValue = "0";
//User.Text = "";
//Cont.Text ="";
//Rol.SelectedValue ="0";
//HiddenField1.Value = "0";
Response.Redirect("AdminUsr.aspx");
}
else
{
Response.Write("<script>alert('El nombre de usuario ya existe');</script>");
}
}
else //nuevo
{
pent.pentagSQL bd = new pent.pentagSQL();
//bd.updateUsr(User.Text, Cont.Text, Rol.SelectedValue, RadioButtonList1.SelectedValue, NumUsr.Text, ConnectionString);
//bd.updateUsrDtl(NameUsr.Text, Email.Text, Comp.Text, AreaFun.SelectedValue, AreaReal.SelectedValue, usrinfo.Text, ConnectionString);
string res = bd.getIDbyuser(User.Text, ConnectionString);
if (res == NumUsr.Text)
{
int usrInfo = bd.InsertUsrDtl(NameUsr.Text, Email.Text, Comp.Text, AreaFun.SelectedValue, AreaReal.SelectedValue, ConnectionString);
bd.InsertUser(User.Text, Cont.Text, Rol.SelectedValue, RadioButtonList1.SelectedValue, usrInfo.ToString(), ConnectionString);
Response.Write("<script>alert('Guardado Correctamente');</script>");
Response.Redirect("AdminUsr.aspx");
}
else
{
User.Text = "";
Cont.Text = "";
Response.Write("<script>alert('El nombre de usuario ya existe');</script>");
}
}
}
protected void Detalle_Click(object sender, EventArgs e)
{
GridView2.Visible = true;
pent.pentagSQL bd = new pent.pentagSQL();
LinkButton lab = (LinkButton)sender;
GridViewRow row = (GridViewRow)lab.NamingContainer;
//FileUpload fupEv = (FileUpload)row.FindControl("V_ID1");
Label rdb_obs = row.FindControl("V_ID1") as Label;
string auxString = rdb_obs.Text;
vosID.Text = rdb_obs.Text;
int temp = bd.getActionPlan("14", auxString, ConnectionString); //pendiente########
GridView2.DataBind(); //OJO instruccion para eliminar cache del grid
SqlDataSource2.SelectParameters["ActPlan"].DefaultValue = temp.ToString();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
if (!(sender == null))
{
pent.pentagSQL bd = new pent.pentagSQL();
LinkButton lab = (LinkButton)sender;
GridViewRow row = (GridViewRow)lab.NamingContainer;
//FileUpload fupEv = (FileUpload)row.FindControl("V_ID1");
Label rdb_obs = row.FindControl("V_ID1") as Label;
string auxString = rdb_obs.Text;
vosID.Text = rdb_obs.Text;
//Panel1.Visible = true;
int temp = bd.getActionPlan("14", auxString, ConnectionString);//pendiente########
SqlDataSource2.SelectParameters["ActPlan"].DefaultValue = temp.ToString();
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
if (!(sender == null))
{
pent.pentagSQL bd = new pent.pentagSQL();
DataTable dt = new DataTable();
LinkButton lab = (LinkButton)sender;
GridViewRow row = (GridViewRow)lab.NamingContainer;
//FileUpload fupEv = (FileUpload)row.FindControl("V_ID1");
Label rdb_obs = row.FindControl("Nuser") as Label;
string auxString = rdb_obs.Text;
dt = bd.getUsersAndInfoById(auxString, ConnectionString);
usrinfo.Text = dt.Rows[0]["usrInfo_id"].ToString();
NumUsr.Text = dt.Rows[0]["usr_id"].ToString();
NameUsr.Text = dt.Rows[0]["usrInfo_name"].ToString();
Email.Text = dt.Rows[0]["usrInfo_email"].ToString();
Comp.Text = dt.Rows[0]["usrInfo_company"].ToString();
string aux = dt.Rows[0]["perArea_id"].ToString();
AreaFun.SelectedValue = aux.Trim();
AreaReal.SelectedValue = dt.Rows[0]["area_id"].ToString();
User.Text = dt.Rows[0]["usr_username"].ToString();
Cont.Text = dt.Rows[0]["usr_pass"].ToString();
Rol.SelectedValue = dt.Rows[0]["rol_id"].ToString();
string tem = dt.Rows[0]["usr_active"].ToString();
if (tem == "True")
{
RadioButtonList1.SelectedValue = "1";
}
else
{
RadioButtonList1.SelectedValue = "0";
}
//Bandera.Text = "1";
HiddenField1.Value = "1";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
if (NoArea.Text != "")//actualizar
{
pent.pentagSQL bd = new pent.pentagSQL();
bd.updateCatArea(Nombre.Text, RadioButtonList2.SelectedValue.ToString(), NoArea.Text, ConnectionString);
//Response.Write("<script>alert('Guardado Correctamente');</script>");
HiddenField1.Value = "0";
Response.Redirect("CatAreas.aspx");
}
else
{//guardar nuevo
pent.pentagSQL bd = new pent.pentagSQL();
bd.InsertCatArea(Nombre.Text, RadioButtonList2.SelectedValue.ToString(), ConnectionString);
Response.Redirect("CatAreas.aspx");
}
}
catch (Exception ex) {
Response.Write("<script>alert('ocurrio un error contacte con el administrador del sistema');</script>");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
if (FormatID.Text != "")//actualizar
{
pent.pentagSQL bd = new pent.pentagSQL();
bd.updateCatFormats(FrmCodigo.Text, FrmVersion.Text, FrmRev.Text, FrmNombre.Text, FrmNorma.Text, FormatID.Text, ConnectionString);
HiddenField1.Value = "0";
Response.Redirect("CatFormatos.aspx");
}
else
{//guardar nuevo
pent.pentagSQL bd = new pent.pentagSQL();
bd.InsertCatFormat(FrmCodigo.Text, FrmVersion.Text, FrmRev.Text, FrmNombre.Text, FrmNorma.Text, ConnectionString);
Response.Redirect("CatFormatos.aspx");
}
}
catch (Exception ex)
{
Response.Write("<script>alert('ocurrio un error contacte con el administrador del sistema');</script>");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
if (AspectID.Text != "")//actualizar
{
pent.pentagSQL bd = new pent.pentagSQL();
bd.updateCatAspect(Elemento.Text, AspectRev.Text, RadioButtonList1.SelectedValue, AspectID.Text, ConnectionString);
HiddenField1.Value = "0";
Response.Redirect("CatAspects.aspx");
}
else
{//guardar nuevo
pent.pentagSQL bd = new pent.pentagSQL();
bd.InsertCatCatAspect(Formatos.SelectedValue, Elemento.Text, AspectRev.Text, RadioButtonList1.SelectedValue, ConnectionString);
Response.Redirect("CatAspects.aspx");
}
}
catch (Exception ex)
{
Response.Write("<script>alert('ocurrio un error contacte con el administrador del sistema');</script>");
}
}
public void PDF(string ruta, string logo, string inspectID, string recursosFolder)
{
// Creamos el documento con el tamaño de página tradicional
Document doc = new Document(PageSize.LETTER);
// Indicamos donde vamos a guardar el documento
PdfWriter writer = PdfWriter.GetInstance(doc, new FileStream(ruta, FileMode.Create));
// **Nota: Esto no será visible en el documento
doc.AddTitle("Inspecciones pentagono");
doc.AddCreator("Admin");
// Abrimos el archivo
doc.Open();
// Creamos el tipo de Font que vamos utilizar
iTextSharp.text.Font _standardFont = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.HELVETICA, 8, iTextSharp.text.Font.NORMAL, BaseColor.BLACK);
// Escribimos el encabezamiento en el documento
//iTextSharp.text.Image imagen = iTextSharp.text.Image.GetInstance(@"C:\Users\REYESFE\Pictures\imgs\logo.jpg");
Image imagen = Image.GetInstance(logo);
//imagen.ScaleToFit(140f, 120f);
imagen.ScalePercent(40);
// Insertamos la imagen en el documento
//doc.Add(imagen);
PdfPTable tblHeader = new PdfPTable(4);
tblHeader.TotalWidth = 500f;
tblHeader.LockedWidth = true;
float[] widths = new float[] { 30f, 50f, 25f, 25f };
tblHeader.SetWidths(widths);
tblHeader.SpacingAfter = 20;
pent.pentagSQL sql = new pent.pentagSQL();
//addCell(tblHeader, "ASPEN", 1);
string formato = sql.getSingleValueByID("format_id", inspectID, "tbl_inspect", "inspect_id", ConnectionString);
//Select format_id, format_codigo, format_version, format_rev," +
// " format_nextRev, format_name,format_norma
DataTable dtHeaderFormat = new DataTable();
dtHeaderFormat = sql.headerFormat(formato, ConnectionString);
PdfPCell cllogo = new PdfPCell(imagen);
cllogo.BorderWidth = 0;
tblHeader.AddCell(cllogo);
addCell(tblHeader, "PLANTA VALLEJO MEXICO", 1);
addCell(tblHeader, "TIPO", 1);
addCell(tblHeader, "FORMATO", 1);
addCell(tblHeader, "", 1);
addCell(tblHeader, "", 1);
addCell(tblHeader, "CODIGO: ", 1);
addCell(tblHeader, dtHeaderFormat.Rows[0][1].ToString(), 1);
addCell(tblHeader, "TITULO: ", 1);
addCell(tblHeader, dtHeaderFormat.Rows[0][5].ToString(), 1);
addCell(tblHeader, "VERSION: ", 1);
addCell(tblHeader, dtHeaderFormat.Rows[0][2].ToString(), 1);
addCell(tblHeader, "NO INSPECCION: " + inspectID, 1);
addCell(tblHeader, dtHeaderFormat.Rows[0]["format_norma"].ToString(), 1); //inspectID
addCell(tblHeader, "PROXIMA REVISIÓN", 1);
addCell(tblHeader, Convert.ToDateTime(dtHeaderFormat.Rows[0][4]).ToString("MMM yyyy"), 1);
doc.Add(tblHeader);
//*** Zona de datos generales del reporte/inspección
PdfPTable tblHead = new PdfPTable(3);
tblHead.TotalWidth = 500f;
tblHead.LockedWidth = true;
float[] widthsHead = new float[] { 40f, 40f, 40f };
tblHead.SetWidths(widthsHead);
//Select tbl_areas.area_name, tbl_inspect.area_id, usrInfo_name ,inspect_noEmp,"+
// inspect_date, recor_desc ,inspect_start,inspect_end,recor_id
DataTable dtInspectHead = new DataTable();
dtInspectHead = sql.headInspeccion(inspectID, ConnectionString);
addCellBorder(tblHead, "Área: " + dtInspectHead.Rows[0][0].ToString(), 1);
addCellBorder(tblHead, "Integrante de la CSH: " + dtInspectHead.Rows[0][2].ToString(), 1);
addCellBorder(tblHead, "Fecha: " + Convert.ToDateTime(dtInspectHead.Rows[0][4]).ToString("dd/MM/yyyy"), 1);
addCellBorder(tblHead, "Número de Empleados: " + dtInspectHead.Rows[0][3].ToString(), 1);
addCellBorder(tblHead, "Recorrido de Verificación: " + dtInspectHead.Rows[0][5].ToString(), 1);
addCellBorder(tblHead, "Inicio: " + Convert.ToDateTime(dtInspectHead.Rows[0][6]).ToString("HH:mm:ss") + " Fin: " + Convert.ToDateTime(dtInspectHead.Rows[0][7]).ToString("HH:mm:ss"), 1);
doc.Add(tblHead);
//*** Zona para el detalle de la inspección
PdfPTable tblDetail = new PdfPTable(5);
tblDetail.TotalWidth = 500f;
tblDetail.LockedWidth = true;
float[] widthsDtl = new float[] { 20f, 50f, 10f, 10f, 30f };
tblDetail.SetWidths(widthsDtl);
tblDetail.SpacingAfter = 20;
addCell(tblDetail, "Elemento", 1, "b", "c", 0.5f);
addCell(tblDetail, "Forma de Revisar", 1, "b", "c", 0.5f);
addCell(tblDetail, "Satisfactorio", 1, "b", "c", 0.5f);
addCell(tblDetail, "No Satisfactorio ", 1, "b", "c", 0.5f);
addCell(tblDetail, "Observaciones: ", 1, "b", "c", 0.5f);
//addCellBorder(tblDetail, "Elemento", 1);
//addCellBorder(tblDetail, "Forma de Revisar", 1);
//addCellBorder(tblDetail, "Satisfactorio", 1);
//addCellBorder(tblDetail, "No Satisfactorio ", 1);
//addCellBorder(tblDetail, "Observaciones: ", 1);
DataTable dtInspect = new DataTable();
Image check = Image.GetInstance(recursosFolder + "check_48.png");
check.ScalePercent(25);
Image cancel = Image.GetInstance(recursosFolder + "cancel_48.png");
cancel.ScalePercent(25);
PdfPCell mark = new PdfPCell(check, false);
mark.HorizontalAlignment = PdfPCell.ALIGN_CENTER;
PdfPCell markBad = new PdfPCell(cancel, false);
markBad.HorizontalAlignment = PdfPCell.ALIGN_CENTER;
dtInspect = sql.detalleInspeccion(inspectID, ConnectionString);
foreach (DataRow row in dtInspect.Rows)
{
addCell(tblDetail, row[0].ToString(), 1, "b", "c", 0.5f);
//addCellBorder(tblDetail, row[0].ToString(), 1);
addCellBorder(tblDetail, row[1].ToString(), 1);
if (Convert.ToBoolean(row[3]))
{
tblDetail.AddCell(mark);
//addCellBorder(tblDetail, , 1);
addCellBorder(tblDetail, "", 1);
}
else
{
addCellBorder(tblDetail, "", 1);
tblDetail.AddCell(markBad);
//addCellBorder(tblDetail, recursosFolder+"cancel_48.png", 1);
}
addCellBorder(tblDetail, row[4].ToString(), 1);
}
doc.Add(tblDetail);
//Salto de linea
//doc.Add(Chunk.NEWLINE);
//*** Tabla de acciones
PdfPTable tblActions = new PdfPTable(3);
tblActions.TotalWidth = 500f;
tblActions.LockedWidth = true;
float[] widthsAct = new float[] { 80f, 20f, 20f };
tblActions.SetWidths(widthsAct);
tblActions.SpacingAfter = 90;
addCellBorder(tblActions, "Acciones recomendadas/correctivas", 1);
addCellBorder(tblActions, "Responsable", 1);
addCellBorder(tblActions, "Fecha compromiso", 1);
DataTable dtActions = new DataTable();
dtActions = sql.listaAcciones(inspectID, "7", "1", ConnectionString);
foreach (DataRow row in dtActions.Rows)
{
addCellBorder(tblActions, row[1].ToString(), 1);
addCellBorder(tblActions, row["usrInfo_name"].ToString(), 1);
addCellBorder(tblActions, Convert.ToDateTime(row[4]).ToString("dd/MM/yyyy"), 1);
}
doc.Add(tblActions);
//*** Tabla de firmas digitales
PdfPTable tblSignatures = new PdfPTable(1);
tblSignatures.TotalWidth = 500f;
tblSignatures.LockedWidth = true;
float[] widthsSig = new float[] { 40f };
tblSignatures.SetWidths(widthsSig);
tblSignatures.SpacingAfter = 20;
//addCell(tblSignatures, "Integrante de la CSH \nNombre y Firma", 1);
//addCell(tblSignatures, "Supervisor \nNombre y Firma", 1);
//addCell(tblSignatures, "Gerente \nNombre y Firma", 1);
//addCell(tblSignatures, "", 1);
//addCell(tblSignatures, "", 1);
//addCell(tblSignatures, "", 1);
DataTable dtSignatuers = new DataTable();
dtSignatuers = sql.getSignatures(inspectID, ConnectionString);
addCell(tblSignatures, "Firmas Electrónicas", 1, "b", "l");
foreach (DataRow row in dtSignatuers.Rows)
{
//addCell(tblSignatures, row["bitac_date"].ToString() +" "+ row["bitac_desc"].ToString(), 1);
addCell(tblSignatures, row["bitac_date"].ToString() + " " + row["bitac_desc"].ToString(), 1, "n", "l");
}
doc.Add(tblSignatures);
doc.Close();
writer.Close();
//System.Diagnostics.Process.Start(ruta);
}
