protected void btnEnviarMotivo_Click(object sender, EventArgs e)
{
if (!(String.IsNullOrEmpty(TextBox4.Text)))
{
tbl_incidentTableAdapter incident = new tbl_incidentTableAdapter();
tbl_actionPlanTableAdapter acPlan = new tbl_actionPlanTableAdapter();
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
int folio = Convert.ToInt32(Request.QueryString["folio"]);
acPlan.updateStatus(10, Convert.ToInt32(txt_folio0.Text));
bitac.Insert(DateTime.Now, "plan de acción rechazado", "Motivo: " + TextBox4.Text, "planAccion", folio, 0, Convert.ToString(Session["userName"]));
bitac.Dispose();
incident.updateApprove(10, folio);
incident.Dispose();
try
{
enviarCorreoRecha(Convert.ToInt32(Request.QueryString["folio"]), txtMotivo.Text);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
Response.Redirect("dash-incidentes.aspx");
}
else
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
tbl_actionPlanTableAdapter actionPlan = new tbl_actionPlanTableAdapter();
tbl_eventActionsTableAdapter evActions = new tbl_eventActionsTableAdapter();
DataSet1.tbl_actionPlanDataTable dtActPlan = new DataSet1.tbl_actionPlanDataTable();
if (txt_folio0.Text == "0")
{
int actPlan_id = 0;
int inciID = Convert.ToInt32(txt_folio.Text);
actionPlan.Insert(0, "", false, 9, 1, inciID, 6);
actPlan_id = Convert.ToInt32(actionPlan.getMaxActPlan());
evActions.updateActPlan(actPlan_id, Convert.ToInt32(txt_folio.Text));
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
bitac.Insert(Convert.ToDateTime(DateTime.Today.ToShortDateString()), "plan de acción creado", "", "investigación", Convert.ToInt32(txt_folio.Text), 0, Convert.ToString(Session["userName"]));
}
else
{
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
bitac.Insert(Convert.ToDateTime(DateTime.Today.ToShortDateString()), "se ha actualizado el plan de acción", "", "investigación", Convert.ToInt32(txt_folio.Text), 0, Convert.ToString(Session["userName"]));
}
actionPlan.Dispose();
evActions.Dispose();
dtActPlan.Dispose();
Response.Redirect("my-reports.aspx");
}
protected void Button3_Click(object sender, EventArgs e)
{
if (!(String.IsNullOrEmpty(txtMotivo.Text)))
{
tbl_incidentTableAdapter incident = new tbl_incidentTableAdapter();
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
int folio = Convert.ToInt32(Request.QueryString["folio"]);
incident.updateApprove(8, folio);
bitac.Insert(DateTime.Now, "solicitud rechazada", "Motivo: " + txtMotivo.Text, "incidenteAccidente", folio, 0, Convert.ToString(Session["userName"]));
bitac.Dispose();
incident.Dispose();
try
{
enviarCorreoRecha(Convert.ToInt32(Request.QueryString["folio"]), txtMotivo.Text);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
Response.Redirect("my-reports.aspx");
}
else
{
}
}
protected void btnAceptar_Click(object sender, EventArgs e)
{
tbl_incidentTableAdapter incident = new tbl_incidentTableAdapter();
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
int folio = Convert.ToInt32(Request.QueryString["folio"]);
incident.updateApprove(7, folio);
bitac.Insert(DateTime.Now, "solicitud aprobada", "", "incidentAccident", folio, 0, Convert.ToString(Session["userName"]));
bitac.Dispose();
incident.Dispose();
enviarCorreo(Convert.ToInt32(Request.QueryString["folio"]));
Response.Redirect("my-reports.aspx");
}
protected void btnActualizar_Click(object sender, EventArgs e)
{
int folio = Convert.ToInt32(Request.QueryString["folio"]);
using (tbl_incidentTableAdapter incid = new tbl_incidentTableAdapter())
{
incid.updateApprove(6, folio);
}
using (tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter())
{
bitac.Insert(DateTime.Now, "Actualización de reporte", "", "incidentAccident", folio, 0, Convert.ToString(Session["userName"]));
}
enviarCorreo(Convert.ToInt32(Request.QueryString["folio"]));
}
protected void btnAceptar0_Click(object sender, EventArgs e)
{
tbl_actionPlanTableAdapter acPlan = new tbl_actionPlanTableAdapter();
tbl_incidentTableAdapter incident = new tbl_incidentTableAdapter();
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
int folio = Convert.ToInt32(Request.QueryString["folio"]);
int actionPlan = Convert.ToInt32(txt_folio0.Text);
acPlan.updateStatus(11, Convert.ToInt32(txt_folio0.Text));
bitac.Insert(DateTime.Now, "plan de acción validado", "", "planAcción", folio, actionPlan, Convert.ToString(Session["userName"]));
bitac.Dispose();
incident.updateApprove(11, folio);
incident.Dispose();
acPlan.Dispose();
correoSHEupdate(Convert.ToInt32(Request.QueryString["folio"]));
Response.Redirect("dash-incidentes.aspx");
}
protected void btnGuardaInv_Click(object sender, EventArgs e)
{
tbl_actionPlanTableAdapter actionPlan = new tbl_actionPlanTableAdapter();
tbl_eventActionsTableAdapter evActions = new tbl_eventActionsTableAdapter();
DataSet1.tbl_actionPlanDataTable dtActPlan = new DataSet1.tbl_actionPlanDataTable();
if (grv_acciones.EditIndex > -1)
{
}
if (txt_folio0.Text == "0")
{
int actPlan_id = 0;
int inciID = Convert.ToInt32(txt_folio.Text);
actPlan_id = Convert.ToInt32(actionPlan.getMaxActPlan()) + 1;
actionPlan.Insert(actPlan_id, "", false, 9, 0, inciID, 9);
actPlan_id = Convert.ToInt32(actionPlan.getMaxActPlan());
evActions.updateActPlan(actPlan_id, Convert.ToInt32(txt_folio.Text));
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
bitac.Insert(DateTime.Now, "plan de acción creado", "", "investigación", Convert.ToInt32(txt_folio.Text), 0, Convert.ToString(Session["userName"]));
correoSHE(Convert.ToInt32(txt_folio.Text));
}
else
{
actionPlan.updateStatus(9, Convert.ToInt32(txt_folio0.Text));
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
bitac.Insert(DateTime.Now, "se ha actualizado el plan de acción", "", "investigación", Convert.ToInt32(txt_folio.Text), 0, Convert.ToString(Session["userName"]));
correoSHEupdate(Convert.ToInt32(txt_folio.Text));
}
tbl_incidentTableAdapter incident = new tbl_incidentTableAdapter();
int folio = Convert.ToInt32(Request.QueryString["folio"]);
incident.updateApprove(9, folio);
actionPlan.Dispose();
evActions.Dispose();
dtActPlan.Dispose();
Response.Redirect("dash-incidentes.aspx");
}
private void generaActualizaReporte()
{
if (grvPersonEvent.EditIndex != -1)
{
//lblError.Text ="Sorre";
}
//creamos la instancia para la tabla extraida del dataset XSD
tbl_incidentTableAdapter incidentes = new tbl_incidentTableAdapter();
if (grvPersonEvent.Rows.Count > 0 && grvInmedActions.Rows.Count > 0)
{
btn_reporte.Enabled = true;
try
{
lbl_errAction.Visible = false;
lbl_errPersona.Visible = false;
string descriptEvento = txt_eventDesc.Text;
DateTime fechaEvento = Convert.ToDateTime(txt_eventFecha.Text);
int turnoEvento = Convert.ToInt32(ddl_turno.SelectedValue);
int areaEvento = Convert.ToInt32(ddl_eventArea.SelectedValue);
int tipoEvento = Convert.ToInt32(ddlEvents2.SelectedValue);
int placeEvento = Convert.ToInt32(ddl_eventPlace.SelectedValue);
int tipoEventoHijo = 0;
int gec = 0;
int tipoEventoHijoHijo = 0;
decimal serie = Convert.ToDecimal(generateSerial());
//string a = System.Configuration.ConfigurationManager.ConnectionStrings["WingtipToys"].ConnectionString;
if (!(DropDownList2.Visible == false || ddlEvCh.SelectedValue == ""))
{
tipoEventoHijo = Convert.ToInt32(DropDownList2.SelectedValue);
}
if (!(ddlEvChCh.Visible == false || ddlEvCh.SelectedValue == ""))
{
tipoEventoHijoHijo = Convert.ToInt32(ddlEvCh.SelectedValue);
}
if (RadioButtonList1.SelectedIndex == -1)
{
gec = 0;
}
else
{
gec = Convert.ToInt32(RadioButtonList1.SelectedValue);
}
//mail(0, ddl_eventArea.SelectedItem.Text, ddl_eventClasif.SelectedItem.Text, txt_eventDesc.Text, txt_eventFecha.Text, "Revisión", Session["userName"].ToString(), 5);
if ((txt_folio.Text == "0") || txt_folio.Text == "")
{
//metodo para insertar la información. De momento se toma todo tal cual de los campos
int resIncident = incidentes.Insert(descriptEvento, fechaEvento, turnoEvento,
areaEvento, tipoEvento, tipoEventoHijo, 0, placeEvento,
serie, 6, gec, Convert.ToInt32(ddl_eventClasif.SelectedValue), Convert.ToInt32(Session["userID"]), DateTime.Now, TimeSpan.Parse(txt_eventHora.Text), Convert.ToString(Session["userName"]));
int incid_id = Convert.ToInt32(incidentes.getIncidentIDBySerial(serie));
tbl_personEventTableAdapter employeeEvent = new tbl_personEventTableAdapter();
int resEmploy = employeeEvent.UpdateIncidID(incid_id, Convert.ToString(Session["userName"]));
//employeeEvent.DeleteTempQuery(Convert.ToString(Session["userName"]), incid_id);
tbl_inmediateActionTableAdapter actions = new tbl_inmediateActionTableAdapter();
int resActions = actions.UpdateIncidID(incid_id, Convert.ToString(Session["userName"]));
//actions.DeleteTempQuery(Convert.ToString(Session["userName"]), incid_id);
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
bitac.Insert(DateTime.Now, "reporte creado", "", "incidenteAccidente", incid_id, 0, Convert.ToString(Session["userName"]));
bitac.Dispose();
//apartado de parametros que conforman el correo electrónico que se despliega
//******Descmentar para el servicio de correo electrónico********
//mail(incid_id, ddl_eventArea.SelectedItem.Text, ddl_eventClasif.SelectedItem.Text, txt_eventDesc.Text, txt_eventFecha.Text, "Revisión", Session["userName"].ToString(), Convert.ToInt32( ddl_eventArea.SelectedValue));
//enviarCorreo(incid_id);
//****** fin de correo electronico ****
lbl_reportNum.Text = incid_id.ToString();
}
else
{
int folio = Convert.ToInt32(txt_folio.Text);
int resIncident = incidentes.Update(descriptEvento, fechaEvento, turnoEvento, areaEvento,
tipoEvento, tipoEventoHijo, 0, placeEvento, serie, 6, gec, Convert.ToInt32(ddl_eventClasif.SelectedValue),
Convert.ToInt32(Session["userID"]), Convert.ToDateTime(lblFechaReporte.Text), TimeSpan.Parse(txt_evHora.Text), Convert.ToString(Session["userName"]), folio);
mail(folio, ddl_eventArea.SelectedItem.Text, ddl_eventClasif.SelectedItem.Text, txt_eventDesc.Text, txt_eventFecha.Text, "Revisión", Session["userName"].ToString(), Convert.ToInt32(ddl_eventArea.SelectedValue));
//correoUpdateReport(folio);
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
bitac.Insert(DateTime.Now, "Actualización de reporte", "", "incidenteAccidente", folio, 0, Convert.ToString(Session["userName"]));
bitac.Dispose();
Response.Redirect("my-reports.aspx");
}
hdf_ok_ModalPopupExtender.Show();
//una vez generado el registro de incidente vamos a buscar el ID para relacionar empleados y acciones inmediatas
//int incid_id = Convert.ToInt32(incidentes.GetIDByFolio(Convert.ToInt32(serie)).Rows[0][0]);
}
catch (Exception ex)
{
lblError.Text = ex.Message;
incidentes.Dispose();
}
}
else
{
//Label20.Text = "Es necesario agregar acciones y los involucrados";
// HttpContext.Current.Response.Write("Es necesario agregar acciones y los involucrados");
if (grvPersonEvent.Rows.Count == 0)
{
lbl_errPersona.Visible = true;
}
else if (grv_acciones.Rows.Count == 0)
{
lbl_errAction.Visible = true;
}
}
}
protected void btnGuardar_Click(object sender, EventArgs e)
{
tbl_bitacoraTableAdapter bitac = new tbl_bitacoraTableAdapter();
bitac.Insert(Convert.ToDateTime(DateTime.Today.ToShortDateString()), "cambio de estatus", "", "incidenteAccidente", Convert.ToInt32(Request.QueryString["folio"]), 0, Convert.ToString(Session["userName"]));
}
