public static void InsertUser(object sender, EventArgs e, register form)
{
SqlConnection connection = null;
SqlCommand cmd = null;
try
{
connection = new SqlConnection(ListConexion.GetDataSource());
connection.Open();
cmd = new SqlCommand("Insert into usuario (Id,nombre,pass,correo) values (@id,@nombre,@pass,@correo)", connection);
cmd.Parameters.AddWithValue("@id", Guid.NewGuid());
cmd.Parameters.AddWithValue("@nombre", form.txtUsername.Text);
cmd.Parameters.AddWithValue("@pass", form.txtPassword.Password);
cmd.Parameters.AddWithValue("@correo", form.txtEmail.Text);
SqlDataAdapter adapt = new SqlDataAdapter(cmd);
MessageBox.Show("Se ha registrado con exito.");
MainWindow fm = new MainWindow();
fm.Show();
form.Hide();
}
catch (Exception x)
{
Console.WriteLine(x.Message);
}
finally
{
cmd.Dispose();
connection.Close();
}
}
public int?ComproveUserPasswordBD(String Email, String Contraseña)
{
int? rownumber;
SqlConexion conexion = null;
SqlCommand command = null;
if (Email == null || Email == "")
{
throw new Exception("Email no valido");
}
if (Contraseña == null || Contraseña == "")
{
throw new Exception("Contraseña no valida");
}
try
{
conexion = new SqlConexion(ListConexion.GetDataSource());
conexion.Open();
command = conexion.CreateCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "Select Count(*) From Usuario Where Email=@Email AND Contraseña=@Contraseña";
command.Parameters.Add(new SqlParameter("@Email", Email));
command.Parameters.Add(new SqlParameter("@Contraseña", Contraseña));
rownumber = command.ExecuteScalar() as int?;
}
catch (SqlException)
{
throw new Exception("Error en la consulta");
}
catch (Exception)
{
throw new Exception("Error en la consulta");
}
finally
{
command.Dispose();
conexion.Close();
}
return(rownumber);
}
