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;
}
}
}
