예제 #1
0
        public Users getUserByName(string username)
        {
            CRoles       rol     = new CRoles();
            CBank        cbank   = new CBank();
            int          idRole  = 0;
            List <Users> luser   = new List <Users>();
            const string query   = "SELECT id_user,user,password,name,last_name,role FROM users WHERE user = @user";
            MySqlCommand command = new MySqlCommand(query, conexion.get());

            command.Parameters.AddWithValue("@user", username);
            try
            {
                conexion.Open();
                MySqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    idRole = Convert.ToInt32(reader["role"]);
                    Users users = new Users(Convert.ToInt32(reader["id_user"]), reader["user"].ToString(), reader["password"].ToString(),
                                            reader["name"].ToString(), reader["last_name"].ToString());
                    luser.Add(users);
                }
                conexion.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "there is an error");
            }
            Users user = luser.First();

            user.Role = rol.getRole(idRole).FirstOrDefault();
            return(user);
        }
예제 #2
0
        public Users getUserByCode(string code)
        {
            List <Users> lu    = new List <Users>();
            CRoles       rol   = new CRoles();
            CBank        cbank = new CBank();
            int          role  = 0;
            const string query = "SELECT u.id_user,u.user,u.password,u.name,u.last_name,u.role FROM users u JOIN userbank ub " +
                                 "ON u.id_user = ub.id_user JOIN banks b ON b.id_bank = ub.id_bank WHERE b.code = @code";
            MySqlCommand command = new MySqlCommand(query, conexion.get());

            command.Parameters.AddWithValue("@code", code);
            try
            {
                conexion.Open();
                MySqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    role = Convert.ToInt32(reader["role"]);
                    lu.Add(new Users(Convert.ToInt32(reader["id_user"]), reader["user"].ToString(),
                                     reader["password"].ToString(), reader["name"].ToString(), reader["last_name"].ToString()));
                }
                conexion.Close();
                MessageBox.Show("transfer successful", "operation successful");
            }
            catch (Exception e)
            {
                MessageBox.Show(e.ToString(), "there is an error:");
            }
            Users user = lu.FirstOrDefault();

            user.Role = rol.getRole(role).First();
            user.Bank = cbank.getBankByCode(code);
            return(user);
        }