private string TextoEnvioAlertaEmpleado() { IEnumerator enumerator; string str = "<html>"; str = (((((((((((str + "<body><center> " + "<div style='font-size:11px; font-family:Arial; text-align:left; padding:10px; width:650px;'>") + "<br><div style='padding-left:30px; padding-right:30px; text-align:justify'><strong>Estimado(a) usuario(a):</strong>" + "<br>El listado presentado a continuacion son los que deben ser corroborado en ERP SPRING, en el ESTADO DEL TRABAJADOR.") + "</div><br>" + "<div style='font-size:11px; font-family:Arial;background-color:#E8EAEE; padding:20px'>") + "<table width='1200' cellpadding='7'>" + "<tr><td colspan='2'>") + "<hr /> </td></tr>" + "<tr><td width='200' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>NOMBRE COMPLETO</td>") + "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>DNI</td>" + "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>TIPO PLANILLA</td>") + "<td width='60' valign='top' style='text-align:center;background-color:#ff3300;font-size:11px; font-family:Arial'>ESTADO</td>" + "<td width='200' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>CARGO</td>") + "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>FECHA INGRESO</td>" + "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>FECHA INICIO CONTRATO</td>") + "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>FECHA FIN CONTRATO</td>" + "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>FECHA CESE</td>") + "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>CENTRO DE COSTO</td>" + "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>DEPARTAMENTO</td>") + "<td width='60' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>ULTIMO USUARIO</td>" + "<td width='80' valign='top' style='text-align:center;background-color:#DDDDDD;font-size:11px; font-family:Arial'>ULTIMA FECHA MODIFICACION</td></tr>"); try { enumerator = ((IEnumerable)BL_ObjControl_Auditoria_Empleado.PoblarAuditoria_EmpleadoSelAll()).GetEnumerator(); while (enumerator.MoveNext()) { BE_Auditoria_Empleado current = (BE_Auditoria_Empleado)enumerator.Current; str = str + "<tr><td width='200' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.NombreCompleto + "</td>"; str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.DNI + "</td>"; str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'> " + current.TipoPlanilla + "</td>"; str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;color:red'> " + current.Estado + "</td>"; str = str + "<td width='200' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.Cargo + "</td>"; str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.FechaIngreso + "</td>"; str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.FechaInicioContrato + "</td>"; str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.FechaFinContrato + "</td>"; str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.FechaCese + "</td>"; str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.CentroCostos + "</td>"; str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.DeptoOrganizacion + "</td>"; str = str + "<td width='60' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.UltimoUsuario + "</td>"; str = str + "<td width='80' valign='top' style='font-size:11px; font-family:Arial;text-align:center;'>" + current.UltimaFechaModif + "</td></tr>"; } } finally { //if (enumerator is IDisposable) //{ // (enumerator as IDisposable).Dispose(); //} } return(((str + "</table>" + "</div>") + "<hr /><div style='font-size:10px; padding-left:30px; padding-right:30px'>" + "<strong><em>QLABSP Investors</em></strong><br><br>") + //"<strong><em>Nexos Comerciales S.A</em></strong><br><br>") + "<strong>P.D:</strong> Este correo es solo para confirmar el estado de recepcion. Agradeceremos no responderlo.</div> </div>" + "</center></body></html>"); }
public override BE_Auditoria_Empleados Obtener_Auditoria_EmpleadoSelAll() { BE_Auditoria_Empleados ps2 = new BE_Auditoria_Empleados(); DbCommand storedProcCommand = this.BaseInterface.GetStoredProcCommand("dbo.Auditoria_Empleados"); using (SqlDataReader reader = (SqlDataReader)this.BaseInterface.ExecuteReader(storedProcCommand)) { while (reader.Read()) { BE_Auditoria_Empleado item = new BE_Auditoria_Empleado(Convert.ToString(reader["CodEmp"]), Convert.ToString(reader["NombreCompleto"]), Convert.ToString(reader["DNI"]), Convert.ToString(reader["TipoPlanilla"]), Convert.ToString(reader["Estado"]), Convert.ToString(reader["Cargo"]), Convert.ToString(reader["FechaIngreso"]), Convert.ToString(reader["FechaInicioContrato"]), Convert.ToString(reader["FechaFinContrato"]), Convert.ToString(reader["FechaCese"]), Convert.ToString(reader["CentroCostos"]), Convert.ToString(reader["DeptoOrganizacion"]), Convert.ToString(reader["UltimoUsuario"]), Convert.ToString(reader["UltimaFechaModif"])); ps2.Add(item); } } return(ps2); }
private void Actualizar_Dato_Empleado() { IEnumerator enumerator; try { enumerator = ((IEnumerable)BL_ObjControl_Auditoria_Empleado.PoblarAuditoria_EmpleadoSelAll()).GetEnumerator(); while (enumerator.MoveNext()) { BE_Auditoria_Empleado current = (BE_Auditoria_Empleado)enumerator.Current; BL_ObjControl_Auditoria_Empleado.ActualizarAuditoria_EmpleadoSelAll(current.CodEmp); } } finally { //if (enumerator is IDisposable) //{ // (enumerator as IDisposable).Dispose(); //} } }