private int getEstatus(int incidentID) { int status = 0; tbl_incidentTableAdapter incid = new tbl_incidentTableAdapter(); status = Convert.ToInt32(incid.getStatus(Convert.ToInt32(incidentID))); incid.Dispose(); return(status); }
private void mail(int incid_id, string area, string clasif, string desc, string fecha, string estatus, string user, int areaID) { string bodytext; string involucrados = ""; tbl_personEventTableAdapter involuc = new tbl_personEventTableAdapter(); DataSet1.tbl_personEventDataTable tblinvoluc = new DataSet1.tbl_personEventDataTable(); involuc.FillByIncid(tblinvoluc, user, incid_id); for (int i = 0; i <= tblinvoluc.Rows.Count - 1; i++) { if (!(String.IsNullOrEmpty(Convert.ToString(tblinvoluc.Rows[i]["perEvent_numEmploy"])))) { involucrados += "No. empleado: " + tblinvoluc.Rows[i]["perEvent_numEmploy"] + " \n\n"; } involucrados += "Nombre de la persona: " + tblinvoluc.Rows[i]["perEvent_name"] + " \n "; involucrados += "Empresa: " + tblinvoluc.Rows[i]["perEvent_company"] + " \n "; involucrados += "Area funcional: " + tblinvoluc.Rows[i]["area_id"] + " \n\n "; } involuc.Dispose(); tblinvoluc.Dispose(); tbl_incidentTableAdapter incid = new tbl_incidentTableAdapter(); tbl_statusTableAdapter stat = new tbl_statusTableAdapter(); bodytext = "\nPor medio del presente se notifica que ha ocurrido un accidente no." + incid_id + " del día " + fecha + " \n"; bodytext = bodytext + "\n Area: " + area + "\n"; bodytext = bodytext + " Clasificación del Incidente: " + clasif + "\n"; bodytext = bodytext + "\n Descripción del Incidente: " + desc + "\n"; bodytext = bodytext + "\nPersonal involucrado: " + "" + ""; bodytext = bodytext + involucrados; bodytext = bodytext + "\n Área funcional: " + area + ""; bodytext = bodytext + "\n Creador del reporte: " + Convert.ToString(Session["userName"]) + ""; bodytext = bodytext + "\n\n Estatus: " + stat.getEstatusDesc(Convert.ToInt32(incid.getStatus(incid_id))) + ""; bodytext = bodytext + "\nPara más información, favor de consultar la siguiente liga. \n http://10.240.151.139/pentagono/incidDetail.aspx?folio=" + incid_id + "\n"; incid.Dispose(); stat.Dispose(); //string to = Convert.ToString(usrInfoTable.Rows[0]["usrInfo_email"]) + ";"; tbl_userInfoTableAdapter usrInfo = new tbl_userInfoTableAdapter(); DataSet1.tbl_userInfoDataTable tblusrInfo = new DataSet1.tbl_userInfoDataTable(); usrInfo.FillByArea(tblusrInfo, areaID); string[] correos; // = {""}; int numCorreos = tblusrInfo.Rows.Count + 1; correos = new string[numCorreos]; correos[0] = Convert.ToString(Session["email"]); for (int j = 1; j <= tblusrInfo.Rows.Count; j++) { correos[j] = Convert.ToString(tblusrInfo.Rows[j - 1]["usrInfo_email"]); } //string[] correos; // = {""}; //correos = new string[2]; ////correos = new string[1]; //correos[0] = Convert.ToString(Session["email"]); //correos[1] = getEmail(getResponsable(Convert.ToInt32(Session["userID"]))); try { lblError.Text = f.enviarCorreoAsync("Fernando Reyes", correos, " ", bodytext, "Reporte incidente/accidente folio " + incid_id); } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { int estatus = 0; btnRechazada_ModalPopupExtender.Hide(); tbl_incidentTableAdapter incid = new tbl_incidentTableAdapter(); estatus = Convert.ToInt32(incid.getStatus(Convert.ToInt32(Request.QueryString["folio"]))); tbl_statusTableAdapter stat = new tbl_statusTableAdapter(); Label22.Text = stat.getEstatusDesc(Convert.ToInt32(estatus)); stat.Dispose(); incid.Dispose(); txt_fechaComp_CalendarExtender.StartDate = DateTime.Today; if (!Page.IsPostBack) { if (Session["userID"] == null) { Response.Redirect("login.aspx?pag=incidDetail&folio=" + Convert.ToString(Request.QueryString["folio"])); } if (Convert.ToInt32(Session["userRol"]) >= 4 || String.IsNullOrEmpty(Request.QueryString["folio"]) || Request.QueryString["folio"] == null) { btnAceptar.Visible = false; btnRechazada.Visible = false; pnl_motivo.Visible = false; } if (!(Request.QueryString["folio"] == null)) { txt_folio.Text = Request.QueryString["folio"]; txt_folio0.Text = Convert.ToString(getPlanAccion(Convert.ToInt32(txt_folio.Text))); } } if (estatus == 6) { //FormView1.DefaultMode = FormViewMode.Edit; btnActualizar.Visible = false; btnAceptar.Visible = true; btnRechazada.Visible = true; FormView1.Enabled = false; GridView1.AutoGenerateEditButton = false; GridView4.AutoGenerateEditButton = false; GridView1.Enabled = false; GridView4.Enabled = false; Panel3.Visible = false; Panel2.Visible = false; Label22.ForeColor = System.Drawing.Color.Blue; } else if (estatus == 7) { btnActualizar.Visible = false; btnAceptar.Visible = false; btnRechazada.Visible = false; FormView1.Enabled = false; GridView1.AutoGenerateEditButton = false; GridView4.AutoGenerateEditButton = false; GridView1.Enabled = false; GridView4.Enabled = false; pnl_motivo.Visible = false; Label22.ForeColor = System.Drawing.Color.Green; Panel3.Visible = true; int actPlanNum = getPlanAccion(Convert.ToInt32(txt_folio.Text)); int actPlanStatus = getPlanActStatus(actPlanNum); } else if (estatus == 8) { btnActualizar.Visible = true; btnAceptar.Visible = false; btnRechazada.Visible = false; pnl_motivo.Visible = false; Panel3.Visible = false; Panel2.Visible = false; Label22.ForeColor = System.Drawing.Color.Red; } else if (Convert.ToInt32(Session["userRol"]) > 2) { btnAceptar0.Visible = false; btnRechazada0.Visible = false; Panel2.Visible = false; pnlBotones.Visible = false; if (estatus == 9) { /* Revisar si se puede modificar despues de guardar */ //grv_acciones.Enabled = false; //grv_causa.Enabled = false; //btn_addCausa.Enabled = false; //btn_save.Enabled = false; //btnGuardaInv.Enabled = false; lblEstatusPlan.Text = "Revisión"; Label22.ForeColor = System.Drawing.Color.Blue; FormView1.Enabled = false; } else if (estatus == 11) { btn_addCausa.Enabled = false; btn_save.Enabled = false; lblEstatusPlan.Text = "Validado"; Label22.ForeColor = System.Drawing.Color.Green; FormView1.Enabled = false; Panel5.Visible = false; } else if (estatus == 10) { lblEstatusPlan.Text = "Rechazada"; Label22.ForeColor = System.Drawing.Color.Red; FormView1.Enabled = false; } } else if (Convert.ToInt32(Session["userRol"]) <= 2) { pnlBotones.Visible = false; btnGuardaInv.Visible = false; FormView1.Enabled = false; GridView1.Enabled = false; GridView4.Enabled = false; if (estatus == 11) { btn_addCausa.Enabled = false; btn_save.Enabled = false; lblEstatusPlan.Text = "Validado"; Label22.ForeColor = System.Drawing.Color.Green; btnRechazada0.Visible = false; btnAceptar0.Visible = false; pnl_motivo.Visible = false; Panel2.Visible = false; grv_causa.Enabled = false; FormView1.Enabled = false; } else if (estatus == 10) { btnRechazada0.Visible = false; btnAceptar0.Visible = false; Panel2.Visible = false; lblEstatusPlan.Text = "Rechazado por validación"; Label22.ForeColor = System.Drawing.Color.Red; FormView1.Enabled = false; } else if (estatus == 9) { lblEstatusPlan.Text = "Por Validar"; Label22.ForeColor = System.Drawing.Color.Blue; FormView1.Enabled = false; } } }