private void BTN_CHANGEPASS_Click(object sender, RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (!(string.IsNullOrEmpty(TXT_OLDPASS.Password.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_NEWPASS.Password.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_RE_NEWPASS.Password.Trim().Replace('\'', ' '))))
{
Connection.ChangeTable("USR_USUARIOS", "USR_ID_PK");
Connection.ChangeSelect("SELECT * FROM USR_USUARIOS WHERE BINARY USR_NICK = '" + Padre.TXT_USUARIO.Text + "'");
Connection.Update_String("UPDATE USR_USUARIOS SET USR_PASSWORD = '******'\'', ' ')) + "' WHERE BINARY USR_NICK = '" + Padre.TXT_USUARIO.Text + "'");
Connection.Conectar();
if ((Connection.getData(0, 2) == EncriptarMD5.Encript(TXT_OLDPASS.Password.Trim().Replace('\'', ' '))) && (TXT_NEWPASS.Password.Trim().Replace('\'', ' ') == TXT_RE_NEWPASS.Password.Trim().Replace('\'', ' ')))
{
Connection.Update_Execute();
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'ChangePass','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "'," + Padre.getUsrID() + ")");
Connection.Insert_Execute();
Connection.Desconectar();
MessageBox.Show("Contraseña cambiada correctamente !", "Información", MessageBoxButton.OK, MessageBoxImage.Information);
Padre.elementHost.Child = new Profile(Padre, Connection);
}
else
{
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Bad ChangePass','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "'," + Padre.getUsrID() + ")");
Connection.Insert_Execute();
Connection.Desconectar();
MessageBox.Show("Error, comprueba si has escrito bien las contraseñas !", "Información", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
else
{
MessageBox.Show("Error, debes rellenar todos los campos !", "Información", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_CREARCURSO_Click(object sender, System.Windows.RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (!(string.IsNullOrEmpty(TXT_NOMBRE.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_DESCRIPCION.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_F_COMIENZO.Text)) && !(string.IsNullOrEmpty(TXT_F_FINALIZACION.Text)))
{
Regex regex = new Regex(@"^(((((0[1-9])|(1\d)|(2[0-8]))/((0[1-9])|(1[0-2])))|((31/((0[13578])|(1[02])))|((29|30)/((0[1,3-9])|(1[0-2])))))/((20[0-9][0-9]))|((((0[1-9])|(1\d)|(2[0-8]))/((0[1-9])|(1[0-2])))|((31/((0[13578])|(1[02])))|((29|30)/((0[1,3-9])|(1[0-2])))))/((19[0-9][0-9]))|(29/02/20(([02468][048])|([13579][26])))|(29/02/19(([02468][048])|([13579][26]))))$");
Match result_match_f_inicio = regex.Match(TXT_F_COMIENZO.Text);
Match result_match_f_fin = regex.Match(TXT_F_FINALIZACION.Text);
if (result_match_f_inicio.Success && result_match_f_fin.Success)
{
string fecha_inicio = DateTime.Parse(TXT_F_COMIENZO.Text).ToString("yyyyMMdd");
string fecha_fin = DateTime.Parse(TXT_F_FINALIZACION.Text).ToString("yyyyMMdd");
if (course_ID != -1)
{
Connection.ChangeTable("CUR_CURSOS", null);
Connection.ChangeSelect("SELECT * FROM CUR_CURSOS WHERE CUR_ID_PK = " + this.course_ID.ToString());
if (Connection.Conectar())
{
Connection.Update_String("UPDATE CUR_CURSOS SET CUR_NOMBRE='" + TXT_NOMBRE.Text.Trim().Replace('\'', ' ') + "',CUR_DESCRIPCION='" + TXT_DESCRIPCION.Text.Trim().Replace('\'', ' ') +
"',CUR_F_COMIENZO='" + fecha_inicio + "',CUR_F_FINAL='" + fecha_fin + "' WHERE CUR_ID_PK = " + this.course_ID.ToString());
Connection.Update_Execute();
Connection.Desconectar();
}
}
else
{
Connection.ChangeTable("USR_USUARIOS", null);
Connection.ChangeSelect("SELECT * FROM USR_USUARIOS WHERE BINARY USR_NICK = '" + Padre.TXT_USUARIO.Text + "'");
if (Connection.Conectar())
{
Connection.Insert_String("INSERT INTO CUR_CURSOS (CUR_USR_ID_PK,CUR_NOMBRE,CUR_DESCRIPCION,CUR_F_COMIENZO,CUR_F_FINAL) VALUES (" +
Connection.getData(0, 0) + "," + "'" + TXT_NOMBRE.Text.Trim().Replace('\'', ' ') + "'," + "'" + TXT_DESCRIPCION.Text.Trim().Replace('\'', ' ') + "'," + "'" + fecha_inicio + "'," + "'" + fecha_fin + "')");
Connection.Insert_Execute();
Connection.Desconectar();
}
}
Padre.elementHost.Child = new OrganizerCourses(Padre, Connection, false);
}
else
{
MessageBox.Show("¡Debes rellenar todos los datos!", "Información");
}
}
else
{
MessageBox.Show("Por favor, introduce correctamente ambas fechas.\nFormato: (DD/MM/AAAA)", "Información");
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_CREARHORARIO_Click(object sender, System.Windows.RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (!(TXT_COMBO_ASIGNATURA.SelectedIndex == -1) && !(string.IsNullOrEmpty(TXT_H_COMIENZO.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_H_FINALIZACION.Text.Trim().Replace('\'', ' '))) && check_Days())
{
if (schedule_ID != -1)
{
Connection.ChangeTable("HOR_HORARIOS", null);
Connection.ChangeSelect("SELECT * FROM HOR_HORARIOS WHERE HOR_ID_PK = " + this.schedule_ID.ToString());
if (Connection.Conectar())
{
Connection.Update_String("UPDATE HOR_HORARIOS SET HOR_ASG_ID_PK = (SELECT ASG_ID_PK FROM ASG_ASIGNATURAS,CUR_CURSOS WHERE ASG_NOMBRE LIKE '" +
TXT_COMBO_ASIGNATURA.Items[TXT_COMBO_ASIGNATURA.SelectedIndex].ToString() + "' AND ASG_CUR_ID_PK = (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_NOMBRE LIKE '" + TXT_COMBO_CURSO.Items[TXT_COMBO_CURSO.SelectedIndex].ToString() + "' AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + ") AND ASG_CUR_ID_PK = CUR_ID_PK), HOR_F_COMIENZO = '" + TXT_H_COMIENZO.Text.Trim().Replace('\'', ' ') + "', HOR_F_FINAL = '" + TXT_H_FINALIZACION.Text.Trim().Replace('\'', ' ') + "', HOR_D_SEMANA= '" + get_Days() + "' WHERE HOR_ID_PK = " + this.schedule_ID.ToString());
Connection.Update_Execute();
Connection.Desconectar();
}
}
else
{
Connection.ChangeTable("USR_USUARIOS", null);
Connection.ChangeSelect("SELECT * FROM USR_USUARIOS WHERE BINARY USR_NICK = '" + Padre.TXT_USUARIO.Text + "'");
if (Connection.Conectar())
{
Connection.Insert_String("INSERT INTO HOR_HORARIOS (HOR_ASG_ID_PK,HOR_F_COMIENZO,HOR_F_FINAL,HOR_D_SEMANA) VALUES (" +
"(SELECT ASG_ID_PK FROM ASG_ASIGNATURAS,CUR_CURSOS WHERE ASG_NOMBRE LIKE '" + TXT_COMBO_ASIGNATURA.Items[TXT_COMBO_ASIGNATURA.SelectedIndex].ToString() + "' AND ASG_CUR_ID_PK = (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_NOMBRE LIKE '" + TXT_COMBO_CURSO.Items[TXT_COMBO_CURSO.SelectedIndex].ToString() + "' AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + ") AND ASG_CUR_ID_PK = CUR_ID_PK)," +
"'" + TXT_H_COMIENZO.Text.Trim().Replace('\'', ' ') + "','" + TXT_H_FINALIZACION.Text.Trim().Replace('\'', ' ') + "','" + get_Days() + "')");
Connection.Insert_Execute();
Connection.Desconectar();
}
}
Padre.elementHost.Child = new OrganizerSchedules(Padre, Connection, -1);
}
else
{
MessageBox.Show("¡Debes rellenar todos los datos!", "Información");
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_CREARASIGNATURA_Click(object sender, System.Windows.RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (!(TXT_COMBO_CURSO.SelectedIndex == -1) && !(string.IsNullOrEmpty(TXT_NOMBRE.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_LUGAR.Text.Trim().Replace('\'', ' '))))
{
if (subject_ID != -1)
{
Connection.ChangeTable("ASG_ASIGNATURAS", null);
Connection.ChangeSelect("SELECT * FROM ASG_ASIGNATURAS WHERE ASG_ID_PK = " + this.subject_ID.ToString());
if (Connection.Conectar())
{
Connection.Update_String("UPDATE ASG_ASIGNATURAS SET ASG_CUR_ID_PK = (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_NOMBRE LIKE '" +
TXT_COMBO_CURSO.Items[TXT_COMBO_CURSO.SelectedIndex].ToString() + "' AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + "), ASG_NOMBRE = '" + TXT_NOMBRE.Text.Trim().Replace('\'', ' ') + "', ASG_LUGAR = '" + TXT_LUGAR.Text.Trim().Replace('\'', ' ') + "' WHERE ASG_ID_PK = " + this.subject_ID.ToString());
Connection.Update_Execute();
Connection.Desconectar();
}
}
else
{
Connection.ChangeTable("USR_USUARIOS", null);
Connection.ChangeSelect("SELECT * FROM USR_USUARIOS WHERE BINARY USR_NICK = '" + Padre.TXT_USUARIO.Text + "'");
if (Connection.Conectar())
{
Connection.Insert_String("INSERT INTO ASG_ASIGNATURAS (ASG_CUR_ID_PK,ASG_NOMBRE,ASG_LUGAR) VALUES (" +
"(SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_NOMBRE LIKE '" + TXT_COMBO_CURSO.Items[TXT_COMBO_CURSO.SelectedIndex].ToString() + "' AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + ")," +
"'" + TXT_NOMBRE.Text.Trim().Replace('\'', ' ') + "','" + TXT_LUGAR.Text.Trim().Replace('\'', ' ') + "')");
Connection.Insert_Execute();
Connection.Desconectar();
}
}
Padre.elementHost.Child = new OrganizerSubjects(Padre, Connection, -1);
}
else
{
MessageBox.Show("¡Debes rellenar todos los datos!", "Información");
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_ACTUALIZAR_Click(object sender, RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (!(string.IsNullOrEmpty(TXT_NOMBRE.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_EMAIL.Text.Trim().Replace('\'', ' '))))
{
Connection.ChangeTable("USR_USUARIOS", "USR_ID_PK");
Connection.ChangeSelect("SELECT * FROM USR_USUARIOS WHERE BINARY USR_NICK = '" + Padre.TXT_USUARIO.Text + "'");
Connection.Update_String("UPDATE USR_USUARIOS SET USR_NOMBRE = '" + TXT_NOMBRE.Text.Trim().Replace('\'', ' ') + "', USR_EMAIL = '" + TXT_EMAIL.Text.Trim().Replace('\'', ' ') + "' WHERE BINARY USR_NICK = '" + Padre.TXT_USUARIO.Text + "'");
Connection.Conectar();
Connection.Update_Execute();
Connection.Update_Execute();
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'UpdateProfile','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "'," + Padre.getUsrID() + ")");
Connection.Insert_Execute();
Connection.Desconectar();
MessageBox.Show("Datos modificados correctamente !", "Información", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Debes introducir tu nombre y tu email !", "Información", MessageBoxButton.OK, MessageBoxImage.Information);
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_CREARTAREA_Click(object sender, System.Windows.RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (!(string.IsNullOrEmpty(TXT_TITULO.Text.Trim().Replace('\'', ' '))))
{
Regex regex = new Regex(@"^(((((0[1-9])|(1\d)|(2[0-8]))/((0[1-9])|(1[0-2])))|((31/((0[13578])|(1[02])))|((29|30)/((0[1,3-9])|(1[0-2])))))/((20[0-9][0-9]))|((((0[1-9])|(1\d)|(2[0-8]))/((0[1-9])|(1[0-2])))|((31/((0[13578])|(1[02])))|((29|30)/((0[1,3-9])|(1[0-2])))))/((19[0-9][0-9]))|(29/02/20(([02468][048])|([13579][26])))|(29/02/19(([02468][048])|([13579][26]))))$");
Match result_match_f_objetivo = regex.Match(TXT_F_OBJETIVO.Text);
string asg_ID = "-1";
if (TXT_COMBO_ASIGNATURA.SelectedIndex != -1)
{
asg_ID = "(SELECT ASG_ID_PK FROM ASG_ASIGNATURAS,CUR_CURSOS WHERE ASG_NOMBRE LIKE '" + TXT_COMBO_ASIGNATURA.Items[TXT_COMBO_ASIGNATURA.SelectedIndex].ToString() + "' AND ASG_CUR_ID_PK = (SELECT CUR_ID_PK FROM CUR_CURSOS WHERE CUR_NOMBRE LIKE '" + TXT_COMBO_CURSO.Items[TXT_COMBO_CURSO.SelectedIndex].ToString() + "' AND CUR_USR_ID_PK = " + Padre.getUsrID().ToString() + ") AND ASG_CUR_ID_PK = CUR_ID_PK)";
}
string fecha_objetivo = "NULL";
bool continuar = true;
if (!(string.IsNullOrEmpty(TXT_F_OBJETIVO.Text)))
{
if (result_match_f_objetivo.Success)
{
fecha_objetivo = "'" + DateTime.Parse(TXT_F_OBJETIVO.Text).ToString("yyyyMMdd") + "'";
}
else
{
MessageBox.Show("Por favor, introduce correctamente la fecha.\nFormato: (DD/MM/AAAA)", "Información");
continuar = false;
}
}
if (continuar)
{
if (task_ID != -1)
{
Connection.ChangeTable("TAR_TAREAS", null);
Connection.ChangeSelect("SELECT * FROM TAR_TAREAS WHERE TAR_ID_PK = " + this.task_ID.ToString());
if (Connection.Conectar())
{
Connection.Update_String("UPDATE TAR_TAREAS SET TAR_TITULO='" + TXT_TITULO.Text.Trim().Replace('\'', ' ') + "',TAR_DESCRIPCION='" + TXT_DESCRIPCION.Text.Replace('\'', ' ') + "',TAR_F_OBJETIVO=" +
fecha_objetivo + ",TAR_ASG_ID_PK=" + asg_ID + ",TAR_PRIORIDAD=" + TXT_COMBO_PRIORIDAD.SelectedIndex + ",TAR_TIPO=" + TXT_COMBO_TIPO.SelectedIndex + " WHERE TAR_ID_PK = " + this.task_ID.ToString());
Connection.Update_Execute();
Connection.Desconectar();
}
}
else
{
Connection.ChangeTable("USR_USUARIOS", null);
Connection.ChangeSelect("SELECT * FROM USR_USUARIOS WHERE BINARY USR_NICK = '" + Padre.TXT_USUARIO.Text + "'");
if (Connection.Conectar())
{
Connection.Insert_String("INSERT INTO TAR_TAREAS (TAR_TITULO,TAR_DESCRIPCION,TAR_F_OBJETIVO,TAR_ASG_ID_PK,TAR_PRIORIDAD,TAR_TIPO,TAR_USR_ID_PK) VALUES (" +
"'" + TXT_TITULO.Text.Trim().Replace('\'', ' ') + "','" + TXT_DESCRIPCION.Text.Replace('\'', ' ') + "'," + fecha_objetivo + "," + asg_ID + "," + TXT_COMBO_PRIORIDAD.SelectedIndex + "," + TXT_COMBO_TIPO.SelectedIndex + "," + Padre.getUsrID().ToString() + ")");
Connection.Insert_Execute();
Connection.Desconectar();
}
}
Padre.elementHost.Child = new TaskList(Padre, Connection, 0);
}
}
else
{
MessageBox.Show("¡Debes introducir un título!", "Información");
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_Identificarse_Click(object sender, RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (Connection.testConnection())
{
if (!(string.IsNullOrEmpty(TXT_USUARIO.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_PASSWORD.Password.Trim().Replace('\'', ' '))))
{
Connection.ChangeTable("USR_USUARIOS", null);
Connection.ChangeSelect("SELECT * FROM USR_USUARIOS WHERE BINARY USR_NICK = '" + TXT_USUARIO.Text.Trim().Replace('\'', ' ') + "' AND BINARY USR_PASSWORD = '******'\'', ' ')) + "'");
if (Connection.Conectar())
{
if (Connection.countRows() == 1)
{
if (Connection.getData(0, 9) == "Activo")
{
Padre.menuHoy.Visible = true;
Padre.menuTareas.Visible = true;
Padre.menuPlanificador.Visible = true;
Padre.menuPerfil.Visible = true;
Padre.TXT_USUARIO.Text = TXT_USUARIO.Text.Trim().Replace('\'', ' ');
Padre.setUsrID(int.Parse(Connection.getData(0, 0)));
Connection.Update_String("UPDATE USR_USUARIOS SET USR_F_ULTIMA_V = '" + DateTime.Now.ToString("yyyyMMdd") + "', USR_LAST_IP = '" + ObtenerIP.ExternalIPAddress.ToString() + "' WHERE USR_ID_PK = " + Padre.getUsrID());
Connection.Update_Execute();
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Login','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "'," + Padre.getUsrID() + ")");
Connection.Insert_Execute();
Padre.elementHost.Child = new Today(Padre, Connection);
}
else
{
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Inactive Login','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "'," + Connection.getData(0, 0) + ")");
Connection.Insert_Execute();
MessageBox.Show("Error, tu cuenta de usuario no está activada.\nSolicita a un administrador su activación", "Información");
}
}
else
{
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Bad Login','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "', 0)");
Connection.Insert_Execute();
MessageBox.Show("Error, usuario y/o contraseña incorrectos.\nRecuerda que ambos campos son sensibles a mayúsculas y minúsculas.", "Información");
TXT_PASSWORD.Password = "";
}
Connection.Desconectar();
}
}
else
{
MessageBox.Show("¡Debes introducir el usuario y la contraseña!", "Información");
}
}
else
{
MessageBox.Show("Error, no se ha podido establecer conexión con el servidor", "Información");
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
private void BTN_CREATE_ACCOUNT_Click(object sender, RoutedEventArgs e)
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
if (Connection.testConnection())
{
if (!(string.IsNullOrEmpty(TXT_NICK.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_PASSWORD.Password.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_RE_PASSWORD.Password.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_NOMBRE.Text.Trim().Replace('\'', ' '))) && !(string.IsNullOrEmpty(TXT_EMAIL.Text.Trim().Replace('\'', ' '))))
{
if (TXT_PASSWORD.Password.Trim().Replace('\'', ' ') == TXT_RE_PASSWORD.Password.Trim().Replace('\'', ' '))
{
Connection.ChangeTable("USR_USUARIOS", null);
Connection.ChangeSelect("SELECT USR_NICK FROM USR_USUARIOS WHERE BINARY UPPER(USR_NICK) = '" + TXT_NICK.Text.ToUpper().Trim().Replace('\'', ' ') + "'");
if (Connection.Conectar())
{
Connection.Desconectar();
}
if (!(Connection.countRows() > 0))
{
Connection.Conectar();
Connection.Insert_String("INSERT INTO USR_USUARIOS (USR_NICK,USR_PASSWORD,USR_NOMBRE,USR_EMAIL,USR_F_REGISTRO,USR_F_ULTIMA_V,USR_LAST_IP) VALUES (" +
"'" + TXT_NICK.Text.Trim().Replace('\'', ' ') + "','" + EncriptarMD5.Encript(TXT_PASSWORD.Password.Trim().Replace('\'', ' ')) + "','" + TXT_NOMBRE.Text.Trim().Replace('\'', ' ') + "','" + TXT_EMAIL.Text.Trim().Replace('\'', ' ') + "','" + DateTime.Now.ToString("yyyyMMdd") + "','" + DateTime.Now.ToString("yyyyMMdd") + "','" + ObtenerIP.ExternalIPAddress.ToString() + "')");
Connection.Insert_Execute();
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Register User','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "', 0)");
Connection.Insert_Execute();
Connection.Desconectar();
MessageBox.Show("¡Cuenta creada!\nRecuerda que es necesario que un administrador la active para poder usarla", "Información");
Padre.elementHost.Child = new Login(Padre, Connection);
}
else
{
if (Connection.Conectar())
{
Connection.Insert_String("INSERT INTO LOG_REGISTROS (LOG_TIPO,LOG_DESCRIPCION,LOG_IP,LOG_FECHA,LOG_USR_ID_PK) VALUES (" +
"'Bad Register User','USR: "******"','" + ObtenerIP.ExternalIPAddress.ToString() + "','" + DateTime.Now.ToString("yyyyMMdd") + "', 0)");
Connection.Insert_Execute();
Connection.Desconectar();
}
MessageBox.Show("Lo siento, ese nick ya está siendo utilizado", "Información");
TXT_NICK.Text = "";
TXT_PASSWORD.Password = "";
TXT_RE_PASSWORD.Password = "";
}
}
else
{
MessageBox.Show("¡No has introducido correctamente ambas contraseñas!", "Información");
TXT_PASSWORD.Password = "";
TXT_RE_PASSWORD.Password = "";
}
}
else
{
MessageBox.Show("¡Debes rellenar todos los datos!", "Información");
TXT_PASSWORD.Password = "";
TXT_RE_PASSWORD.Password = "";
}
}
else
{
MessageBox.Show("Error, no se ha podido establecer conexión con el servidor", "Información");
}
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
}
