private string getEmail(int userID)
{
tbl_userTableAdapter users = new tbl_userTableAdapter();
int userInfo = Convert.ToInt32(users.getUsrInfo(userID));
tbl_userInfoTableAdapter usrInfo = new tbl_userInfoTableAdapter();
DataSet1.tbl_userInfoDataTable dtUsrInfo = new DataSet1.tbl_userInfoDataTable();
usrInfo.FillByUserID(dtUsrInfo, userInfo);
string correo = Convert.ToString(dtUsrInfo.Rows[0]["usrInfo_email"]);
users.Dispose();
usrInfo.Dispose();
dtUsrInfo.Dispose();
return(correo);
}
protected void txt_numEmployee_TextChanged(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(txt_numEmployee.Text))
{
tbl_userInfoTableAdapter userInfo = new tbl_userInfoTableAdapter();
DataSet1.tbl_userInfoDataTable dtInfo = new DataSet1.tbl_userInfoDataTable();
decimal numEmpleado = Convert.ToDecimal(txt_numEmployee.Text);
userInfo.FillByNoEmpleado(dtInfo, numEmpleado);
if (dtInfo.Rows.Count != 0)
{
txt_nombreEmployee.Text = Convert.ToString(userInfo.GetDataByNoEmpleado(numEmpleado).Rows[0]["usrInfo_name"]);
txt_company.Text = Convert.ToString(userInfo.GetDataByNoEmpleado(numEmpleado).Rows[0]["usrInfo_company"]);
txt_antique.Text = Convert.ToString(userInfo.GetDataByNoEmpleado(numEmpleado).Rows[0]["usrInfo_antique"]);
ddl_personArea.SelectedValue = Convert.ToString(userInfo.GetDataByNoEmpleado(numEmpleado).Rows[0]["perArea_id"]);
}
}
}
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;
}
}
private bool dataLogin(string Usuario, string Contrasena)
{
bool auth = false;
string ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["pentagonov2ConnectionString"].ConnectionString;
LDAPaccess authLdap = new LDAPaccess();
pent.pentagSQL pentSQL = new pent.pentagSQL();
tbl_userTableAdapter usuarioAdapter = new tbl_userTableAdapter();
DataTable dtUsuario = new DataTable();
dtUsuario = usuarioAdapter.GetDataByUser(Usuario, Contrasena);
auth = authLdap.autenticado(Usuario, Contrasena);
if (auth)
{
string[] userInfo = { "", "" };
userInfo = authLdap.datosLdapUser(txtUser.Text);
Session["email"] = userInfo[0];
Session["user_Name"] = userInfo[1];
dtUsuario = usuarioAdapter.GetDataByNetUser(Usuario);
if (dtUsuario.Rows.Count == 1)
{
Session["userID"] = Convert.ToInt32(dtUsuario.Rows[0]["usr_id"]);
Session["userName"] = Convert.ToString(dtUsuario.Rows[0]["usr_username"]);
Session["userRol"] = Convert.ToInt32(dtUsuario.Rows[0]["rol_id"]);
Session["Area"] = pentSQL.getUsersArea(Convert.ToInt32(dtUsuario.Rows[0]["usrInfo_id"]), ConnectionString);
if (Convert.ToString(Session["email"]) == "")
{
tbl_userInfoTableAdapter usrInfo = new tbl_userInfoTableAdapter();
Session["email"] = Convert.ToString(usrInfo.getEmailByUser(Convert.ToInt32(dtUsuario.Rows[0]["usrInfo_id"])));
usrInfo.Dispose();
}
auth = true;
usuarioAdapter.updateLastAccess(DateTime.Now, Convert.ToInt32(dtUsuario.Rows[0]["usr_id"]));
}
else
{
Session["userID"] = 0;
Session["userName"] = Usuario;
Session["userRol"] = 4;
}
}
else
{
if (dtUsuario.Rows.Count == 1)
{
Session["userID"] = Convert.ToInt32(dtUsuario.Rows[0]["usr_id"]);
Session["userName"] = Convert.ToString(dtUsuario.Rows[0]["usr_username"]);
Session["userRol"] = Convert.ToInt32(dtUsuario.Rows[0]["rol_id"]);
pentagSQL bd = new pentagSQL();
string userInfoID = bd.getSingleValueByID("usrInfo_id", Session["userName"].ToString(), "tbl_user", "usr_username", ConnectionString);
string nameUser = bd.getSingleValueByID("usrInfo_name", userInfoID, "tbl_userInfo", "usrInfo_id", ConnectionString);
Session["user_Name"] = nameUser;
tbl_userInfoTableAdapter usrInfo = new tbl_userInfoTableAdapter();
Session["email"] = Convert.ToString(usrInfo.getEmailByUser(Convert.ToInt32(dtUsuario.Rows[0]["usrInfo_id"])));
Session["Area"] = pentSQL.getUsersArea(Convert.ToInt32(dtUsuario.Rows[0]["usrInfo_id"]), ConnectionString);
usrInfo.Dispose();
auth = true;
usuarioAdapter.updateLastAccess(DateTime.Now, Convert.ToInt32(dtUsuario.Rows[0]["usr_id"]));
}
}
usuarioAdapter.Dispose();
dtUsuario.Dispose();
return(auth);
}
